This topic contains a solution. Click here to go to the answer

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

eruditmonkey@yahoo.com

  • Hero Member
  • *****
  • Posts: 546
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
Answer to Question 1

B

Answer to Question 2

TRUE




eruditmonkey@yahoo.com

  • Member
  • Posts: 546
Reply 2 on: Jul 7, 2018
Gracias!


rleezy04

  • Member
  • Posts: 322
Reply 3 on: Yesterday
Wow, this really help

 

Did you know?

An identified risk factor for osteoporosis is the intake of excessive amounts of vitamin A. Dietary intake of approximately double the recommended daily amount of vitamin A, by women, has been shown to reduce bone mineral density and increase the chances for hip fractures compared with women who consumed the recommended daily amount (or less) of vitamin A.

Did you know?

In the United States, there is a birth every 8 seconds, according to the U.S. Census Bureau's Population Clock.

Did you know?

Tobacco depletes the body of vitamins A, C, and E, which can result in any of the following: dry hair, dry skin, dry eyes, poor growth, night blindness, abscesses, insomnia, fatigue, reproductive system problems, sinusitis, pneumonia, frequent respiratory problems, skin disorders, weight loss, rickets, osteomalacia, nervousness, muscle spasms, leg cramps, extremity numbness, bone malformations, decayed teeth, difficulty in walking, irritability, restlessness, profuse sweating, increased uric acid (gout), joint damage, damaged red blood cells, destruction of nerves, infertility, miscarriage, and many types of cancer.

Did you know?

The National Institutes of Health have supported research into acupuncture. This has shown that acupuncture significantly reduced pain associated with osteoarthritis of the knee, when used as a complement to conventional therapies.

Did you know?

Cocaine was isolated in 1860 and first used as a local anesthetic in 1884. Its first clinical use was by Sigmund Freud to wean a patient from morphine addiction. The fictional character Sherlock Holmes was supposed to be addicted to cocaine by injection.

For a complete list of videos, visit our video library