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 >> SQL PLSQL
  2. Suggest New Category

What are the differences between Database Trigger and
Integrity constraints ?

Question Posted / santu sarkar

Answer Posted / santu sarkar

1> A database trigger is written in PL/SQL. Integrity Constraints are CHECK Constraints, Not NULL, Unique key, primary key and foreign key.
2> Trigger will not affect the existing data. Constraint will affect the existing data.

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the advantages of sql ? : Sql dba

1105

What is database white box testing and black box testing?

1155

explain what is mysql? : Sql dba

1126

What are sql indexes?

1039

Are there any features that are decommissioned in 11g that are not present in 11g?

2194

How many tables can you join in sql?

1000

Why is sql*loader direct path so fast?

1138

Can two tables have same primary key?

1018

Explain the update statement in sql

1037

Which is better join or inner query?

1117

What are sql injection vulnerabilities?

1020

How does sql developer connect to oracle database?

1045

Can we call stored procedure in function?

996

What is trigger point?

1051

Which certification is best for sql?

1035