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
Answer:A
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
Explanation:Foreign key is to enforce referential integrity.