1z1-064試験無料問題集（120題）「Oracle Database 12c: Performance Management and Tuning 認定」

出題：1

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 Performance Analyzer.

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

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

正解：B 解答を投票する

出題：2

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

A. Set the STALE_PERCENT statistic preference to a higher value than the default, and then gather statistics.

B. Set the PUBLISH statistic preference to FALSE, and then gather statistics.

C. Set the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE for the session in which you want to test the query.

D. Set the INCREMENTAL preference to TRUE, and then gather statistics.

E. Set the NO_INVALIDATE statistic preference to TRUE, and then gather statistics.

F. Set the STATISTICS_LEVEL parameter to ALL for the instance.

正解：B,F 解答を投票する

出題：3

Which two are prerequisites for running the I/O calibration tool? (Choose two.)

A. The disks to be tested must be configured to use asynchronous I/O for data files.

B. The database should be opened in restricted mode.

C. For determining latency time, the STATISTICS_LEVEL parameter must be set to TYPICAL or ALL.

D. The database instance must be started using an SPFILE.

E. The database must be in MOUNT state.

正解：D,E 解答を投票する

出題：4

As part of an application upgrade, new objects are being added to an application schem a. You want to check the effect of the new schema objects on the performance of the SQL workload generated by the application.
How would you accomplish this?

A. Capture the workload, set the OPTIMIZER_USE_PENDING_STATISTICS to FALSE, and then replay the workload.

B. Capture the workload in an STS and submit to SQL Tuning Advisor as an input to generate recommendations for indexes and SQL profiles.

C. Set the PUBLISH statistic preference to FALSE, gather statistics, capture the workload in a SQL Tuning Set (STS), and submit the STS to SQL Tuning Advisor.

D. Capture the workload in an STS and submit to SQL Access Advisor as an input to generate recommendations for indexes and materialized views.

正解：D 解答を投票する

出題：5

You have been asked to use table compression for two large tables. Given are the details of the tables:
The TRANS_DET table:
The table is used by an OLTP application.
High volume insert and update operations are performed on the table.
The table is frequently queried using index range scans.
The TRANS_HISTORY table:
The table is used by a DSS application.
High volume bulk loads are performed on the table.
The table is used to store archival data on which large table full-table scans (FTS) are performed.
Which row store compression would you recommend for these tables with minimal overhead on performance? (Choose the best answer.)

A. basic table compression for both the tables

B. basic table compression for the TRANS_DET table and advanced row compression for the TRANS_HISTORY table

C. advanced row compression for both the tables

D. basic table compression for the TRANS_HISTORY table and advanced row compression for the TRANS_DET table

E. warehouse compression for the TRANS_DET table and archive compression for the TRANS_HISTORY table

正解：A 解答を投票する

出題：6

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

A. It can be used to create a comparison report between the Database Replay workload capture report and the replay report.

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

C. It is automatically invoked whenever the AWR Compare Period report is invoked.

D. It is automatically invoked whenever ADDM is run by default.

正解：A,D 解答を投票する

出題：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.)

A. Set the PUBLISH statistics preference to FALSE and then gather statistics.

B. Set the STALE_PERCENT statistics preference to zero and then gather statistics.

C. Set the OPTIMIZER_USE_PENDING_STATISTICS initialization parameter to TRUE for the session.

D. Set the NO_INVALIDATE statistics preference to FALSE and gather statistics without affecting old statistics.

E. Use the DBMS_STATS.PUBLISH_PENDING_STATS procedure to make pending statistics the current statistics.

正解：B,C 解答を投票する

出題：8

You are administrating a database that supports a mixed workload. Given are the details of the workload:
During the day, short transactions and syntactically similar queries are repeatedly issued.
At night, DSS batch queries and jobs are executed with large sort operations.
Examine the parameters set for the database instance:

To automate memory requirements for both workloads, which three changes to parameters would you recommend?

A. Set DB_CACHE_SIZE, SHARED_POOL_SIZE, and LARGE_POOL_SIZE to their minimum required values.

B. Set the MEMORY_TARGET parameter to the value of SGA_MAX_SIZE.

C. Set the MEMORY_MAX_TARGET and MEMORY_TARGET parameters to a value greater than the sum of SGA_MAX_SIZE and PGA_AGGREGATE_TARGET.

D. Set the SGA_TARGET parameter to the value of the SGA_MAX_SIZE parameter.

E. Set the SGA_TARGET and PGA_AGGREGATE_TARGET parameters to their minimum required values.

正解：A,D,E 解答を投票する

出題：9

Examine the query and its execution plan:

Explained.

Which two interpretations are correct?

A. Id 4 is the second step executed.

B. Id 3 is the first step executed.

C. The Id 0 step indicates the cost of the entire plan.

D. The SORT UNIQUE operation applies only the CUST_MAIN table.

正解：A,D 解答を投票する

出題：10

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 physical I/O performed by the sessions or users of the ERP application that are connected to the database

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

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

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

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

正解：A,C,E 解答を投票する

1z1-064試験無料問題集「Oracle Database 12c: Performance Management and Tuning 認定」