OCP-1Z0-052-V8.02-166题

最新推荐文章于 2019-08-02 09:30:06 发布

原创最新推荐文章于 2019-08-02 09:30:06 发布 · 7.9k 阅读

2 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

OCP11g解析

OCP-1Z0-052

本文详细解释了数据库中PCTFREE参数的作用及意义。PCTFREE设置为数据块预留一定百分比的空间，以便后续更新操作不会导致数据块过度填满。默认情况下，PCTFREE值为10%，意味着每个数据块预留10%的空间用于现有行的更新，同时允许新行填充最多90%的空间。

166. View the Exhibit and examine the setting for a table.

Which statement is true about the PCTFREE setting for the 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.