Oracle 1Z0-064 Dumps Questions 2021

We offers . "Oracle Database 12c: Performance Management and Tuning", also known as 1Z0-064 exam, is a Oracle Certification. This set of posts, Passing the 1Z0-064 exam with , will help you answer those questions. The covers all the knowledge points of the real exam. 100% real and revised by experts!

Oracle 1Z0-064 Free Dumps Questions Online, Read and Test Now.

NEW QUESTION 1
Which two statements are true about Compare Period ADDM? (Choose two.)

  • A. It is automatically invoked whenever the AWR Compare Period report is invoked.
  • B. It is automatically invoked whenever ADDM is run by default.
  • C. It verifies if there is any change in the workload or average resource consumption by the SQL executed during the two specified time periods, to ensure 100% accuracy.
  • D. It can be used to create a comparison report between the Database Replay workload capture report and the replay report.

Answer: CD

NEW QUESTION 2
Examine the partial Activity Over Time section of an Active Session History (ASH) report:
1Z0-064 dumps exhibit
Which two inferences are correct? (Choose two.)

  • A. In the first time slot, five different sampled sessions were connected to the database instance.
  • B. In the second time slot, out of the nine sampled sessions connected to the database instance, only one sampled session was idle at the time of report generation.
  • C. In the first time slot, only one sampled session was using the CPU.
  • D. In the second time slot, five different sampled sessions were using the CPU.
  • E. In the second time slot, 0.14% of the time was spent on the CPU.

Answer: AE

NEW QUESTION 3
Users complain about increased response time for queries in your production database that supports an OLTP workload. On investigation, you notice a large number of db file scattered read, latch: cache buffers lru chain, and latch: cache buffers chains wait events:
Identify three possible reasons for the increased response time. (Choose three.)

  • A. too many sort operations being performed
  • B. repeated simultaneous access to a block or small number of blocks
  • C. the shared pool is inadequately sized
  • D. queries not using indexes and performing full table scans
  • E. queries repeatedly fetching blocks that are not in the database buffer cache
  • F. cursors are closed explicitly after each execution

Answer: BDE

NEW QUESTION 4
You are administering a database that supports an OLTP workload. CURSOR_SHARING is set to EXACT for the instance. An application is frequently executing almost identical queries that vary in literal values in the WHERE clause, causing a large number of hard parses to occur.
Which four statements would be true if you use bind variables for these queries? (Choose four.)

  • A. Mutex contention in the library cache will be reduced.
  • B. The optimizer will use one parent cursor and one child cursor for each SQL statement with different literal values.
  • C. Hard parses will be reduced for the queries.
  • D. The optimizer will use bind peeking and subsequent execution of the queries will always generate the same plans irrespective of the cardinality.
  • E. The optimizer will generate the same plan for all bind values if no histograms exist on the columns used in the WHERE clause of these queries.
  • F. The optimizer will use bind peeking and use the literal value to determine the execution plan for these queries.

Answer: ACDE

NEW QUESTION 5
In which three situations can dynamic statistics be used? (Choose three.)

  • A. when the sampling time is a small fraction of the total time for a query
  • B. when an execution plan is suboptimal because of complex predicates
  • C. when extended statistics are not available for SQL statements that use complex predicates
  • D. when a query is on a partitioned table with a global index
  • E. when index statistics are missing on a column that is used in SQL statements with highly selective filters

Answer: ABC

Explanation: Reference: https://docs.oracle.com/database/121/TGSQL/tgsql_statscon.htm#TGSQL341

NEW QUESTION 6
In the CUSTOMERS table, the values in the CUST_STATE column are dependent on the values in the COUNTRY_ID column. You want to make the optimizer aware of this dependency when these columns are used together in WHERE clause predicates that contain equalities or in-lists.
Which two methods achieve this? (Choose two.)

  • A. gathering statistics on the CUSTOMERS table and its dependent objects, and then locking the statistics
  • B. using SQL plan directives to generate an optimal plan
  • C. setting the dynamic statistics level to 4 and setting the OPTIMIZER_USE_PENDING_STATISTICS initialization parameter to true
  • D. creating column group statistics, regathering statistics, and ensuring that histograms exist on both these columns

Answer: AD

NEW QUESTION 7
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:
1Z0-064 dumps exhibit
Which two statements are true? (Choose two.)

  • A. A single trace file is generated for all sessions mapped to the ORCL1 service.
  • B. SQL trace is enabled for all modules and actions for sessions mapped to the ORCL1 service.
  • C. An SQL trace file is generated for each session that maps to the ORCL1 service.
  • D. An SQL trace file is generated for each of the modules using the ORCL1 service.
  • E. SQL trace is not enabled for the service because a module name is not specified.

Answer: AC

NEW QUESTION 8
You are administering a database that supports a DSS workload. Automatic Shared Memory Management is enabled for the database instance. Users issue queries to perform large soft operations and complain about degraded performance of the queries. On investigation, you notice that the queries are performing multipass work area executions and the I/O contention on one of the temporary tablespaces is very high.
Which two can be possible resolutions for this issue? (Choose two.)

  • A. Increase the size of the large pool.
  • B. Increase the value of the PGA_AGGREGATE_TARGET parameter.
  • C. Create a temporary tablespace group and assign it to users.
  • D. Increase the value of the PGA_AGGREGATE_LIMIT parameter.
  • E. Create another temporary tablespace and assign it to users.
  • F. Enable temporary undo.

Answer: CD

NEW QUESTION 9
Examine the parameters set for a database instance supporting a mixed workload:
1Z0-064 dumps exhibit
The database instance supports shared server and dedicated server connections simultaneously. Users complain about increased response times of a few DSS queries. During investigation, you execute the queries:
1Z0-064 dumps exhibit
Based on the output, which two courses of action would you recommend to improve query performance? (Choose two.)

  • A. Use a parallel hint in the queries.
  • B. Increase the number of DBWn processes.
  • C. Increase the value of the SORT_AREA_SIZE initialization parameter.
  • D. Increase the size of the temporary tablespace or add a new temporary tablespace.
  • E. Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.
  • F. Increase the size of the large pool.

Answer: CF

NEW QUESTION 10
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:
1Z0-064 dumps exhibit
Which three statements are true in this scenario? (Choose three.)

  • A. Sessions are waiting for mutexes in share mode on cursors but other sessions areholding the mutexes in exclusive mode.
  • B. The CPU is spending more time in finding cursors in the library cache.
  • C. Cursors are not getting shared, resulting in a large number of hard parses.
  • D. Sessions are waiting for mutexes in exclusive mode on cursors but other sessions are holding the mutexes in share mode.
  • E. The buffers required by queries are not found in the buffer cache, thereby increasing expensive disk I/O.

Answer: BDE

NEW QUESTION 11
Examine the query and its output:
1Z0-064 dumps exhibit
Which two statements are true? (Choose two.)

  • A. Session 2832 had to wait 2029 seconds for a message to arrive because of a network bottleneck.
  • B. Session 4208 is either idle or experiencing poor response time due to a network or resource bottleneck on the client process.
  • C. Session 3346 is in wait state because it wants to lock a row in a block in which other sessions have already locked rows, and there is no free ITL slot available in this block.
  • D. Session 3346 is in wait state because either it is waiting to update a row that is locked by another session or another session is trying to insert the same key value in a UNIQUE index.
  • E. Session 4208 is definitely idle and should be killed to free network resources.

Answer: AD

NEW QUESTION 12
You execute this query twice in a session:
1Z0-064 dumps exhibit
Then you query V$SQL_SHARED_CURSOR for details about child cursors as shown.
1Z0-064 dumps exhibit
Which two statements are true? (Choose two.)

  • A. No statistics were collected during the first execution of the query.
  • B. A subsequent execution of the query in this session is likely to undergo a soft parse.
  • C. The second execution of the query was hard parsed because the estimated cardinality was inaccurate.
  • D. A subsequent execution of the query in this session will undergo a hard parse.
  • E. The second execution of the query was hard parsed because extended statistics were collected after the first execution of the query.

Answer: BC

NEW QUESTION 13
Which two situations can lead to sparsely populated index blocks? (Choose two.)

  • A. Data is frequently inserted using direct path load into a table with an index.
  • B. Indexed columns in a table are frequently updated.
  • C. Values in an indexed column are inserted using monotonically incrementing sequences.
  • D. Bulk delete operations are performed on a table with indexes.
  • E. Online table move operations are performed frequently on a table with indexes.

Answer: BD

NEW QUESTION 14
Examine the initialization parameters set for a database instance:
1Z0-064 dumps exhibit
The database supports an OLTP workload. Applications connect to the instance using shared server connections and perform small, random I/Os. All the data files are on the same disk. You notice free buffer wait events for sessions in the database instance.
To solve the problem, you increase the size of the buffer cache. But after some time, you notice sessions waiting again on free buffer waits.
What will you recommend to alleviate the issue? (Choose the best answer.)

  • A. Run the I/O calibration tool.
  • B. Configure the database instance to make asynchronous I/O available to DBWR.
  • C. Spread the data files over multiple disks, controllers, and I/O buses to ensure that there are no hotspots in the I/O subsystem.
  • D. Configure dedicated server connections for the applications.

Answer: B

NEW QUESTION 15
Examine the partial TOP 10 Foreground Events by Total Wait Time section of an AWR report:
1Z0-064 dumps exhibit
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

Answer: B

NEW QUESTION 16
Examine the Load Profile section of an AWR report:
1Z0-064 dumps exhibit
Which two inferences can you derive from the details in this section? (Choose two.)

  • A. The values for Redo size and Block changes imply that only updates were performed by transactions.
  • B. The values for Parses (SQL) and Hard parses (SQL) imply that cursor sharing occurred quite often.
  • C. The values for DB Time and DB CPU imply that the database had a high proportion of idle time during the specified snapshot interval.
  • D. The values for SQL Work Area and User calls imply that only sort-based operations were performed.
  • E. 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.

Answer: BD

NEW QUESTION 17
Examine the parameters set for your database instance:
1Z0-064 dumps exhibit
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.)

  • A. Create it in a locally managed tablespace with ASSM enabled and assign a high value for the PCTFREE attribute.
  • B. Create it in a locally managed tablespace with manual segment space management.
  • C. Create it in a locally managed tablespace with a bigger nonstandard block size and ASSM enabled.
  • D. Create it in locally managed tablespace with ASSM enabled and an additional freelist.

Answer: C

NEW QUESTION 18
You want to capture the performance of your database during the last ten days of the first quarter of the current financial year, so that you can compare this performance against the remaining quarter ends of the current financial year.
Which method should you use? (Choose the best answer.)

  • A. Create a static baseline that can be used with AWR compare reports.
  • B. Create a new moving window baseline and enable adaptive thresholds for relevant metrics.
  • C. Use a repeating baseline template to create and drop baselines based on a repeating time schedule and set adaptive thresholds at a high significance level.
  • D. Use fixed baseline templates to create a new moving window baseline and set relevant warning alerts that are computed as a percentage multiple of the maximum value observed for the data in the moving window baseline.

Answer: D

Recommend!! Get the Full 1Z0-064 dumps in VCE and PDF From 2passeasy, Welcome to Download: https://www.2passeasy.com/dumps/1Z0-064/ (New 84 Q&As Version)