What is the difference between column level constraints and
table level constraints?
- 14 Answers
- 82816 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
How to delete an existing row from a table in oracle?
What are the extensions used by oracle reports?
Can we write dml statement in function in oracle?
What is the string concatenation operator in oracle?
How to manage transaction isolation level?
What is ASM (Automatic Storage Management) in Oracle?
How to convert characters to times in oracle?
State the various uses of dbcc command?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What is partitioned table in Oracle?
How to pass parameters to procedures?
How many types of table in Oracle?
How to connect to the server with user account: sys?
How remove data files before opening a database?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
