Materialized views have the data itself. This makes it slower to access

Options
- True
- False

CORRECT ANSWER : False

Discussion Board
Materialized Views

The above statement is wrong. A materialized view is a replica of a target master from a single point in time. The master can be either a master table at a master site or a master materialized view at a materialized view site. The materialized view is populated immediately. The materialized view is populated on the first requested refresh. The following refresh types are available.
FAST : A fast refresh is attempted. If materialized view logs are not present against the source tables in advance, the creation fails.
COMPLETE : The table segment supporting the materialized view is truncated and repopulated completely using the associated query.
FORCE : A fast refresh is attempted. If one is not possible a complete refresh is performed.

Prajakta Pandit 02-9-2017 07:29 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲