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?
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?
The SQL statement that would create a set difference of the two relations with the widest variety of Structured Query Language dialects is: SELECT * FROM Dept1_Parts WHERE Part_ID NOT IN (SELECT Part_ID FROM Dept2_Parts). This statement uses the NOT IN clause, which is widely supported across different SQL dialects, to filter out rows from Dept1_Parts where the Part_ID exists in Dept2_Parts.
D is the valid exam