File Info
| Exam | Oracle Database 12c: Performance Management and Tuning |
| Number | 1z0-064 |
| File Name | Oracle.1z0-064.NewDumps.2017-11-22.84q.tqb |
| Size | 3 MB |
| Posted | Nov 22, 2017 |
| Download | Oracle.1z0-064.NewDumps.2017-11-22.84q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
Examine the Load Profile section of an AWR report:
Which two inferences can you derive from the details in this section? (Choose two.)
- The values for Redo size and Block changes imply that only updates were performed by transactions.
- The values for Parses (SQL) and Hard parses (SQL) imply that cursor sharing occurred quite often.
- The values for DB Time and DB CPU imply that the database had a high proportion of idle time during the specified snapshot interval.
- The values for SQL Work Area and User calls imply that only sort-based operations were performed.
- The values for Logical reads and Physical reads imply that the number of disk reads per second was less than the total number of DB block reads and consistent gets per second.
Correct answer: BD
Question 2
Which two statements are true about the interpretation of Buffer Cache Hit Ratio in the Instance Efficiency Percentages section of an AWR report? (Choose two.)
- A high value indicates that the buffer cache is adequately sized for the current workload.
- Poor hit ratios indicate that a large number of indexed lookups or small table scans are being performed.
- A low hit ratio does not necessarily imply that increasing the size of the buffer cache will improve performance.
- A high hit ratio may indicate that repeated scanning of the same large table or index is being performed.
- A low hit ratio indicates that a KEEP buffer pool should be configured based on the size of the largest object accessed in the buffer cache.
Correct answer: CE
Question 3
Which four objectives are achieved by using Resource Manager to manage multiple concurrent user sessions that are competing for resources? (Choose four.)
- distributing available CPU by allocating percentages of CPU time to different users and applications
- limiting the degree of parallelism of any operation performed by members of a group of users
- limiting queries based on resource consumption of runaway sessions or calls that consume more than a specified amount of CPU, physical I/O, logical I/O, or elapsed time
- limiting the number of concurrent sessions for a user
- limiting the number of user sessions allowed to be concurrently active within a group of users
- limiting the number of parallel executions that can be executed by a user
Correct answer: ACEF
