MENU
Which clause should you use in a select statement to combine rows in one table with rows in another table?
Suggested Answer: A
Get Premium DP-900 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
27 comments · newest first
GA
Gary
11 months ago
A is the standard, no doubt about it!
UL
Ulysses
11 months ago
Wait, are we sure JOIN is the only option? Seems too simple.
JO
Jodi
11 months ago
A is correct, but why do people still confuse it with KEY?
ET
Ettie
12 months ago
I thought it was VALUES at first, but JOIN makes more sense.
AG
Agustin
12 months ago
Definitely A, JOIN is the way to go!
KA
Kassandra
1 year ago
I definitely recall that JOIN is the standard way to combine rows. I hope that’s the correct answer!
OL
Oliva
1 year ago
I’m a bit confused because VALUES sounds familiar too, but I don’t think it’s for combining tables.
KE
Kenny
1 year ago
I remember that JOIN is used to combine rows from different tables. It seems like the right choice here.
CA
Catalina
1 year ago
I think the answer might be JOIN, but I’m not completely sure. We did practice some similar questions in class.
SH
Shannan
1 year ago
I'm a little confused by this question. The options don't seem to match the wording of the question very well. But I think A. JOIN is the best answer based on my understanding of SQL.
HE
Herman
1 year ago
Okay, let me think this through step-by-step. The question is asking which clause we use to combine rows from one table with rows in another table. That sounds like a JOIN operation, so I'm going to go with A. JOIN.
AA
Aaron
1 year ago
Hmm, I'm a bit unsure about this one. I know we use JOIN to combine tables, but I can't remember if that's the exact wording they're looking for. I'll have to think this through carefully.
CH
Chery
1 year ago
I'm pretty sure the answer is A. JOIN is the clause used to combine rows from multiple tables in a SELECT statement.
FA
Fabiola
1 year ago
I'm not sure about option D (a value containing the collection name). That doesn't seem like it would be a good partition key since the workload needs to be spread evenly.
LY
Lynelle
2 years ago
I'll just use the COMBINE clause. That's a real SQL keyword, right? *wink wink*
DY
Dylan
1 year ago
User 3: The COMBINE clause is not a real SQL keyword, you should use JOIN instead.
VI
Virgie
1 year ago
User 2: Yeah, JOIN is the correct clause for that.
DA
Dalene
1 year ago
User 1: You should use JOIN in a select statement to combine rows in one table with rows in another table.
JE
Jesusita
2 years ago
SET? That's for updating columns, not joining tables. I think the exam writer needs to go back to SQL 101.
JE
Jenelle
2 years ago
KEY? Really? That's not even close. Maybe they're testing our database design knowledge instead of our SQL skills.
ST
Stephaine
2 years ago
I thought the VALUES clause was for inserting new rows, not combining them. Guess I need to brush up on my SQL basics.
KY
Kyoko
2 years ago
You're right, the JOIN clause is used to combine rows from different tables in a select statement.
ME
Merilyn
2 years ago
A) JOIN
ET
Ettie
2 years ago
The JOIN clause is definitely the correct answer here. It's the bread and butter of combining data from multiple tables.
JO
Josephine
2 years ago
I'm not sure, but I think it's C) set because it sounds like it could be used for combining rows.
NA
Nan
2 years ago
I agree with Samuel, JOIN is used to combine rows from different tables.
SA
Samuel
2 years ago
I think the answer is A) JOIN.