• Description: New Features For Administrators
• Passing Score: 75%
• Practice Test - Number of questions: 73 questions
• Simulation Test - Number of questions: 73 questions
• Simulation Test Duration: 41 minutes
• Has explanations: Yes

Examine this execution plan: Execution Plan -------------------------------------------------------------- 0 SELECT STATEMENT Optimizer = CHOOSE 1 0 COUNT (STOPKEY) 2 1 VIEW 3 2 SORT (ORDER BY STOPKEY) 4 3 TABLE ACCESS (FULL) OF ??CLASSES?? Which statement generated this execution plan?

Answer(s)

1. SELECT COUNT (*)FROM classesORDER BY stopkey;
2. SELECT COUNT (*)FROM classesORDER BY start_date;
3. SELECT *FROM (SELECT * FROM classesORDER BY start_date DESC)WHERE ROWNUM <11;
4. SELECT *FROM (SELECT * FROM classesWHERE ROWNUM <11)ORDER BY start_date DESC;

SELECT COUNT (*)FROM classesORDER BY stopkey;