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

Popular posts from this blog

c++ - QTextObjectInterface with Qml TextEdit (QQuickTextEdit) -

javascript - angular ng-required radio button not toggling required off in firefox 33, OK in chrome -

xcode - Swift Playground - Files are not readable -