MENU
Which keyword can be used to combine two results into one table?
Suggested Answer: A
Get Premium Data Management - Foundations (D426) Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
The UNION keyword in SQL is used to combine the results of two or more SELECT queries into a single result set while removing duplicate rows.
Example:
sql
SELECT Name FROM Employees
UNION
SELECT Name FROM Managers;
Option A (Correct): UNION combines results from multiple queries into one set, removing duplicates.
Option B (Incorrect): MERGE is not a valid SQL keyword for combining result sets (it is used in some database systems for data merging).
Option C (Incorrect): INTEGRATE is not a SQL keyword.
Option D (Incorrect): CONSOLIDATE is not an SQL keyword.
12 comments · newest first
LA
Lashawn
2 months ago
I feel confident about A) UNION too. It’s widely used in SQL.
SH
Shaun
2 months ago
Agreed, A) UNION is the standard term.
SH
Sharita
2 months ago
I think it's A) UNION. It makes sense.
MO
Mollie
2 months ago
I agree with UNION, it's the standard way!
IO
Iola
2 months ago
Wait, is it really A? Sounds too simple.
EA
Earnestine
2 months ago
A) UNION is the right answer, no doubt!
DA
Dahlia
3 months ago
I thought it was B) MERGE.
VI
Victor
3 months ago
Definitely A) UNION!
OL
Ollie
3 months ago
I’m torn between A) UNION and D) CONSOLIDATE. I remember both terms being discussed, but I can't recall which one is correct.
SU
Suzan
3 months ago
I’m pretty confident it’s A) UNION. We practiced combining tables in our last class, and that term came up a lot.
CH
Cherilyn
3 months ago
I feel like I saw something similar in our last review session. Was it A) UNION or was it B) MERGE?
LO
Lorenza
4 months ago
I think the answer might be A) UNION, but I'm not entirely sure. I remember it being used in practice questions.