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.Decrease the value of the ASM_POWER_LIMIT parameter.
• D.Set the DISK_REPAIR_TIME disk attribute to a lower value.
• E.Set the DISK_REPAIR_TIME disk attribute to a higher value.

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 STALE_PERCENT statistics preference to zero and then gather statistics.
• B.Set the PUBLISH statistics preference to FALSE and then gather statistics.
• C.Use the DBMS_STATS.PUBLISH_PENDING_STATS procedure to make pending statistics the current statistics.
• D.Set the NO_INVALIDATE statistics preference to FALSE and gather statistics without affecting old statistics.
• E.Set the OPTIMIZER_USE_PENDING_STATISTICS initialization parameter to TRUE for the session.

You upgrade your database from Oracle Database 11g to 12c. You capture execution plans for a resource-intensive SQL workload before the upgrade. After the upgrade, you load the plans into the SQL Management Base.
Examine the parameters set for the instance:

Which two statements are true?

• A.New execution plans generated will always be added to the SQL plan baselines as fixed plans.
• B.New SQL plan baselines might be generated automatically for the repeatable SQL statements.
• C.New execution plans cannot be evolved until execution plans from the previous version are dropped.
• D.New execution plans generated will always be added to the SQL plan baselines as accepted plans.
• E.A better execution plan may be found for the SQL statements and can be evolved manually.

The SALES table has over one million rows. Statistics for the SALES table and its dependent objects are gathered by the Oracle AutoTask task during a predefined maintenance window.
Examine the query:

Which two actions can improve the accuracy of cardinality estimates for this query?

• A.gathering system statistics during peak workload time to augment the standard statistics
• B.setting the OPTOMIZER_DYNAMIC_SAMPLING parameter to 4 to augment the default standard statistics
• C.setting the FORCE parameter of the GATHER_*_STATS procedure to TRUE and gathering statistics for the SALES table and its dependent objects
• D.ensuring that histograms exist for the CUST_ID and PROD_ID columns

You are administering a database that supports an OLTP workload. RESULT_CACHE_MODE is set to the default value and a result cache is configured for the instance. Multiple sessions execute syntactically similar queries without dblinks, containing functions and expressions, on tables with no DML activity. Some users complain about poor performance of these queries.
You investigate and find that the queries are frequently performing physical I/O, even though the results fetched by the queries are similar.
Which two actions do you recommend to overcome the problem affecting these queries? (Choose two.)

• A.Use bind variables for similar queries instead of literals.
• B.Set the RESULT_CAHCE_MODE parameter to FORCE for the instance.
• C.Use the result cache hint in the queries.
• D.Configure the KEEP pool and cache the queried tables used in the KEEP pool.
• E.Set the RESULT_CACHE_REMOTE_EXPIRATION parameter to a nonzero value.