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                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
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 the role of PCTFREE parameter is Storage clause ?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is the role of PCTFREE parameter is Storage clause ?
Answer
# 1		 
A oracle block divided into three parts.
block header,pctfree,pctused.


block header :its contain the information datafiles.


pctfree: its a free space in a datablock for updation and 
insertion of a row.default is 10% of a block size.one more 
thing it's default value is depand of OS also.


pctused : its a space where data are store in a block.its 
default value is 40% of a block size.
 
0
Ankur Aggarwal
 
  Re: What is the role of PCTFREE parameter is Storage clause ?
Answer
# 2		 
pctfree is only used for future updation, not for inserts.
 
0
Vivek
 
 
 
 
 
 
Other Architecture Interview Questions
 
  Question Asked @ Answers
 
What is the function of Dispatcher (Dnnn)?  2
How will you estimate the space required by a non-clustered tables?  1
What is Server Process?  1
How will you swap objects into a different table space for an existing database?  1
What is meant by free extent ?  2
What Does DBWR do?  2
What is Cursor?  2
How to implement the multiple control files for an existing database ?  1
When does LGWR write to the database?  2
What are the components of SGA?  1
What is use of Rollback Segments In Database ?  2
What is the function of Lock (LCKn) Process?  1
What do Redo Log Buffers contain?  1
Why query fails sometimes ?  1
What is PGA?  3
What is dictionary cache ?  2
What is Dedicated Server Configuration?  1
What is function of RECO?  1
What are functions of PMON?  2
What is meant by Redo Log file mirrorring ? How it can be achieved?  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