READ Free Dumps For Oracle- 1z0-020
Question ID 8207 | 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? |
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 8208 | 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 |