Oracle creates an index for the _____________ in the snapshot base table

Options
- Primary key
- Foreign key
- Super key
- Both a and c

CORRECT ANSWER : Primary key

Discussion Board
Snapshot concepts

Oracle creates an index for the primary key in the snapshot base table. Primary key snapshots are the default type of snapshot.

They are updateable if the snapshot was created as part of a snapshot group and "FOR UPDATE" was specified when defining the snapshot.

Changes are propagated according to the row-level changes that have occurred, as identified by the primary key value of the row (not the ROWID).

Prajakta Pandit 02-16-2017 01:26 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
 
▲