For which three SYSTEM EVENTS can triggers be created? (Choose three.)
For which three SYSTEM EVENTS can triggers be created? (Choose three.)
Triggers can be created for the following system events: SHUTDOWN, SERVERERROR, and STARTUP. These events are system-level occurrences that can be used to automate administrative tasks or handle specific system conditions. SHUTDOWN triggers can be used to clean up resources or perform logging when the system is shut down. SERVERERROR triggers respond to specific database errors and can be used to take corrective actions. STARTUP triggers can initialize resources or set up configurations when the database starts. Other options like DDL, AFTER AUDIT, BEFORE ANALYZE, and BEFORE GRANT are not considered system events in this context.
D,E,F are correct A is incorrect because DDL is user event not system event https://docs.oracle.com/cd/F49540_01/DOC/server.815/a67781/c18trigs.htm
See link below, correct answers is D, E and F. https://docs.oracle.com/cd/A81042_01/DOC/appdev.816/a76939/adg14evt.htm#999373
What about DDL ,, isn't System event ?
DDL (Data Definition Language) triggers can be created to capture and respond to DDL events such as CREATE, ALTER, and DROP operations on database objects like tables, views, and sequences. They can be useful in maintaining an audit trail, enforcing naming conventions, or implementing other custom actions related to schema changes.
DDL is not a SYSTEM EVENT
D,E,F are correct
DEF are correct