Online Access Free 1Z0-084 Exam Questions

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.Enable Adaptive Plans so that Oracle can change the Join method as well as the Join order for this query.
• B.Create an index on SALES.TIME_ID to force the return of rows in the order specified by the ORDER BY clause.
• C.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.
• D.Replace the FETCH FIRST clause with ROWNUM to enable the use of an index on SALES.
• E.Collect a new set of statistics on PRODUCT, CUSTOMERS, and SALES because the current stats are inaccurate.

Database performance degraded between 23:15 and 23:30 for the last three nights. The awr snapshot interval is one hour. The AODM report contains nothing about this performance problem.
With which tool can you further analyze this problem?

• A.SQL Tuning Advisor
• B.Active Session History report
• C.SQL Performance Analyzer
• D.AWR Compare Periods report

Which two Oracle Database features use database services?

• A.Oracle SQL Performance Management
• B.Oracle SQL Tuning Advisor
• C.Oracle Automatic Reoptimization
• D.Oracle Scheduler
• E.Database Resource Manager

You use SQL Tuning Advisor to tune a given SQL statement.
The analysis eventually results in the implementation of a SQL Profile.
You then generate the new SQL Profile plan and enforce it using a SQL Plan Baseline but forget to disable the SQL Profile and a few days later you find out that the SQL Profile is generating a new execution plan.
Which two statements are true?

• A.The execution plan is the one enforced by the SQL Plan Baseline.
• B.The execution plan is the one enforced by the SQL Profile.
• C.The SQL Profiles as well as SQL Plan Baseline are implemented using hints, so they both generate the same plan.
• D.The existence of two concurrent plan stability methods generates a child cursor for every execution.
• E.The conflict between the two plan stability methods results in an error.
• F.The SQL Plan Baseline must be accepted in order to be used for the execution plan.

You must produce a consolidated formatted trace file by combining all trace files generated by all clients for a single service.
Which combination of utilities does this?

• A.Trcsess and TKPROF
• B.Trace Analyzer and Tracsess
• C.TKPROF and Trace Analyzer
• D.Autotrace and TKPROF