Code AnalysisIntermediate 60s

Deadlock from lock ordering

Two transactions acquire rows in opposite order. What occurs?

Starter code

-- T1: UPDATE a; UPDATE b;
-- T2: UPDATE b; UPDATE a;

Think you can answer under pressure?

Get matched and answer live questions in 3-minute 1v1 battles. Elo ranking, badge tiers and bragging rights on the line.