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

Dorothy

7 days ago

I'm not sure about that. Option D seems more portable to me. The WHERE clause with the equality comparison is a more basic SQL construct that should work across a wider range of database systems.

upvoted 0 times

...

Sue

9 days ago

Option B looks like the way to go. The INTERSECTION keyword is supported by most SQL dialects, including SQL Server, Oracle, and PostgreSQL.

upvoted 0 times

...

Diane

9 days ago

Why do you think C is the correct answer?

upvoted 0 times

...

Veronique

11 days ago

I disagree, I believe the answer is C.

upvoted 0 times

...

Diane

12 days ago

I think the answer is B.

upvoted 0 times

...