ExamGecko
Question list
Search
Search

Question 229 - TDS-C01 discussion

Report
Export

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.
Answers
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.
Answers
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.
Answers
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.
Answers
D.
You have two data sets saved in different formats that you want to unify into a single format.
Suggested answer: A

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

asked 23/09/2024
Ahmed Khalifa
47 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first