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

質問 1

You want to enable the Database Smart Flash Cache feature on your database. For this purpose, you configure two flash devices: /dev/sdj and /dev/sdk, with sizes of 64 GB and 32 GB, respectively.
Examine the parameters set for your database instance:

How would you make sure that the database uses these devices for Database Smart Flash Cache?

（A）by setting the value of the DB_FLASH_CACHE_SIZE parameter to 64G, 32G

（B）by setting the DB_FLASH_CACHE_SIZE parameter to 86G and the MEMORY_TARGET parameter to 112G

（C）by disabling Automatic Memory Management, setting SGA_TARGET to 96G, and setting the required memory that you want to set for SGA

（D）by setting the value of the DB_FLASH_CACHE_SIZE parameter to 8G

（E）by configuring the DB_FLASH_CACHE_SIZE parameter and making sure that all flash devices are of the same size

正解：A 解答を投票する

質問 2

Examine the parameters set for a database instance supporting a mixed workload:

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:

Based on the output, which two courses of action would you recommend to improve query performance? (Choose two.)

（A）Increase the value of the SORT_AREA_SIZE initialization parameter.

（B）Use a parallel hint in the queries.

（C）Increase the size of the temporary tablespace or add a new temporary tablespace.

（D）Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.

（E）Increase the number of DBWn processes.

（F）Increase the size of the large pool.

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

質問 3

Examine the query and its output:

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

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

（D）Session 4208 is either idle or experiencing poor response time due to a network or resource bottleneck on the client process.

（E）Session 4208 is definitely idle and should be killed to free network resources.

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

質問 4

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）warehouse compression for the TRANS_DET table and archive compression for the TRANS_HISTORY table

（B）basic table compression for both the tables

（C）basic table compression for the TRANS_HISTORY table and advanced row compression for the TRANS_DET table

（D）basic table compression for the TRANS_DET table and advanced row compression for the TRANS_HISTORY table

（E）advanced row compression for both the tables

正解：B 解答を投票する

質問 5

Which two statements are true about gathering statistics? (Choose two.)

（A）For each session that is accessing a global temporary table, the optimizer uses only the shared statistics.

（B）If end users query newly inserted data, it is possible to get a suboptimal execution plan even if the automatic statistics gathering job is enabled.

（C）If concurrent statistics gathering is done by using parallel execution, the Resource Manager should be used for efficient resource management.

（D）If an application has only SQL statements with bind variables, it is better to drop existing histograms, disable creation of histograms, and allow the optimizer to select the best execution plans.

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

質問 6

For which three problem categories does Automatic Database Diagnostic Monitor (ADDM) provide analysis and recommendations by default? (Choose three.)

（A）for application-level lock contention.

（B）for high-load PL/SQL execution and compilation, and high-load Java usage

（C）for network stack-related bandwidth contention

（D）for concurrency issues because of buffer busy problems

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

質問 7

You are administering a database that supports an OLTP workload. The CURSOR_SHARING parameter is set to EXACT for the instance. The performance of queries issued by one of the modules has degraded. The queries executed by the module are almost identical in syntax. To investigate, you analyze the latest AWR report and find a large number of latch:shared pool wait events and also a high percentage of the hard parse elapsed time.
Which two can be reasons for this? (Choose two.)

（A）Bind variables are not used for similar queries, causing hard parses.

（B）The I/O performance is slow.

（C）The CURSOR_SHARING parameter is set to EXACT, which does not allow similar queries to share a cursor.

（D）Repeated access to a small number of blocks.

（E）Excessive time is spent on finding cached cursors in the library cache.

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

質問 8

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

（A）ADDM resource utilization and cost of analysis depends on the actual load on the database and the number of performance problems analyzed.

（B）It can analyze performance issues that occurred in past events provided they fall within the AWR retention period.

（C）It analyzes the performance of a database instance based on the time period covered by the most recent AWR snapshot, and generates recommendations based on hard-coded criteria.

（D）It documents only those components and wait classes that are significantly impacting the performance of the database.

（E）It first identifies the performance symptoms, and then refines them to reach the root cause with the singular aim of reducing the DB CPU metric.

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

質問 9

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）Spread the data files over multiple disks, controllers, and I/O buses to ensure that there are no hotspots in the I/O subsystem.

（B）Run the I/O calibration tool.

（C）Configure the database instance to make asynchronous I/O available to DBWR.

（D）Configure dedicated server connections for the applications.

正解：C 解答を投票する

質問 10

You are administering a database that supports a mixed workload. Many applications are running on the middle tier that use connection pools to connect to the database instance. Application users perform OLTP operations during the day and another application performs batch job operations at night. You want to measure and prioritize the two workloads.
Which action would you take to achieve this? (Choose the best answer.)

（A）Create database services for the applications and assign different profiles to the sessions to set a relative priority for resource usage.

（B）Create database services for the applications, create a job class associated with the service, batch the jobs, and then create jobs by using the job class.

（C）Create database services for the applications, assign individual sessions created by the applications to consumer groups, and then set a priority.

（D）Assign profiles to users running the batch operations and make sure that a priority is set for resource limits in profiles.

正解：A 解答を投票する

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

弊社を連絡する

関連リンク

トップ試験