Download Oracle.1z0-064.SelfTestEngine.2018-12-17.50q.tqb
| Vendor: | Oracle |
| Exam Code: | 1z0-064 |
| Exam Name: | Oracle Database 12c: Performance Management and Tuning |
| Date: | Dec 17, 2018 |
| File Size: | 2 MB |
| Downloads: | 1 |
Demo Questions
Question 1
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
Question 2
You want to capture AWR data to monitor performance variation every Monday between 9:00 AM and 12:00 PM for three months and automatically remove the older AWR data every fortnight.
How would you achieve this? (Choose the best answer.)
- Create AWR baselines.
- Create SQL plan baselines.
- Create repeating baseline templates.
- Create database services and make sure that user connections use them to connect to the database instance.
- Create a single baseline template.
Correct answer: D
Question 3
Examine the partial TOP 10 Foreground Events by Total Wait Time section of an AWR report:
What should you examine to diagnose the cause of the top three wait events? (Choose the best answer.)
- the V$ACTIVE_SESSION_HISTORY view
- the Time Model Statistics section of the AWR report
- the SQL statements based on elapsed time from the AWR report
- the Latch Activity section
- the Segment Statistics section of the AWR report
Correct answer: B
