ocp 19c考題,科目082考試題(23)- space management within blocks managed ASSM

unix_5030發表於2022-02-14

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

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

source : cuug


來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/70010796/viewspace-2855619/,如需轉載,請註明出處,否則將追究法律責任。

相關文章