You have a rollback segment in a version 7.2 dat

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

(Continued from previous question...)

You have a rollback segment in a version 7.2 database that has expanded beyond optimal, how can it be restored to optimal?

Level: Low
Expected answer: Use the ALTER TABLESPACE ..... SHRINK command.

(Continued on next question...)

Other Job Interview Questions

• How can you gather statistics on a table?
• What are the built-ins that are used for setting the LOV properties at runtime?
• How can a group in a cross products be visually distinguished from a group that does not form a cross product?
• What is a Synonym?
• What?s the command to see the current user name?
• What is new_form built-in?
• What are the built-ins used for processing rows?
• How can a group in a cross products be visually distinguished from a group that does not form a cross product?
• What are Most Common types of Complex master-detail relationships?
• How many number of columns a record group can have?
• More...