1Z0-068 · Question #53
Examine this command: SQL> CREATE DISKROUP data NORMAL REDANDUNCY: FAILGROUP fgrpl DISK /dev/disk1' NAME disk1, /dev/disk2' NAME disk2, /dev/disk3' NAME disk3, FAILGROUP fgrpl2 DISK /dev/disk4' NAME…
The correct answer is B. File created in this disk group always has two copies for each allocation unit: one primary and C. It can contain ASM Dynamic Volume Manager (ADVM) volumes. C is incorrect because compatible.advm should be >= 11.2 https://docs.oracle.com/database/121/SQLRF/statements_5009.htm#SQLRF01114
Question
Examine this command:
SQL> CREATE DISKROUP data NORMAL REDANDUNCY:
FAILGROUP fgrpl DISK /dev/disk1' NAME disk1, /dev/disk2' NAME disk2, /dev/disk3' NAME disk3, FAILGROUP fgrpl2 DISK /dev/disk4' NAME disk4, /dev/disk5' NAME disk5, /dev/disk6' NAME disk6, FAILGROUP fgrpl3 DISK /dev/disk7' NAME disk7, /dev/disk8' NAME disk8, /dev/disk9' NAME disk9, ATTRIBUTE au_size'='4M', compatible.asm' = '11.12', compatible.rdbms' = '11.12', compatible.advm' = '11.12', content_type' = `recovery'; Which two statements a true about this disk group, created using Grid Infrastructure 12.1?
Options
- AEach disk in each of the three fail groups is a mirror of the corresponding disk of the other two
- BFile created in this disk group always has two copies for each allocation unit: one primary and
- CIt can contain ASM Dynamic Volume Manager (ADVM) volumes.
- DAny database instance with the COMPATIBLE parameter set to 11.2 or higher can access it.
- EThe ASM compatible attributes can be changed to 11.1 for this disk group.
How the community answered
(30 responses)- A7% (2)
- B77% (23)
- D13% (4)
- E3% (1)
Explanation
C is incorrect because compatible.advm should be >= 11.2 https://docs.oracle.com/database/121/SQLRF/statements_5009.htm#SQLRF01114
Topics
Community Discussion
No community discussion yet for this question.