You are managing an Oracle Database 11g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statement regarding the ASM disk group compatibility attributes are true in this scenario？（）

A

 The database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances.

B

 RDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group.

C

 The RDBMS compatibility settings for a disk group control the format of data structures for ASM metadata on the disk.

D

 ASM compatibility controls which features for the ASM will be enabled.

相关问题推荐

• You want to migrate your database to ASM， so you have done a clean shutdown， made a closed backup of the entire You wa database， noted the location of your control files and online redo log files， and changed your spfile to use OMF. The last step is to run an RMAN script to do the conversion.  Using the following steps，what is the correct order in which the following RMAN commands should be executed？（）   1. STARTUP NOMOUNT  2. ALTER DATABASE OPEN RESETLOGS  3. SQL "ALTER DATABASE RENAME ，，logfile1 path TO ，，+dgrp4 ，，" # plus all other logfiles  4. SWITCH DATABASE TO COPY  5. BACKUP AS COPY DATABASE FORMAT ，，+dgrp4 6. ALTER DATABASE MOUNT  7. RESTORE CONTROLFILE FROM ，，controlfile_location

  A、 2， 5， 3， 1， 7， 6， 4

  B、 1， 7， 6， 5， 4， 3， 2

  C、 5， 1， 2， 7， 4， 6， 3

  D、 7， 3， 1， 5， 6， 2， 4

  查看答案

• You are maintaining the SALES database. You have added a new disk to a disk group. Automatic StorageManagement 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

  查看答案

• Your production database is running in archivelog mode and you are using recovery manager （RMAN） with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday， the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted.   The steps to recover the damaged data files are follows：   1. Mount the database  2. Open the database  3. Recover the data file  4. Restore the data file  5. Make the data file offline  6. Make the data file online   Which option identifies the correct sequence that you must use to recover the data files？（）

  A、 2，4，3

  B、 1，4，3，2

  C、 2，5，4，3，6

  D、 5，2，4，3，6

  E、 1，5，4，3，6，2

  查看答案

• 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.

  查看答案

• Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?（） (Choose three.)

  A

  Alert log file

  B

  Archived redo log files

  C

  Control file autobackups

  D

  Server Parameter file (SPFILE)

  E

  Recovery Manager (RMAN) backup piece

  查看答案