What is the difference between column level constraints and
table level constraints?
- 14 Answers
- 84776 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 are the limitations of check constraint?
How to connect ms access to oracle servers?
Why is oracle database so popular?
Can you tell me how to add new column in existing views?how?How is possible?
How to test null values?
Can you have more than one content canvas view attached with a window ?
What is rowid and rownum in oracle?
what is the scripts in data base?
Is java required for oracle client?
What are the parameters that we can pass through a stored procedure?
Explain the use of record option in exp command.
Explain cascading triggers.
How to create a table interactively?
How to pass parameters to procedures?
What is the maximum number of triggers that can be applied to a single table?
