nerdexam
Oracle

1Z0-052 · Question #77

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…

The correct answer is D. Setting the DB_16K_CACHE_SIZE parameter for the database instance to a nonzero value. To create a tablespace with a non-standard block size in Oracle, a corresponding buffer cache must be allocated for that block size using the appropriate initialization parameter.

Managing Database Storage Structures

Question

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?

Exhibit

1Z0-052 question #77 exhibit

Options

  • AChoosing the extent allocation type to uniform
  • BChoosing the Segment Space Management option to manual
  • CSetting autoextension on for the data file mentioned for the tablespace
  • DSetting the DB_16K_CACHE_SIZE parameter for the database instance to a nonzero value

How the community answered

(47 responses)
  • A
    11% (5)
  • B
    2% (1)
  • C
    6% (3)
  • D
    81% (38)

Why each option

To create a tablespace with a non-standard block size in Oracle, a corresponding buffer cache must be allocated for that block size using the appropriate initialization parameter.

AChoosing the extent allocation type to uniform

Extent allocation type (uniform vs. autoallocate) controls how extents are sized within a tablespace and has no relationship to the block size available for selection.

BChoosing the Segment Space Management option to manual

Segment Space Management (manual vs. automatic) governs how free and used space is tracked within segments using freelists or bitmaps, and does not influence the block size options.

CSetting autoextension on for the data file mentioned for the tablespace

Autoextension controls whether a data file grows automatically when space is exhausted; it has no effect on which block sizes are available for a tablespace.

DSetting the DB_16K_CACHE_SIZE parameter for the database instance to a nonzero valueCorrect

Oracle supports multiple block sizes per database, but each non-default block size requires a dedicated buffer cache pool. Setting DB_16K_CACHE_SIZE to a nonzero value allocates a 16KB buffer cache, which is a prerequisite before any tablespace using a 16KB block size can be created. Without this parameter set, the Oracle instance has no memory pool to service 16KB block I/O, so the option is simply unavailable in the storage configuration UI.

Concept tested: Oracle multiple block size tablespace configuration

Source: https://docs.oracle.com/cd/E11882_01/server.112/e40540/logical.htm#CNCPT401

Topics

#non-standard block size#DB_16K_CACHE_SIZE#tablespace creation#buffer cache

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice