Question

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? UNION JOIN INTERSECT UNION ALL

Answer 1

"UNION" is the answer for the above question.

Step-by-step explanation:

• The Union is a keyword which gives the result after merging the one or more table excluding the duplicate value.
• The above question wants an unduplicated value from the two tables. SO the union is an operator which gives this type of result. Hence the "Union" is the correct answer. While the other is not because:-

1. The "Union all" operator is also used to find the record of one or more tables, but it includes the duplicate value and the duplicate value is not needed in the above question.
2. The "Join" is also used to find the record of one or more tables, but it produces the record on the behalf of some keys.
3. The "intersect" is used to find the common record or duplicate record from the two or more tables.