Which Type of Merge Statement Only Combines Rows That Exist

question 24

Multiple Choice

Which type of merge statement only combines rows that exist in two result sets?

• A)UNION
• B)EXCEPT
• C)INTERSECT
• D)JOIN

---

Definitions:

Semi-Autonomous Responsibility

The granting of partial autonomy and control to employees or teams over their work and decision-making processes.

Formalization

The extent to which rules, procedures, and standards are written and explicitly articulated within an organization.

Duplication

The act of making an exact copy of something, often used in the context of data replication or the reproduction of research results for validation.

Underutilization

The situation where resources, such as personnel, equipment, or capacity, are not being used to their full potential.