The very design that makes an OLTP system efficient for transaction processing makes it inefficient for
A)end-user ad hoc reports,queries,and analysis.
B)transaction processing systems that constantly update operational databases.
C)the collection of reputable sources of intelligence.
D)transactions such as ATM withdrawals,where we need to reduce a bank balance accordingly.

Question

Quizplus · Accepted Answer

OLTP systems are optimized for transaction processing, which requires speed, accuracy, and consistency of data. This efficiency comes at the expense of flexibility and ease of use for ad hoc reporting and analysis by end-users. OLTP systems are typically designed for a specific set of transactions and do not allow for complex queries or customized reports.

The Very Design That Makes an OLTP System Efficient for Transaction