Assume You Are Using the INTERSECT Operator to Combine the Results

question 69

Multiple Choice

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

• A)0
• B)2
• C)7
• D)10

---

Definitions:

Market Price

The current market quote for the sale or purchase of an asset or service.

Debt-equity Ratio

A calculation showing how much a firm relies on borrowed funds, determined by dividing the sum of its obligations by the equity of its shareholders.

Pre-tax Cost

The cost of an investment or expense before any taxes are applied, often considered when evaluating investment options.

Cost of Equity

The presumed income given to a firm's equity investors to reimburse them for the risk undertaken with their investment.