1Z0-084 practice question 6 of 15

Which two Oracle Database features use database services?

Full set: 55 questions
Answer options
A:

A. Oracle Automatic Reoptimization

B:

B. Database Resource Manager

Correct answer
C:

C. Oracle SQL Performance Management

D:

D. Oracle SQL Tuning Advisor

E:

E. Oracle Scheduler

Correct answer
Correct Answer:
B. B. Database Resource Manager; E. E. Oracle Scheduler
Explanation

Database services are logical names that clients use to connect to one or more database instances. They are a key component for managing workloads and ensuring high availability.
(B) The Database Resource Manager (DBRM) can use the service name a session connected with to map that session to a specific resource consumer group, thereby controlling its resource allocation (e.g., CPU, parallelism).
(E) The Oracle Scheduler can be configured to associate job classes with services. This allows administrators to control on which instance(s) in a Real Application Clusters (RAC) environment a job will run, effectively managing job placement and workload.

Why Incorrect

A. Automatic Reoptimization is an optimizer feature that adjusts plans based on execution statistics; it is not configured or managed via database services.
C. SQL Performance Management is a collection of features for managing SQL execution plans; it operates at the SQL statement level, not the service level.
D. The SQL Tuning Advisor is a tool that analyzes specific SQL statements to provide tuning recommendations; its operation is independent of database services.

References

1. Oracle Real Application Clusters Administration and Deployment Guide, 19c, Chapter 4, "Making Applications Highly Available Using Services". The section "Services for the Database Resource Manager" states, "You can specify a service as an attribute of a resource consumer group."

2. Oracle Real Application Clusters Administration and Deployment Guide, 19c, Chapter 4, "Making Applications Highly Available Using Services". The section "Services for the Oracle Scheduler" states, "You can configure the Scheduler to use services to control the instances on which jobs run."

3. Oracle Database Administrator's Guide, 19c, Chapter 27, "Managing Resources with Oracle Database Resource Manager". This chapter explains the mapping of sessions to consumer groups, often based on connection attributes like service name.

Scroll to Top