QUESTION NO: 36
You issued the following command to mount the DATA disk group in restricted mode:
ALTER DISKGROUP data MOUNT RESTRICT;
What is the implication of this command?
A. The client RDBMS instance can access the file as a read-only file.
B. A new disk cannot be added to a disk group.
C. A disk in a disk group can be taken offline.
D. The client RDBMS instance cannot access the files in the disk group.
Answer: D
Explanation:

diskgroup_availability

Use this clause to make one or more disk groups available or unavailable to the database instances running on the same node as the Oracle ASM instance. This clause does not affect the status of the disk group on other nodes in a cluster.

MOUNT 

Specify MOUNT to mount the disk groups in the local Oracle ASM instance. Specify ALL MOUNT to mount all disk groups specified in the ASM_DISKGROUPS initialization parameter. File operations can only be performed when a disk group is mounted. If Oracle ASM is running in a cluster or a standalone server managed by Oracle Restart, then the MOUNT clause automatically brings the corresponding resource online.

RESTRICTED | NORMAL Use these clauses to determine the manner in which the disk groups are mounted.

·         In the RESTRICTED mode, the disk group is mounted in single-instance exclusive mode. No other Oracle ASM instance in the same cluster can mount that disk group. In this mode the disk group is not usable by any Oracle ASM client.

·         In the NORMAL mode, the disk group is mounted in shared mode, so that other Oracle ASM instances and clients can access the disk group. This is the default.