File Info
| Exam | Oracle Database 12c: Performance Management and Tuning |
| Number | 1z0-064 |
| File Name | Oracle.1z0-064.CertDumps.2017-11-22.84q.vcex |
| Size | 3 MB |
| Posted | Nov 22, 2017 |
| Download | Oracle.1z0-064.CertDumps.2017-11-22.84q.vcex |
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
Examine the Load Profile section of an AWR report:
Which two inferences can you derive from the details in this section? (Choose two.)
- The values for Redo size and Block changes imply that only updates were performed by transactions.
- The values for Parses (SQL) and Hard parses (SQL) imply that cursor sharing occurred quite often.
- The values for DB Time and DB CPU imply that the database had a high proportion of idle time during the specified snapshot interval.
- The values for SQL Work Area and User calls imply that only sort-based operations were performed.
- 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.
Correct answer: BD
Question 2
Which two statements are true about the interpretation of Buffer Cache Hit Ratio in the Instance Efficiency Percentages section of an AWR report? (Choose two.)
- A high value indicates that the buffer cache is adequately sized for the current workload.
- Poor hit ratios indicate that a large number of indexed lookups or small table scans are being performed.
- A low hit ratio does not necessarily imply that increasing the size of the buffer cache will improve performance.
- A high hit ratio may indicate that repeated scanning of the same large table or index is being performed.
- A low hit ratio indicates that a KEEP buffer pool should be configured based on the size of the largest object accessed in the buffer cache.
Correct answer: CE
Question 3
Which four objectives are achieved by using Resource Manager to manage multiple concurrent user sessions that are competing for resources? (Choose four.)
- distributing available CPU by allocating percentages of CPU time to different users and applications
- limiting the degree of parallelism of any operation performed by members of a group of users
- limiting queries based on resource consumption of runaway sessions or calls that consume more than a specified amount of CPU, physical I/O, logical I/O, or elapsed time
- limiting the number of concurrent sessions for a user
- limiting the number of user sessions allowed to be concurrently active within a group of users
- limiting the number of parallel executions that can be executed by a user
Correct answer: ACEF
Question 4
Which two statements are true about server-generated alerts? (Choose two.)
- They are always logged in the alert log.
- They are written to a trace file if the TRACE_ENABLED initialization parameter is set to TRUE.
- They are generated only when the STATISTICS_LEVEL initialization parameter is set to ALL.
- They can be generated for user-defined metric thresholds.
- They appear in the DBA_ALERT_HISTORY view whenever corrective action is taken for an alert.
Correct answer: CD
Question 5
Examine the parameters:
Your database supports a mixed workload and users have dedicated server connections. Users complain about the increased response time of a few queries that are performing large sort operations. On investigation, you notice an increase in the number of multipass work area executions and high number of direct path write wait events.
Which two actions could improve the performance? (Choose two.)
- increasing the value of the SORT_AREA_SIZE parameter
- increasing the value of the PGA_AGGREGATE_TARGET parameter
- enabling Automatic Memory Management for the instance
- increasing the size of the default temporary tablespace
- using parallel hint in queries performing large sort operations
- enabling Automatic Shared Memory Management for the instance
Correct answer: AF
Question 6
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 addedback 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.)
- Increase the number of ASMB processes.
- Decrease the value of the ASM_POWER_LIMIT parameter.
- Set the DISK_REPAIR_TIME disk attribute to a lower value.
- Specify the POWER clause with a lower value in an ALTER DISKGROUP statement.
- Set the DISK_REPAIR_TIME disk attribute to a higher value.
Correct answer: BD
Question 7
You are administering a database that supports a mixed workload. The CURSOR_SHARING parameter is set to the default value. While analyzing the latest Automatic Workload Repository (AWR) report, you find a large number of cursor: pin S wait on X, cursor: pin X wait on S, and library cache mutex waits in the Top 10 foreground events section.
Examine the Instance Efficiency Percentages section in the AWR report:
Which three statements are true in this scenario? (Choose three.)
- Sessions are waiting for mutexes in share mode on cursors but other sessions are holding the mutexes in exclusive mode.
- The CPU is spending more time in finding cursors in the library cache.
- Cursors are not getting shared, resulting in a large number of hard parses.
- Sessions are waiting for mutexes in exclusive mode on cursors but other sessions are holding the mutexes in share mode.
- The buffers required by queries are not found in the buffer cache, thereby increasing expensive disk I/O.
Correct answer: BDE
Question 8
Which two statements are true about ADDM or Real-Time ADDM? (Choose two.)
- ADDM can be run manually by selecting any range of AWR snapshots available within the AWR retention period, provided they do not cover a time period when the instances were restarted.
- ADDM runs in Partial mode to analyze any hung database issues.
- Real-Time ADDM can proactively detect and diagnose transient performance issues that last for a few seconds.
- Real-Time ADDM is automatically invoked by ADDM at the end of every hour.
Correct answer: BC
Question 9
Which three actions should you perform to reduce shared pool fragmentation and avoid the "ORA-04031: unable to allocate .... bytes of shared memory" error for the shared pool? (Choose three.)
- Configure the Server Result Cache.
- Configure shared server mode.
- Identify the packages or procedures that are causing the "ORA-04031: unable to allocate ....bytes of shared memory" error and use the DBMS_SHARED_POOL.KEEP to keep them in the shared pool.
- Use DBMS_SHARED_POOL.KEEP to keep the SYS.STANDARD, SYS.DBMS_STANDARD, and SYS.DIUTILpackages and frequently executed compiled triggers.
- Use more anonymous procedures.
- Standardize the type, size, and naming conventions for bind variables and spacing conventions for SQLstatements and PL/SQL blocks.
Correct answer: ABD
Question 10
Examine the parameters set for your database instance:
You are administering a database that supports an OLTP workload. Users complain about the degraded performance of some queries. While diagnosing, you notice a large number of hard parses occurring for several syntactically almost identical SQL statements that differ only in literal values in the WHERE clause.
Which two actions would you recommend to improve performance? (Choose two.)
- Create the KEEP cache and cache the tables used in the queries.
- Set the CURSOR_SHARING parameter to FORCE.
- Use bind variables instead of literals.
- Create SQL plan baselines for the almost identical SQL statements and load them into the cursor cache.
- Set the OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameter to TRUE.
Correct answer: BE
