Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

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

1 Answers   Accenture, XP,

How does database replication work?

0 Answers  

What is the database url?

0 Answers  

How to produce such kind of file?

0 Answers   Tech Mahindra,

if we have set auto differencial back up then waht is difference between 1.appen to media 2.over right the existing media

1 Answers   Indian Web Technology,

What are the differences between Database Trigger and Integrity constraints ?

2 Answers   Synergy,

What does currency type mean in database?

0 Answers   Amazon,

Explain entity set?

0 Answers  

What are the most common databases?

0 Answers  

How concurrency problems effect the database?

0 Answers   BirlaSoft,

What is the function of cluster index?

0 Answers   Alcatel-Lucent,

What does specialization in DBMS mean?

0 Answers   BirlaSoft,

For more Databases AllOther Interview Questions Click Here
Categories