Capgemini Engineering Interview Question

Q: Query involving Foreign Key constraint in SQL.