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 Part_ID
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
DIFFERENCE
(SELECT Part_ID
FROM Dept2_Parts);