1Z0-084 practice question 6 of 15
Which two Oracle Database features use database services?
Full set: 55 questionsDatabase 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.
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.
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.
Keep practicing
Take the free 1Z0-084 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-084 practice questions
- Question 1What are the least elevated values of statistics_level and C0NTR0LJ4ANAGEMENT_PACK_ACCESS…
- Question 2You execute the following: EXECUTE DBMS_AuTO_TASK_ADMIN.DISABLE; Which advisor remains en…
- Question 3You must produce a consolidated formatted trace file by combining all trace files generat…
- Question 4Which procedure gathers statistics that are always used in the generation of any executio…
- Question 5Which two statements are true about the use and monitoring of Buffer Cache Hit ratios and…
- Question 7Which two statements are true about cursor sharing?
