ALLInterview.com :: Home Page Forum9.Com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage   interview questions urls   External Links  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories >> Software >> Databases >> Oracle >> Architecture
 
 


 

 
 Oracle General interview questions  Oracle General Interview Questions
 OCI interview questions  OCI Interview Questions
 Architecture interview questions  Architecture Interview Questions
 Oracle Security interview questions  Oracle Security Interview Questions
 Database Management interview questions  Database Management Interview Questions
 Forms Reports interview questions  Forms Reports Interview Questions
Question 
What is meant by free extent ?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is meant by free extent ?
Answer
# 1		 
A free extent is a collection of continuous free blocks in
tablespace. When a segment is dropped its extents are
reallocated and are marked as free.
 
Is This Answer Correct ?    0 Yes 0 No
Orawhiz
 
  Re: What is meant by free extent ?
Answer
# 2		 
FREE EXTENT MEANS UNALLOCATED AREA OF A SEGMENT.

WHEN WE DELETE DATA FROM TABLE, EXTENT OF CORROSPONDING 
SEGMENT BECOMES FREE.

BUT IF WE ARE TRUNCATING A TABLE IT REMOVES EXTENTS ALSO.
 
Is This Answer Correct ?    0 Yes 0 No
Manvendra
 
 
 
 
 
 
Other Architecture Interview Questions
 
  Question Asked @ Answers
 
How many Dispatcher Processes are created?  1
How will you create multiple rollback segments in a database ?  1
What is advantage of having disk shadowing/ Mirroring ?  1
What is the functionality of SYSTEM table space ?  2
What are the functions of SMON?  1
What is meant by free extent ?  2
How does Space allocation table place within a block ?  1
Why query fails sometimes ?  1
What is Shared Pool?  3
What is dictionary cache ?  2
What is use of Rollback Segments In Database ?  2
What is a Rollback segment entry ? TCS3
what is ORACLE MEMORY STRUCTURES  1
What are the components of SGA?  2
How will you monitor rollback segment status ?  1
How free extents are managed in Ver 6.0 and Ver 7.0 ? IBM1
What are functions of PMON?  2
What does LGWR do?  1
What is User Process?  1
List the factors that can affect the accuracy of the estimations ?  1
 
For more Architecture Interview Questions Click Here 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com