Interested to Buy Any Domain ? << Click Here >> for more details...
What are the differences between Database Trigger and
Integrity constraints ?
- 2 Answers
- 7590 Views
- Synergy, I also Faced
- E-Mail Answers
Answer Posted / ganesh
Trigger: A set of pl/sql statments that are stored
permenantly in the database it activates when ever the DML
operations performed on the table.
constraints: Set of predefind rules are applied on table
column while creating the table or after creating the
table. and automatically performed when DML statemets are
performed by user.
the main differece between the two is
trigger will not effect the existing rows(it will effects
only new rows after creating a trigger on a table),
where as in the constraints it will effect the existing
rows also.
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What are different types of blocks used in stored procedure?
Is it good to store images in database?
What is a super key?
What does specialization in DBMS mean?
When should you not use firebase?
What is the DIF format and when we will use in teradata
What is ase database?
Differentiate between delete and truncate table?
What is the purpose of firebase?
wHat Is THE difference between MOVEL and MOVEL(P)……….. CAN ANYONE EXPLAIN ME..
WHAT IS CARDINALITIES OF JOIN?
What is meant by distributed system?
What is ole db in ssis?
Difference between sql and mysql?
There are three servers are run by Oracle, MS Access and .Net. What are the procedure fetching the values of two variables from two servers among these?
