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 41 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
Excellent

olderstudent

  • Member
  • Posts: 339
Reply 3 on: Yesterday
:D TYSM

« previous next »
 

Did you know?

Asthma occurs in one in 11 children and in one in 12 adults. African Americans and Latinos have a higher risk for developing asthma than other groups.

Did you know?

The first successful kidney transplant was performed in 1954 and occurred in Boston. A kidney from an identical twin was transplanted into his dying brother's body and was not rejected because it did not appear foreign to his body.

Did you know?

According to animal studies, the typical American diet is damaging to the liver and may result in allergies, low energy, digestive problems, and a lack of ability to detoxify harmful substances.

Did you know?

Less than one of every three adults with high LDL cholesterol has the condition under control. Only 48.1% with the condition are being treated for it.

Did you know?

Walt Disney helped combat malaria by making an animated film in 1943 called The Winged Scourge. This short film starred the seven dwarfs and taught children that mosquitos transmit malaria, which is a very bad disease. It advocated the killing of mosquitos to stop the disease.

Double-check for any oil or vacuum leaks after starting the engine. Double-check for any oil or vacuum leaks after starting the engine.
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 ...
A form that the customer should fill out if there is a driveablilty concern to help the service ... A form that the customer should fill out if there is a driveablilty concern to help the service ...
How to determine the commission of a sale How to determine the commission of a sale
Sketch the graph using the tables providing. Determine if each function is continuous or ... Sketch the graph using the tables providing. Determine if each function is continuous or ...
A bank statement shows a balance of $2,970.31 The check register of the account owner shows an ... A bank statement shows a balance of $2,970.31 The check register of the account owner shows an ...
Video: Antidiuretic hormone (vasoconstriction, water reabsorption & sweat inhibition)

For a complete list of videos, visit our video library