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

vickyvicksss

  • Member
  • Posts: 351
Reply 3 on: Yesterday
Gracias!

« previous next »
 

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?

It is difficult to obtain enough calcium without consuming milk or other dairy foods.

Did you know?

The toxic levels for lithium carbonate are close to the therapeutic levels. Signs of toxicity include fine hand tremor, polyuria, mild thirst, nausea, general discomfort, diarrhea, vomiting, drowsiness, muscular weakness, lack of coordination, ataxia, giddiness, tinnitus, and blurred vision.

Did you know?

Pregnant women usually experience a heightened sense of smell beginning late in the first trimester. Some experts call this the body's way of protecting a pregnant woman from foods that are unsafe for the fetus.

Did you know?

To prove that stomach ulcers were caused by bacteria and not by stress, a researcher consumed an entire laboratory beaker full of bacterial culture. After this, he did indeed develop stomach ulcers, and won the Nobel Prize for his discovery.

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 ...
Using a scan tool to check for IAC counts or percentage as part of a diagnostic routine. Using a scan tool to check for IAC counts or percentage as part of a diagnostic routine.
To check to see if the electric fuel pump can be operated from the relay contacts, use a fused ... To check to see if the electric fuel pump can be operated from the relay contacts, use a fused ...
A. Open portable massage table on its side. B. Straighten out legs completely and check that leg ... A. Open portable massage table on its side. B. Straighten out legs completely and check that leg ...
Prepare knee for cold application. Undrape the leg. Check tissues visually and through palpation, ... Prepare knee for cold application. Undrape the leg. Check tissues visually and through palpation, ...
Fingertip kneading along the paraspinal muscles from shoulders to buttocks. Check to make sure all ... Fingertip kneading along the paraspinal muscles from shoulders to buttocks. Check to make sure all ...
Video: Four Giant Convection Cells oF Earth

For a complete list of videos, visit our video library