Database Developer Question:
Download Job Interview Questions and Answers PDF
Tell us what is the difference between UNIQUE and PRIMARY KEY constraints?
Answer:
There should be only one PRIMARY KEY in a table whereas there can be any number of UNIQUE Keys.
PRIMARY KEY doesn’t allow NULL values whereas Unique key allows NULL values.
PRIMARY KEY doesn’t allow NULL values whereas Unique key allows NULL values.
Download Database Developer Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Explain me what are SQL constraints? | Tell us what is a DEFAULT constraint? |