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
what is the difference between substr and instr function in oracle?
Respected sir, Please send me technical questions related to oracle apps..
What are the arithmetic operations?
When do we use group by clause in a sql query?
What are advantages of dateset in datastage?
Explain cascading triggers.
What privilege is needed for a user to create tables in oracle?
What is an oracle transaction?
Explain an integrity constrains?
Explain an index segment?
What are the different types of synonyms?
How to drop a stored procedure in oracle?
How can I create database in oracle?
Explain the use of consistent option in exp command.
What is a data dictionary and how can it be created?