Programmatic Constructs Question:

Explain What are the differences between Database Trigger and Integrity constraints?

Oracle Programmatic Constructs Interview Question
Oracle Programmatic Constructs Interview Question

Answer:

A declarative integrity constraint is a statement about the database that is always true. A constraint applies to existing data in the table and any statement that manipulates the table. A trigger does not apply to data loaded before the definition of the trigger, therefore, it does not guarantee all data in a table conforms to the rules established by an associated trigger. A trigger can be used to enforce transitional constraints where as a declarative integrity constraint cannot be used.


Previous QuestionNext Question
Explain What is an Oracle Data Block?Explain What are the different types of PL/SQL program units that can be defined and stored in ORACLE database?