Interested to Buy Any Domain ? << Click Here >> for more details...
What are the differences between Database Trigger and
Integrity constraints ?
- 2 Answers
- 7474 Views
- Synergy, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
1. How to test Database? Please, give me all details for "SQL,Msaccess, Mysql Database? 2.For which functionalities database used? 3.How to convert Guest to Admin by Mysql database?
What are different types of resources?
Give the syntax of exception handling used in DBMS?
What is the difference between a stored procedure and a query?
What is a database lookup?
What is the purpose of firebase?
i have windows-xp processor with P4 system. whenever I tried to download foxpro for windows 2.6 on windows XP, my operating system failed to install foxpro for windows 2.6.please. how could i download , install & run foxpro for windows 2.6 easily on windows XP ?
What are the concurrency problems a database faces?
what are wrappers and build ups and what it's use?
Explain database partitioning.
What is the use of default key?
What happens when shared and exclusive locks are applied on data item?
HOW PASS PARAMETERS FOLLOWING ORDER RPG-CL-RPG?
What are the advantages of normalizing a database.
Explain normalization in one line?
