CIW Exam 1D0-541 Topic 2 Question 86 Discussion

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

Question #: 86
Topic #: 2

[All 1D0-541 Questions]

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 Loreta at Apr 26, 2024, 08:15 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

8 hours ago

I disagree, I believe the answer is C.

upvoted 0 times

...

1 days ago

I think the answer is B.

upvoted 0 times

...