triggers

[ajomara]

Hai everyboby
i am new to this group,can one help me in triggers
could anyone help in the fallowing lines
"Database triggers can be system triggers on a database or a schema.
With a database,trigge rs fire for each event for all users.
With a schema,triggers fire for each event for that specifiv user."

What is the difference between trigger in a database or in a schema?
thank u in advance.

[nunnasujatha]

Hi
for this u need to know what is schema.
In Oracle terminology, a user is someone who can connect to a database (if granted enough privileges) and optionally (again, if granted the appropriate privileges) can own objects (such as tables) in the database. The objects a user owns are collectively called schema.
The objects(tables, views,procedure s,etc) of particular user are named something called schema

so the schema trigger means for particular user(schema).an d database trigger is for all the users of database(all the schemas in database).

[ajomara]

hai
can u help me in this please
Which three are true statements about dependent objects? (Choose three)
A. Invalid objects cannot be described.
B. An object with status of invalid cannot be a referenced object.
C. The Oracle server automatically records dependencies among objects.
D. All schema objects have a status that is recorded in the data dictionary.
E. You can view whether an object is valid or invalid in the USER_STATUS data dictionary view.
F. You can view whether an object is valid or invalid in the USER_OBJECTS data dictionary view.

ANS: I think A,D,F
but the correct answers are A,C,F
how the option D is wrong

[pragatiswain]

hai
can u help me in this please
Which three are true statements about dependent objects? (Choose three)
A. Invalid objects cannot be described.
B. An object with status of invalid cannot be a referenced object.
C. The Oracle server automatically records dependencies among objects.
D. All schema objects have a status that is recorded in the data dictionary.
E. You can view whether an object is valid or invalid in the USER_STATUS data dictionary view.
F. You can view whether an object is valid or invalid in the USER_OBJECTS data dictionary view.

ANS: I think A,D,F
but the correct answers are A,C,F
how the option D is wrong

Object status is not recoded in Data dictionary. Status can be "Vadid" or "Invalid".
Tables, sequences, and synonyms are always valid. But view, procedure, function, or package may get invalid, if the dependent objects are altered or deleted/ doesn't exist.
Lets say a Stored Procedure SP1 is dependent on Table1. If Table1 is altered or deleted/ doesn't exist, SP1 becomes invalid. That info. is stored in USER_OBJECTS.

Hope this helps

[ajomara]

hai,
thank u very much nunnasujatha
you have given me clear idea of schema,database

[ajomara]

hai pragathi
i think ,datadictionary stores all the information about the database
but why cant we see status in the data dictionary...
could u explain me please.........

[ajomara]

Hai everbody
i am now preparing for OCA exam
i have so many doubts in pl/sql,could u help me ..........
Under which situation do you create a server side procedure?
A. When the procedure contains no SQL statements.
B. When the procedure contains no PL/SQL commands.
C. When the procedure needs to be used by many client applications accessing several remote
databases.
D. When the procedure needs to be used by many users accessing the same schema objects on a local
database.
can any one help me what is server side procedure?

[pragatiswain]

hai pragathi
i think ,datadictionary stores all the information about the database
but why cant we see status in the data dictionary...
could u explain me please.........

It just doesn't store the status of the objects.