Prepare
Practice
Interview
Aptitude
Reasoning
English
GD
Placement papers
HR
Current affairs
Engineering
MCA
MBA
Online test
Login
Online Practice Test
>
Oracle Replication
« Previous
Next »
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
« Previous
Next »
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
Oracle (40)
Oracle (30)
Oracle (49)
Oracle (51)
Oracle (52)
Oracle DBA (29)
Oracle PLSQL (30)
Oracle Replication (20)
Oracle Architecture (20)
Oracle Transaction (20)
PLSQL (22)
PLSQL (24)
PLSQL (50)
Advertisement
▲