Câu 21: 1D0-541: CIW v5 Database Design Specialist

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?

1. A. SELECT * FROM Dept1_Parts EXCEPT(SELECT PartJD FROM Dept2_Parts);
2. B. SELECT * FROM Dept1_Parts MINUS (SELECT Part_ID FROM Dept2_Parts);
3. C. SELECT * FROM Dept1_Parts DIFFERENCE (SELECT Part_ID FROM Dept2_Parts);
4. D. SELECT * FROM Dept1_Parts WHERE Part_ID NOT IN (SELECT Part_ID FROM Dept2_Parts); — đáp án hiện tại