READ Free Dumps For Oracle- 1z0-020
Question ID 7740 | Examine this execution plan: Execution Plan 0SELECT STATEMENT Optimizer = CHOOSE 10COUNT(STOPKEY) 21VIEW 32SORT (ORDER BY STOPKEY) 43TABLE ACCESS (FULL) OF 'CLASSES' Which statement generated this execution plan? |
Option A | SELECT COUNT (*) FROM classes ORDER BY stopkey; |
Option B | SELECT COUNT (*) FROM classes ORDER BY start_date; |
Option C | SELECT * FROM (SELECT * FROM classes ORDER BY start_date DESC) WHERE ROWNUM<11; |
Option D | SELECT * FROM (SELECT * FROM classes WHERE ROWNUM< 11) ORDER BY start_date DESC; |
Correct Answer | A |
Question ID 7741 | What is the maximum number of archival destinations allowed in Oracle 8i? |
Option A | 1 |
Option B | 2 |
Option C | 3 |
Option D | 5 |
Option E | 7 |
Correct Answer | D |