What is On-line Redo Log?

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

(Continued from previous question...)

136. What is On-line Redo Log?

The On-line Redo Log is a set of tow or more on-line redo files that record all committed changes made to the database. Whenever a transaction is committed, the corresponding redo entries temporarily stores in redo log buffers of the SGA are written to an on-line redo log file by the background process LGWR. The on-line redo log files are used in cyclical fashion.

(Continued on next question...)

Other Job Interview Questions

• A developer is trying to create a view and the database won?t let him. He has the "DEVELOPER" role which has the "CREATE VIEW" system privilege and SELECT grants on the tables he is using, what is the problem?
• What is the use of transactional triggers?
• What are the steps involved in Database Startup?
• Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?
• What is a “trigger”?
• What is SAVE POINT?
• What are the different windows events activated at runtimes?
• A user selects from a sequence and gets back two values, his select is:
• What is a pseudo column. Give some examples?
• Explain the difference between a hot backup and a cold backup and the benefits associated with each.
• More...