Which two statements are true about Quality of Service Management?
A.
It can enable a more efficient sharing of hardware resources.
B.
It can improve the performance of SQL statements.
C.
It can improve system stability as the workload changes.
D.
It can improve the performance of PL/SQL.
E.
It can reduce the load on the system caused by Oracle background processes.
Explanation:
Oracle Database QoS Management provides the following benefits:
Enables more effective sharing of hardware resources
Provides stability to the system as the workloads change
Note: More benefits are:
Reduces the time and expertise requirements for system administrators who manage Oracle Real Application Clusters (Oracle RAC) resources
Helps reduce the number of performance outages
Reduces the time needed to resolve problems that limit or decrease the performance of your applications
Makes the addition or removal of servers transparent to applications
Reduces the impact on the system caused by server failures
Helps ensure that service-level agreements (SLAs) are met https://docs.oracle.com/cd/E11882_01/server.112/e24611/apqos_intro.htm#APQOS268
A,c correct
A and C Correct
https://docs.oracle.com/cd/E11882_01/server.112/e24611/apqos_intro.htm#APQOS116
Oracle Database QoS Management provides the following benefits:
– Reduces the time and expertise requirements for system administrators who manage Oracle Real Application Clusters (Oracle RAC) resources
– Helps reduce the number of performance outages
– Reduces the time needed to resolve problems that limit or decrease the performance of your applications
– Provides stability to the system as the workloads change
– Makes the addition or removal of servers transparent to applications
– Reduces the impact on the system caused by server failures
– Helps ensure that service-level agreements (SLAs) are met
– Enables more effective sharing of hardware resources