Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between column level constraints and
table level constraints?
- 14 Answers
- 87417 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / adinarayana
COLUMN LEVEL
1.Column level constraints can be defined along with the
columns.
2.NOT NULL constraints can be defined at this level(to only
one column).
3.Composite keys can't be defined at this level
TABLE LEVEL
1.Table level constraints can be defined after defining the
all columns
2.NOT NULL constraints can't be defined at this level.
3.Composite key can be defined at this level
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Explain the truncate in oracle?
What are the types of trigger in oracle?
How to assign a tablespace to a users in oracle?
What is a table in oracle?
What is the parameter mode that can be passed to a procedure?
How to connect to the server with user account: sys?
State some uses of redo log files?
How to shutdown your 10g xe server?
What is a database table in oracle?
What is the exact use of Collections?
Explain the difference between a procedure and a function? What do you understand by those terms?
What is a system tablespace?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
How to upsert (update or insert into a table)?
what are archived logs?
