Microsoft Technology Associate Mta · Free Practice Question Medium
Question 9
You need to write a query that will combine data from two database tables that have a similar structure.
Which command should you use in this query?
-
A
INTERSECT
-
B
JOIN
-
C
TRUNCATE
-
D
UNION
Reveal correct answer
Correct answer: D
Explanation
The UNION operator combines the results of two or more queries into a distinct single result set that includes all the rows that belong to all queries in the UNION. When using the UNION command both queries must return identical columns (names and data types) or common columns.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
