Download Oracle Database 12c-Performance Management and Tuning.certkiller.1z0-064.2020-01-16.1e.71q.vcex
Download Exam
File Info
| Exam | Oracle Database 12c: Performance Management and Tuning |
| Number | 1z0-064 |
| File Name | Oracle Database 12c-Performance Management and Tuning.certkiller.1z0-064.2020-01-16.1e.71q.vcex |
| Size | 2.59 Mb |
| Posted | January 16, 2020 |
| Downloads | 97 |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: EXAMFILESCOM
With discount: 20%
Demo Questions
Question 1
Examine the partial TKPROF output for an SQL statement:
Which two inferences can definitely be made from this output? (Choose two.)
Which two inferences can definitely be made from this output? (Choose two.)
- A: Array fetch operations were not performed for this query.
- B: No hard parse was performed for this query.
- C: The number of logical I/Os is almost equal to the number of physical I/Os.
- D: Another transaction held a shared lock on the table, thereby causing a significant delay.
- E: An uncommitted transaction made a series of updates to the NAME_ID column just before the execution of this query.
Question 2
Which two actions can reduce library cache latch contention for an OLTP application that repeatedly executes queries containing a mix of literals and bind variables? (Choose two.)
- A: setting the OPEN_CURSORS parameter to hold a sufficient number of concurrently open cursors
- B: coding the application such that a frequently executed statement is parsed only once and executed repeatedly as required
- C: setting the CURSOR_SHARING parameter to EXACT
- D: avoiding the granting of privileges on objects associated with cursors during peak load
- E: enabling Automatic Memory Management and allocating at least 50% of the available memory for SHARED_POOL_SIZE
- F: configuring shared server connections
Question 3
You want to generate statistics for new objects added to an OLTP application without affecting old statistics and the sessions that currently use them.
Which two tasks would you perform to test the new statistics? (Choose two.)
Which two tasks would you perform to test the new statistics? (Choose two.)
- A: Set the OPTIMIZER_USE_PENDING_STATISTICS initialization parameter to TRUE for the session.
- B: Set the STALE_PERCENT statistics preference to zero and then gather statistics.
- C: Set the PUBLISH statistics preference to FALSE and then gather statistics.
- D: Use the DBMS_STATS.PUBLISH_PENDING_STATS procedure to make pending statistics the current statistics.
- E: Set the NO_INVALIDATE statistics preference to FALSE and gather statistics without affecting old statistics.
Question 4
You plan to upgrade your production database from Oracle Database 11g to 12c. As part of the upgrade, you want to introduce new indexes and materialized views. You have already created a test system with Oracle Database 12c, having the same structure and data as the production database, along with new schema objects to be added to the production database.
You want to identify regressed SQL statements, if any, which may have been caused by schema changes and the change in the optimizer version.
Which two methods would you use to achieve this? (Choose two.)
You want to identify regressed SQL statements, if any, which may have been caused by schema changes and the change in the optimizer version.
Which two methods would you use to achieve this? (Choose two.)
- A: Create an SQL Tuning Set (STS) for the SQL statements on the production database and submit as input to the SQL Tuning Advisor on the test database.
- B: Create an STS for the SQL statements on the production database and submit as input to the SQL Performance Analyzer with the OPTIMIZER_FEATURES_ENABLE parameter first set to 11.2.0.1, and then to 12.1.0.1on the test database.
- C: Generate an Automatic Workload Repository (AWR) compare periods report with snapshots taken before and after schema changes on the test database.
- D: Capture the production database workload, replay it on the test system by using Database Replay, and analyze by using the workload replay compare period report.
- E: Create an STS for the SQL statements on the production database and submit as input to the SQL Access Advisor on the test database.
- F: Create an STS for the SQL statements on the production database before and after changes and submit as input to the SQL Performance Analyzer on the test database.
Question 5
You recently joined a new team administering a database.
You notice that full table scans are performing poorly compared with full table scans on the databases you administered in a previous job.
You decide that performance problems are caused by a misconfiguration of factors affecting full table scans.
Which three factors should you investigate to determine the cause of the poorly performing Full Table Scans (FTS)? (Choose three.)
You notice that full table scans are performing poorly compared with full table scans on the databases you administered in a previous job.
You decide that performance problems are caused by a misconfiguration of factors affecting full table scans.
Which three factors should you investigate to determine the cause of the poorly performing Full Table Scans (FTS)? (Choose three.)
- A: value of DB_FILE_MULTIBLOCK_READ_COUNT
- B: storing query results in the result cache
- C: setting of the DISK_ASYNC_IO parameter to TRUE
- D: setting of the OPTIMIZER_MODE parameter to ALL_ROWS
- E: use of parallel queries
- F: block size of the tablespaces in which the tables being scanned are stored
- G: value of the OPTIMIZER_DYNAMIC_SAMPLING parameter
Question 6
Examine the Time Model Statistics section of an AWR report:
Which two inferences can be definitely derived from this section? (Choose two.)
Which two inferences can be definitely derived from this section? (Choose two.)
- A: The available CPU resources were not utilized to their maximum capacity.
- B: All sequence numbers used during this AWR time interval were cached.
- C: A large number of connected user sessions were idle.
- D: New child cursors were created because of new bind values or usage of literal values as well as different bind types or sizes.
- E: The DB CPU time was not spent exclusively for processing SQL statements.
Question 7
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.)
What should you examine to diagnose the cause of the top three wait events? (Choose the best answer.)
- A: the V$ACTIVE_SESSION_HISTORY view
- B: the Time Model Statistics section of the AWR report
- C: the SQL statements based on elapsed time from the AWR report
- D: the Latch Activity section
- E: the Segment Statistics section of the AWR report
Question 8
Examine the partial AWR report taken for a time period of 60 minutes:
Which two inferences can you draw from this report? (Choose two.)
Which two inferences can you draw from this report? (Choose two.)
- A: The database user calls are issuing frequent explicit commits.
- B: The CPUs are busy executing server processes and background processes for a considerable amount of CPU time.
- C: The database user calls are spending most of their time in I/O for single block reads.
- D: The database user calls are spending most of their time waiting for sessions that are in more important consumer groups.
Question 9
For your database some users complain about not being able to execute transactions. Upon investigation, you find that the problem is caused by some users performing long-running transactions that consume huge amounts of space in the UNDO tablespace.
You want to control the usage of the UNDO tablespace only for these user sessions.
How would you avoid the issue from repeating in future? (Choose the best answer.)
You want to control the usage of the UNDO tablespace only for these user sessions.
How would you avoid the issue from repeating in future? (Choose the best answer.)
- A: Create a profile for the users with the LOGICAL_READS_PER_SESSION and LOGICAL_READS_PER_CALL limits defined.
- B: Create external roles to restrict the usage of the UNDO tablespace and assign them to the users.
- C: Set the threshold for UNDO tablespace usage for the users.
- D: Implement a Database Resource Manager plan by mapping the users to a resource consumer group with limits defined for UNDO tablespace usage.
Question 10
You are administering a database that supports an OLTP workload. Users complain about the degraded response time of a query. You want to gather new statistics for objects accessed by the query and test query performance with the new statistics without affecting other sessions connected to the instance.
The STALE_PERCENT statistic preference is set to a default value and the STATISTICS_LEVEL parameter is set to TYPICAL.
Which two actions would you take to accomplish the task? (Choose two.)
The STALE_PERCENT statistic preference is set to a default value and the STATISTICS_LEVEL parameter is set to TYPICAL.
Which two actions would you take to accomplish the task? (Choose two.)
- A: Set the STALE_PERCENT statistic preference to a higher value than the default, and then gather statistics.
- B: Set the STATISTICS_LEVEL parameter to ALL for the instance.
- C: Set the INCREMENTAL preference to TRUE, and then gather statistics.
- D: Set the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE for the session in which you want to test the query.
- E: Set the PUBLISH statistic preference to FALSE, and then gather statistics.
- F: Set the NO_INVALIDATE statistic preference to TRUE, and then gather statistics.
HOW TO OPEN VCEX AND EXAM FILES
Use ProfExam Simulator to open VCEX and EXAM files
HOW TO OPEN VCE FILES
Use VCE Exam Simulator to open VCE files
