What are the differences between Database Trigger and Integrity constraints ?

What are the differences between Database Trigger and
Integrity constraints ?

Question Posted / nilkantha

2 Answers
6691 Views
Synergy, I also Faced
E-Mail Answers

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

what is tkprof tool and how it is used???

0 Answers Genpact,

what are wrappers and build ups and what it's use?

0 Answers TCS,

Hi, I want do a course in DWH Informatica Administrator and Abinito Administrator please tell me some institute in chennai and i am searching for a job,so please help me and my mail id : satty_rh@yahoo.co.in Thanks, Kumar

0 Answers

WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?

0 Answers Wipro,

What the various ways to tune a teradata query

0 Answers

write a query for the fifth highest salary?

17 Answers IBM, Matlabs, Ramco,

Explain natural key?

0 Answers

Explain about ur projets on teradata???

0 Answers Wipro,

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