Interested to Buy Any Domain ? << Click Here >> for more details...
What are the differences between Database Trigger and
Integrity constraints ?
- 2 Answers
- 7608 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 |
What do you mean by foreign key and primary key?
How to shrink a database?
How do you select an index for a table
List various types of log-based recovery in DBMS.
a __________ is a virtual table made up of subset of actual table
What is database collection?
Can you tell any two advantages of stored procedures?
Explain data independence & its types.
What is odm in database?
What is the difference between oracle and MS Access?
What is meant by distributed system?
I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
