User-defined transactions can improve system performance because:
A) transactions are processed as sets, reducing system overhead.
B) transactions are mapped to SQL statements.
C) speed is improved due to query optimization.
D) all of the above.

Question

Quizplus · Accepted Answer

User-defined transactions allow multiple operations to be grouped together as a set, which is processed as a single transaction. This reduces system overhead and improves performance compared to processing each operation individually. Mapping transactions to SQL statements and optimizing queries may contribute to better performance, but they are not directly related to the benefits of user-defined transactions.

User-Defined Transactions Can Improve System Performance Because