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 39 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
Thanks for the timely response, appreciate it

komodo7

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

« previous next »
 

Did you know?

Certain chemicals, after ingestion, can be converted by the body into cyanide. Most of these chemicals have been removed from the market, but some old nail polish remover, solvents, and plastics manufacturing solutions can contain these substances.

Did you know?

Fatal fungal infections may be able to resist newer antifungal drugs. Globally, fungal infections are often fatal due to the lack of access to multiple antifungals, which may be required to be utilized in combination. Single antifungals may not be enough to stop a fungal infection from causing the death of a patient.

Did you know?

According to the FDA, adverse drug events harmed or killed approximately 1,200,000 people in the United States in the year 2015.

Did you know?

The first war in which wide-scale use of anesthetics occurred was the Civil War, and 80% of all wounds were in the extremities.

Did you know?

Excessive alcohol use costs the country approximately $235 billion every year.

Brumbies awaiting their sale and new homes. Brumbies awaiting their sale and new homes.
Covering the interior as soon as the vehicle comes in for service helps improve customer ... Covering the interior as soon as the vehicle comes in for service helps improve customer ...
Setup used to check the opening temperature of a thermostat. Setup used to check the opening temperature of a thermostat.
Step 8 is very important. Be sure that the customer’s concern has been corrected. Step 8 is very important. Be sure that the customer’s concern has been corrected.
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 ...
Everytime Im trying to study Check Me! Check Me! Everytime Im trying to study Check Me! Check Me!
Video: Phlebotomy

For a complete list of videos, visit our video library