What are the differences between Database Trigger and
Integrity constraints ?
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
What are the advantages of using database?
Explain the table term used in database.
What is redis good for?
Can you tell any two advantages of stored procedures?
What is the difference between data source and database?
What is the advantage of varchar2 over char?
What are different types of blocks used in stored procedure?
What is a database connection string?
How to implement database security?
Explain file manager?
What does new grouping sets enables you to do?
What is a Transformation?
define primary key index, bitmap index, hash index,virtual indwx
i applied prompt on country when i run report it shows list of all countries but want it to show only four countries name
Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid: