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
- 12990 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / radhika
A table can hava multiple Unique constraints but only one
primary key.
| Is This Answer Correct ? | 16 Yes | 1 No |
Post New Answer View All Answers
What is rownum in sql?
What is rtm in testing?
Explain some predefined exceptions.
What is sql select statement?
Explain isolation levels. : Transact sql
How do I save a stored procedure?
Inline the values in PL/SQL, what does it mean.?
Does view contain data?
Is sql open source?
Explain about various levels of constraint.
What are pl sql data types?
What is indexing in sql and its types?
What is out parameter used for eventhough return statement can also be used in pl/sql?
What do you mean by query optimization?
How do you use collections in procedure to return the resultset?
