- Home
- Database
- Oracle 12 C
- OCA Oracle 12C Administration(1Z0-062)
86.
Which of these packages are used to administer the Resource Manager? (Choose two.)
- A.DBMS_RESOURCE_MANAGER
- B.DBMS_RESOURCE_MANAGEMENT
- C.DBMS_RESOURCE_MANAGE
- D.DBMS_RESOURCE_MANAGER_PRIVS
- E.DBMS_RESOURCE_MANAGEMENT_PRIVS
- Answer & Explanation
- Report
Answer : [A, D]
Explanation :
Explanation :
| The packages are called DBMS_RESOURCE_MANAGER and DBMS_RESOURCE_MANAGER_PRIVS. |
87.
A consumer group object can be assigned to which of the following? (Choose two.)
- A.A plan
- B.A subplan
- C.A consumer group
- D.None of the above
- Answer & Explanation
- Report
Answer : [A, B]
Explanation :
Explanation :
| Plans and subplans contain the details of how resources are allocated. Consumer groups simply group together the consumers that will consume the details of the plans. |
88.
If a plan contains two subplans and one consumer group is below the subplan level,
and each of the subplans is allocated 45 percent of CPU cycles each, what is the most
that can be allocated to the consumer group, assuming that the subplans and plan are
fully occupied?
- A.11 percent
- B.45 percent
- C.5 percent
- D.0 percent
- E.None of the above
- Answer & Explanation
- Report
Answer : [E]
Explanation :
Explanation :
| E is correct because the total must add up to 100 percent, where the consumer group can have a maximum of 10 percent. |
89.
Which of these can help prevent parallel processing limits from being exceeded, and
help to prevent a database from being swamped by parallel executing queries?
- A.Degree of parallelism
- B.Parallel server processes
- C.Parallel queue timeouts
- D.All of the above
- E.None of the above
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| All three of these settings are useful for controlling parallel processing. The degree of parallelism can be used to execute queries and some DML statements much faster. When a parallel process is started, it starts up multiple parallel servers to handle the separate parallel executed threads. Parallel queue timeouts force parallel processes to abort a little sooner. All of these settings will help to prevent overzealous parallel pro- cessing from becoming out of control parallel processing, which can swamp and drasti- cally slow database performance. |
90.
How many levels of utilization are there for CPU allocation in the Resource Manager?
- A.0
- B.1
- C.15
- D.8
- E.None of the above
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| Eight hierarchical layers of CPU utilization can be set for a multiple level hierarchy of plans, subplans, and consumer groups. |
|
|
||||||||||||||||||||||||||||
