nerdexam
Oracle

1Z0-052 · Question #113

View the Exhibit. 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…

The correct answer is D. You are using General Purpose template and not the Custom Database template to create the database. In DBCA, the Block Size field is only configurable when using the Custom Database template, not when using predefined templates like General Purpose.

Managing the Database Instance

Question

View the Exhibit. 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?

Exhibit

1Z0-052 question #113 exhibit

Options

  • AYou have chosen the File System option as the storage option.
  • BYou have chosen the Automatic Storage Management (ASM) as the storage option.
  • CThe data block size can be increased only when DBCA is invoked from Oracle Universal Installer (OUI).
  • DYou are using General Purpose template and not the Custom Database template to create the database.

How the community answered

(52 responses)
  • A
    2% (1)
  • B
    2% (1)
  • C
    6% (3)
  • D
    90% (47)

Why each option

In DBCA, the Block Size field is only configurable when using the Custom Database template, not when using predefined templates like General Purpose.

AYou have chosen the File System option as the storage option.

The storage option of File System does not affect whether the block size field is enabled or disabled in the DBCA wizard.

BYou have chosen the Automatic Storage Management (ASM) as the storage option.

Choosing ASM as the storage option controls where datafiles are placed, not whether the block size parameter is editable in DBCA.

CThe data block size can be increased only when DBCA is invoked from Oracle Universal Installer (OUI).

DBCA can be launched independently or from OUI; invoking it from OUI does not unlock additional configuration parameters such as block size.

DYou are using General Purpose template and not the Custom Database template to create the database.Correct

The General Purpose template in DBCA uses predefined, fixed settings to streamline database creation, and the block size is one of the parameters locked by the template. Only the Custom Database template exposes all low-level configuration options including DB_BLOCK_SIZE, allowing you to set a non-default block size before the database is created.

Concept tested: DBCA template types and block size configuration

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/creating-and-configuring-an-oracle-database.html

Topics

#DBCA#block size#database templates#database creation

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-052 Practice