Purpose of foreign key constraint in SQL Server is :

Question

Options:

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: Option A

Submit Your Solution Below and Earn Points !

Next Question

More Questions on This Topic :

Question 1. Which of the following constraint does not enforce uniqueness ? ....

Question 2. The command ________________ such tables are available only within the transaction executing the query, and are dropped....executing the query, and are dropped when the transaction finishes.

Question 3. Which of the following error message will be displayed if ORDER CLAUSE is not mentioned in ROW NUMBER function ? ....

Question 4. Which of the following is the simplest ranking function ? ....

Question 5. Select * from employee where salary>10000 and dept_id=101; Which of the following fields are displayed as output? ....

Chapter 1 - GLOBAL STEEL SCENARIO & INDIAN STEEL INDUSTRY Part 1 : (13-04-2024) INDUSTRY AND COMPANY AWARENESS (ICA)

Direction Sense Test Part 1 Reasoning (Hindi)

Chapter 1 - RMHP / OHP / OB & BP Part 1 : (14-02-2024) GPOE

Cube & Cuboid Part 1 Reasoning (Hindi)

Data Interpretation (DI) Basic Concept Reasoning (Hindi)

Counting Figures Part 1 Counting Of Straight Lines Reasoning (Hindi)

Sail E0 free webinar Webinars

Real Numbers Part 7 Class 10 Maths

Real Numbers Part 1 Class 10 Maths

Polynomials Part 1 Class 10 Maths

DSP Combined 1 Free Revision Test SAIL JO E-0

GPOE / GPA Combined 1 Free Revision Test SAIL JO E-0

BSP Plant Specific Review Test SAIL JO E-0

BSL Combined 1 Free Revision Test SAIL JO E-0

GFM Combined 1 Free Revision Test SAIL JO E-0