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
Explanation:
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)
a and d
AFTER STARTUP
Causes the database to fire the trigger whenever the database is opened. This event is valid only with DATABASE, not with SCHEMA.
BEFORE SHUTDOWN
Causes the database to fire the trigger whenever an instance of the database is shut down. This event is valid only with DATABASE, not with SCHEMA.
check this
http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/create_trigger.htm#LNPLS2064
D is an answer
A is wrong because it doesn’t fire both database and schema
A,D
https://docs.oracle.com/cd/E18283_01/appdev.112/e10766/tdddg_triggers.htm
A,D
A , D
A,D
I think it is only D.
ad
Ans: D.
A – AFTER LOGON — this is not a system event, this is a client event.
B – AFTER STARTUP — this fires only on database
C – BEFORE SHUTDOWN – this fires only on database
D – SERVERERROR — this can fire on both database as well as schemas.
https://docs.oracle.com/cd/B10501_01/appdev.920/a96590/adg14evt.htm
also, SERVERERROR is a system even (that’s what asked in the question).