Assume You Are Using the UNION Operator to Combine the Results

question 51

Multiple Choice

Assume you are using the UNION operator to combine the results from two tables with identical structure,CUSTOMER and CUSTOMER_2.The CUSTOMER table contains 10 rows,while the CUSTOMER_2 table contains 7 rows.Customers Dunne and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2 table.How many records are returned when using the UNION operator?

• A) 7
• B) 10
• C) 15
• D) 17

---

Definitions:

Point-of-purchase Display

Marketing or advertising materials placed at retail store locations to catch consumer interest and stimulate impulse buying.

Cognitive Dissonance

The mental discomfort experienced by an individual who holds contradictory beliefs, values, or attitudes, especially in relation to behavioral decisions and attitude change.

Alternative Evaluation

The stage in the consumer decision-making process where potential options are assessed and compared based on criteria like price, quality, and features.

Purchase Outlet

A specific place, whether physical or online, where consumers can buy goods or services.