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

Parkinson's disease is both chronic and progressive. This means that it persists over a long period of time and that its symptoms grow worse over time.

Did you know?

Drug-induced pharmacodynamic effects manifested in older adults include drug-induced renal toxicity, which can be a major factor when these adults are experiencing other kidney problems.

Did you know?

Limit intake of red meat and dairy products made with whole milk. Choose skim milk, low-fat or fat-free dairy products. Limit fried food. Use healthy oils when cooking.

Did you know?

The human body's pharmacokinetics are quite varied. Our hair holds onto drugs longer than our urine, blood, or saliva. For example, alcohol can be detected in the hair for up to 90 days after it was consumed. The same is true for marijuana, cocaine, ecstasy, heroin, methamphetamine, and nicotine.

Did you know?

Looking at the sun may not only cause headache and distort your vision temporarily, but it can also cause permanent eye damage. Any exposure to sunlight adds to the cumulative effects of ultraviolet (UV) radiation on your eyes. UV exposure has been linked to eye disorders such as macular degeneration, solar retinitis, and corneal dystrophies.

For a complete list of videos, visit our video library