Please select what Alex is doing wrong here?

group by m.item_id;

Step 3: After 1 hour, he decided to temporarily suspend the use (and maintenance) of the DataReportMV materialized view for cost saving purpose.

alter materialized view DataReportMV suspend;

Please select what Alex is doing wrong here?
A . A materialized view, DataReportMV does not support Join operations, so Step 2 would be failed & he cannot proceed further.
B . Materialized view on top of External tables is not supported feature.
C . Once DataReportMV got suspended, any query on the top of the view will generate error like: Failure during expansion of view ‘DATAREPORTMV’: SQL compilation error: Materialized view DataReportMV is invalid.
D . There is no command like suspend for temporarily suspension of Materialized views, Step 3 will
give error like invalid Suspend command.
E . Alex is doing everything correct.

View Answer

Answer: E

Explanation:

All Steps will be executed successfully by Alex without any error.