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

question 37

Multiple Choice

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

---

Definitions:

Condenses

The process by which a substance changes from a gaseous state to a liquid state.

Low-pressure Cells

Areas in the Earth's atmosphere where the air pressure is lower than that of the surrounding regions, often associated with wet weather conditions.

Predominant Natural Vegetation

The most common type of wild plants growing in a particular region without human intervention.

Climate

The average weather conditions of a region over a long period, typically including temperature, precipitation, humidity, and seasons.