CompTIA
DS0-001 · Question #19
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 sh
Sign in or unlock DS0-001 to reveal the answer and full explanation for question #19. The question stem and answer options stay visible for context.
Database Fundamentals
Question
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?
Options
- AUNION
- BJOIN
- CINTERSECT
- DCROSS JOIN
Unlock DS0-001 to see the answer
You've previewed enough free DS0-001 questions. Unlock DS0-001 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#SQL Commands#Set Operators#Data Migration#Duplicate Data Handling