Oracle Database Administration I — Question 42

Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)?
(Choose two.)

Answer options

• A. PCTFREE defaults to 10% for all blocks in all segments for all compression methods
• B. ASSM assigns blocks to one of four fullness categories based on what percentage of the block is allocated for rows
• C. Update operations always attempt to find blocks with free space appropriate to the length of the row being updated
• D. Insert operations always attempt to find blocks with free space appropriate to the length of the row being inserted
• E. A block will always be eligible for inserts if the row is short enough to fit into the block

Correct answer: B, D

Explanation

Option B is correct because ASSM does categorize blocks into fullness categories based on the allocation percentage. Option D is also correct as insert operations do seek blocks that have sufficient space for the new row. Options A and C are incorrect because A misrepresents the default PCTFREE value and C inaccurately describes the behavior of update operations, which do not always prioritize free space based on row length.