Machine-translated by Google. Questions are authored in English.
Top

Discussion

Each answer below shows example data from a table. Which answer is an example of the missing values problem?

  • A.Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.
  • B.Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.
  • C.Three rows have the values Brown, NULL, and Blue in the same column.
  • D.One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.

Answer: C

Correct answer: Three rows have the values Brown, NULL, and Blue in the same column.

The missing values problem is the presence of nulls, and the difficulty is that a null is ambiguous: it may mean the value is unknown, or that it does not apply, or that nobody has entered it yet. Since the three call for different treatment and the data does not distinguish them, every null has to be investigated rather than assumed.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.