Interested to Buy Any Domain ? << Click Here >> for more details...
What are the differences between Database Trigger and
Integrity constraints ?
- 4 Answers
- 18264 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
How do you break a loop in pl sql?
Is left join and outer join same?
What are the rules to be applied to nulls whilst doing comparisons?
what is clause? : Sql dba
Which kind of parameters cannot have a default value in pl sql?
How can I get the number of records affected by a stored procedure?
What is autocommit sql?
Explain the insert into statements in sql?
What is sql and its types?
What is acid property in a database?
Explain autonomous transaction.
What is pragma in pl sql?
Mention what does the hierarchical profiler does?
Describe types of sql statements?
how to calculate the difference between two dates? : Sql dba
