Which parameter would be ignored while starting up the instance for the database PROD?

You want an ASM instance to manage the files of your database. To achieve this objective, you
specify the following parameters in the parameter file of the database:

INSTANCE_TYPE = RDBMS
DB_NAME = PROD
LARGE_POOL_SIZE = 8MB
DB_BLOCK_SIZE = 4K
LOG_ARCHIVE_DEST = +dgroupA
LOG_ARCHIVE_FORMAT = “$ORACLE_SID_%s_%t.%t”
DB_CREATE_FILE_DEST = +dgroupA
COMPATIBLE = 10.1.0.2.0
CONTROL_FILES = +dgroupA
Which parameter would be ignored while starting up the instance for the database PROD?

You want an ASM instance to manage the files of your database. To achieve this objective, you
specify the following parameters in the parameter file of the database:

INSTANCE_TYPE = RDBMS
DB_NAME = PROD
LARGE_POOL_SIZE = 8MB
DB_BLOCK_SIZE = 4K
LOG_ARCHIVE_DEST = +dgroupA
LOG_ARCHIVE_FORMAT = “$ORACLE_SID_%s_%t.%t”
DB_CREATE_FILE_DEST = +dgroupA
COMPATIBLE = 10.1.0.2.0
CONTROL_FILES = +dgroupA
Which parameter would be ignored while starting up the instance for the database PROD?

A.
LARGE_POOL_SIZE

B.
DB_CREATE_FILE_DEST

C.
LOG_ARCHIVE_DEST

D.
CONTROL_FILES

E.
LOG_ARCHIVE_FORMAT

F.
DB_BLOCK_SIZE



Leave a Reply 0

Your email address will not be published. Required fields are marked *