Interested to Buy Any Domain ? << Click Here >> for more details...
What are the differences between Database Trigger and
Integrity constraints ?
- 2 Answers
- 7700 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
What are the advantages of using database?
Design an ETL process( batch job/script)from source to starting that u will not be dependent on the source in the near future?please elobarate details on what are things to consider.if you'd like to do a diagram that will be great.please answer it
Two tables emp(empid,name,deptid,sal) and dept(deptid,deptname) are there.write a query which displays empname,corresponding deptname also display those employee names who donot belong to any dept.
What is dialect in database?
What is Object Oriented model?
can u combine pipeline parallelism and partition parallalism? how and whan?
What is a database string?
Write a query to get maximum and second maximum in oracle?
What is database client?
What the various ways to tune a teradata query
Does facebook use graph database?
What is meant by distributed system?
What is difference between clustered, non-clustered and unique index?
What is the database url?
query to Compare data of two tables between two different Databases(Oracle and SQL Server) Eg., Source Database: Oracle Table: Employee Target Database : SQL Server Table : emp
