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.
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
Explain what is a field in a database and record in a database?
how to increment dates by 1 in mysql? : Sql dba
What is indexing oracle sql?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
What is scope and visibility in PL/SQL?
what is normalization? : Sql dba
What are the limitations of sql express?
What is a database trigger?
What is an ndf file?
What is out parameter used for eventhough return statement can also be used in pl/sql?
Explain raise_application_error.
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
Do stored procedures prevent sql injection?
What's the procedure?
How do I count rows in sql?