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.

Question

Options

• A2 KB
• B4 KB
• C8 KB
• D16 KB
• E32 KB

• A
  3% (1)
• B
  14% (5)
• C
  73% (27)
• D
  8% (3)
• E
  3% (1)

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

No community discussion yet for this question.