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

The B-complex vitamins and vitamin C are not stored in the body and must be replaced each day.

Did you know?

Blastomycosis is often misdiagnosed, resulting in tragic outcomes. It is caused by a fungus living in moist soil, in wooded areas of the United States and Canada. If inhaled, the fungus can cause mild breathing problems that may worsen and cause serious illness and even death.

Did you know?

According to the National Institute of Environmental Health Sciences, lung disease is the third leading killer in the United States, responsible for one in seven deaths. It is the leading cause of death among infants under the age of one year.

Did you know?

Astigmatism is the most common vision problem. It may accompany nearsightedness or farsightedness. It is usually caused by an irregularly shaped cornea, but sometimes it is the result of an irregularly shaped lens. Either type can be corrected by eyeglasses, contact lenses, or refractive surgery.

Did you know?

Immunoglobulin injections may give short-term protection against, or reduce severity of certain diseases. They help people who have an inherited problem making their own antibodies, or those who are having certain types of cancer treatments.

For a complete list of videos, visit our video library