Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between column level constraints and
table level constraints?
- 14 Answers
- 87986 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 recursive hints in oracle?
How do I limit the number of oracle database connections generated by weblogic server?
Explain oracle insert into command?
What happens to the data files if a tablespace is dropped?
Explain an index?
Explain the importance of .pll extension in oracle?
what is port in oracle? how is it related to database application.
How to install oracle database 10g xe?
Is insert autocommit in oracle?
What are the ways tablespaces can be managed and how do they differ?
How to create a stored program unit?
What are the uses of synonyms?
What is set operator oracle?
How to rename an index?
What are the various oracle database objects?
