Assume a Designer Is Using the UNION Operator to Combine

question 15

Multiple Choice

Assume a designer is 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 Jenna and Howard 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:

Centriole

In animal cells, a barrel-shaped organelle from which microtubules grow.

Cilia

Microscopic, hair-like structures on the surface of certain cells that move in a wave-like manner, facilitating movement or the transport of fluids and particles.

Vesicle

A small, fluid-filled sac or cyst within the body or a cell, used to transport materials within the cytoplasm.

Membrane Enclosed Sac

A structure within a cell, bounded by lipids, that contains fluid or smaller organelles, involved in transport, storage, and processing.