File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Oracle/OAS and the fly likes pctfree & pctused parameter setting Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Reply Bookmark "pctfree & pctused parameter setting" Watch "pctfree & pctused parameter setting" New topic
Author

pctfree & pctused parameter setting

Lipman Li
Ranch Hand

Joined: May 02, 2002
Posts: 122
there's a question on this subject on the Oracle OCP study guide on fundamentals I:
You are configuring block space utilization on an Oracle table. which of following choice identifies block space utilization settings that are never appropriate under any circumstances?
a) pctfree 20, pctused 70
b) pctfree 15, pctused 80
c) pctfree 10, pctused 40
d) pctfree 5, pctused 90
the answer is choice b).
I could not understand why, as I know that only hard threshold is pctfree + pctused < 100.
in this question, choice a) and b) looks similar.
choice d) may be appropriate for read-only table
choice c) may be appropriate for table whose data changed frequently.
may anyone explain?
 
 
subject: pctfree & pctused parameter setting
 
Threads others viewed
labels for break statement
Found this Question in the Mock exam. Can anybody tell/explain what the choice is...
Weblogic 7.0 certification mock test question
catch{} blocks
try-catch statement
MyEclipse, The Clear Choice