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:

Idea Generation

The creative process of generating, developing, and communicating new concepts or solutions.

Development Time

The duration it takes from the initial idea conception of a product or service until its launch in the market.

Financial Resources

The available resources in the form of cash, liquid securities, and credit lines that a business can use for expenditure.

Kano Model

A theory for product development and customer satisfaction, which categorizes customer preferences into must-be, performance, and delighter attributes.