Practise the standard verbs for managing SQL query timeouts safely.
0 / 5 completed
1 / 5
Fill in: 'We ___ a statement timeout on every connection so a runaway query can never hold a lock indefinitely.'
We 'set a timeout' — the standard, simple collocation for configuring a maximum execution duration. The other options are less idiomatic here.
2 / 5
Fill in: 'A missing timeout on a reporting query can ___ the whole connection pool tied up behind one slow request.'
We say a missing timeout will 'leave' the pool tied up — the standard, natural collocation for the resulting bottleneck. The other options aren't idiomatic here.
3 / 5
Fill in: 'We ___ a canceled query cleanly with a clear error instead of letting the client hang waiting forever.'
We 'handle' a query — the standard, simple collocation for processing an outcome in code. The other options are less idiomatic here.
4 / 5
Fill in: 'We ___ different timeout values for interactive queries versus long-running batch jobs on the same database.'
We 'apply' a value — the standard, established collocation for setting a differentiated configuration per context. The other options aren't the recognised term here.
5 / 5
Fill in: 'We ___ queries that hit the timeout limit regularly so a slow report doesn't just get retried forever unnoticed.'
We 'log' queries — the standard, simple collocation for recording events for later inspection. The other options are less idiomatic here.