You are creating an additional database by using the Database Configuration Assistant (DBCA).
You opted to create a General Purpose database and during the database creation realize that the
Block Size field is not enabled.
What could be the reason for this?
A.
You have chosen the File System option as the storage option.
B.
You have chosen the Automatic Storage Management (ASM) as the storage option.
C.
The data block size can be increased only when DBCA is invoked from Oracle Universal
Installer (OUI).
D.
You are using General Purpose template and not the Custom Database template to create the
database.
Explanation:
Using the DBCA to Create a Database
The DBCA provides several options to allow you to create a database to meet your needs. The
DBCA provides a series of pages where you enter configuration information. On most pages, the
DBCA provides default settings that you can accept if they apply. The steps involved in creating a
database using the DBCA are as follows:
1. Operations: Select “Create a Database.”
2. Database Templates: Select the type of database template to be used in creating the database.
There are two database templates (Data Warehouse and General Purpose and Transaction
Processing) that copy a preconfigured database, including the data files. These data files includecontrol files, redo log files, and data files for various included tablespaces. Click Show Details to
see the configuration for each type of database.
For more complex environments, you may want to select the Custom Database option.