« previous next »

Author Question: In which of the following situations would one have to use an outer join in order to obtain the ... (Read 58 times)

Metfan725

  • Hero Member
  • *****
  • Posts: 552
on: Jul 7, 2018
In which of the following situations would one have to use an outer join in order to obtain the desired results?
 
  A) A report is desired that lists all customers who placed an order.
  B) A report is desired that lists all customers and the total of their orders.
  C) A report is desired that lists all customers and the total of their orders during the most recent month, and includes customers who did not place an order during the month (their total will be zero).
  D) There is never a situation that requires only an outer join.

Question 2

Sensitivity testing involves:
 
  A) checking to see if your teeth hurt when you brush.
  B) seeing how accurate data are.
  C) checking to see if missing data will greatly impact results.
  D) deleting the associated row.
Modern Database Management ¦ Hoffer, Venkataraman, Topi ¦ 13th Edition
Buy Test-Bank


Ksh22

  • Sr. Member
  • ****
  • Posts: 297
Reply #1 on: Jul 7, 2018
Answer to Question 1

C

Answer to Question 2

C


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

Did you know?

The most dangerous mercury compound, dimethyl mercury, is so toxic that even a few microliters spilled on the skin can cause death. Mercury has been shown to accumulate in higher amounts in the following types of fish than other types: swordfish, shark, mackerel, tilefish, crab, and tuna.

Did you know?

ACTH levels are normally highest in the early morning (between 6 and 8 A.M.) and lowest in the evening (between 6 and 11 P.M.). Therefore, a doctor who suspects abnormal levels looks for low ACTH in the morning and high ACTH in the evening.

Did you know?

A recent study has found that following a diet rich in berries may slow down the aging process of the brain. This diet apparently helps to keep dopamine levels much higher than are seen in normal individuals who do not eat berries as a regular part of their diet as they enter their later years.

Did you know?

The top 10 most important tips that will help you grow old gracefully include (1) quit smoking, (2) keep your weight down, (3) take supplements, (4) skip a meal each day or fast 1 day per week, (5) get a pet, (6) get medical help for chronic pain, (7) walk regularly, (8) reduce arguments, (9) put live plants in your living space, and (10) do some weight training.

Did you know?

In inpatient settings, adverse drug events account for an estimated one in three of all hospital adverse events. They affect approximately 2 million hospital stays every year, and prolong hospital stays by between one and five days.

Metastasis Cancer Order Metastasis Cancer Order
Client files are kept in alphabetical order in locked file cabinets. Client files are kept in alphabetical order in locked file cabinets.
Afterload is the pressure that the ventricles must overcome in order to open the aortic and pulmonic Afterload is the pressure that the ventricles must overcome in order to open the aortic and pulmonic
First-order sensory neuron with free nerve endings First-order sensory neuron with free nerve endings
Here, in alphabetical order, are 20 foods and 4 cultures. Here, in alphabetical order, are 20 foods and 4 cultures.
Analysis of double-mutant phenotypes to find order of genes in developmental pathways Analysis of double-mutant phenotypes to find order of genes in developmental pathways
Video: Simple and Double Sugar

For a complete list of videos, visit our video library