1z0-064 試験問題を無料オンラインアクセス

Your database supports an online transaction processing (OLTP) workload. The database uses ASM storage. One of the ASM disks goes offline because of hardware failure. When the disk is replaced and then added back to the diskgroup, database performance is affected by rebalance operations.
Which two actions would you recommend to lower the impact of rebalance operations on the performance of the database? (Choose two.)

• A.Specify the POWER clause with a lower value in an ALTER DISKGROUP statement.
• B.Increase the number of ASMB processes.
• C.Set the DISK_REPAIR_TIME disk attribute to a higher value.
• D.Decrease the value of the ASM_POWER_LIMIT parameter.
• E.Set the DISK_REPAIR_TIME disk attribute to a lower value.

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.Increase the number of DBWn processes.
• B.Enable Automatic Memory Management.
• C.Increase the value of the PGA_AGGREGATE_TARGET parameter.
• D.Increase the value of the SGA_TARGET parameter.
• E.Enable Automatic Shared Memory Management.
• F.Enable temporary undo.

You are administrating a database that supports a DSS workload. Syntactically similar queries using joins and aggregate functions are frequently executed by users to fetch data from remote databases by using database links.
Which three tasks should you perform to improve the performance of these queries?

• A.Ensure that the RESULT_CACHE_MAX_SIZE parameter is set to a nonzero value on both the local and remote database instances.
• B.Ensure that the RESULT_CACHE_MAX_SIZE parameter is set to a nonzero value on the remote database instance.
• C.Ensure that the RESULT_CACHE_MAX_RESULT parameter is set to 100.
• D.Ensure that the RESULT_CACHE_REMOTE_EXPIRATION parameter is set to a nonzero value for the local instance.
• E.Ensure that the RESULT_CACHE_MODE parameter is set to FORCE for remote database instances.
• F.Ensure that the RESULT_CACHE_MAX_SIZE parameter is set to a nonzero value on the local database instance.
• G.Ensure that the RESULT_CACHE_MAX_MODE parameter is set to FORCE for the local instance.

Your database supports an OLTP workload. You are planning to migrate database storage from file system storage to Automatic Storage Management (ASM). The applications supported by the database primarily perform small, random I/Os.
Which two statements are true regarding ASM striping in combination with RAID 0?

• A.It helps in reducing network latency.
• B.It allows you to evenly spread data over multiple disks.
• C.It improves availability and reliability of data be ensuring that logical data corruptions are found and repaired.
• D.It provides higher I/O bandwidth.
• E.It improves the performance of only write-intensive workloads.

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 NO_INVALIDATE statistic preference to TRUE, and then gather statistics.
• B.Set the STALE_PERCENT statistic preference to a higher value than the default, and then gather statistics.
• C.Set the INCREMENTAL preference to TRUE, and then gather statistics.
• D.Set the PUBLISH statistic preference to FALSE, and then gather statistics.
• E.Set the STATISTICS_LEVEL parameter to ALL for the instance.
• F.Set the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE for the session in which you want to test the query.