IBM

A2090-560 · Question #97

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

The correct answer is D. Materialized views can contain an ORDER BY clause. E. Materialized views can reference only one base table in the FROM clause. See the full explanation below for the reasoning.

Question

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

Options

AMaterialized views can contain aggregates.
BMaterialized views can contain a HAVING clause.
CMaterialized views can contain a WHERE clause.
DMaterialized views can contain an ORDER BY clause.
EMaterialized views can reference only one base table in the FROM clause.

How the community answered

(31 responses)

A
13% (4)
B
6% (2)
C
3% (1)
D
77% (24)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full A2090-560 Practice