30. denormalization

DBMS Published 30 Sept 2026 Updated 30 Sept 2026 0 Views Verified

When can denormalization be justified?

Looking for the latest Sarkari Result 2026 updates? Check the latest government exam results, merit lists and result updates on Sarkari Resultess.

Answer & Explanation

4 Answers

Verified Correct Answer

Option A

It can be justified for measured read-performance or reporting needs when the extra duplicated data can be kept consistent.

Additional Explanation

Correct implementation. Prefer parameterized queries in application code, validate affected rows for UPDATE/DELETE, and use transactions for related writes.

Verified

Option B

Whenever joins exist.

Additional Explanation

This option is incorrect for the stated requirement.

Verified

Option C

Whenever a table has a primary key.

Additional Explanation

This option is incorrect for the stated requirement.

Verified

Option D

Only when the database has no indexes.

Additional Explanation

This option is incorrect for the stated requirement.