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:

Progesterone

A hormone released by the ovaries which regulates the condition of the inner lining (endometrium) of the uterus and is essential for maintaining pregnancy.

Neurotransmitter

Chemical substances in the nervous system that transmit signals across a synapse from one neuron to another.

Acetylcholine

A neurotransmitter in the nervous system that plays a crucial role in muscle movement and cognitive functions such as memory and attention.

Dopamine

A neurotransmitter in the brain that plays a major role in reward-motivated behavior and other functions.