To support tablespaces that use a block size other than the default, the DBA can configure separate buffer caches. Which of the following accurately describes configuring these separate buffer caches?
A . Set the init.ora DB_nK_CACHE_SIZE parameters to the required cache size where n is some block size in the series 2, 4, 8, 16, and 32, including the default block size.
B . The init.ora parameter DB_CACHE_BLOCK_SIZE can be set to any one of the values 2, 4, 8, 16, or 32.
C. Set the init.ora DB_nK_CACHE_SIZE parameters to the required cache size where n is some block size in the series 2, 4, 8, 16, and 32, excluding the default block size.
D . Set the init.ora parameters DB_nK_CACHE_SIZE to the required cache size where n is some block size in the range of 2 to 32, excluding the default block size.
E . Set the init.ora parameters DB_nK_CACHE_SIZE to the required cache size where n is some block size in the range of 1 to 32, including the default block size.
Explanation:
Answer C: The DBA can create separate buffer caches, based on the non-default block sizes. Acceptable block size values are 2, 4, 8, 16, and 32, excluding the value for DB_BLOCK_SIZE, which is the default database block size and the block size for the system tablespace.
No comments:
Post a Comment