1
What is a business key in MySQL?
Explanation:
2
Can you explain what a natural key is?
Explanation:
3
What is a candidate key?
Explanation:
4
How do you differentiate between a business key and a surrogate key?
Explanation:
5
Why might you choose to use a natural key over a surrogate key?
Explanation:
6
Can you give an example of a candidate key that is not a primary key?
Explanation:
7
How can the use of natural keys impact database performance?
Explanation:
8
Describe a scenario where using a business key might lead to issues in a database system.
Explanation:
9
How would you handle a situation where a natural key needs to change?
Explanation:
10
During a database certification exam, you are asked to explain the importance of choosing the correct candidate key. What would be your response?
Explanation: