CIW 1D0-541 Exam - Topic 8 Question 42 Discussion

Question

CIW 1D0-541 Exam - Topic 8 Question 42 Discussion

Consider the Dept1_Parts and Dept2_Parts relations shown in the exhibit. Which of thefollowing SQL statements would create an intersection of the two relations with the widest varietyof Structured Query Language dialects?

A) SELECT * FROM Dept1_Parts AND (SELECT * FROM Dept2_Parts);

B) SELECT * FROM Dept1_Parts INTERSECTION (SELECT * FROM Dept2_Parts);

C) SELECT * FROM Dept1_Parts WHERE Dept1_Parts.Part_ID = Dept2_Parts.Part_ID;

Accepted Answer

D) SELECT * FROM Dept1_Parts WHERE Dept1_Parts.Part_ID = Dept2_Parts.Part_ID;

CIW 1D0-541 Exam - Topic 8 Question 42 Discussion

CIW 1D0-541 Exam - Topic 8 Question 42 Discussion

Contribute your Thoughts:

Kaycee

Mozell

Roxane

Kayleigh

Rosio

Xochitl

Mozell