Which system events can be used to create triggers that fire both at database and schema levels? (Choose all that apply)
A.
AFTER LOGON
B.
AFTER STARTUP
C.
BEFORE SHUTDOWN
D.
AFTER SERVERERROR
Which system events can be used to create triggers that fire both at database and schema levels?
Which system events can be used to create triggers that fire both at database and schema levels? (Choose all that apply)
Only D will be the answer. The first one ‘After Logon’ is not a system event. It is user event.
So answer is only D.
Maybe user event = system event (but not vice versa).
Also check this question:
http://www.aiotestking.com/oracle/2012/07/what-type-of-trigger-needs-to-be-created/
A and D . After logon and AFTER SERVERERROR are system events.
check this
http://psoug.org/reference/system_trigger.html
It’s a nice reference.
Thanks.
Here’s another one to help confirm that both A and D are the answers:
http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/create_trigger.htm#LNPLS2064
D
shutdown and startup are for database only.
A and D are correct.
Respuesta Correcta A y D.
A,D
A,D