What is Diff Between constarints and triggers?

Question

Accepted Answer

Constraints are rules enforced on data in a table, while triggers are actions performed in response to certain events.

Constraints ensure data integrity and consistency, while triggers automate actions based on specific events.
Constraints are defined at the time of table creation, while triggers are created separately.
Constraints can be used to enforce rules such as unique values, primary keys, and foreign keys, while triggers can be used to perform actions such as logging changes or updating related tables.
Constraints are checked before data is inserted or updated, while triggers are executed after the data has been modified.
Examples of constraints include NOT NULL, CHECK, UNIQUE, PRIMARY KEY, and FOREIGN KEY, while examples of triggers include INSERT, UPDATE, and DELETE triggers.

Popular interview questions of Plsql Developer