Oracle Database Administration II — Question 132

In performance management, which two factors might reduce the ability of an application to scale to a large number of users? (Choose two.)

Answer options

• A. poorly written SQL
• B. the number of tablespaces containing tables updated by a transaction
• C. poorly trained users who do not commit transactions
• D. the number of data files containing extents belonging to tables updated by a transaction
• E. issuing multiple savepoints during a transaction

Correct answer: A, B

Explanation

Poorly written SQL can lead to inefficient queries that slow down performance, making it difficult for the application to handle a large user base. The number of tablespaces containing tables updated by a transaction can also affect scalability, as excessive tablespaces can create overhead and bottlenecks. The other options, while they may impact performance, do not directly relate to the application's ability to scale in the same way.