Assume You Are Using the MINUS Operator to Combine the Results

question 21

Multiple Choice

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

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

---

Definitions:

Employee Stock Option (ESO)

An option granted to an employee by a company giving the employee the right to buy shares of stock in the company at a fixed price for a fixed time.

European Options

Financial derivatives that give the holder the right, but not the obligation, to buy or sell an underlying asset at a specified price on the expiration date, unlike American options which can be exercised at any time before expiry.

European Options

Options that can only be exercised at the expiration date, not before.

Expiration Date

The date on which an option, futures contract, or similar financial instrument becomes void and the right to exercise it ceases.