Your question is Understanding Foreign Key Constraints. Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
What is a foreign key constraint in SQL? Explain its purpose, how it maintains referential integrity, and provide examples of its implementation in a relational database.
The interviewer expects a clear understanding of foreign key constraints, including their definition, use cases, and potential pitfalls in database design.