1Z0-064 Online Practice Questions and Answers

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.)

A. limiting the amount of time that a session is idle and blocking other sessions of the ERP application

B. limiting the amount of undo generated by operations performed by sessions created by the ERP application

C. creating two resource plans with resource limits defined for the workload generated by the applications and automatically changing resource plans based on the workload

D. allocating a lower percentage of CPU to sessions used by the REPORTING application than to those used by the ERP application

E. limiting the physical I/O performed by the sessions or users of the ERP application that are connected to the database

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.)

A. It generates an error because the warning threshold cannot exceed 100%.

B. It generates an error because the percentage of maximum threshold cannot be set with a significance-level threshold value.

C. It generates an alert when an observed metric is 99% of the 99th percentile value as measured over the moving window baseline.

D. It generates an alert when an observed metric is 110% of the 99th percentile value as measured over the moving window baseline.

E. It generates an alert when 1 in 100 observations for an observed metric exceeds the 99th percentile value as measured over the fixed baseline.

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.

Examine the parameters set for a database instance: The database supports a mixed workload. Users complain about the increased response time of a few DSS queries. During investigation, you execute the query:

Based on the output, which two are possible ways to improve the performance of the queries? (Choose two.)

A. Enable temporary undo.

B. Enable Automatic Memory Management.

C. Increase the number of DBWn processes.

D. Enable Automatic Shared Memory Management.

E. Increase the value of the SGA_TARGET parameter.

F. Increase the value of the PGA_AGGREGATE_TARGET parameter.

Your database supports a mixed workload. In an application, multiple complex queries with functions and expressions are executing. You want to analyze the queries that are currently cached in the library cache to receive recommendations about the usage of indexes and materialized views.

What should you do to achieve this? (Choose the best answer.)

A. Create an STS for the queries cached in the library cache and submit it as an input to SQL Tuning Advisor.

B. Create an STS for the queries cached in the library cache and submit it as an input to SQL Access Advisor.

C. Capture the workload in an STS and submit to SQL Tuning Advisor for recommendations.

D. Create an STS for the queries cached in the library cache and submit it as an input to SQL Performance Analyzer.

Examine the partial Activity Over Time section of an Active Session History (ASH) report:

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.

You are administering a database that supports an OLTP workload. RESULT_CACHE_MODE is set to the default value and a result cache is configured for the instance. Multiple sessions execute syntactically similar queries without dblinks, containing functions and expressions, on tables with no DML activity. Some users complain about poor performance of these queries.

You investigate and find that the queries are frequently performing physical I/O, even though the results fetched by the queries are similar.

Which two actions do you recommend to overcome the problem affecting these queries? (Choose two.)

A. Set the RESULT_CAHCE_MODE parameter to FORCE for the instance.

B. Use the result cache hint in the queries.

C. Use bind variables for similar queries instead of literals.

D. Set the RESULT_CACHE_REMOTE_EXPIRATION parameter to a nonzero value.

E. Configure the KEEP pool and cache the queried tables used in the KEEP pool.

To diagnose the performance degradation of your production database, you execute these queries:

Segment space management is manual for some of the tablespaces.

What can be the reason for the performance degradation?

A. PGA is undersized

B. Contention is caused by freelist management.

C. There are too many disk sort operations.

D. The buffer cache is undersized.

E. The database writer (DBWR) process is processing buffers at a rate that is faster than the rate at which the I/O system can return the buffers.

Which four statements are true about Consolidated Database Replay?

A. Multiple replay schedules can be defined and any existing replay schedules can also be used.

B. Multiple database workloads can be replayed only if both the capture and replay databases are on the same operating system.

C. The replay starts simultaneously for all participating workload captures if no order is defined in the replay schedule.

D. Consolidated workloads from one or multiple databases can be replayed concurrently on a single system.

E. A subset of the captured workload can be replayed on a test system.

F. Multiple database workloads can be replayed only if both the capture and replay databases have the same database version.

G. The number of replay clients must be equal to the number of captured workloads.

Which two statements are true about wait events?

A. A single resource wait event may be recorded as multiple waits, depending on the number of session timeouts during that wait.

B. A wait event can be defined in multiple wait classes.

C. Wait event statistics are cumulatively collected only at the instance level.

D. Wait events for an instance include statistics for both background and foreground processes.

E. Wait event countries are incremented by the server process that waits.