Oracle Database: Advanced PL/SQL — Question 27

Which three are true about DDL triggers? (Choose three.)

Answer options

• 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.
• G. They must be created in a disabled state.

Correct answer: A, C, E

Explanation

The correct answers A, C, and E highlight important characteristics of DDL triggers. A is true because DDL triggers do not support a WHEN clause, C is correct as they can indeed fire on table truncation, and E is accurate since they can fire before or after DDL execution. Options B, D, F, and G are incorrect as they misrepresent the behavior and requirements of DDL triggers.