File Info
| Exam | Oracle Database 12c: Performance Management and Tuning |
| Number | 1z0-064 |
| File Name | Oracle.1z0-064.SelfTestEngine.2018-12-17.50q.tqb |
| Size | 2 MB |
| Posted | Dec 17, 2018 |
| Download | Oracle.1z0-064.SelfTestEngine.2018-12-17.50q.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
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
