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
Exhibit not showing
If DB_16K_CACHE_SIZE is non-zeroļ¼then we can choose 16K for the block size when we create the space.
sys@TEST0924> alter system set db_16k_cache_size=32M;
The database is created with a standard block size and up to 5 … 0M DB_16K_CACHE_SIZE = 0M DB_32K_CACHE_SIZE = 0M … SQL> ALTER SYSTEM SET DB_2K_CACHE_SIZE=16M