You have been given two tables, CUSTOMER and SALE. You want to ...

[eruditmonkey@yahoo.com]

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

[connor417]

Answer to Question 1

B

Answer to Question 2

TRUE

[eruditmonkey@yahoo.com]

Excellent

[sultansheikh]

Thanks for the timely response, appreciate it