Q163 Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)?
- A) PCTFREE defaults to 10% for all blocks in all segments for all compression methods
- B) Update operations always relocate rows into blocks with free space appropriate to the length of the row being updated
- C) ASSM assigns blocks to one of four fullness categories based on what percentage of the block is allocated for rows
- D) The first block with enough free space to accommodate a row being inserted will always be used for that row
- E) Insert operations always insert new rows into blocks with free space appropriate to the length of the row being inserted
Answer: C,E