Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between column level constraints and
table level constraints?
- 14 Answers
- 86939 Views
- IBM, TCS, I also Faced
- E-Mail Answers
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 are the common oracle dba tasks?
How remove data files before opening a database?
How to manage transaction isolation level?
What is raw datatype in oracle?
Name the various constraints used in oracle?
How to sort output in descending order in oracle?
What is Trigger in Oracle?
How to turn on or off recycle bin for the session?
What is where clause in oracle?
What do you mean by a tablespace?
Explain a data segment?
What is an Oracle Instance?
What is a subquery?
List the parts of a database trigger.
What is a data dictionary and how can it be created?
