CompTIA Data+ (DA0-001) — Question 113

Which of the following statements would be used to append two tables that have the same number of columns?

Answer options

• A. UNION ALL
• B. MERGE
• C. GROUP BY
• D. JOIN

Correct answer: A

Explanation

The correct answer is A: UNION ALL, as it is specifically designed to concatenate the results of two tables with the same structure. The other options do not serve this purpose; MERGE is used for combining records based on a key, GROUP BY is for aggregating data, and JOIN is meant for combining rows based on a related column.