What is the difference between column level constraints and
table level constraints?
- 14 Answers
- 88328 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / adinarayana
COLUMN LEVEL
1.Column level constraints can be defined along with the
columns.
2.NOT NULL constraints can be defined at this level(to only
one column).
3.Composite keys can't be defined at this level
TABLE LEVEL
1.Table level constraints can be defined after defining the
all columns
2.NOT NULL constraints can't be defined at this level.
3.Composite key can be defined at this level
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
How to start an oracle instance?
How to write a left outer join with the where clause in oracle?
How to select all columns of all rows from a table in oracle?
How to put more than 1000 values into an oracle in clause?
What is oracle latest version?
How to use values from other tables in update statements using oracle?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
Design database draw er diagram for a certain scenario ?
