You have been given two tables, CUSTOMER and SALE. You want to check the referential integrity constraint: SALE.CustomerNumber must exist in CUSTOMER
CustomerNumberYou run the following SQL query:SELECT CustomerNumberFROM SALEWHERE 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.
B
You might also like to view...
Which of the following situations best describes an example of a double interact, as used in Weickâs Information Systems Approach?
A. An employee speaks; the manager listens and nods her head. B. Each person in the system acts and responds to each other person in the system. C. An employee makes a suggestion to improve the production line; the manager follows the suggestion and corporate productivity increases. D. An employee offers a suggestion; the manager tells her that the correct procedure is to put the suggestion in writing and send it to all department heads; the employee follows the procedure.
Which of the following solvency ratios is the best measure of a company's ability to pay interest and maturing principal amounts on its long-term debt?
a. Debt-to-equity ratio b. Times interest earned ratio c. Debt service coverage ratio d. Earnings per share
Transformational leadership is fundamentally morally uplifting. This suggests that ______.
A. use of coercive leadership cannot be considered leadership B. all transformative leadership has a negative side C. using contingent reward cannot be considered leadership D. using management by exception cannot be considered leadership
Austin has decided to take the MBTI to get a better understanding of himself. Once he takes the test, he looks at the ________________ to identify his personality type.
What will be an ideal response?