What are the differences between Database Trigger and
Integrity constraints ?
Answer Posted / santu sarkar
1> A database trigger is written in PL/SQL. Integrity Constraints are CHECK Constraints, Not NULL, Unique key, primary key and foreign key.
2> Trigger will not affect the existing data. Constraint will affect the existing data.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What are the set operators in sql?
What are triggers in sql?
Which type of cursor is used to execute the dml statement?
Explain the difference between sql and mysql.
Why do we need cursors in pl sql?
How can you save or place your msg in a table?
Is sql a backend?
What are the three pl sql block types?
Differentiate between % rowtype and type record.
What are the different types of triggers?
How to execute a stored procedure?
What is a rank in sql?
What is a schema? How is it useful in sql servers?
Which join is default?
how to calculate the difference between two dates? : Sql dba