Question

Purpose of foreign key constraint in SQL Server is __________

(a) FOREIGN KEY constraints identify and enforce the relationships between tables

(b) A foreign key in one table points to a candidate key in another table

(c) You cannot insert a row with a foreign key value, except NULL, if there is no candidate key with that value

(d) None of the mentioned

This question was addressed to me by my school principal while I was bunking the class.

I want to ask this question from Constraints in chapter Manipulating Data with Select of SQL Server

Answer 1

Right choice is (a) FOREIGN KEY constraints identify and enforce the relationships between tables

Best explanation: Foreign key is to enforce referential integrity.