Suppose tables EMPLOYEE and CUSTOMER both store address information,and you want to send a letter to all employees and customers of your company to make a major announcement.Which SQL keyword would you most likely use here?
A)INTERSECT
B)UNION
C)UNION ALL
D)JOIN

Question

Quizplus · Accepted Answer

The UNION keyword combines the results of two or more SELECT statements, removing duplicates. In this case, we want to send a letter to both employees and customers, so we would use UNION to combine the address information from both tables. We do not need to use UNION ALL since we do not want to include duplicate addresses in the mailing. The JOIN and INTERSECT keywords are not relevant in this scenario as they relate to combining data in a different way.

Suppose Tables EMPLOYEE and CUSTOMER Both Store Address Information,and You