Author Question: You have been given two tables, CUSTOMER and SALE. You want to check the referential integrity ... (Read 81 times)

eruditmonkey@yahoo.com · **on:** Jul 7, 2018

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

Question 2

In two-phase locking, all locks are obtained during the growing phase.

Indicate whether the statement is true or false