WGU Data-Management-Foundations Question Answer
Which keyword can be used to combine two results into one table?
UNION
MERGE
INTEGRATE
CONSOLIDATE
TheUNIONkeyword in SQL is used tocombine the resultsof two or more SELECT queries into asingle result setwhile removing duplicate rows.
Example:
sql
SELECT Name FROM Employees
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 insome database systems for data merging).
Option C (Incorrect):INTEGRATE is not a SQL keyword.
Option D (Incorrect):CONSOLIDATE is not an SQL keyword.
TESTED 01 Jan 2026
Copyright © 2014-2026 ACE4Sure. All Rights Reserved