1Z0-149: Oracle Database Program with PL/SQLDemo

By Oracle · Question Mode

QuestionQ41

PL/SQL Language Fundamentals

Which three statements are true about DDL triggers?

Choose three
  • A They cannot include the WHEN clause.
  • B They must be created in an enabled state.
  • C They can be fired when a table is truncated.
  • D They fire only when a DDL statement is executed by the owner of the trigger.
  • E They can be fired either before or after a DDL statement executes.
  • F They can be fired when a privilege is granted to a user.
Explanation

Oracle DDL system triggers can fire before or after a DDL statement. TRUNCATE is a valid DDL trigger event, and GRANT is also a valid event when system privileges, roles, or object privileges are granted to a user or role. A system trigger can be created either enabled or disabled, and applicable system triggers can use a WHEN condition.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!