Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between column level constraints and
table level constraints?
- 14 Answers
- 87989 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 bitmap indexes? How does they work?
How to get maxsal , minsal, ename department wise in single query
What are the various oracle database objects?
How many types of segments in Oracle?
How to convert a date to char in oracle? Give one example.
How to create a new table by selecting rows from another table?
In which language oracle has been developed?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
What do you mean by a tablespace?
What is instant client oracle?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
What happens if you set the sga too low in oracle?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
How to resolve the ORA-39133 error in Oracle?
Can we store pictures in the database and if so, how it can be done?
