kinderc182 kinderc182

19-12-2022
Business

Answered

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

Answer :

Other Questions

When the allowance method of accounting for uncollectible accounts is used, Bad Debts Expense is recorded: a. in the year after the credit sale is made. b. in t

Whole-firm LBOs tend to result in all the following negative outcomes EXCEPT: a. large debt and increased financial risk. b. failure to invest in R&D. c. ri

Which of the following refers to the amount that you must pay on a claim before insurance comes into play? Group of answer choices: -Deductible -Transfer risk -

A major trend in business is _________, where employees work at least part time at home using a computer and modem. a) riveting b) outbounding c) outsourcing d)

When starting their business, John and Barb would most likely have benefitted from understanding ________. A) social media B) buzz marketing C) public relations

________ manufacturing is any manufacturing that takes place in a country different from the home country. A) Offshore B) Outsourcing C) Multidomestic D) Cost-m

Which of the following can increase both productivity and income? a. An increase in the savings rate. b. An increase in population. c. A decrease in the savings

During the closing decades of the nineteenth century farmers complained about all EXCEPT: A-rising prices B-High Interest C-high freight rates D-high storage pr

As the interest rate falls, the quantity Select one: a. demanded of money falls. b. demanded of money rises. c. supplied of money rises. d. supplied of money fa

Which of the following are examples of sustainability reporting that is mandatory in the United States? A The legally mandated disclosure of mine safety data B