Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


What are the differences between Database Trigger and
Integrity constraints ?

Answers were Sorted based on User's Feedback



What are the differences between Database Trigger and Integrity constraints ?..

Answer / 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

What are the differences between Database Trigger and Integrity constraints ?..

Answer / nilkantha

I can't find the answer.Pls Give me the right answer

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More Databases AllOther Interview Questions

Explain entity ?

0 Answers  


What is the difference between database and server?

0 Answers  


characters of DBMS A) non redundant B) data independence C) increased security D) all the above

1 Answers   Accenture, XP,


After normalization, what are the conditions which have to keep in mind to de-normalize it?

0 Answers   C DAC, CDAC,


What is a trace file?

0 Answers   Tech Mahindra,






What is a driver in database?

0 Answers  


Can you tell any two advantages of stored procedures?

0 Answers   Verifone,


What are the tools used for backup and ticketing?

0 Answers   Alcatel-Lucent,


WHAT TYPE OF JOINS RETURNS INCORRECT RESULTS?

2 Answers   HP,


You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?

0 Answers   3i Infotech,


How is image stored in database?

0 Answers  


What is difference between server and database?

0 Answers  






Categories