What are the uses of rollback segment?

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

(Continued from previous question...)

114. What are the uses of rollback segment?

If we find any problem after data manipulation and if we want to undo it, then we can use this ROLLBACK segment.
SAVEPOINT is the command used to save the workdone. After saving data, if we want to perform insertion/deletion and we done it wrongly, then we can ROLLBACK it by using the SAVEPOINT.

Ex:
SAVEPOINT s1;
ROLLBACK s1;

(Continued on next question...)

Other Job Interview Questions

• What is the difference between OLE Server & OLE Container?
• How do you reference a parameter indirectly?
• What are the built-ins used for Creating and deleting groups?
• What other parts of your organization do you interact with and how?
• What is the frame & repeating frame?
• What are the built-ins used for finding Object ID function?
• List the Optional Flexible Architecture (OFA) of Oracle database? How can we organize the tablespaces in Oracle database to have maximum performance?
• What command would you use to create a backup control file?
• If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)
• What are built-ins used for Processing rows?
• More...