Which four triggering events can cause a trigger to fire? (Choose four)
A.
A specific error or any errors occurs.
B.
A database is shut down or started up.
C.
A specific user or any user logs on or off.
D.
A user executes a CREATE or an ALTER table statement.
E.
A user executes a SELECT statement with an ORDER BY clause.
F.
A user executes a JOIN statement that uses four or more tables.
Explanation:
Correct Answers
A, B & C: These are system events. Triggering events that cause system triggers to fire are
Server Errors, Users Logging on or off the database, Database startup or shutdown,
D: Database Triggers fire on DDL Statements including a CREATE, ALTER or DROP of a Table