Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between column level constraints and
table level constraints?
- 14 Answers
- 86846 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 save point in oracle database?
What is procedure overloading in oracle?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
What are the different windows events activated at runtime ?
What are dml statements in oracle?
Explain oracle instance.
When do you get a .pll extension in oracle? Explain its importance
How to commit the current transaction in oracle?
What is private procedure oracle?
How to login to the server without an instance?
What are the original export and import utilities?
How to use "in out" parameter properly?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
Can the query output be sorted by multiple columns in oracle?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
