Assume You Are Using the UNION ALL Operator to Combine

question 14

Multiple Choice

Assume you are using the UNION ALL 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 ALL operator?

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

---

Definitions:

Automatic Transfer

A banking service that automatically moves funds from one account to another at scheduled times or under specific conditions.

Adjusted Cash Balance

The cash amount shown on a company's books after adjustments have been made for checks outstanding, deposits in transit, and other discrepancies.

Check Register

A record kept by an individual or institution to track checks written, deposits made, and the current balance of a checking account.

Bank Statement

A document issued by a bank detailing transactions, balances, and other financial information for a specific account over a period.