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

147. View the Exhibit.

You want to create a tablespace to contain objects with block size 16 KB. But while configuring the

storage you find that the block size that you can provide is only 8 KB. 

Which configuration could have enabled the block selection of 16 KB?

A.choosing the extent allocation type to uniform

B.choosing the Segment Space Management option to manual

C.setting autoextension on for the data file mentioned for the tablespace

D.setting the DB_16K_CACHE_SIZE parameter for the database instance to a nonzero value

Answer: D  

答案解析：

参考：http://blog.csdn.net/rlhua/article/details/12572003

当DB_16K_CACHE_SIZE为非零值是，在创建表空间时，才可以选择16K的块大小。

sys@TEST0924> alter system set db_16k_cache_size=32M;

System altered.

在创建表空间时，可选择16K的数据块。