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
think below for cases
a) ON SERVERERROR
WHEN ISSERVERERROR12345)
b) STARTUP ON DATABASE
or SHUTDOWN ON DATABASE
c) LOGON ON mySchema.schema
LOGON ON database
one question is: yourUser is not the owner of mySchema, when yourUser logon mySchema like as sysdba, can this event fire the trigger?
Answer is no: “A SCHEMA trigger is created on a schema and fires whenever the user who owns it is the
current user and initiates the triggering event.” . The trigger is created on mySchema, myUser is the owner of the mySchema.trigger, thus the logon of your user could not fire the trigger.