This topic contains a solution. Click here to go to the answer
« previous next »

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

eruditmonkey@yahoo.com

  • Hero Member
  • *****
  • Posts: 546
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


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

connor417

  • Sr. Member
  • ****
  • Posts: 329
Reply #1 on: Jul 7, 2018
Answer to Question 1

B

Answer to Question 2

TRUE


eruditmonkey@yahoo.com

  • Member
  • Posts: 546
Reply 2 on: Jul 7, 2018
:D TYSM

atrochim

  • Member
  • Posts: 331
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

« previous next »
 

Did you know?

The people with the highest levels of LDL are Mexican American males and non-Hispanic black females.

Did you know?

Though the United States has largely rejected the metric system, it is used for currency, as in 100 pennies = 1 dollar. Previously, the British currency system was used, with measurements such as 12 pence to the shilling, and 20 shillings to the pound.

Did you know?

Street names for barbiturates include reds, red devils, yellow jackets, blue heavens, Christmas trees, and rainbows. They are commonly referred to as downers.

Did you know?

There are more nerve cells in one human brain than there are stars in the Milky Way.

Did you know?

Serum cholesterol testing in adults is recommended every 1 to 5 years. People with diabetes and a family history of high cholesterol should be tested even more frequently.

Mitosis + Check Points 1 of 5 Mitosis + Check Points 1 of 5
Mitosis + Check Points 4 of 5 Mitosis + Check Points 4 of 5
A typical malfunction indicator lamp (MIL) often labeled “check engine.” A typical malfunction indicator lamp (MIL) often labeled “check engine.”
Prepare upper back for hot application. Undrape upper back. Check tissues visually and through ... Prepare upper back for hot application. Undrape upper back. Check tissues visually and through ...
Medical Hot Zone Entry Exclusion Criteria During Pre-Entry Check Medical Hot Zone Entry Exclusion Criteria During Pre-Entry Check
How to determine the commission of a sale How to determine the commission of a sale
Video: Introduction to Autism

For a complete list of videos, visit our video library