nerdexam
Oracle

1Z0-043 · Question #171

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 =…

The correct answer is E. LOG_ARCHIVE_FORMAT. See the full explanation below for the reasoning.

Question

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?

Options

  • ALARGE_POOL_SIZE
  • BDB_CREATE_FILE_DEST
  • CLOG_ARCHIVE_DEST
  • DCONTROL_FILES
  • ELOG_ARCHIVE_FORMAT
  • FDB_BLOCK_SIZE

How the community answered

(56 responses)
  • A
    5% (3)
  • B
    4% (2)
  • D
    2% (1)
  • E
    75% (42)
  • F
    14% (8)

Community Discussion

No community discussion yet for this question.

Full 1Z0-043 Practice