What is the difference between column level constraints and
table level constraints?
- 14 Answers
- 82818 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 blob datatype?
Difference between the “verify” and “feedback” command?
Which is better Oracle or MS SQL? Why?
What happens to the current transaction if a ddl statement is executed?
How to connect to the server with user account: sys?
what is reindexing?
How to best split csv strings in oracle 9i?
What are the predefined tablespaces in a database?
What is blob data type in oracle?
What is an oracle recycle bin?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
Explain self joins in oracle?
Is postgres faster than oracle?
How to get the Installed Oracle Version Information ?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
