Author Question: Explain the possible interpretations of a null value. What will be an ideal ... (Read 37 times)

lidoalex

  • Hero Member
  • *****
  • Posts: 538
Explain the possible interpretations of a null value.
 
  What will be an ideal response?

Question 2

When creating an OLAP report based on Access 2013 data, it is often a good idea to create a view equivalent query to organize the data needed for the OLAP report.
 
  Indicate whether the statement is true or false



paavo

  • Sr. Member
  • ****
  • Posts: 301
Answer to Question 1

The problem with allowing null values in a table is that the null value is open to three different interpretations. First, a null value in a field may mean that no value is appropriate for the field for the given record. Second, a null value may mean that the value of that field is known to be blank for the given record. Third, a null value may mean that the value of that field is not known for the given record.

Answer to Question 2

TRUE



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

Aspirin may benefit 11 different cancers, including those of the colon, pancreas, lungs, prostate, breasts, and leukemia.

Did you know?

In 1885, the Lloyd Manufacturing Company of Albany, New York, promoted and sold "Cocaine Toothache Drops" at 15 cents per bottle! In 1914, the Harrison Narcotic Act brought the sale and distribution of this drug under federal control.

Did you know?

All adverse reactions are commonly charted in red ink in the patient's record and usually are noted on the front of the chart. Failure to follow correct documentation procedures may result in malpractice lawsuits.

Did you know?

Malaria mortality rates are falling. Increased malaria prevention and control measures have greatly improved these rates. Since 2000, malaria mortality rates have fallen globally by 60% among all age groups, and by 65% among children under age 5.

Did you know?

The term pharmacology is derived from the Greek words pharmakon("claim, medicine, poison, or remedy") and logos ("study").

For a complete list of videos, visit our video library