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 52 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

nathang24

  • Member
  • Posts: 314
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

Bacteria have flourished on the earth for over three billion years. They were the first life forms on the planet.

Did you know?

A serious new warning has been established for pregnant women against taking ACE inhibitors during pregnancy. In the study, the risk of major birth defects in children whose mothers took ACE inhibitors during the first trimester was nearly three times higher than in children whose mothers didn't take ACE inhibitors. Physicians can prescribe alternative medications for pregnant women who have symptoms of high blood pressure.

Did you know?

Disorders that may affect pharmacodynamics include genetic mutations, malnutrition, thyrotoxicosis, myasthenia gravis, Parkinson's disease, and certain forms of insulin-resistant diabetes mellitus.

Did you know?

In 1886, William Bates reported on the discovery of a substance produced by the adrenal gland that turned out to be epinephrine (adrenaline). In 1904, this drug was first artificially synthesized by Friedrich Stolz.

Did you know?

The U.S. Preventive Services Task Force recommends that all women age 65 years of age or older should be screened with bone densitometry.

THE WORLD'S BIGGEST SALE THE WORLD'S BIGGEST SALE
Correctly completed check stub. Correctly completed check stub.
The transmission and flexplate (flywheel) were removed to check the exact location of this oil ... The transmission and flexplate (flywheel) were removed to check the exact location of this oil ...
When checking a coil-on-plug (COP) assembly, check that the primary and secondary wiring looks ... When checking a coil-on-plug (COP) assembly, check that the primary and secondary wiring looks ...
Step 1 is to verify the customer concern or problem. If the problem cannot be verified, then the ... Step 1 is to verify the customer concern or problem. If the problem cannot be verified, then the ...
Remove the heat source, and check the skin for redness. Massage the area, and notice muscle ... Remove the heat source, and check the skin for redness. Massage the area, and notice muscle ...
Video: Humerus Adduction Animation

For a complete list of videos, visit our video library