Which system events can be used to create triggers that fire both at database and schema levels?

One thought on “Which system events can be used to create triggers that fire both at database and schema levels?”

1. I agree that correct answers are A,D.
   Just adding some quotes from provided reference.
   AFTER LOGON and AFTER SERVERERROR doesn’t have any level restrictions as triggers below.

   http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/create_trigger.htm#LNPLS2064

   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

   1

   Reply