Exam 1z0-060 topic 1 question 144 discussion

Actual exam question from Oracle's 1z0-060

Question #: 144
Topic #: 1

A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL:

There is enough free space in the disk group for mirroring to be done.
What happens if the CONTROLLER1 failure group becomes unavailable due to error or for maintenance?

A. Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.
B. Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.
C. The data in the CONTROLLER1 failure group is copied to the CONTROLLER2 failure group and rebalancing is initiated.
D. ASM does not mirror any data until the CONTROLLER1 failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the failure group, without mirroring.

Show Suggested Answer

Suggested Answer: D 🗳️

by Blade69 at Dec. 28, 2021, 10:37 p.m.

Comments

Submit Cancel

Nilendu

3 years ago

Selected Answer: B

Correct Answer: B There is mirroring in ASM which facilitates no data loss scenario in Normal redundancy. If one Fail group is lost ASM uses the second one if available.

upvoted 1 times

...

Blade69

3 years, 5 months ago

Correct Answer B: Explanation: CREATE DISKGROUP NORMAL REDUNDANCY * For Oracle ASM to mirror files, specify the redundancy level as NORMAL REDUNDANCY (2-way mirroring by default for most file types) or HIGH REDUNDANCY (3-way mirroring for all files).

upvoted 1 times

...