Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between column level constraints and
table level constraints?
- 14 Answers
- 87514 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
How to assign query results to variables?
What is java oracle used for?
How do I connect to oracle database?
What happens if you set the sga too low in oracle?
When do you get a .pll extension in oracle? Explain its importance
What is system global area (sga) in oracle?
what's query optimization and without use of IN AND Exist can we get another way data from query
How many file formats are supported to export data?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
How to get execution statistics reports on query statements?
How to convert characters to numbers in oracle?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
What is a system tablespace and when it is created?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
How to create tables for odbc connection testing?
