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:
http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/create_trigger.htm#LNPLS2064
A, D
AFTER STATRUP, BEFORE SHUTDOWN can be created only on DATABASE LEVEL.
it seems to be a logical question…
A, D
a,d
AD
this means that a after logon trigger fires two times?
A,D
STARTUP and SHUTDOWN are valid system events only with DATABASE, not SCHEMA
System Event Trigger Types
AFTER LOGON
BEFORE LOGOFF
AFTER LOGON
AFTER SERVERERROR
AFTER SERVERERROR triggers fire after an Oracle error is raised
AFTER SERVERERROR
Causes the database to fire the trigger whenever both of these conditions are true:
A server error message is logged.
Oracle relational database management system (RDBMS) determines that it is safe to fire error triggers.
Examples of when it is unsafe to fire error triggers include:
RDBMS is starting up.
A critical error has occurred.
help: can servererror can have one WHEN clause like “WHEN is_servererror(012345)”?
A,D
AD
??