Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between column level constraints and
table level constraints?
- 14 Answers
- 87402 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / vijay
1)Column level constraint is declared at the time of
creating a table but table level constraint is created
after table is created.
2)NOT NULL constraint can't be created at table level.
3)Composite primary key must be declared at table level.
4)All the constraints can be created at table level but for
table level NOT NULL is no allowed.
| Is This Answer Correct ? | 48 Yes | 25 No |
Post New Answer View All Answers
What is meant by an index?
How can we find out the current date and time in oracle?
Why use resource manager in Oracle?
How do I limit the number of oracle database connections generated by weblogic server?
Is oracle an open source?
How to get last row id?
How to insert multiple rows with one insert statement in oracle?
What is catalog in Oracle?
What is a lookup table in oracle?
How to write a query with a left outer join in oracle?
How to use in conditions in oracle?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
What are the various oracle database objects?
Can select statements be used on views in oracle?
What is a database schema in oracle?
