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 85 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
Gracias!

Alyson.hiatt@yahoo.com

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

« previous next »
 

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?

Colchicine is a highly poisonous alkaloid originally extracted from a type of saffron plant that is used mainly to treat gout.

Did you know?

More than 150,000 Americans killed by cardiovascular disease are younger than the age of 65 years.

Did you know?

No drugs are available to relieve parathyroid disease. Parathyroid disease is caused by a parathyroid tumor, and it needs to be removed by surgery.

Did you know?

For high blood pressure (hypertension), a new class of drug, called a vasopeptidase blocker (inhibitor), has been developed. It decreases blood pressure by simultaneously dilating the peripheral arteries and increasing the body's loss of salt.

Mitosis + Check Points 2 of 5 Mitosis + Check Points 2 of 5
To check pupillary reflexes the nurse first holds the penlight To check pupillary reflexes the nurse first holds the penlight
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 ...
Use a DMM set to read DC volts to check the voltage drop of the positive circuit to the fuel ... Use a DMM set to read DC volts to check the voltage drop of the positive circuit to the fuel ...
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 ...
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: Griffith's experiments

For a complete list of videos, visit our video library