we provide 100% Guarantee Oracle 1z0-054 free practice exam which are the best for clearing 1z0-054 test, and to get certified by Oracle Oracle Database 11g: Performance Tuning. The 1z0-054 Questions & Answers covers all the knowledge points of the real 1z0-054 exam. Crack your Oracle 1z0-054 Exam with latest dumps, guaranteed!
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1z0-054 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Q11. View the Exhibit and examine the partial output obtained when you issued the following query:
SQL> SELECT name,class,value FROM v$sysstat ORDER BY class;
Which two interpretations are correct about the information obtained from this view? (Choose two.)
A. db block changes indicates the number of data blocks that have been changed.
B. buffer is pinned count indicates the number of buffers that are currently pinned in the database instance.
C. Usage of CACHE and NOCACHE hints affects statistics for table scans (long tables) and table scans (short tables).
D. redo log space requests indicates the number of times a there were waits for disk space to be allocated for the redo log entries.
Q12. While configuring the snapshot data capture for your database, you have specified the snapshot level setting as 6.
Which statistics would be captured by the Statspack report? (Choose all that apply.)
A. resource limit
B. memory statistics
C. parent and child latches
D. segment-level statistics
E. optimizer execution plans
Q13. The SALES table in your database undergoes frequent changes. While observing the statistics for the table in the middle of the day, you find a change since the last observation. But the information about the statistics collection is not recorded in the DBA_TAB_STATS_HISTORY.
Identify the reason for this.
A. The AWR retention time was set to zero.
B. The STATISTICS_LEVEL parameter was set to BASIC.
C. Some of the statistics were collected using the ANALYZE command.
D. There were user-defined statistics that were set by using the DBMS_STATS.SET_TABLE_STATS procedure.
Q14. View the Exhibit.Which statement is true about applying the threshold setting in the Exhibit.
A. The threshold does not depend on any baseline.
B. The threshold is decided by comparing the warning and threshold values with the LAST_NIGHT baseline.
C. The threshold is decided by comparing the warning and threshold values with the SYSTEM_MOVING_WINDOW baseline.
D. The threshold is decided by comparing the warning and critical values with the baseline set on the performance page.
Q15. You query the V$SYSSTAT view and notice a significantly high value for the redo log space requests statistic.
Which three components would you consider for further investigation based on this information? (Choose three.)
C. archiver activity
D. size of the log buffer
E. size of the redo log files
Q16. You work as a database administrator to manage an online transaction processing (OLTP) system.The application code was recently tuned for optimum performance and users acknowledged the performance improvement. However, the users are now again complaining that the application response time has gone down considerably. You used a few queries to investigate the problem and a couple of important queries are shown in the Exhibit. View the Exhibit and analyze the output shown.
Which actions would improve the performance? (Choose all that apply.)
A. increasing the number database writers
B. decreasing the number of database writers
C. increasing the size of the database buffer cache
D. decreasing the size of the database buffer cache
E. decreasing the value set to the FAST_START_MTTR_TARGET parameter
Q17. Identify the situation in which you would use the Automatic Workload Repository (AWR) baseline template.
A. when creating AWR snapshots based on a repeating time schedule
B. when creating and dropping AWR baselines based on a repeating time schedule
C. when computing statistics for all moving window baselines based on a repeating time schedule in the future
D. when resetting the threshold values for the SYSTEM_MOVING_WINDOW baseline based on a repeating time schedule in the future
Q18. You are working on an online transaction processing (OLTP) system. You are investigating the reasons for performance degradation in the database. View the Exhibit named TOP5EVENTS and note the top five events.
View the Exhibit named TOPSQL and note the problems related to these statements.
View the Exhibit named INSTACT and note the table scans.
Which is the most appropriate solution?
A. Create indexes on short tables.
B. Use the CACHE hint to access long tables.
C. Keep the long tables in the keep buffer pool.
D. Keep the short tables in the keep buffer pool.
E. Keep the short tables in the recycle buffer pool.
Q19. Your database has the HR and Reporting applications. The HR application does most of the transactions on the database and the Reporting application does most of the batch processing operations.The Reporting application has more workload during nonpeak hours. Both the HR and Reporting applications run on the middle tier using connection pooling for connecting to database.You want to statistically measure the workload generated by both the applications and set priority for the workload generated by the applications.
Which option would help you achieve this?
A. Assigning individual sessions created by the applications to consumer groups and setting relative priority
B. Assigning profiles to individual sessions created by the applications to set the relative priority for the resource usage
C. Creating services for the applications and setting the relative priority of services within an instance by binding the services directly to consumer groups
D. Creating services for the applications and assigning different profiles to the sessions created by the sessions to set the relative priority for the resource usage
Q20. Which two inferences are correct about the CPU time and the wait time that appear in the Automatic Workload Repository AWR and Statspack reports in the Top 5 Event section? (Choose two.)
A. Adding CPUs to systems showing increased wait time due to contention will improve response time.
B. Systems where the CPU time is dominant in comparison to the wait time have optimal response time.
C. Increase in wait time when the CPU time increases or remains the same indicates an increase in the load on the system.
D. Systems where the proportion of CPU time does not decrease significantly with increasing load would most likely benefit from adding CPUs.
E. The appearance of CPU time together with wait time in the Top 5 Event section of the AWR report of a system always indicates high contention.