Capgemini Engineering interview question

Q: Query involving Foreign Key constraint in SQL.