Multiple choice technology performance

Ideal Elapsed time for a SQL in OLTP type of Application

  1. Less than 10ms

  2. 100ms

  3. 150ms

  4. 50ms
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In OLTP (Online Transaction Processing) applications, individual SQL statements should execute very quickly - typically less than 10 milliseconds - to maintain high transaction throughput and responsiveness. Values of 50ms, 100ms, or 150ms would be considered too slow for OLTP workloads.

AI explanation

In OLTP (Online Transaction Processing) systems, queries are typically small, indexed lookups tied to individual user transactions, so response times are expected to be very fast — generally under 10 milliseconds — to keep the application responsive. Larger elapsed times like 50-150ms are more typical of batch or reporting workloads, not OLTP.

Keep practicing — related questions