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.
Replace the FETCH FIRST clause with ROWNUM to enable the use of an index on SALES.
C.
Collect a new set of statistics on PRODUCT, CUSTOMERS, and SALES because the current stats are inaccurate.
D.
Enable Adaptive Plans so that Oracle can change the join method as well as the join order for this query.
E.
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.
Create an index on SALES.TIME_ID to force the return of rows in the order specified by the ORDER BY clause.
upvoted 3 times
...
This section is not available anymore. Please use the main Exam Page.1z0-084 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
cujar2003
8 months, 2 weeks ago