What is the role of PCTFREE parameter is Storage clause ? - This is used to reserve certain amount of space in a block for expansion of rows. - Memory Management Interview Questions and Answers

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

ORACLE

MEMORY MANAGEMENT

DETAILS

Question: What is the role of PCTFREE parameter is Storage clause ?

Answer: This is used to reserve certain amount of space in a block for expansion of rows.

Category	Memory Management Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.2) By 8124 users
Added on	10/27/2009
Views	69563
Rate it!

Question: What is the role of PCTFREE parameter is Storage clause ?

Answer:

This is used to reserve certain amount of space in a block for expansion of rows. Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	What is the OPTIMAL parameter?	View Answer
	What is the functionality of SYSTEM table space ?	View Answer
	How will you create multiple rollback segments in a database ?	View Answer
	How the space utilization takes place within rollback segments ?	View Answer
	Why query fails sometimes ?	View Answer
	How will you monitor the space allocation ?	View Answer
	How will you monitor rollback segment status ?	View Answer
	List the sequence of events when a large transaction that exceeds beyond its optimal value when an entry wraps and causes the rollback segment toexpand into another extend.	View Answer
	How can we plan storage for very large tables ?	View Answer
	How will you estimate the space required by a non-clustered tables?	View Answer
	It is possible to use raw devices as data files and what is the advantages over file. system files ?	View Answer
	What is a Control file ?	View Answer
	How to implement the multiple control files for an existing database ?	View Answer
	What is meant by Redo Log file mirroring ? How it can be achieved?	View Answer
	What is advantage of having disk shadowing/ Mirroring ?	View Answer
	What is use of Rollback Segments In Database ?	View Answer
	What is a Rollback segment entry ?	View Answer
	What is hit ratio ?	View Answer
	When will be a segment released ?	View Answer
	What are disadvantages of having raw devices ?	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All Memory Management Interview Questions & Answers - Exam Mode / Learning Mode