Online Access Free 1Z0-084 Exam Questions

You need to transport performance data from a Standard Edition to an Enterprise Edition database. What is the recommended method to do this?

• A.Export the data by using expdp from Statspack and import it by using $ORACLE_HOME/rdbms/admin
  /awrload into the AWR repository.
• B.Export the data by using the expdp utility and parameter file spuexp.par from the Statspack repository and import it by using impdp into Export the data by using expdp from the Statspack repository and import it by using impdp into the AWR repository.
• C.Export the data by using expdp from the ftatspack repository and import it by using impdp into the AWR repository.
• D.Export the data by using the exp utility and parameter file spuexp.par from the Statspack repository and import it by using imp into a dedicated Statspack schema on the destination.

Which two statements are true about session wait information contained in v$session or v$session_wait?

• A.Rows for sessions displaying WAITED UNKNOWN TIME in the STATE column indicate that the session is still waiting.
• B.Rows for sessions that are not waiting always contain the total wait time since the session started.
• C.Rows for sessions that are currently waiting have their wait time incremented every microsecond.
• D.Rows for sessions that are currently waiting have a wait time of 0.
• E.Rows for sessions that are not waiting might contain the actual wait time for the last event for which they waited.

A Standard Edition production database has performance problems for two hours on the same day each week.
Which tool must you use to diagnose the problem?

• A.AWR Compare Periods report
• B.Database Replay
• C.SQL Performance Analyzer
• D.Statspack report

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.Setting cursor_sharing to EXACT prevents Adaptive Cursor Sharing from being used.
• C.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.
• D.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.
• E.Adaptive Cursor Sharing guarantees that a suboptimal plan will never be used on any execution of a SQL statement.

You must write a statement that returns the ten most recent sales. Examine this statement:

Users complain that the query executes too slowly. Examine the statement's current execution plan:

What must you do to reduce the execution time and why?

• A.Create an index on SALES.TIME_ID to force the return of rows in the order specified by the ORDER BY clause.
• B.Enable Adaptive Plans so that Oracle can change the Join method as well as the Join order for this query.
• C.Collect a new set of statistics on PRODUCT, CUSTOMERS, and SALES because the current stats are inaccurate.
• D.Create an index on SALES.CUST_ID to force an INDEX RANGE SCAN on this index followed by a NESTED LOOP join between CUSTOMERS and SALES.
• E.Replace the FETCH FIRST clause with ROWNUM to enable the use of an index on SALES.