What is the Diff b/w Constraints and Trigeer

Answer Posted / mohanbabu

Constraints are used to limit the type of data that can go
into a table.
Constraints can be specified when a table is created or
after the table is created.

A trigger is a fragment of code that you tell Oracle to run
before or after table is modified.

Is This Answer Correct ?    13 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is multiple columns?

775


What is autocommit sql?

706


What is minus?

754


What is the use of index in hive?

727


What is sql architecture?

744






What is set transaction?

764


What is sql lookup?

683


What are the subsets of sql?

752


Why do we go for stored procedures?

729


what is a view? : Sql dba

811


What is the usage of when clause in trigger?

759


What are schema-level triggers?

756


what is try_catch block in procedure

1390


Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3308


how to enter binary numbers in sql statements? : Sql dba

702