Download Oracle.1z0-064.Pass4Sure.2019-12-05.50q.tqb
| Vendor: | Oracle |
| Exam Code: | 1z0-064 |
| Exam Name: | Oracle Database 12c: Performance Management and Tuning |
| Date: | Dec 05, 2019 |
| File Size: | 2 MB |
| Downloads: | 1 |
Demo Questions
Question 1
Your database supports a mixed workload. The ERP application creates short sessions and performs small, random I/Os; the REPORTING application executes long-running DSS queries.
You want to set a priority for the workload generated by the ERP application and optimize resource usage for them.
Which three objectives can be achieved by the Resource Manager? (Choose three.)
- limiting the amount of time that a session is idle and blocking other sessions of the ERP application
- limiting the amount of undo generated by operations performed by sessions created by the ERP application
- creating two resource plans with resource limits defined for the workload generated by the applications and automatically changing resource plans based on the workload
- allocating a lower percentage of CPU to sessions used by the REPORTING application than to those used by the ERP application
- limiting the physical I/O performed by the sessions or users of the ERP application that are connected to the database
Correct answer: BDE
Question 2
Examine the partial TKPROF output for an SQL statement:
Which two inferences can definitely be made from this output? (Choose two.)
- Array fetch operations were not performed for this query.
- No hard parse was performed for this query.
- The number of logical I/Os is almost equal to the number of physical I/Os.
- Another transaction held a shared lock on the table, thereby causing a significant delay.
- An uncommitted transaction made a series of updates to the NAME_ID column just before the execution of this query.
Correct answer: BD
Question 3
In your database, the measured 99th percentile value is used as the maximum value. You set a warning threshold level of 110% of maximum trigger as an alert.
What is the outcome? (Choose the best answer.)
- It generates an error because the warning threshold cannot exceed 100%.
- It generates an error because the percentage of maximum threshold cannot be set with a significance-level threshold value.
- It generates an alert when an observed metric is 99% of the 99th percentile value as measured over the moving window baseline.
- It generates an alert when an observed metric is 110% of the 99th percentile value as measured over the moving window baseline.
- It generates an alert when 1 in 100 observations for an observed metric exceeds the 99th percentile value as measured over the fixed baseline.
Correct answer: A
