Interested to Buy Any Domain ? << Click Here >> for more details...
What are the differences between Database Trigger and
Integrity constraints ?
- 4 Answers
- 18194 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
Which data type is a composite type?
Explain the the delete statements in sql?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
What is the purpose of the primary key?
How many clustered indexes can be created on a table?
Which one is faster ienumerable or iqueryable?
explain the difference between myisam static and myisam dynamic. : Sql dba
List different type of expressions with the example.
what is the difference between cluster and non cluster index? : Sql dba
what is normalization? : Sql dba
How do I trace sql profiler?
Can dml statements be used in pl/sql?
Is sql database free?
What type of database is sql?
How many developers work on postgresql?
