Multiple choice technology databases

Which of the following are two factual statements regarding an OLTP environment? (Choose two)

  1. Transactions are write intensive

  2. The number rows per transaction is large

  3. Transactions typically occur within seconds, not minutes

  4. The number of rows per transaction is small
Reveal answer Fill a bubble to check yourself
A,C Correct answer
Explanation

OLTP (Online Transaction Processing) environments are characterized by write-intensive operations as users constantly insert, update, and delete data. Transactions typically complete within seconds because users expect immediate feedback for business operations. OLTP processes small row sets per transaction (individual customer orders, account updates), not large batches like analytical systems.

Keep practicing — related questions