What are the differences between Database Trigger and
Integrity constraints ?
- 2 Answers
- 6632 Views
- Synergy, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / nilkantha
I can't find the answer.Pls Give me the right answer
| Is This Answer Correct ? | 1 Yes | 2 No |
Explain normalization in one line?
WHAT IS OPM?(IN DETAILED)
What is the importance of database partitioning?
What is ole db provider for sql server?
What will happen non-clustered index will be created on clustered index?
in informatica workflow has 5 sessions and running seqentially and 3rd session has been failed how can we run again from only 3rd to 5th session
How to do Stored procedure testing? Who does this testing (Developer or tester)?
Its possible to use auto increment in oracle or not? If no means why?
plz suggest me the book for preparation of NIC exam.
Can we use redis as database?
What are the types of indexes that are present inside a database?
How default key is different from primary key?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
