1Z0-062 · Question #187
You want to create a database with a block size other than the default 8 KB by using the Database Configuration Assistant (DBCA). Which option should you use?
The correct answer is A. A custom database template. DBCA seed templates like General Purpose or Data Warehouse lock in the default 8 KB block size. Only a custom template exposes advanced database options such as a non-default block size.
Question
You want to create a database with a block size other than the default 8 KB by using the Database Configuration Assistant (DBCA). Which option should you use?
Options
- AA custom database template
- BA Data Warehouse database template
- CAutomatic Storage Management (ASM) for storage of data files.
- DA file system for storage of data files
How the community answered
(46 responses)- A96% (44)
- B2% (1)
- D2% (1)
Why each option
DBCA seed templates like General Purpose or Data Warehouse lock in the default 8 KB block size. Only a custom template exposes advanced database options such as a non-default block size.
A custom database template in DBCA presents the Advanced configuration pages, including the option to specify DB_BLOCK_SIZE at creation time; pre-built seed templates hide this parameter and enforce the 8 KB default. Because block size is set at database creation and cannot be changed afterward, the custom template path is the only way to configure it through DBCA.
The Data Warehouse seed template is a pre-built template that uses the default 8 KB block size and does not expose the block size configuration option.
Selecting ASM as the storage mechanism determines where data files are placed but has no effect on the database block size.
Choosing a file system for storage governs the file placement method only and does not influence the DB_BLOCK_SIZE setting.
Concept tested: DBCA custom template for non-default block size
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/creating-and-configuring-an-oracle-database.html
Topics
Community Discussion
No community discussion yet for this question.