What is Rollback Segment?

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

(Continued from previous question...)

175. What is Rollback Segment?

A Database contains one or more Rollback Segments to temporarily store “undo” information.

(Continued on next question...)

Other Job Interview Questions

• Display the records between two range
• What are the uses of rollback segment?
• How would you determine what sessions are connected and what resources they are waiting for?
• What is Parallel Server?
• Explain materialized views and how they are used.
• What is schema?
• What are the built-ins used for finding Object ID function?
• What is the maximum number of triggers, can apply to a single table?
• What background process refreshes materialized views?
• What is Full Backup?
• More...