Which two characteristics describe materialized views. (Choose two.)

A.
“Materialized views can contain aggregates.

B.
“Materialized views can contain a HAVING clause.

C.
“Materialized views can contain a WHERE clause.

D.
“Materialized views can contain an ORDER BY clause.

E.
“Materialized views can reference only one base table in the FROM clause.

Explanation: