1Z0-083 · Question #141
In performance management, which two factors might reduce the ability of an application to scale to a large number of users? (Choose two.)
The correct answer is A. poorly written SQL C. poorly trained users who do not commit transactions. About Concurrency and Scalability The better your application handles concurrency, the more scalable it is. Concurrency is the simultaneous execution of multiple transactions. Statements within concurrent transactions can update the same data. Concurrent transactions must…
Question
In performance management, which two factors might reduce the ability of an application to scale to a large number of users? (Choose two.)
Options
- Apoorly written SQL
- Bthe number of tablespaces containing tables updated by a transaction
- Cpoorly trained users who do not commit transactions
- Dthe number of data files containing extents belonging to tables updated by a transaction
- Eissuing multiple savepoints during a transaction
How the community answered
(41 responses)- A71% (29)
- B5% (2)
- D17% (7)
- E7% (3)
Explanation
About Concurrency and Scalability The better your application handles concurrency, the more scalable it is. Concurrency is the simultaneous execution of multiple transactions. Statements within concurrent transactions can update the same data. Concurrent transactions must produce meaningful and consistent results. Therefore, a multiuser database must provide the following: Data concurrency , which ensures that users can access data at the same time. Data consistency, which ensures that each user sees a consistent view of the data, including visible changes from his or her own transactions and committed transactions of other users
Topics
Community Discussion
No community discussion yet for this question.