You Have Been Given Two Tables,CUSTOMER and SALE

question 48

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 CUSTOMER) ;
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)All values of Customer number that are in CUSTOMER but not in SALE.

---

Definitions:

Inguinal Hernia

A condition in which tissue, such as part of the intestine, protrudes through a weak spot in the abdominal muscles near the groin area.

Gangrene

A serious condition where loss of blood supply causes body tissue to die, potentially leading to amputation if not treated.

BUN

Blood Urea Nitrogen, a test that measures the amount of nitrogen in the blood that comes from the waste product urea, indicating kidney function.

Liver Disease

A broad category of diseases and disorders that affect the liver's ability to function properly.