Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

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?

Show Suggested Answer Hide Answer
Suggested Answer: D

Contribute your Thoughts:

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
...
Dorothy
25 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
Valentin
8 days ago
But what about Option B? Wouldn't using the INTERSECTION keyword be more efficient?
upvoted 0 times
...
Sabra
9 days ago
I agree, the WHERE clause with the equality comparison is a safer bet for compatibility.
upvoted 0 times
...
Clarence
12 days ago
Option D is definitely more portable. It's a basic SQL construct that should work on many systems.
upvoted 0 times
...
...
Sue
27 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
27 days ago
Why do you think C is the correct answer?
upvoted 0 times
...
Veronique
29 days ago
I disagree, I believe the answer is C.
upvoted 0 times
...
Diane
1 months ago
I think the answer is B.
upvoted 0 times
...

Save Cancel