Oracle 1z0-064 問題集

質問 1：
You are administrating a database that supports an OLTP workload. A few users complain about the poor performance of some SQL statements. You notice that these SQL statements belong to different applications and conclude that there is no correlation between them. You create a SQL Tuning Set (STS) containing these SQL statements.
What must you do to analyze and generate recommendations for the SQL statements in the STS?
A. Submit the STS as input to the SQL Access Advisor to generate recommendations for SQL profiles.
B. Submit the STS as input to the SQL Tuning Advisor to generate recommendations for SQL plan baselines.
C. Submit the STS as input to the SQL Performance Analyzer to generate recommendations for creating indexes and materialized views.
D. Submit the STS as input to the SQL Tuning Advisor to generate recommendations for indexes or SQL profiles or both.
正解：B

質問 2：
You are administrating a database that supports an OLTP workload. A new application module is deployed that is shipped along with the SQL plan baselines for the SQL statements executed by the application. You load the SQL plan baselines to the SQL Management Base.
Examine the parameters:

Which two statements are true in this scenario?
A. The SQL plan baselines are used but better execution plans may be found and can be evolved manually for the SQL statements.
B. The SQL plan baselines are used by the SQL statements and ensure that the best plan is used.
C. The SQL plan baselines are not used by the SQL statements if the optimizer statistics are stale.
D. The SQL plan baselines are loaded but are not used until SQL profiles are generated for the SQL statements.
正解：C,D

質問 3：
Your database supports an OLTP workload during the day and batch processing at night. You want to monitor performance metrics to detect any degradation of performance in both types of workloads over a time period of 30 days.
Examine this list of possible steps:
1. Create a fixed baseline.
2. Create a baseline template.
3. Create a new moving window baseline.
4. Increase the retention period default value to 30 days.
5. Increase the size of the existing moving window baseline to 30 days.
6. Create warning and critical alerts for the relevant metrics.
7. Enable adaptive thresholds to detect the workload patterns and specify a high-significance-level threshold type.
8. Enable adaptive thresholds to detect the workload patterns and set different threshold values as a percentage of the maximum value.
Which option represents the required steps in the correct order? (Choose the best answer.)
A. 3, 4, 8
B. 4, 5, 7
C. 5, 7
D. 2, 4, 3
E. 5, 1, 6, 8
正解：E

質問 4：
Examine the Load Profile section of an AWR report:

Which two inferences can you derive from the details in this section? (Choose two.)
A. The values for DB Time and DB CPU imply that the database had a high proportion of idle time during the specified snapshot interval.
B. The values for Redo size and Block changes imply that only updates were performed by transactions.
C. The values for Parses (SQL) and Hard parses (SQL) imply that cursor sharing occurred quite often.
D. 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.
E. The values for SQL Work Area and User calls imply that only sort-based operations were performed.
正解：C,E

質問 5：
Your database supports an online transaction processing (OLTP) workload. The database uses ASM storage. One of the ASM disks goes offline because of hardware failure. When the disk is replaced and then added back to the diskgroup, database performance is affected by rebalance operations.
Which two actions would you recommend to lower the impact of rebalance operations on the performance of the database? (Choose two.)
A. Decrease the value of the ASM_POWER_LIMIT parameter.
B. Set the DISK_REPAIR_TIME disk attribute to a higher value.
C. Set the DISK_REPAIR_TIME disk attribute to a lower value.
D. Specify the POWER clause with a lower value in an ALTER DISKGROUP statement.
E. Increase the number of ASMB processes.
正解：A,D

質問 6：
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.)
A. Create AWR baselines.
B. Create repeating baseline templates.
C. Create SQL plan baselines.
D. Create a single baseline template.
E. Create database services and make sure that user connections use them to connect to the database instance.
正解：E