What is a SNAPSHOT LOG?

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

(Continued from previous question...)

79. What is a SNAPSHOT LOG?

A snapshot log is a table in the master database that is associated with the master table. ORACLE uses a snapshot log to track the rows that have been updated in the master table. Snapshot logs are used in updating the snapshots based on the master table.

(Continued on next question...)

Other Job Interview Questions

• What is a SQL * NET?
• What is an Integrity Constrains?
• What is term?
• What is the difference between boiler plat images and image items?
• What is a correlated subquery?
• How do you switch from an init.ora file to a spfile?
• Explain what partitioning is and what its benefit is.
• What are the triggers available in the reports?
• What is a Schema?
• What is the difference between SHOW_EDITOR and EDIT_TEXTITEM?
• More...