How to Answer: What is the difference between a primary key and a unique key?
Advice and answer examples written specifically for a Database Administrator job interview.
24. What is the difference between a primary key and a unique key?
How to Answer
This is your first technical question. Technical questions ask you to define terms or processes used in your profession. The best way to respond to a technical question is to first define the term, describe how it is used, and possibly provide an example. Your answer should be brief and to the point. This enables interviewers to ask follow-up questions if they want to explore the topic in more detail or have a specific interest in it.
Written by William Swansen on October 9th, 2020
Answer Example
"The main difference between a primary and a unique key is that a primary key will accept no null values, whereas a unique key will accept just one null value. Additionally, the primary key will create a clustered index automatically when it is defined, whereas the unique key generates a non-clustered index."
Written by William Swansen on October 9th, 2020