Interested to Buy Any Domain ? << Click Here >> for more details...
What are the differences between Database Trigger and
Integrity constraints ?
- 4 Answers
- 18048 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
Is not null in sql?
How to fetch alternate records from a table?
what is the difference between myisam static and myisam dynamic? : Sql dba
Explain mutating table error.
What packages(if any) has oracle provided for use by developers?
What is the use of double ampersand (&&) in sql queries? Give an example
What are sql indexes?
What are the types of records?
What is a field in a database?
What is full join in sql?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
what is query cache in mysql? : Sql dba
What is crud stand for?
What are the different tcl commands in sql?
What is nvl?
