Advanced replication facility allows applications to insert, update, and delete table rows through updatable snapshots

Options
- True
- False


CORRECT ANSWER : True

Discussion Board
Snapshot concepts

The above statement is true. Master sites in an advanced replication system can consolidate the information that applications update at remote snapshot sites. Oracle's symmetric replication facility allows applications to insert, update, and delete table rows through updatable snapshots. Updatable snapshots have the following properties:
1. Updatable snapshots are always simple, fast-refreshable table snapshots.
2. Oracle propagates the changes made through an updatable snapshot to the snapshot's remote master table. If necessary, the updates then cascade to all other master sites.
3. Oracle refreshes an updatable snapshot as part of a refresh group, identical to read-only snapshots.
4. Updatable snapshots have the same underlying objects (base table, indexes, and views) as read-only snapshots. Additionally, Oracle creates a table USLOG$_snapshotname to support updatable snapshots.

Prajakta Pandit 02-16-2017 02:10 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