adspace


What is the difference between column level constraints and
table level constraints?

Answer Posted / rahulnayan007@gmail.com

clc = column level constraints
tlc = table level constraints

a) tlc do not support null constraint but clc do.
b) tlc can be used to construct composite keys but clc can't.
c) tlc and clc,using both we can assign names to consraints . being applied to any column.
d)

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to start an oracle instance?

1103


How to write a left outer join with the where clause in oracle?

1156


How to select all columns of all rows from a table in oracle?

1132


Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1956


How to use values from other tables in update statements using oracle?

1158


How to put more than 1000 values into an oracle in clause?

1115


Design database draw er diagram for a certain scenario ?

4656


What is oracle latest version?

1174