Purpose of foreign key constraint in SQL Server is __________

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

B) FOREIGN KEY constraints identify and enforce the relationships between tables

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 above

Correct Answer : FOREIGN KEY constraints identify and enforce the relationships between tables

Explanation : Foreign key is to enforce referential integrity.

Top Trending Technologies MCQ's

Machine Learning

Artificial Intelligence

Natural Language Processing

Top Trending Technologies Interview Questions