- Home
- Database
- Oracle 12 C
- OCA Oracle 12C Administration(1Z0-062)
81.
Which of these is performed by the Resource Manager?
- A.Percentages of CPU time are split up.
- B.Percentages of memory are split up.
- C.Percentages of swap space in *nix and virtual memory in Windows are split up.
- D.Disk space is split up.
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
| The Resource Manager in Oracle can only divide up CPU usage as a way of spread- ing out resource power between different requirements. |
82.
Which of these can be controlled by Resource Manager?
- A.Active session limits per user groups
- B.Assigning priorities
- C.Controlling runaway or out-of-control sessions
- D.Session idle time limits
- E.All of the above
- Answer & Explanation
- Report
Answer : [E]
Explanation :
Explanation :
| All of the options are true, and the Resource Manager can do much more than this. |
83.
Which of the following is the most significant and most effective allocation method
controlled by the Resource Manager?
- A.Allocate CPU use between competing sessions
- B.Allocate CPU use between competing sessions based on priorities
- C.Limiting parallel processing
- D.Session idle time limits
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| A is true, but unless some needs have higher priorities than others, there might be ill effects. Both C and D are correct, but they have far less impact overall than controlling and allocating the CPU cycles to the various tasks in a database. |
84.
How can runaway sessions be curtailed and prevented from overwhelming a system?
(Choose two.)
- A.Automatically aborting a session when archive log space is filled
- B.Automatically aborting a session when rollback reaches an upper limit
- C.Automatically aborting a transaction inside a session when the transaction is too large
- D.Automatically changing the CPU use of a session to a consumer group with a lower priority
- Answer & Explanation
- Report
Answer : [B,D]
Explanation :
Explanation :
| With respect to A, aborting a session has nothing to do with archive logs and archive log space exhaustion. For C, transactions cannot be controlled but sessions can. So a session can be aborted, but it can also have its allocation of CPU curtailed to reduce overhead by moving the session to a consumer group with less CPU cycles. |
85.
Which of these is a Resource Manager object?
- A.Plan direction
- B.Resource consumer plan
- C.Resource allocation method
- D.Subplan directive
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| Resources are allocated to plan directives, which are assigned to plans and subplans, and grouped with consumers of those plan directives into resource consumer groups. |
|
|
||||||||||||||||||||||||||||
