Oracle Database: Advanced PL/SQL — Question 18

For which three SYSTEM EVENTS can triggers be created? (Choose three.)

Answer options

• A. DDL
• B. AFTER AUDIT
• C. BEFORE ANALYZE
• D. SHUTDOWN
• E. SERVERERROR
• F. STARTUP
• G. BEFORE GRANT

Correct answer: D, E, F

Explanation

The correct answers are D, E, and F because triggers can be defined for SYSTEM EVENTS like SHUTDOWN, SERVERERROR, and STARTUP. The other options, such as DDL, AFTER AUDIT, BEFORE ANALYZE, and BEFORE GRANT, do not qualify as SYSTEM EVENTS for trigger creation.