What is the difference between UNIQUE CONSTRAINT and
PRIMARY KEY?
1. There is no difference.
2. A PRIMARY KEY cannot be declared on multiple columns.
3. A UNIQUE CONSTRAINT cannot be declared on multiple
columns.
4. A table can have multiple PRIMARY KEYS but only one
UNIQUE CONSTRAINT.
5. A table can have multiple UNIQUE CONSTRAINTs but only
one PRIMARY KEY.
- 7 Answers
- 13006 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / sdp
A table can have multiple UNIQUE CONSTRAINTs but only
one PRIMARY KEY.
| Is This Answer Correct ? | 21 Yes | 1 No |
Post New Answer View All Answers
What are hotfixes and patches?
What is the current version of postgresql?
What is the purpose of cursors in pl/sql?
What is sqlservr exe?
what is the difference between char and varchar data types? : Sql dba
What is the advantage of index in sql?
What is the difference between function and procedure in pl/sql?
How do you know if a relationship is 2nf?
What is dense_rank?
Why primary key is required?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
How can a function retun more than one value in oracle with proper example?
Can there be more than one function with a similar name in a pl/sql block?
What is type and rowtype in pl sql?
What are the types of subqueries?
