Oracle
1Z0-054 · Question #132
1Z0-054 Question #132: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #132. The question stem and answer options stay visible for context.
Question
View the Exhibit and examine the execution plan of the following query: SQL> SELECT s.prod_id 2 , t.fiscal_month_number 3 , sum(s.amount_sold) AS sum_amount 4 FROM sales s, times t 5 WHERE s.time_id = t.time_id 6 AND t.fiscal_year = 2000 7 GROUP BY s.prod_id, t.fiscal_month_number 8 ORDER BY s.prod_id, t.fiscal_month_number; Which statement regarding the SALES_PROD object in the execution plan is true?
Exhibit
Options
- AIt is an index.
- BIt is a complex view.
- CIt is a mapping table.
- DIt is a materialized view.
- EIt is an index-organized table (IOT).
Unlock 1Z0-054 to see the answer
You've previewed enough free 1Z0-054 questions. Unlock 1Z0-054 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.