SQL Practice Logo

SQLPractice Online

Level 9 - DistinguishedScenario-Based Questionsm3 concurrency isolation deadlocks

Contention Control in Flash-Sale Checkout

Scenario: flash-sale checkout spikes lock waits and timeout failures. Propose one queueing/ordering strategy and one timeout policy to keep reliability.