QUESTION 27 Which view type replicates data by physically storing the view query's results?

a. Complex View

b. Materialized View

c. Inline View

d. Simple View

QUESTION 28 The B-tree (balanced-tree) index is the most common index used in Oracle.

a. True

b. False

QUESTION 29 A _______ function performs increasing levels of cumulative subtotals, based on the provided column list.

a. MAX

b. STDDEV

c. ROLLUP

d. CUBE