Oracle Database Administration 2019 Certified Professional — Question 61

Which three statements are true about Quality of Service Management (QoS)? (Choose three.)

Answer options

• A. It can manage database services only if they are defined as UNIFORM services.
• B. It requires Oracle Grid Infrastructure for a Cluster to be installed and Clusterware to be running.
• C. A server pool can be managed by QoS even if it does have database instances running on any server in the pool.
• D. Databases managed by QoS can be administrator managed or policy managed.
• E. It supports multiple databases assigned to the same server pool.

Correct answer: B, D, E

Explanation

The correct answer includes B, D, and E because Oracle Grid Infrastructure is essential for QoS to function, and it can manage databases in both administrator and policy managed modes while supporting multiple databases in a single server pool. Option A is incorrect as QoS does not limit management to only UNIFORM services, and option C is misleading because QoS specifically requires that there are database instances running in the pool for management purposes.