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 is the difference between trigger and constraint?

Question Posted / kulpriya

Answers were Sorted based on User's Feedback



what is the difference between trigger and constraint?..

Answer / kumar jabu

Constraints implements specific conduct or rules on table column like it determines whether field data should be unique,not null ..
But triiger implements rules on systems or application event.
whenever dml occurs that implemented rules been fired.

Is This Answer Correct ?    3 Yes 0 No

what is the difference between trigger and constraint?..

Answer / naga sindhuri

Triggers not apply for existing rows but constraints can
apply for existing rows.

Is This Answer Correct ?    2 Yes 0 No

what is the difference between trigger and constraint?..

Answer / milind chopde

1) Constraints can be used for validation but trigger can be used for complex validation and auditing purpose.
2) Trigger is database object but constraint not.
3) Trigger can be fired on DDL commands but constraints are created or altered using DDL commands.
4) Trigger can be fired on particular event like before/after DML but constraint always check before any data insert or update to table.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

0 Answers  

what are sequences

0 Answers  

How many subqueries can be nested in a statement?

0 Answers  

what is column? : Sql dba

0 Answers  

Give the order of sql select?

0 Answers  

Is left join inner or outer by default?

0 Answers  

What are the types of queries in sql?

0 Answers  

What are the different ddl commands in sql?

0 Answers  

What is nosql db?

0 Answers  

Can you have more than one key in a database?

0 Answers  

Which one of the following pairs of aggregate functions do you use with character fields? 1. COUNT(field) and MAX(field) 2. AVG(field) and COUNT(field) 3. MIN(field) and SUM(field) 4. AVG(field) and MAX(field) 5. COUNT(field) and SUM(field)

6 Answers   HCL,

Explain what is a subquery ?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories