ExamTopics Logo
Mail Us[email protected]
Menu
Comptia Discussions
exam questions

Exam DA0-001 All Questions

View all questions & answers for the DA0-001 exam
Go to Exam

Exam DA0-001 topic 1 question 117 discussion

Actual exam question from CompTIA's DA0-001
Question #: 117
Topic #: 1
[All DA0-001 Questions]

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

  • A. UNION ALL
  • B. MERGE
  • C. GROUP BY
  • D. JOIN
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by Swift_and_Quick at April 16, 2024, 11:22 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Swift_and_Quick
8 months, 2 weeks ago
A. UNION ALL. The UNION ALL statement combines the results of two SELECT queries into a single result set by appending the rows of one table to the rows of another table. It's important to note that UNION ALL requires that the tables have the same number of columns and compatible data types.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel