Oracle DDL triggers properties? -
which statement true triggers on data definition language (ddl) statements?
a. can used track changes table or index.
b. can defined users in database or specific user.
c. fired when owner of object issues ddl statement.
d. can used track changes table, table space, view, or synonym.
which correct answer,a surely wrong confused b,c,d. did lot of research not found relevant.
answer wrong - ddl triggers can apply more tables or indexes.
answer b not clear: trigger can created user provided required priviliges has been granted user. not limited user, e.g. sys
answer c wrong - doesn't matter issues ddl statement.
answer d seems correct. create
, drop
, alter
statements ddl statements, may fire ddl trigger.
Comments
Post a Comment