Explain an extent?



Explain an extent?..

Answer / Prakash Kumar Jha

An extent in Oracle is a logical unit of storage used to allocate space for segments. An extent consists of one or more contiguous database blocks and is the smallest unit of allocation that can be managed by Oracle. Extents are allocated based on the size specified when creating a table, index, cluster, or LOB.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle General Interview Questions

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

1 Answers   MCN Solutions,


How to define a specific record type?

1 Answers  


What is a relational database management system?

1 Answers  


What is TNS File

7 Answers   Thermotech,


Hi Guys,I have completed my B.com Commerc in the year 2005 and MBA finance in 2008(Correspondance).And I have 3+yrs exp in Accounting and Finance feild.I have worked for TCS for 1.8yrs as Project manage office as a enduser in oracle ERP module.Currently working as Project Adminstartor for CSC.I have joined in Oracle financial classes and I am through with that subject.So my concern is After learning oracle, am in dilemma that will i be eligible to get job in oracle or not?Please advice or Give me suggestions.To kick start my career as fresher in Oracle

0 Answers  


How to invoke the data pump export utility?

1 Answers  


20. Using a set operator, display the client number of all clients who have never placed an order.

1 Answers   Wipro,


what is data abstraction

3 Answers   Semantic Space,


Difference between pre-select and pre-query

1 Answers  


Differentiate between translate and replace?

1 Answers  


Is a rollback possible to any savepoint?

1 Answers  


What are the sql clauses supported in the link property sheet ?

1 Answers   Oracle,


Categories
  • Oracle General Interview Questions Oracle General (1803)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)