Question

Explain what are The Events On Which A Database Trigger Can Be Based?

Answer 1

Database triggers are based on system events and can be defined at database or schema level. The various events on which a database trigger can be based are given as follows:

•  Data definition statement on a database or schema object
•  Logging off or on of a specific user
•  Database shutdown or startup
•  On any specific error that occurs