Senior ACID Properties

Test your Senior-level Database Fundamentals Acid Properties skills in Database Data Management. This timed assessment evaluates your expertise in Information Technology.

Duration: 5 minutes

•40 questions

Time Remaining: 05:00

Progress: 0%

40 questions remaining

Question 1 of 40Assessment

How does 'Two-Phase Locking' (2PL) prevent non-serializable schedules in a transaction processing system?

A. By requiring all locks to be acquired before any are released, creating an expansion and contraction phase.

B. By assigning each transaction a unique priority based on the amount of data it needs to access.

C. By forcing every transaction to wait for a random amount of time before it is allowed to start.

D. By using a single global lock that prevents more than one transaction from running at any time.

Keyboard Shortcuts

↑↓Navigate options

EnterSelect answer

←→Prev/Next question

SSkip question

1-4Select A-D

EscClear answer

SpaceNext question

BackspacePrevious question