149979
AssignmentMultiple Choice

Querying a Database

Question 149979 • TX-Business Information Management (BIM) I

What is a rule of solid database design regarding calculated values?

Answer
A
They should be stored in a database.
B
They should not be stored in a database.
C
They should be hidden from query results.
D
They should be eliminated from query results.

Explanation

Calculated values are derived from other data, so a solid database design generally avoids storing them separately. Instead, calculate them when needed; this prevents stored values from becoming outdated or inconsistent if the underlying data changes. Therefore, the correct choice is “They should not be stored in a database.”

AI-written and checked against the verified answer.

Previous
Next