Oracle
1Z0-908 · Question #64
1Z0-908 Question #64: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-908 to reveal the answer and full explanation for question #64. The question stem and answer options stay visible for context.
Performance Tuning
Question
Examine this query and output: Which two statements are true? (Choose two.)
Exhibit
Options
- AThe country table is accessed as the first table, and then joined to the city table.
- BIt takes more than 8 milliseconds to sort the rows.
- CThe optimizer estimates that 51 rows in the country table have Continent = `Asia'.
- D35 rows from the city table are included in the result.
- EThe query returns exactly 125 rows.
Unlock 1Z0-908 to see the answer
You've previewed enough free 1Z0-908 questions. Unlock 1Z0-908 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#execution plans#optimizer statistics#query performance#join analysis