What are the differences between Database Trigger and
Integrity constraints ?
- 4 Answers
- 17232 Views
- I also Faced
- E-Mail Answers
Answer Posted / kalyana chakravarthy
Intigrity constraints are Proactive-- Like they take the
cols into consideration before sitting on it like if U levy
a PK on a col having duplicate or null values it will not
obey to sit on that col
Triggers are reactive-- Triggres react only when a DML
occurs. When it comes and sit on a table then its starts
working and never considers what happened before it arrival
Both are used to perform business rules
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
what is bdb (berkeleydb)? : Sql dba
What does count (*) do in sql?
Do stored procedures prevent sql injection?
What is use of trigger?
What is a heap in sql?
what is the difference between myisam static and myisam dynamic? : Sql dba
How you improve the performance of sql*loader? : aql loader
Explain the working of primary key?
Why do we need unique key in a table?
How do you write a complex sql query?
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
How to read xml file in oracle pl sql?
State few characteristics of pl/sql?
How do I create a sql database?
What is range partitioning?
