What is an Extent?

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

(Continued from previous question...)

163. What is an Extent?

An Extent is a specific number of contiguous data blocks, obtained in a single allocation, and used to store a specific type of information.

(Continued on next question...)

Other Job Interview Questions

• What are the more common pseudo-columns?
• What is RULE-based approach to optimization?
• How do I eliminate the duplicate rows ?
• What is Read-Only Transaction?
• Other way to replace query result null value with a text
• Why is it preferable to create a fewer no. of queries in the data model?
• What is a trace file and how is it created?
• What DBA activities did you to do today?
• What is the use of Control File?
• State any three mouse events system variables?
• More...