CMS专题

单选题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_

题目
单选题
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

DB_BLOCK_SIZE

B

CONTROL_FILES

C

LARGE_POOL_SIZE

D

LOG_ARCHIVE_DEST

E

LOG_ARCHIVE_FORMAT

F

DB_CREATE_FILE_DEST

如果没有搜索结果,请直接 联系老师 获取答案。
如果没有搜索结果,请直接 联系老师 获取答案。
相似问题和答案

第1题:

n your production database you want to use an Automatic Storage Management (ASM) instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance?()

  • A、 Oracle Migration Assistant
  • B、 Recovery Manager (RMAN)
  • C、 Oracle Data Pump Export and Import
  • D、 conventional Oracle Export and Import
  • E、 operating system utilities to copy the files to the ASM instance

正确答案:B

第2题:

You want to convert your existing non-ASM files to ASM files for the database PROD.  Which method or command would you use to accomplish this task?()  

  • A、 Data Pump Export and Import
  • B、 conventional export and import
  • C、 the CONVERT command of RMAN
  • D、 the BACKUP AS COPY. command of RMAN

正确答案:D

第3题:

You have been assigned to manage a set of databases. The previous DBA did not leave you notes regarding the structure of each of the databases. While analyzing an instance, you notice that the system identifier (SID) for the instance is set to ’+ASM’. What is the purpose of this instance?()

  • A、 This instance is being used to manage the operating system files.
  • B、 This instance is being used to manage the files of other databases.
  • C、 This instance is being used to manage the instances of other databases.
  • D、 This instance is being used to manage the background processes of other instances.

正确答案:B

第4题:

You want to migrate your existing non-ASM files to ASM files for the database PROD. Which method  or command would you use to accomplish this task?()

  • A、the CONVERT command of RMAN
  • B、Data Pump Export and Import into the same database
  • C、conventional export and import into the same database
  • D、the BACKUP DATABASE and RESTORE DATABASE commands of RMAN
  • E、the BACKUP AS COPY DATABASE and SWITCH DATABASE TO COPY command of RMAN

正确答案:A,E

第5题:

You have a single Automatic Storage Management (ASM) instance running on the node on which your Oracle Database 10g resides. Which ASM instance initialization parameters must be included in the ASM instance initialization parameter file?()

  • A、 INSTANCE_TYPE
  • B、 DB_UNIQUE_NAME
  • C、 ASM_DISKSTRING
  • D、 ASM_POWER_LIMIT

正确答案:A

第6题:

You are maintaining the SALES database.You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity.Which parameter should you specify to control the speed of the rebalancing activity?()

  • A、ASM_POWER_LIMIT
  • B、ASM_DISKSTRING
  • C、ASM_DISKGROUPS
  • D、INSTANCE_TYPE

正确答案:A

第7题:

In your production database you want to use an Automatic Storage Management (ASM) instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance?()

  • A、Oracle Migration Assistant
  • B、Recovery Manager (RMAN)
  • C、Oracle Data Pump Export and Import
  • D、conventional Oracle Export and Import
  • E、operating system utilities to copy the files to the ASM instance

正确答案:B

第8题:

You are using an Automatic Storage Management (ASM) instance to manage the files of your production database. While studying the parameter file of the ASM instance, you find the following entry:  ASM_DISKSTRING = /devices/*  What could be the reason for this setting?()

  • A、to enable the ASM instance to identify the alert log file
  • B、to enable the ASM instance to identify the server parameter file
  • C、to enable the ASM instance to define the locations for Oracle Managed Files (OMF)
  • D、to enable the ASM instance to identify all disks that can be accessed by it in the /devices directory

正确答案:B

第9题:

Your production database uses an Automatic Storage Management (ASM) instance to manage its files.  You want to add a new disk group to the ASM instance to manage the increased data load.  What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users?()

  • A、mount the new disk group in the ASM instance
  • B、restart the ASM instance and the production database instance
  • C、register the new disk groups in the production database instance
  • D、restart the ASM instance without restarting the production database instance
  • E、include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

正确答案:A

第10题:

You want to migrate your existing non/x7fASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task?()

  • A、the CONVERT command of RMAN
  • B、Data Pump Export and Import into the same database
  • C、conventional export and import into the same database
  • D、the BACKUP DATABASE and RESTORE DATABASE commands of RMAN
  • E、the BACKUP AS COPY DATABASE and SWITCH DATABASE TO COPY command of RMAN

正确答案:A,E

更多相关问题