CIW Exam 1D0-541 Topic 8 Question 42 Discussion

Actual exam question for CIW's 1D0-541 exam

Question #: 42
Topic #: 8

Consider the Dept1_Parts and Dept2_Parts relations shown in the exhibit. Which of the

following SQL statements would create an intersection of the two relations with the widest variety

of Structured Query Language dialects?

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

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

CSELECT *
FROM Dept1_Parts
WHERE Dept1_Parts.Part_ID = Dept2_Parts.Part_ID;

DSELECT *
FROM Dept1_Parts
WHERE Dept1_Parts.Part_ID = Dept2_Parts.Part_ID;

Show Suggested Answer

Suggested Answer: D

by Zona at May 08, 2022, 04:51 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!