Interested to Buy Any Domain ? << Click Here >> for more details...
What are the differences between Database Trigger and
Integrity constraints ?
- 4 Answers
- 18252 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 are the sql commands?
What does <> sql mean?
Is delete faster than truncate?
What are the different types of functions in sql?
how to convert numeric values to character strings? : Sql dba
How to know the last executed procedure?
Which are the different character-manipulation functions in sql?
what are date and time data types? : Sql dba
how can I make a script that can be bi-language (supports english, german)? : Sql dba
How to read xml file in oracle pl sql?
How do I run pl sql in sql developer?
What is an exception in PL/SQL? What are the two types of exceptions?
Explain correlated query work?
What is a dirty read sql?
What are reports usually used for?
