（532）As DBA for the Rebel Alliance you have decided that you need to facilitate some redundancy in your database.

Using ASM,you want to create a disk group that will provide for the greatest amount of redundancy for your ASM data

(you do not have advanced SAN mirroring technology available to you,unfortunately).

Which of the following commands would create a disk group that would offer the maximum in data redundancy?

A.

CREATE DISKGROUP dg_alliance1 NORMAL REDUNDANCY

failgroup diskcontrol1 DISK 'c:\oracle\asm_disk\_file_disk3' NAME file_diska1

failgroup diskcontrol2 DISK 'c:\oracle\asm_disk\_file_disk4' NAME file_diskb1;

B.

CREATE DISKGROUP dg_alliance1 EXTERNAL REDUNDANCY

failgroup diskcontrol1 DISK'c:\oracle\asm_disk\_file_disk3'NAME file_diska1;

C.

CREATE DISKGROUP dg_alliance1 HIGH REDUNDANCY

failgroup diskcontrol1 DISK 'c:\oracle\asm_disk\_file_disk1' NAME file_disk1

failgroup diskcontrol2 DISK 'c:\oracle\asm_disk\_file_disk2' NAME file_disk2

failgroup diskcontrol2 DISK 'c:\oracle\asm_disk\_file_disk3' NAME file_disk3;

D.

CREATE DISKGROUP dg_alliance1 MAXIMUM REDUNDANCY

failgroup diskcontrol1 DISK 'c:\oracle\asm_disk\_file_disk1' NAME file_disk1

failgroup diskcontrol2 DISK 'c:\oracle\asm_disk\_file_disk2' NAME file_disk2

failgroup diskcontrol2 DISK 'c:\oracle\asm_disk\_file_disk3' NAME file_disk3

failgroup diskcontrol2 DISK 'c:\oracle\asm_disk\_file_disk4' NAME file_disk4;

E.None of the above

答案：（C）

解析：

题目要求provide for the greatest amount of redundancy for your ASM data，即使用最高级别的冗余来创建磁盘组。

指定冗余度，有三个选择：

1. HIGH(高度冗余>三路)

2. NORMAL(标准冗余--双路)

3. XTERNAL(外部存储冗余)

ITPub博客

Oracle 11G OCP 1Z0-053 532