Which of the following situations describe the best reason to use a union?
A.
You have two tables with similarly named columns of data that you want to combine.
B.
You have two data sets with similar data types for which you want to find only distinct values.
C.
You have two tables with differently named columns of data that you want to combine.
D.
You have two data sets saved in different formats that you want to unify into a single format.
The Answer Is:
A
This question includes an explanation.
Explanation:
You should use a union when you have two tables with similarly named columns of data that you want to combine. A union is a method for combining data by appending rows of one table onto another table. The tables that you union must have the same number of fields, the same field names, and the same data types2
TDS-C01 PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 75% Discount on All Products,
Use Coupon: "ac75sure"