ocp 19c考题，科目082考试题(23)- space management within blocks managed ASSM
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博客 ” ，链接：https://blog.itpub.net/70010796/viewspace-2855619/ ，如需转载，请注明出处，否则将追究法律责任。
最新文章
- 从小白到专家 PG技术大讲堂 - Part 2：PG源代码安装
- 从小白到专家 PG 技术大讲堂 - Part 1：PG 简介
- ocp 19c考题，科目082考试题(34)
- ocp 19c考题，科目082考试题(33)
- ocp 19c考题，科目082考试题(32) -
- ocp 19c考题，科目082考试题(31) - resource_limit
- ocp 19c考题，科目082考试题(30) - default profile
- ocp 19c考题，科目082考试题(29) - about profiles
- ocp 19c考题，科目082考试题(28) - oracle profiles
- ocp 19c考题，科目082考试题(27) - order by clause
