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

Which two actions can cause invalidation or loss of one or more results in the SQL Query Result Cache?

• A.result_cache_max_size is set dynamically to 0.
• B.Decreasing the value set for RESULT_CACHE_REMOTE_EXPIRATION.
• C.A request was made by the RCBG background of a non-RAC database.
• D.One or more results were aged out of the result cache.
• E.A request was made by the RCBG background process in a physical standby database that is opened read only and whose primary has a result cache.

Accessing the SALES tables causes excessive db file sequential read wait events.
Examine this AWR except:

Now, examine these attributes displayed by querying dba_tables:

Finally, examine these parameter settings:

Which two must both be used to reduce these excessive waits?

• A.Increase PCTFREE for the SALES table.
• B.Compress the SALES table.
• C.Re-create the SALES table.
• D.Coalesce all sales table indexes.
• E.Partition the SALES table.

A database instance is suffering poor I/O performance on two frequently accessed large tables.
No Big Table caching occurs in the database.
Examine these parameter settings:

Which are two actions either one of which will allow Big Table caching to occur?

• A.Increasing DB_BIG_TABLE_CACHE_PERCENT_TARGET to at least 50
• B.Setting DB_KEEP_CACHE_SIZE to at least 50M
• C.Setting PARALLEL_DEGREE_POLICYADAPTIVE
• D.Setting PARALLEL_DEGREE_POLICYAUTO
• E.Increasing DB_BIG_TABLE_CACHE_PERCENT_TARGET to at least 25
• F.Increasing DB_CACHESIZE to 1 G

What is the right time to stop tuning an Oracle database?

• A.When the allocated budget for performance tuning has been exhausted
• B.When the I/O is less than 10% of the DB time
• C.When the tuning goal has been met
• D.When all the concurrency waits are eliminated from the Top 10
• E.When the buffer cache and library cache hit ratio is above 95%

Which two statements are true about cursor sharing?

• A.Setting optimizer_capture_sql_plan_baselines to TRUE loads all adaptive plans for the same statement into the cursor cache.
• B.Adaptive Cursor Sharing requires histograms on filtered columns, used in equality predicates, to allow different execution plans to be generated for statements whose bound values would normally generate different plans at hard parse time.
• C.Adaptive Cursor Sharing guarantees that a suboptimal plan will never be used on any execution of a SQL statement.
• D.Setting cursor_sharing to EXACT prevents Adaptive Cursor Sharing from being used.
• E.Setting Cursor_sharing to FORCE can result in a plan that is suboptimal for the majority of values bound to a bind variable when executing a cursor with one or more bind variables.