Oracle认证考试

A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows: SQL> CREATE DISKGROUP dgroup1 NORMAL REDUNDANCY FAILGROUP controller1 DISK '/devices/diska1', '/devices/diska2' FAILGROUP co

题目

A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows: SQL> CREATE DISKGROUP dgroup1 NORMAL REDUNDANCY FAILGROUP controller1 DISK '/devices/diska1', '/devices/diska2' FAILGROUP controller2 DISK '/devices/diskb1', '/devices/diskb2' ; What happens when the whole CONTROLLER1 Failure group is damaged?()

  • A、The transactions that use the disk group will halt.
  • B、The mirroring of allocation units occurs within the CONTROLLER2 failure group.
  • C、The data in the CONTROLLER1 failure group is shifted to the CONTROLLER2 failure group and implicit rebalancing is triggered.
  • D、The ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the CONTROLLER2 failure group.
参考答案和解析
正确答案:C
如果没有搜索结果,请直接 联系老师 获取答案。
相似问题和答案

第1题:

Which two statements are true regarding an Automatic Storage Management (ASM) instance?() (Choosetwo.)

A. As ASM instance mounts an ASM control file

B. An ASM instance uses the ASMB process for rebalancing of disks within a disk group

C. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitly

D. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started


参考答案:C, D

第2题:

You work as a database administrator at Certkiller .com. 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

第3题:

Examine the CREATE DISKGROUP command used to create a disk group:In which situation would you use this method of disk group creation?()

A. When two-way disk mirroring is required for the allocation units

B. When three-way disk mirroring is required for the allocation units

C. When using hardware mirroring or RAID

D. When disk mirroring is required for the Automatic Storage Management (ASM) disks


参考答案:C

第4题:

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

第5题:

Which two statements are true regarding an Automatic Storage Management (ASM) instance? ()

  • A、As ASM instance mounts an ASM control file
  • B、An ASM instance uses the ASMB process for rebalancing of disks within a disk group
  • C、Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitly
  • D、An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

正确答案:C,D

第6题:

Examine the CREATE DISKGROUP command used to create a disk group:SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCYDISK ‘ORCL: FRA3‘ NAME misc1, ‘ORCL: FRA4‘ NAME misc2;In which situation would you use this method of disk group creation?()

A. When two-way disk mirroring is required for the allocation units

B. When three-way disk mirroring is required for the allocation units

C. When using hardware mirroring or RAID

D. When disk mirroring is required for the Automatic Storage Management (ASM) disks


参考答案:C

第7题:

You are using an Automatic Storage Management (ASM) instance to manage the database files of your production database. After adding a new disk group to the ASM instance, you execute the following command:  ALTER DISKGROUP dg3 REBALANCE POWER 0; What would be the result of this command?()

  • A、The rebalancing of the disk group would be stopped.
  • B、The rebalancing of the disk group would be completed as fast as possible.
  • C、The command would result in an error because the value of POWER cannot be 0.
  • D、The rebalancing of the disk group would be completed without affecting the disk group DG3.
  • E、The command would result in an error because the disk groups cannot be manually rebalanced.

正确答案:A

第8题:

A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows:What happens when the whole CONTROLLER1 Failure group is damaged?()

A. The transactions that use the disk group will halt.

B. The mirroring of allocation units occurs within the CONTROLLER2 failure group.

C. The data in the CONTROLLER1 failure group is shifted to the CONTROLLER2 failure group and implicit rebalancing is triggered.

D. The ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the CONTROLLER2 failure group.


参考答案:C

第9题:

Which background process of a database instance,using Automatic Storage Management (ASM), connects as a foreground process into the ASM instance?()

  • A、 ASMB
  • B、 PMON
  • C、 RBAL
  • D、 SMON

正确答案:A

第10题:

You have an Automatic Storage Management (ASM) instance managing the database files of your production database. The database contains ASM files and non-ASM files. Using Recovery Manager (RMAN), you migrate the complete production database to use the ASM instance. Which statement is true? ()

  • A、 RMAN would relocate all the data files to an ASM disk group and other files to an operating system location, defined using Oracle Managed Files (OMF).
  • B、 RMAN would relocate the ASM files to an ASM disk group and the non-ASM files to an operating system location, defined using OMF
  • C、 RMAN would relocate all the database files to an ASM disk group.
  • D、 RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.

正确答案:C

更多相关问题