What is the difference between column level constraints and
table level constraints?
- 14 Answers
- 84777 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / pcsenthil
we can achive all type of constraint in both level but we
cannot use NOT NULL in table Level, the reason was "All
Constraint will give logical view to that particular column
but NOT NULL will assign to the structure of the table
itself.. that's why we can see NOT NULL constraint while
Describe the table, no other constraint will be seen.
| Is This Answer Correct ? | 17 Yes | 5 No |
Post New Answer View All Answers
Explain integrity constraint?
Point out the difference between user tables and data dictionary?
How to pass parameters to procedures in oracle?
Differentiate between translate and replace?
How do I reset a sequence in oracle?
How to import one table back from a dump file?
What are the different types of trigger and explain its various uses and functions?
What is a trigger and what are its types in oracle?
What is index in Oracle?
What is the data pump export utility?
What suggestions do you have to reduce the network traffic?
What are the uses of linked server and explain it in detail?
What is a view and how is it different from a table?
How do we get field details of a table?
What are the different types of database objects?
