Download Oracle Database 12c: Performance Management and Tuning.1z0-064.SelfTestEngine.2018-12-17.50q.vcex

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

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAM_HUB

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

Demo Questions

Question 1
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 2
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.)
  1. Create AWR baselines.
  2. Create SQL plan baselines.
  3. Create repeating baseline templates.
  4. Create database services and make sure that user connections use them to connect to the database instance.
  5. Create a single baseline template.
Correct answer: D
Question 3
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 4
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
Question 5
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.)
  1. Create a profile for the users with the LOGICAL_READS_PER_SESSION and LOGICAL_READS_PER_CALL limits defined.
  2. Create external roles to restrict the usage of the UNDO tablespace and assign them to the users.
  3. Set the threshold for UNDO tablespace usage for the users.
  4. Implement a Database Resource Manager plan by mapping the users to a resource consumer group with limits defined for UNDO tablespace usage.
Correct answer: D
Question 6
Which two actions should you take to monitor the throughput generated by the modules of an application? (Choose two.)
  1. Use the Resource Manager.
  2. Enable SQL Trace at the session level.
  3. Create a service.
  4. Use a dedicated server configuration.
  5. Use the DBMS_APPLICATION_INFO package to define the current module and action so that they appear in V$SESSION.
Correct answer: AB
Question 7
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.)
  1. Set the STALE_PERCENT statistic preference to a higher value than the default, and then gather statistics.
  2. Set the STATISTICS_LEVEL parameter to ALL for the instance.
  3. Set the INCREMENTAL preference to TRUE, and then gather statistics.
  4. Set the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE for the session in which you want to test the query.
  5. Set the PUBLISH statistic preference to FALSE, and then gather statistics.
  6. Set the NO_INVALIDATE statistic preference to TRUE, and then gather statistics.
Correct answer: BE
Question 8
Examine the structure of the EMPLOYEES table. 
  
EMPLOYEE_ID is the primary key. No other indexes exist on this table. 
View the Exhibit to examine the commands and their output. 
  
Which two actions should you perform to make the cursor bind aware? (Choose two.)
  1. Create a histogram on the DEPARTMENT_ID column.
  2. Change the default CURSOR_SHARING value to FORCE.
  3. Execute the query with the same DEPARTMENT_ID value multiple times.
  4. Create an index on the DEPARTMENT_ID column.
  5. Gather statistics for the index.
  6. Regather statistics on the table.
Correct answer: CD
Question 9
Examine the output of the query executed to diagnose the reason for performance degradation of queries:
  
Which three factors will you investigate further to identify the cause of the performance degradation? (Choose three.)
  1. Check the number of disk sorts.
  2. Check for the causes of the full table scans.
  3. Check the number of chained or migrated rows.
  4. Check the indexes on the tables used in queries for clustering factor.
  5. Check the size of the temporary tablespace for sorting operations.
Correct answer: ABC
Question 10
Examine the parameters set for your database instance:
  
You are asked by a developer to create a table for an application with these requirements:
  • The table will be used for a DSS application. 
  • High volume bulk loads will be performed. 
  • The table will be used to store archival data on which large full-table scans (FTS) will be performed. 
Which attributes are the best for the tablespace in which this table should be created? (Choose the best answer.)
  1. Create it in a locally managed tablespace with ASSM enabled and assign a high value for the PCTFREE attribute.
  2. Create it in a locally managed tablespace with manual segment space management.
  3. Create it in a locally managed tablespace with a bigger nonstandard block size and ASSM enabled.
  4. Create it in locally managed tablespace with ASSM enabled and an additional freelist.
Correct answer: C
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!