What does coalescing a tablespace do?

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

(Continued from previous question...)

40. What does coalescing a tablespace do?

Coalescing is only valid for dictionary-managed tablespaces and de-fragments space by combining neighboring free extents into large single extents.

(Continued on next question...)

Other Job Interview Questions

• What is an index and How it is implemented in Oracle database?
• What is WHEN-Database-record trigger?
• How would you determine who has added a row to a table?
• How can a square be drawn in the layout editor of the report writer?
• What is the frame & repeating frame?
• What is the use of ANALYZE command?
• Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
• Explain the use of TKPROF? What initialization parameter should be turned on to get full TKPROF output?
• What are the responsibilities of a Database Administrator?
• What is the difference between the SQL*Loader and IMPORT utilities?
• More...