Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 14930 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / chandrasekar.ramasamy
A table can have compite primarykey but only one unique
constraint
| Is This Answer Correct ? | 0 Yes | 15 No |
Post New Answer View All Answers
Can you do multiple joins in sql?
What is break?
Why is there a need for sqlcode and sqlerrm variables?
What is restrict in sql?
what is denormalization. : Sql dba
What is partition in sql query?
What do you understand by pl/sql records?
what is the difference between a having clause and a where clause? : Sql dba
Explain the difference between triggers and constraints?
Which kind of parameters cannot have a default value in pl sql?
How many types of keys are there in sql?
Show code of a cursor for loop.
Where is sql database stored?
Can you upgrade sql express to full sql?
Why is normalization important?
