Programmatic Constructs Question:

Download Job Interview Questions and Answers PDF

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.

Download Oracle Programmatic Constructs Interview Questions And Answers PDF

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?