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

Medications that are definitely not safe to take when breastfeeding include radioactive drugs, antimetabolites, some cancer (chemotherapy) agents, bromocriptine, ergotamine, methotrexate, and cyclosporine.

Did you know?

Adult head lice are gray, about ? inch long, and often have a tiny dot on their backs. A female can lay between 50 and 150 eggs within the several weeks that she is alive. They feed on human blood.

Did you know?

Historic treatments for rheumatoid arthritis have included gold salts, acupuncture, a diet consisting of apples or rhubarb, nutmeg, nettles, bee venom, bracelets made of copper, prayer, rest, tooth extractions, fasting, honey, vitamins, insulin, snow collected on Christmas, magnets, and electric convulsion therapy.

Did you know?

To maintain good kidney function, you should drink at least 3 quarts of water daily. Water dilutes urine and helps prevent concentrations of salts and minerals that can lead to kidney stone formation. Chronic dehydration is a major contributor to the development of kidney stones.

Did you know?

Many medications that are used to treat infertility are injected subcutaneously. This is easy to do using the anterior abdomen as the site of injection but avoiding the area directly around the belly button.

For a complete list of videos, visit our video library