What are the differences between Database Trigger and
Integrity constraints ?
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
Differentiate between sga and pga.
Explain autonomous transaction.
How can I change database name in sql?
What are the main features of cursor?
What is the difference between delete, truncate and drop command?
What does 0 mean in sql?
what are the properties and different types of sub-queries? : Sql dba
how many tables will create when we create table, what are they? : Sql dba
Does mysql support pl sql?
What is a left join?
What is replication id?
What pl/sql package consists of?
What is mdf ldf and ndf?
What are sql*plus environment variables?
What is the use of & in pl sql?