What is the difference between column level constraints and
table level constraints?
- 14 Answers
- 82796 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
Can we connect to ORACLE db using Windows Authentication?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
How to establish administrator authentication to the server?
State some uses of redo log files?
Explain view?
How to use subqueries with the exists operator in oracle?
How to see free space of each tablespace?
What are ddl statements in oracle?
What is max rowid in oracle?
Explain rename?
What is a proxy object?
What is the difference between online and offline backups?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
What is merge in oracle?
What is rich query?
