DEVFYI - Developer Resource - FYI

What are the options available to refresh snapshots ?

ORACLE Interview Questions and Answers (Part 1)


(Continued from previous question...)

107. What are the options available to refresh snapshots ?

COMPLETE - Tables are completely regenerated using the snapshots query and the master tables every time the snapshot referenced.
FAST - If simple snapshot used then a snapshot log can be used to send the changes to the snapshot tables.
FORCE - Default value. If possible it performs a FAST refresh; Otherwise it will perform a complete refresh.

(Continued on next question...)

Other Interview Questions