Multiple choice technology databases

How do you change the block size specified by DB_BLOCK_SIZE?

  1. modify the parameter, backup the init file and the database, and restart the instance

  2. modify the parameter and restart the instance

  3. re-create the database

  4. modify the parameter, backup the init file and restart the instance
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

DB_BLOCK_SIZE is a fundamental storage parameter that can only be set when a database is first created. It determines the size of data blocks and cannot be changed by simply modifying parameters or restarting - the entire database must be recreated with the new block size.

Keep practicing — related questions