Download Oracle Database 12c: Performance Management and Tuning.1z0-064.Pass4Sure.2019-12-05.50q.vcex

Vendor: Oracle
Exam Code: 1z0-064
Exam Name: Oracle Database 12c: Performance Management and Tuning
Date: Dec 05, 2019
File Size: 2 MB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAMFILESCOM

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

Demo Questions

Question 1
Your database supports a mixed workload. The ERP application creates short sessions and performs small, random I/Os; the REPORTING application executes long-running DSS queries. 
You want to set a priority for the workload generated by the ERP application and optimize resource usage for them. 
Which three objectives can be achieved by the Resource Manager? (Choose three.)
  1. limiting the amount of time that a session is idle and blocking other sessions of the ERP application
  2. limiting the amount of undo generated by operations performed by sessions created by the ERP application
  3. creating two resource plans with resource limits defined for the workload generated by the applications and automatically changing resource plans based on the workload
  4. allocating a lower percentage of CPU to sessions used by the REPORTING application than to those used by the ERP application
  5. limiting the physical I/O performed by the sessions or users of the ERP application that are connected to the database
Correct answer: BDE
Question 2
Examine the partial TKPROF output for an SQL statement:
  
Which two inferences can definitely be made from this output? (Choose two.)
  1. Array fetch operations were not performed for this query.
  2. No hard parse was performed for this query.
  3. The number of logical I/Os is almost equal to the number of physical I/Os.
  4. Another transaction held a shared lock on the table, thereby causing a significant delay.
  5. An uncommitted transaction made a series of updates to the NAME_ID column just before the execution of this query.
Correct answer: BD
Question 3
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.)
  1. It generates an error because the warning threshold cannot exceed 100%.
  2. It generates an error because the percentage of maximum threshold cannot be set with a significance-level threshold value.
  3. It generates an alert when an observed metric is 99% of the 99th percentile value as measured over the moving window baseline.
  4. It generates an alert when an observed metric is 110% of the 99th percentile value as measured over the moving window baseline.
  5. 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 4
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.)
  1. setting the OPEN_CURSORS parameter to hold a sufficient number of concurrently open cursors
  2. coding the application such that a frequently executed statement is parsed only once and executed repeatedly as required
  3. setting the CURSOR_SHARING parameter to EXACT
  4. avoiding the granting of privileges on objects associated with cursors during peak load
  5. enabling Automatic Memory Management and allocating at least 50% of the available memory for SHARED_POOL_SIZE
  6. configuring shared server connections
Correct answer: CE
Explanation:
Question 5
You are administering a database that supports multiple applications, which make dedicated connections to the database instance by using different services. 
You execute the command to enable tracing of the ORCL1 service:
  
Which two statements are true? (Choose two.)
  1. A single trace file is generated for all sessions mapped to the ORCL1 service.
  2. SQL trace is enabled for all modules and actions for sessions mapped to the ORCL1 service.
  3. A SQL trace file is generated for each session that maps to the ORCL1 service.
  4. A SQL trace file is generated for each of the modules using the ORCL1 service.
  5. SQL trace is not enabled for the service because a module name is not specified.
Correct answer: AC
Question 6
In which three situations can dynamic statistics be used? (Choose three.)
  1. when the sampling time is a small fraction of the total time for a query
  2. when an execution plan is suboptimal because of complex predicates
  3. when extended statistics are not available for SQL statements that use complex predicates
  4. when a query is on a partitioned table with a global index
  5. when index statistics are missing on a column that is used in SQL statements with highly selective filters
Correct answer: BCD
Explanation:
Question 7
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.)
  1. Set the OPTIMIZER_USE_PENDING_STATISTICS initialization parameter to TRUE for the session.
  2. Set the STALE_PERCENT statistics preference to zero and then gather statistics.
  3. Set the PUBLISH statistics preference to FALSE and then gather statistics.
  4. Use the DBMS_STATS.PUBLISH_PENDING_STATS procedure to make pending statistics the current statistics.
  5. Set the NO_INVALIDATE statistics preference to FALSE and gather statistics without affecting old statistics.
Correct answer: AB
Question 8
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.)
  1. value of DB_FILE_MULTIBLOCK_READ_COUNT
  2. storing query results in the result cache
  3. setting of the DISK_ASYNC_IO parameter to TRUE
  4. setting of the OPTIMIZER_MODE parameter to ALL_ROWS
  5. use of parallel queries
  6. block size of the tablespaces in which the tables being scanned are stored
  7. value of the OPTIMIZER_DYNAMIC_SAMPLING parameter
Correct answer: ABC
Question 9
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.)
  1. the V$ACTIVE_SESSION_HISTORY view
  2. the Time Model Statistics section of the AWR report
  3. the SQL statements based on elapsed time from the AWR report
  4. the Latch Activity section
  5. the Segment Statistics section of the AWR report
Correct answer: B
Question 10
Examine the partial AWR report taken for a time period of 60 minutes:
  
Which two inferences can you draw from this report? (Choose two.)
  1. The database user calls are issuing frequent explicit commits.
  2. The CPUs are busy executing server processes and background processes for a considerable amount of CPU time.
  3. The database user calls are spending most of their time in I/O for single block reads.
  4. The database user calls are spending most of their time waiting for sessions that are in more important consumer groups.
Correct answer: BC
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!