Answer & Explanation

4 Answers
Verified

Option A

It removes all indexes.
Additional Explanation
This option is incorrect for the stated requirement.
Sarkari Resultess
Editorial Answer 1
Verified Correct Answer

Option B

Multi-Version Concurrency Control keeps multiple row versions or visibility information so readers can often avoid blocking writers.
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 stores only one version forever.
Additional Explanation
This option is incorrect for the stated requirement.
Sarkari Resultess
Editorial Answer 3
Verified

Option D

It means every query is serialized.
Additional Explanation
This option is incorrect for the stated requirement.
Sarkari Resultess
Editorial Answer 4