1. Categories >> Software >> Databases >> Databases AllOther
  2. Suggest New Category

What are the differences between Database Trigger and
Integrity constraints ?

Question Posted / nilkantha

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

How do database connections work?

0 Answers  

How do you pass parameter in stored procedure?

0 Answers   CGI,

A lowest level of security by most RDBMS is

0 Answers   Baan Infotech,

Data structure used to implements a menu:

0 Answers   Verifone,

How do I manually create a database?

0 Answers  




Explain entity set?

0 Answers  

what is meant by Dynamic query?

3 Answers   Satyam,

How many types of normalization? What is the use of it?

0 Answers   Accenture,

plz suggest me the books for the preparation of NIC written exam.

4 Answers   NIC, Rolta,

How do I setup a database connection?

0 Answers  

Give the syntax of exception handling used in DBMS?

0 Answers   C DAC, CDAC,

Differentiate between delete and truncate table?

0 Answers  

For more Databases AllOther Interview Questions Click Here
Categories