Please Answer Questions Follow The Prompts Below

select
A . The operation will be successful and the materialized view will be created
B. Materialized view always needs to be a secure view, hence this will fail
C. Aggregate functions used in complex expressions can only be used in the outer-most level of a query, not in a subquery or an in-line view, hence this operation will fail.

View Answer

Answer: C

Explanation

Aggregate functions used in complex expressions (e.g. (sum(salary)/10)) can only be used in the outer-most

level of a query, not in a subquery or an in-line view.

For example, the following is allowed:

create materialized view mv1 as

select

sum(x) + 100

from t;

The following is not allowed:

create materialized view mv2 as

select

y + 10

from (

select

sum(x) as y

from t

);