Identify the type of refresh that is NOT supported by materialized views.
A.
Deferred
B.
Incremental
C.
Full
D.
Heuristic
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.
Reference: Oracle Database SQL Language Reference, 11g Release 1 (11.1),CREATE
MATERIALIZED VIEW
A is totally wrong, because the Deferred, see oracle document
http://docs.oracle.com/cd/B10501_01/server.920/a96520/mv.htm
Build Method Description
BUILD IMMEDIATE
Create the materialized view and then populate it with data
BUILD DEFERRED
Create the materialized view definition but do not populate it with data
it is not a refresh type, but a build type. “RE”fresh without any physical stored data is really odd.
So the answer should be A and D.