Thread: can i get answer for this

the creation of which 4 database objects will cause a DDl trigger to fire
1.index
2.cluster
3.package
4.function
5.synonym
6.database link
7.dimentions

can you explain in brief about this

DDL triggers can be made to trigger before or after any of the data definition statements.
For example, any create or alter stmts which cause a change in the definition of the objects.

that may be an table or index or anything.

This link is having a list of events that triggers the DDL triggers.

http://www.extremeexperts.com/SQL/Yu...LTriggers.aspx

Originally Posted by gujjar

the creation of which 4 database objects will cause a DDl trigger to fire
1.index
2.cluster
3.package
4.function
5.synonym
6.database link
7.dimentions

Hi Gujjar,

The database objects which cause a DDl trigger to fire are Index, Package, Function, Synonym & Clusters in the above mentioned list.
Since they have asked for only 4 options, im very sure about Index, Package, Function & Synonym. So the answer which can opted are 1, 3, 4, 5.

*** Innila ***

ddl trig can fire on following objects only
clustr,function,index,package,procedure,role,sequence,synonym,table,tablespace,trigger,type,view,user

so the choices r first five are right so if u tried to choose any 4 of first five it will correct but u will definately loose ur one marks in exam...it happen....