Oracle Security Question:
Download Job Interview Questions and Answers PDF
Explain What are the options available to refresh snapshots?
Answer:
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.
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.
Download Oracle Security Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Explain snapshot log? | How to Enforce Refrencial Integrity in snapshots? |