Answer & Explanation

4 Answers
Verified

Option A

It is only a UI feature.
Additional Explanation
This option is incorrect for the stated requirement.
Sarkari Resultess
Editorial Answer 1
Verified Correct Answer

Option B

Partitioning divides one logical table into physical partitions managed by the DBMS, often by range, list, hash or similar strategy.
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 removes the primary key.
Additional Explanation
This option is incorrect for the stated requirement.
Sarkari Resultess
Editorial Answer 3
Verified

Option D

It always creates separate databases for each row.
Additional Explanation
This option is incorrect for the stated requirement.
Sarkari Resultess
Editorial Answer 4