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...

What are the differences between Database Trigger and
Integrity constraints ?

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 set operators in sql?

1136


What are triggers in sql?

1059


Which type of cursor is used to execute the dml statement?

995


Explain the difference between sql and mysql.

1112


Why do we need cursors in pl sql?

1155


How can you save or place your msg in a table?

1039


Is sql a backend?

1071


What are the three pl sql block types?

1049


Differentiate between % rowtype and type record.

1390


What are the different types of triggers?

1191


How to execute a stored procedure?

1155


What is a rank in sql?

1005


What is a schema? How is it useful in sql servers?

1174


Which join is default?

1013


how to calculate the difference between two dates? : Sql dba

1113