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?
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);