READ Free Dumps For Oracle- 1z0-058
| Question ID 2035 | The DBA has executed the command: |
| Option A | A. Creates a singleton service named batch using the server pool sp2 with a manual service management policy. |
| Option B | B. Creates a singleton service named batch for the prod database by using only server pool SP2 with a manual service management policy. |
| Option C | C. Creates a singleton service named batch, which runs by default in the prod database by using the server pool SP2 with a manual service management policy, but can fail over to other databases. |
| Option D | D. Creates a singleton service, which is only used for batch workloads for the prod database by using only server pool sp2 with a manual service management policy. |
| Correct Answer | B |
| Question ID 2036 | You are managing a policy-managed three-instance RAC database. You ran database ADDM for the database and noticed gc current block congested and gc cr block congested waits. What are two possible reasons for these wait events? |
| Option A | A. The wait events indicate a delay in processing has occurred in the Global Cache Services (GCS), which is usually caused by high load. |
| Option B | B. The wait times indicate that the blocks must wait after initiating a gc block request, for the round trip from the start of the wait until the blocks arrive. |
| Option C | C. The wait events indicate that there is block contention resulting in multiple requests for access to local blocks. |
| Option D | D. The wait events indicate that the local instance making the request for current or consistent read blocks was waiting for logical I/O from its own buffer cache at the same time. |
| Correct Answer | A,B |