Explain the difference between Triggers and Constraints?

devquora
devquora

Posted On: Feb 22, 2018

 

    1 Answer Written

  •  devquora
    Answered by devquora

    Triggers and constraints are two distinct concepts used in various fields, including computer programming, databases, and project management. triggers are code or instructions that automatically execute in response to specific events, while constraints are predefined rules or conditions imposed on data to ensure its validity and consistency. Triggers focus on event-driven actions, while constraints focus on defining and enforcing the rules and relationships within a system. Both triggers and constraints play important roles in maintaining data integrity and controlling system behavior.

Related Questions

Please Login or Register to leave a response.

Related Questions

PL/SQL Interview Questions

What is PL/SQL?

PL/SQL stands for Procedural Language extension of Structured Query Language (SQL). It is a block-structured language ha..

PL/SQL Interview Questions

Differentiate between PL/SQL and SQL?

PL/SQL is Oracle’s Procedural Language SQL which allows you to write full programs to execute options like insert/ sel..

PL/SQL Interview Questions

State few characteristics of PL/SQL?

Some of the characteristics of PL/SQL are furnished below: PL/SQL is completely portable as code can be executed on any ..