What are the options available to refresh snapsh

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

78. 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 Job Interview Questions

• What is WHEN-Database-record trigger?
• How can we reduce the network traffic?
• How do you switch from an init.ora file to a spfile?
• What is an index and How it is implemented in Oracle database?
• Do View contain Data?
• A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
• What are the built-ins used for Creating and deleting groups?
• What is the diff. when Flex mode is mode on and when it is off?
• If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?
• How do you create a new session while open a new form?
• More...