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

Exam DS0-001 All Questions

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

Exam DS0-001 topic 1 question 19 discussion

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

A database administrator is migrating the information in a legacy table to a newer table. Both tables contain the same columns, and some of the data may overlap.
Which of the following SQL commands should the administrator use to ensure that records from the two tables are not duplicated?

  • A. UNION
  • B. JOIN
  • C. INTERSECT
  • D. CROSS JOIN
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by Pete9972 at April 26, 2024, 6:51 a.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
Pete9972
8 months ago
Selected Answer: A
The UNION operator is used to combine the result-set of two or more SELECT statements. - Every SELECT statement within UNION must have the same number of columns - The columns must also have similar data types - The columns in every SELECT statement must also be in the same order The UNION operator selects only distinct values by default, thereby preventing duplicate records.
upvoted 2 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