Oracle PL-SQL Question:
Download Questions PDF

What is a database trigger? Name some usages of database trigger?

Answer:

Database trigger is stored PL/SQL program unit associated with a specific database table. Usages are Audit data modifications, Log events transparently, Enforce complex business rules Derive column values automatically, Implement complex security authorizations. Maintain replicate tables.

Download Oracle PL-SQL Interview Questions And Answers PDF

Previous QuestionNext Question
Explain the usage of WHERE CURRENT OF clause in cursors?How many types of database triggers can be specified on a table? What are they?