Oracle
1Z0-054 · Question #132
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…
The correct answer is D. It is a materialized view. See the full explanation below for the reasoning.
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).
How the community answered
(36 responses)- A6% (2)
- B3% (1)
- C11% (4)
- D78% (28)
- E3% (1)
Community Discussion
No community discussion yet for this question.