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

Discussion

For a number of reasons, normalizations is not often an advantage for a(n) ________ database.

  • A.read-only
  • B.updateable
  • C.either a read-only or an updateable
  • D.None of the above is correct.

Answer: A

Correct answer: read-only

Normalization exists to prevent modification anomalies, and a database that is never updated cannot suffer them. What remains is the cost: more tables, more joins, more complex and slower queries. So for a read-only database the balance tips the other way, and deliberately denormalized structures are the norm - which is exactly what a data warehouse star schema is.

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

Post your comment

Please log in or register to post a comment.