OCP-1Z0-052-V8.02-166题
来源:互联网 发布:实对称矩阵对角化方法 编辑:程序博客网 时间:2024/05/20 05:57
166. View the Exhibit and examine the setting for a table.
A.It sets the minimum percentage of a data block to be reserved to contain chained rows from other
blocks.
B.It sets the minimum percentage of a data block to be reserved as free space before the server prevents
inserts into the block.
C.It sets the minimum percentage of a data block to be reserved to contain the bitmap used to maintain
the free block information.
D.It sets the minimum percentage of a block that can be used for row data plus overhead before new rows
are added to the block.
Answer: B
答案解析:
默认的PCTFREE 为10%,意味着在一个数据块里至少有10%的空闲空间,如果插入的数据或者更新的数据让数据块的空闲空间少于10%,则会插入或更新到另一个数据块里。
PCTFREE integer
Specify a whole number representing the percentage of space in each data block of the database object reserved for future updates to rows of the object. The value ofPCTFREE
must be a value from 0 to 99. A value of 0 means that the entire block can be filled by inserts of new rows. The default value is 10.This value reserves 10% of each block for updates to existing rows and allows inserts of new rows to fill a maximum of 90% of each block.
- OCP-1Z0-052-V8.02-166题
- OCP-1Z0-052-V8.02-1题
- OCP-1Z0-052-V8.02-91题
- OCP-1Z0-052-V8.02-92题
- OCP-1Z0-052-V8.02-80题
- OCP-1Z0-052-V8.02-81题
- OCP-1Z0-052-V8.02-82题
- OCP-1Z0-052-V8.02-79题
- OCP-1Z0-052-V8.02-77题
- OCP-1Z0-052-V8.02-23题
- OCP-1Z0-052-V8.02-72题
- OCP-1Z0-052-V8.02-157题
- OCP-1Z0-052-V8.02-156题
- OCP-1Z0-052-V8.02-155题
- OCP-1Z0-052-V8.02-29题
- OCP-1Z0-052-V8.02-110题
- OCP-1Z0-052-V8.02-165题
- OCP-1Z0-052-V8.02-171题
- 结构体的内存分配(对齐)
- 文件上传简介1---上传到指定的目录
- OCP-1Z0-052-V8.02-167题
- 转折后的总结--2014年找工作
- 虚拟类--动物描述
- OCP-1Z0-052-V8.02-166题
- 图片上按钮特效 热点链接(img map area)
- 华为机考回忆版(三:自己的)
- C++学习之旅——C++类型转换
- directx 编译书中带的源码出现无法解析的外部符号
- TJU Counting Letters
- VC操作文件、注册表
- C#专题 运算
- 【Mono】C# + Mono + Linux 编程初体验之 HelloWorld