Programmatic Constructs Question:

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

Tweet Share WhatsApp

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 PDF Read All 11 Oracle Programmatic Constructs Questions
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?