Yong,
I would pick D instead, as it is true that index block will never get
updated, it will only insert a new entries.

Thanks And Regards
Chark Sairlao



-----Original Message-----
From: yong huang [mailto:[Email Address Removed] Thursday, 31 May 2001 14:48
To: LazyDBA.com Discussion
Subject: My answer to somebody's question


I hope next time you post a message with a more meaningful Subject. Many
people
skip messages with generic Subjects.

My answer to this question is: none of them. If I have to take an exam, I'll
pick B. A, C and D are wrong. B is correct but does not sound relevant to
the
question. C is wrong because you CAN alter an index. D is wrong because when
a
key below the highest in the full (above PCTFREE) block is inserted, it
causes
a block split near the middle of the block (exact position has eluded the
most
prominent Oracle expert in the world!). That's how an index block is
modified.

Yong Huang
[Email Address Removed] wrote:

The DBA is developing an index creation script. Which of the following
choices best explains the reason why indexes do not permit
the definition of the pctused storage option? A: Indexes have a preset
pctused setting of 25.
B: Oracle must keep index entries in order, so index blocks are always
being updated.
C: Indexes are not altered unless they are recreated.
D: Indexes will not be modified after the pctfree threshold is crossed.

__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/

--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page