You Have Been Given Two Tables,CUSTOMER and SALE

question 86

Multiple Choice

You have been given two tables,CUSTOMER and SALE.You want to check the referential integrity constraint: SALE.CustomerNumber must exist in CUSTOMER.CustomerNumber
You run the following SQL query:
SELECT CustomerNumber
FROM SALE
WHERE CustomerNumber NOT IN
(SELECT CustomerNumber
FROM SALE,CUSTOMER
WHERE SALE.CustomerNumber = CUSTOMER.CustomerNumber) ;
What is shown in the results of this query?

• A)All values of CustomerNumber that match the constraint.
• B)All values of CustomerNumber that violate the constraint.
• C)All values of CustomerNumber where
• SALE.CustomerNumber = CUSTOMER.CustomerNumber.
• D)A and C
• E)B and C

---

Definitions:

Interest Expense

The cost incurred by an entity for borrowed funds.

Premium on Bonds Payable

The amount by which the selling price of a bond exceeds its principal (face value), often resulting from interest rates lower than the bond's coupon rate.

Par Value

The nominal value of a bond or stock as declared by the issuer.

Issuance of Bond

The process by which a bond issuer offers bonds to investors to raise capital, typically with terms outlining repayment and interest.