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

質問 1

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）The buffer cache is undersized.

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

（C）There are too many disk sort operations.

（D）PGA is undersized

（E）Contention is caused by freelist management.

正解：B 解答を投票する

質問 2

You are administering a database that supports an OLTP workload. An application performs a large number of small transactions. Users complain about increased response times for transactions. On investigation, you find that the cache hit ratio is 69%. Examine a partial output from V$SYSTEM_EVENT:

Which four can be possible reasons for the increased response time? (Choose four.)

（A）The database buffer cache is inadequately sized.

（B）DBWR is not writing the dirty buffers fast enough.

（C）Blocks are aging out of the buffer cache frequently.

（D）Several full table scans are performed by transactions.

（E）Many sessions are waiting for buffers that are currently being read into the buffer cache by other sessions.

（F）A large number of blocks are fetched from disks frequently.

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

質問 3

Which three actions should you perform to reduce shared pool fragmentation and avoid the "ORA-04031: unable to allocate .... bytes of shared memory" error for the shared pool? (Choose three.)

（A）Standardize the type, size, and naming conventions for bind variables and spacing conventions for SQL statements and PL/SQL blocks.

（B）Identify the packages or procedures that are causing the "ORA-04031:unable to allocate....bytes of shared memory" error and use the DBMS_SHARED_POOL.KEEP to keep them in the shared pool.

（C）Use DBMS_SHARED_POOL.KEEP to keep the SYS.STANDARD, SYS.DBMS_STANDARD, and SYS.DIUTIL packages and frequently executed compiled triggers.

（D）Use more anonymous procedures.

（E）Configure shared server mode.

（F）Configure the Server Result Cache.

正解：C、E、F 解答を投票する

質問 4

Examine the parameters set for your database instance:

You are administrating a database that supports a DSS workload. You make some changes to the sizes of memory components. Consequently, you receive this error:

Which three actions might resolve the issue?

（A）setting the PGA_AGGREGATE_TARGET parameter to 0 and the MEMORY_TARGET parameter to the value of the PGA_AGGREGATE_TARGET parameter

（B）enabling Automatic Shared Memory Management for the database instance

（C）pinning the cursors in the shared pool

（D）setting the value of MEMORY_MAX_TARGET to the value of the SGA_MAX_SIZE parameter

（E）increasing the size of the shared pool

（F）enabling Automatic Memory Management for the database instance

正解：B、D、F 解答を投票する

質問 5

Examine the Load Profile and partial Top 10 Foreground Events by Total Wait Time sections from an AWR report.

Which two areas should you examine next to identify possible bottlenecks?

（A）the "SQL ordered by Gets" section of the AWR report to check for excessive logical I/O

（B）the application code because user calls are performing several queries that require sorting

（C）the application code because of CPU-intensive activities

（D）the "SQL ordered by Reads" section of the AWR report to check for excessive physical reads

正解：A、C 解答を投票する

質問 6

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 Tuning Advisor to generate recommendations for SQL plan baselines.

（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 Access Advisor to generate recommendations for SQL profiles.

正解：A 解答を投票する

質問 7

Examine the parameters set for a database instance:

An application performs a large number of identical queries on small lookup tables very frequently. Users complain about the slow response time of queries on these tables. On investigation, you notice that buffers are getting aged out of the buffer cache. To mitigate the issue, you increase the value of the SGA_MAX_SIZE and SGA_TARGET parameters, but after some time, you notice the same issue again.
Which two would you recommend as long-term solutions for this issue? (Choose two.)

（A）pinning the cursors of the queries in the library cache

（B）configuring Automatic Memory Management

（C）configuring the KEEP buffer pool and altering tables to use the KEEP pool

（D）configuring the result cache for the instance

（E）increasing the size of the database buffer cache

正解：B、E 解答を投票する

質問 8

For which two tasks would you recommend the use of a repeating baseline template?

（A）to capture user activity information for a consumer group over a specified period of time

（B）to capture AWR data for a specified contiguous time period on an ongoing basis

（C）to capture statistics performance variation over a specified period of time

（D）to capture AWR data for a scheduled job that runs every day over a specified period of time

（E）to capture AWR data during a system test that is scheduled for a weekend

正解：B、D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 9

Examine the partial PLAN_TABLE output:

Which is the correct sequence of execution? (Choose the best answer.)

（A）3, 2, 4, 1, 0, 2

（B）3, 2, 4, 1, 0

（C）0, 1, 2, 3, 4, 1

（D）0, 4, 1, 3, 2, 1

（E）3, 2, 1, 4, 0

正解：E 解答を投票する

質問 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 amount of time that a session is idle and blocking other sessions of the ERP application

（B）creating two resource plans with resource limits defined for the workload generated by the applications and automatically changing resource plans based on the workload

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

（D）limiting the physical I/O performed by the sessions or users of the ERP application that are connected to the database

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

正解：C、D、E 解答を投票する

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

弊社を連絡する

関連リンク

トップ試験