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 80 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
Great answer, keep it coming :)

connor417

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

« previous next »
 

Did you know?

There are major differences in the metabolism of morphine and the illegal drug heroin. Morphine mostly produces its CNS effects through m-receptors, and at k- and d-receptors. Heroin has a slight affinity for opiate receptors. Most of its actions are due to metabolism to active metabolites (6-acetylmorphine, morphine, and morphine-6-glucuronide).

Did you know?

Anesthesia awareness is a potentially disturbing adverse effect wherein patients who have been paralyzed with muscle relaxants may awaken. They may be aware of their surroundings but unable to communicate or move. Neurologic monitoring equipment that helps to more closely check the patient's anesthesia stages is now available to avoid the occurrence of anesthesia awareness.

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.

Did you know?

Elderly adults are living longer, and causes of death are shifting. At the same time, autopsy rates are at or near their lowest in history.

Did you know?

When blood is deoxygenated and flowing back to the heart through the veins, it is dark reddish-blue in color. Blood in the arteries that is oxygenated and flowing out to the body is bright red. Whereas arterial blood comes out in spurts, venous blood flows.

Mitosis + Check Points 4 of 5 Mitosis + Check Points 4 of 5
Phrases that Decrease Customer Service Level Phrases that Decrease Customer Service Level
Is it ethical to break the law to defend our personal integrity? Is it ethical to break the law to defend our personal integrity?
Setup used to check the opening temperature of a thermostat. Setup used to check the opening temperature of a thermostat.
If the pump is not running, check the wiring and current flow before going through the process of ... If the pump is not running, check the wiring and current flow before going through the process of ...
Medical Hot Zone Entry Exclusion Criteria During Pre-Entry Check Medical Hot Zone Entry Exclusion Criteria During Pre-Entry Check
Video: Hypoglycemia Animation

For a complete list of videos, visit our video library