Within the framework of concurrency control in a d...
Guiding State PSC aspirants since 2016 50,000+ students · 1,000+ final selections Exam Calendar Results Call 9116926003
pscnotes
Pick your state
GPSC Prelims previous year questions

Within the framework of concurrency control in a database management system, what aspect of transaction execution is formally governed by a locking protocol to ensure coordinated access to shared data resources and maintain transactional correctness?

Asked in GPSC ICT Officer, Class-2 2026

  1. The methodology by which data records are physically organized and persistently stored within the database storage system.
  2. The conditions and sequence of operations under which a transaction is permitted to acquire locks on, or release locks from specific data items during its execution.
  3. The procedures and structural mechanisms employed to construct and maintain index structures for facilitating efficient data retrieval.
  4. The techniques and optimization strategies used by the query processor to determine an efficient execution plan for database queries.
Show answer

Answer: B. The conditions and sequence of operations under which a transaction is permitted to acquire locks on, or release locks from specific data items during its execution.

This previous-year question came without the commission's answer key; the answer was checked by AI. Always confirm with the official key.

More GPSC Prelims previous year questions questions

All 18,593 GPSC Prelims previous year questions questions →