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

出題：1

In your database, supporting an OLTP workload, the SALES table is range-partitioned on the SALES_DATE column. A new partition is created every quarter and is frequently used for updates and queries. You recently noticed degraded performance of queries on a new partition due to stale statistics. A local partitioned index exists on the SALES_DATE column.
What would you recommend to improve performance?

A. setting the INCREMENTAL preference to TRUE and the GRANULARITY preference to AUTO for the partitioned table while gathering statistics

B. dropping the local partitioned index and creating a global partitioned index on the SALES_DATE column

C. setting the INCREMENTAL preference to TRUE and the CASCADE preference to FALSE for the partitioned table while gathering statistics

D. setting the INCREMENTAL preference to TRUE and the NO_INVALIDATE preference to TRUE for the partitioned table while gathering statistics

正解：A 解答を投票する

出題：2

Which three methods can you use to create a pre-change SQL trial to capture performance data by using SQL Performance Analyzer? (Choose three.)

A. loading performance data and execution plans from an STS.

B. generating only execution plans on a test database without actually running SQL statements.

C. generating an execution plan and statistics for selective SQL statements captured in an STS

D. executing SQL statements in a SQL Tuning Set (STS) on a test database by using database links to the production database.

E. generating both execution plans and statistics for each SQL statement in an STS by actually running the SQL statements on a test database.

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

出題：3

Examine the initialization parameters set for a database instance:

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. Configure the database instance to make asynchronous I/O available to DBWR.

B. Configure dedicated server connections for the applications.

C. Run the I/O calibration tool.

D. Spread the data files over multiple disks, controllers, and I/O buses to ensure that there are no hotspots in the I/O subsystem.

正解：A 解答を投票する

出題：4

Which two statements are true about server-generated alerts? (Choose two.)

A. They appear in the DBA_ALERT_HISTORY view whenever corrective action is taken for an alert.

B. They are always logged in the alert log.

C. They are written to a trace file if the TRACE_ENABLED initialization parameter is set to TRUE.

D. They can be generated for user-defined metric thresholds.

E. They are generated only when the STATISTICS_LEVEL initialization parameter is set to ALL.

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

出題：5

Examine an extract from a PGA Memory Advisory for your database:

Which two inferences are correct? (Choose two.)

A. Automatic management of PGA memory is disabled.

B. The current PGA size is sufficient and does not require the memory manager to allocate more memory.

C. PGA size should be increased at least four times its current size for significant improvement in performance and disk space management.

D. The current PGA size requires the use of a temporary tablespace for sorting operations.

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

出題：6

Your database supports a DSS system.
Examine the parameter values configured in your database:
sga_max_size = 480M
sga_target = 480M
pga_aggregate_target = 160M
The CUSTOMERS table contains 8,000 rows. The CUST_ID column is the primary key and the COUNTRY_ID column contains only three possible values: 1111, 2222, and 3333.
You execute the commands:
SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS('SH','CUSTOMERS');
PL/SQL procedure successfully completed.
SQL> CREATE INDEX COUNTRY_IDX ON CUSTOMERS (COUNTRY_ID);
Index created.
You then perform several INSERT, UPDATE, and DELETE operations, significantly altering the data in the table.
View the Exhibit to examine the query and its execution plan.

Which three options would improve the performance of the query? (Choose three.)

A. creating a SQL profile

B. creating a KEEP cache

C. increasing the size of the PGA

D. creating a histogram on the COUNTRY_ID column

E. regathering statistics on the CUSTOMERS table

F. creating a bitmap index on the COUNTRY_ID column

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

出題：7

You are administrating a database that supports an OLTP workload. A few users complain about the poor performance of some SQL statements. You notice that these SQL statements belong to different applications and conclude that there is no correlation between them. You create a SQL Tuning Set (STS) containing these SQL statements.
What must you do to analyze and generate recommendations for the SQL statements in the STS?

A. Submit the STS as input to the SQL Access Advisor to generate recommendations for SQL profiles.

B. Submit the STS as input to the SQL Performance Analyzer to generate recommendations for creating indexes and materialized views.

C. Submit the STS as input to the SQL Tuning Advisor to generate recommendations for indexes or SQL profiles or both.

D. Submit the STS as input to the SQL Tuning Advisor to generate recommendations for SQL plan baselines.

正解：D 解答を投票する

出題：8

Which three statements are true about using Real-Time Database Operations? (Choose three.)

A. The STATISTICS_LEVEL initialization parameter must be set to ALL to enable automatic SQL monitoring for all long-running queries.

B. Real-Time Database Operations can be enabled only at the system level.

C. Real-Time Database Operations can be created by using the DBMS_MONITOR or DBMS_SESSION packages.

D. The STATISTICS_LEVEL initialization parameter can be set to TYPICAL or ALL to enable Real-Time Database Operations.

E. Database operation monitoring starts automatically when a database operation consumes at least five seconds of the CPU or I/O time in a single execution.

F. The CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter must be set to DIAGNOSTIC+TUNUNG to use Real-Time Database Operations.

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

出題：9

In which three scenarios can you use ADDM to get recommendations?

A. to determine if the SGA_TARGET parameter value needs to be changed when your database is configured for Automatic Shared Memory Management and additional physical memory is added to the database server

B. to determine whether SQL profiling needs to be done to tune SQL statements transparently without requiring any change to the application code

C. to determine the SQL statements that are performing poorly before you launch the SQL Tuning Advisor to tune them

D. to determine the segments on which waits are occurring when the database has a high number of buffer busy waits

E. to analyze problems in an unresponsive database, which requires a database restart

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

出題：10

Examine the parameters set for your database instance:

You are administering a database that supports an OLTP workload. Users complain about the degraded performance of some queries. While diagnosing, you notice a large number of hard parses occurring for several syntactically almost identical SQL statements that differ only in literal values in the WHERE clause.
Which two actions would you recommend to improve performance? (Choose two.)

A. Set the CURSOR_SHARING parameter to FORCE.

B. Set the OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameter to TRUE.

C. Use bind variables instead of literals.

D. Create SQL plan baselines for the almost identical SQL statements and load them into the cursor cache.

E. Create the KEEP cache and cache the tables used in the queries.

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

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