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 general-purpose remarks column 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: D

Correct answer: One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.

A general-purpose remarks column holds free text into which users put whatever they think worth recording, so the same column contains different kinds of fact in different rows. It cannot be queried reliably, cannot be validated, and the information in it - here a colour, a model and a year range - belongs in columns of its own.

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

Post your comment

Please log in or register to post a comment.