Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between column level constraints and
table level constraints?
- 14 Answers
- 86854 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
State and explain about oracle instance?
What are the limitations oracle database 10g xe?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
How to change program global area (pga) in oracle?
What is parameterized cursor in oracle?
Explain the function of optimizer in oracle?
Explain the use of indexes option in imp command.
What is the difference between PFILE and SPFILE in Oracle?
How to omit columns with default values in insert statement in oracle?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
What are the attributes of cursor?
Can we commit inside a function in oracle?
What is the difference between primary key and unique key and foreign key in oracle?
How to fetch the row which has the max value for a column?
How to empty your oracle recycle bin?
