Oracle Security Interview Question:

Explain What are the options available to refresh snapshots?

Submitted by: Administrator

COMPLETE - Tables are completly regenerated using
the snapshot's 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.
Submitted by: Administrator