What are the differences between Database Trigger and
Integrity constraints ?
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 is the best database?
Write a query to get maximum and second maximum in oracle?
What is the function of cluster index?
What is a database example?
What is redis good for?
how to configure oracle 10g in java1.5 and tell me know how to set class path in system?
Explain various types of locks in a transaction? Which is better and why?
Explain buffer manager?
Explain transaction manager?
How to do Data size testing? Who does this testing (Developer or tester)?
What is aws documentdb?
How many indexes can be created on a table?
Can we use redis as database?
how can we view column head in first page but not in remaining pages?
1. How to test Database? Please, give me all details for "SQL,Msaccess, Mysql Database? 2.For which functionalities database used? 3.How to convert Guest to Admin by Mysql database?