PrepAway - Latest Free Exam Questions & Answers

which of the following is true?

When defining a referential constraint between the parent table T2 and the dependent table T1,
which of the following is true?

PrepAway - Latest Free Exam Questions & Answers

A.
The list of column names in the FOREIGN KEY clause can be a subset of the list of column
names in the primary key of T2 or a UNIQUE constraint that exists on T2.

B.
The list of column names in the FOREIGN KEY clause can be a subset of the list of column
names in the primary key of T1 or a UNIQUE constraint that exists on T1.

C.
The list of column names in the FOREIGN KEY clause must be identical to the list of column
names in the primary key of T2 or a UNIQUE constraint that exists on T2.

D.
The list of column names in the FOREIGN KEY clause must be identical to the list of column
names in the primary key of T1 or a UNIQUE constraint that exists on T1.

2 Comments on “which of the following is true?


Leave a Reply