Month End Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: simple70

CompTIA DataSys+ Certification Exam DS0-001 Question # 32 Topic 4 Discussion

CompTIA DataSys+ Certification Exam DS0-001 Question # 32 Topic 4 Discussion

DS0-001 Exam Topic 4 Question 32 Discussion:
Question #: 32
Topic #: 4

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.

IINTERSECT


D.

CROSS JOIN


Get Premium DS0-001 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.