Which of the following statements holds true for snap shots?

Options
- A snapshot log is a copy of the master table.
- The log can also be used to track the columns that have been updated in the master table
- The snapshot table is updated using batch updates
- Both a and c

CORRECT ANSWER : Both a and c

Discussion Board
Snapshot logs

The snapshot logs that Oracle creates for a master table is a table in its own right. It is stored in the same database as the table. If a transaction modifies data in the master table, an internal trigger (kernel code in Oracle8) on the master table automatically inserts rows into it's snapshot log. One master table can only have one snapshot log. However, the master table can have multiple snapshots each having data replicated to them from the one master table via the snapshot log.

Prajakta Pandit 02-10-2017 12:13 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
 
▲