Which of the following is a type of replication?

Options
- Update replication
- Read-only materialized views
- Multi replication
- All of the above


CORRECT ANSWER : Read-only materialized views

Discussion Board
Read-only materialized view

A materialized view can be either read-only, updatable, or writeable. Users cannot perform data manipulation language (DML) statements on read-only materialized views, but they can perform DML on updatable and writeable materialized views. Read-only materialized view eliminates the possibility of a materialized view introducing data conflicts at the master site or master materialized view site, although this convenience means that updates cannot be made at the remote materialized view site.

Prajakta Pandit 02-16-2017 12:37 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.)


Advertisement