Author Question: Explain the possible interpretations of a null value. What will be an ideal ... (Read 18 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?

In 1835 it was discovered that a disease of silkworms known as muscardine could be transferred from one silkworm to another, and was caused by a fungus.

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?

Tobacco depletes the body of vitamins A, C, and E, which can result in any of the following: dry hair, dry skin, dry eyes, poor growth, night blindness, abscesses, insomnia, fatigue, reproductive system problems, sinusitis, pneumonia, frequent respiratory problems, skin disorders, weight loss, rickets, osteomalacia, nervousness, muscle spasms, leg cramps, extremity numbness, bone malformations, decayed teeth, difficulty in walking, irritability, restlessness, profuse sweating, increased uric acid (gout), joint damage, damaged red blood cells, destruction of nerves, infertility, miscarriage, and many types of cancer.

Did you know?

Green tea is able to stop the scent of garlic or onion from causing bad breath.

Did you know?

Hyperthyroidism leads to an increased rate of metabolism and affects about 1% of women but only 0.1% of men. For most people, this increased metabolic rate causes the thyroid gland to become enlarged (known as a goiter).

For a complete list of videos, visit our video library