Identify the default block Size used for the database.

When creating an Oracle Cluster database using DBCA the “Memory size (SGA and PGA) field is

supplied on value of 2000 MB. Identify the default block Size used for the database.

A.
2 KB

B.
4 KB

C.
8 KB

D.
16 KB

E.
32 KB

Explanation:
Type of LimitLimit Value
Minimum2k.Must be a multiple of operating system physical block size
MaximumOperating system dependent, but never more than 32 KB
DBCA tab sizing
In this tab, you specify the smallest block size and the maximum number of operating system user
processes that can simultaneously connect to the database.
In the Block Size list, enter the size in bytes or accept the default. Oracle Database data is stored
in these blocks. One data block corresponds to a specific number of bytes of physical space on
disk. While using pre-defined templates, this field is not enabled since the database will be created
with the default block size of 8 KB. But while using the custom option, you can change block size.
Selecting a block size other than the default 8 KB value requires advanced knowledge and should
only be done when absolutely required.
Oracle Database 2 Day DBA