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

Get Premium 1D0-541 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Fidelia

3 days ago

Option A? Really? Combining a SELECT with an AND operator? That's not valid SQL syntax, is it? Looks like a trick question to me.

upvoted 0 times

...

Fernanda

9 days ago

Hmm, I don't know. Option C looks like it might have a typo. Shouldn't it be `Dept1_Parts.Part_ID = Dept2_Parts.Part_ID` instead of the other way around?

upvoted 0 times

...

1 months ago

I think the answer is B.

upvoted 0 times

...