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
List various types of log-based recovery in DBMS.
Explain various types of locks in a transaction? Which is better and why?
Explain inner and outer joins with examples.
Is hive a database?
A lowest level of security by most RDBMS is
What is odm in database?
What is ole db in ssis?
Can you create a database in word?
What is difference between data and database?
How many types of locks are present in a database?
What are the types of indexes that are present inside a database?
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 ?
5. Explain about relational algebra.
Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.
What are the most common databases?