PrepAway - Latest Free Exam Questions & Answers

Which of the following SQL statements would create a set difference of the two relations with the widest varie

Consider the Dept1_Parts and Dept2_Parts relations shown in the exhibit. Which of the following
SQL statements would create a set difference of the two relations with the widest variety of
Structured Query Language dialects?

PrepAway - Latest Free Exam Questions & Answers

A.
SELECT * FROM
Dept1_Parts
EXCEPT(SELECT
PartJD FROM
Dept2_Parts);

B.
SELECT * FROM
Dept1_Parts MINUS
(SELECT Part_ID
FROM Dept2_Parts);

C.
SELECT * FROM
Dept1_Parts
DIFFERENCE
(SELECT Part_ID
FROM Dept2_Parts);

D.
SELECT * FROM
Dept1_Parts WHERE
Part_ID NOT IN
(SELECT Part_ID FROM
Dept2_Parts);


Leave a Reply