Answer & Explanation

4 Answers
Verified

Option A

It forces every table to have one row.
Additional Explanation
This option is incorrect for the stated requirement.
Sarkari Resultess
Editorial Answer 1
Verified Correct Answer

Option B

Normalization reduces unnecessary redundancy and helps prevent insert, update and delete anomalies by organizing dependencies into appropriate relations.
Additional Explanation
Correct implementation. Prefer parameterized queries in application code, validate affected rows for UPDATE/DELETE, and use transactions for related writes.
Sarkari Resultess
Editorial Answer 2
Verified

Option C

It guarantees zero joins.
Additional Explanation
This option is incorrect for the stated requirement.
Sarkari Resultess
Editorial Answer 3
Verified

Option D

It removes all constraints.
Additional Explanation
This option is incorrect for the stated requirement.
Sarkari Resultess
Editorial Answer 4