Which two considerations should you give priority to when tuning these databases?

In your organization, there are two key databases. One of them is used primarily for an online
transaction processing (OLTP) application and is directly accessed by the users in a client/server
configuration. The application must process an average of 4,000 small transactions per day. The
users enter frequent queries on whose results they depend for completing their transactions. One
of the SLA requirements is that any query or transaction processing in the OLTP system should
not exceed 15 seconds.
The second database supports a decision support system (DSS) as well as batch report
programs. It is accessed by client-side users, who submit ad hoc queries through SQL*Plus and
by a browser-based,third party application that provides pooled connections for a large user base.
The queries vary: some fetch only a few records, whereas others fetch and sort hundreds of
records from several tables. As per the SLA specification the average turnaround time for a query
on the DSS returning 10000 records should be 24 hours.
For both the systems, the number of users is not consistent and may vary from time to time.The
management wants to ensure maximum resource usage is allocated for the OLTP processing.
Which two considerations should you give priority to when tuning these databases? (Choose two.)

In your organization, there are two key databases. One of them is used primarily for an online
transaction processing (OLTP) application and is directly accessed by the users in a client/server
configuration. The application must process an average of 4,000 small transactions per day. The
users enter frequent queries on whose results they depend for completing their transactions. One
of the SLA requirements is that any query or transaction processing in the OLTP system should
not exceed 15 seconds.
The second database supports a decision support system (DSS) as well as batch report
programs. It is accessed by client-side users, who submit ad hoc queries through SQL*Plus and
by a browser-based,third party application that provides pooled connections for a large user base.
The queries vary: some fetch only a few records, whereas others fetch and sort hundreds of
records from several tables. As per the SLA specification the average turnaround time for a query
on the DSS returning 10000 records should be 24 hours.
For both the systems, the number of users is not consistent and may vary from time to time.The
management wants to ensure maximum resource usage is allocated for the OLTP processing.
Which two considerations should you give priority to when tuning these databases? (Choose two.)

A.
Minimize parallelism for the OLTP systems.

B.
Maximize throughput for batch processing.

C.
Minimize the response time for OLTP users.

D.
Maximize parallelism for the decision support systems.

E.
Minimize response time for the decision support systems.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


L. Zhu

L. Zhu

For DSS, maximize throughput
For OLTP, minimize response time

B. C.