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:

Weighted-Average Method

A technique that figures out the cost of sold goods and the finishing inventory value, by averaging the cost of all items up for sale.

Labour and Overhead

Combined costs of workforce (both direct and indirect labor) and overhead expenses incurred during production.

Blending Department

A division within a manufacturing operation where raw materials are combined to produce a homogeneous product.

Weighted-Average Method

An inventory costing method that calculates the cost of goods sold and ending inventory based on the average cost of all units available for sale.