Identify the type of refresh that is NOT supported by materialized views.

The correct answer is D. Heuristic. Use the CREATE MATERIALIZED VIEW statement to create a materialized view. A materialized view is a database object that contains the results of a query. Incorrect answer: A: Specify DEFERRED to indicate that the materialized view is to be populated by the next REFRESH…

Materialized Views

Question

Options

ADeferred
BIncremental
CFull
DHeuristic

How the community answered

(45 responses)

A
4% (2)
B
7% (3)
C
18% (8)
D
71% (32)

Explanation

Use the CREATE MATERIALIZED VIEW statement to create a materialized view. A materialized view is a database object that contains the results of a query. Incorrect answer: A: Specify DEFERRED to indicate that the materialized view is to be populated by the next REFRESH operation. B: Oracle Database uses the default index to speed up incremental (FAST) refresh of the materialized view. C: By default, Oracle Database creates a primary key materialized view with refresh on demand only. If a materialized view log exists on the table, then the column can be altered to be capable of fast refresh. If no such log exists, then only full refresh of the column is possible.

Topics

#materialized view refresh#incremental refresh#full refresh#deferred refresh

Community Discussion

No community discussion yet for this question.

Full 1Z0-515 Practice