Chinaunix首页 | 论坛 | 博客
  • 博客访问: 21921
  • 博文数量: 36
  • 博客积分: 0
  • 博客等级: 民兵
  • 技术积分: 210
  • 用 户 组: 普通用户
  • 注册时间: 2021-11-30 10:47
文章分类
文章存档

2022年(28)

2021年(8)

我的朋友

分类: Oracle

2022-02-14 16:32:37

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

阅读(272) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~