Oracle Database 11g: Administration II
Question No: 11 – (Topic 1)
In which situations will the ASM metadata backup help you recover the ASM disk in a disk group? (Choose all that apply.)
when one or more file directory paths are accidentally deleted from an ASM disk group
when one of the disks in a disk group is accidentally unplugged
when the data file on an ASM disk group gets corrupted
when one or more disks in an ASM disk group are lost
Question No: 12 – (Topic 1)
Which background process coordinates the rebalance activity for disk groups?
Answer: C Explanation: RBAL
ASM Rebalance Master Process Coordinates rebalance activity
In an ASM instance, it coordinates rebalance activity for disk groups. In a database instances, it manages ASM disk groups.
Question No: 13 – (Topic 1)
Which background process of a database instance, using Automatic Storage Management (ASM), connects as a foreground process into the ASM instance?
Answer: A Explanation:
ASMB (ASM Background Process): Communicates with the ASM instance, managing storage and providing statistics, runs in ASM instances when the ASMCMD cp command runs or when the database instance first starts if the server parameter file is stored in ASM. ASMB also runs with Oracle Cluster Registry on ASM.
RBAL (ASM Rebalance Master Process): In an ASM instance, it coordinates rebalance activity for disk groups. In a database instances, it manages ASM disk groups.
PMON (Process Monitor): Monitors the other background processes and performs process recovery when a server or dispatcher process terminates abnormally.
SMON (System Monitor Process): Performs critical tasks such as instance recovery and dead transaction recovery, and maintenance tasks such as temporary space reclamation, data dictionary cleanup, and undo tablespace management
Question No: 14 – (Topic 1)
Which two statements are true regarding the functionality of the remap command in ASMCMD? (Choose two.)
It repairs blocks that have read disk I/O errors.
It checks whether the alias metadata directory and the file directory are linked correctly.
It repairs blocks by always reading them from the mirror copy and writing them to the original location.
It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate location on disk if the blocks on the original location cannot be read properly.
Answer: A,D Explanation:
Reference from the Oracle document release v11.1 at here:
Repairs a range of physical blocks on a disk. The remap command only repairs blocks that have read disk I/O errors. It does not repair blocks that contain corrupted contents, whether or not those blocks can be read. The command assumes a physical block size of 512 bytes and supports all allocation unit sizes (1 to 64 MB).
Reference from the Oracle document release v11.2 at here:
The remap command marks a range of blocks as unusable on the disk and relocates any data allocated in that range.
Question No: 15 – (Topic 1)
What is the advantage of setting the ASM-preferred mirror read for the stretch cluster configuration?
It improves resync operations.
This feature enables much faster file opens.
It improves performance as fewer extent pointers are needed in the shared pool.
It improves performance by reading from a copy of an extent closest to the node.
Answer: D Explanation:
Preferred Read Failure Groups
When you configure Oracle ASM failure groups, it might be more efficient for a node to read from an extent that is closest to the node, even if that extent is a secondary extent. In other words, you can configure Oracle ASM to read from a secondary extent if that extent is closer to the node instead of Oracle ASM reading from the primary copy which might be farther from the node. Using the preferred read failure groups feature is most useful in extended clusters.
Question No: 16 – (Topic 1)
You are managing an Oracle 11g database with ASM storage, for which the COMPATIBLE initialization parameter is set to 11.1.0. In the ASM instance, the COMPATIBLE.RDBMS attribute for the disk group is set to 10.2 and the COMPATIBLE.ASM attribute is set to 11.1.
Which two statements are true in this scenario for the features enabled for ASM? (Choose two.)
The ASM-preferred mirror read feature is enabled.
The ASM supports variable sizes for extents of 1, 8, and 64 allocation units.
The ASM disk is dropped immediately from a disk group when it becomes unavailable.
The RDBMS always reads the primary copy of a mirrored extent of the ASM disk group.
Question No: 17 – (Topic 1)
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?
The client RDBMS instance can access the file as a read-only file.
A new disk cannot be added to a disk group.
A disk in a disk group can be taken offline.
The client RDBMS instance cannot access the files in the disk group.
Answer: D Explanation: MOUNT (link)
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.
Question No: 18 – (Topic 1)
Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.
Which tool or utility would you use to start the listener?
Oracle Net Manager
Listener Control utility
Database Configuration Assistant
Oracle Net Configuration Assistant
Question No: 19 – (Topic 1)
What is the result of increasing the value of the parameter ASM_POWER_LIMIT during a rebalance operation?
The ASM rebalance operation will likely consume fewer resources and complete in a shorter amount of time.
The ASM rebalance operation will consume fewer resources and complete in a longer amount of time.
The ASM rebalance operation will be parallelized and should complete in a shorter amount of time.
There is no ASM_POWER_LIMIT setting used in ASM.
None of the above
Question No: 20 – (Topic 1)
When an ASM instance receives a SHUTDOWN NORMAL command, what command does it pass on to all database instances that rely on the ASM instances disk groups?
|Lowest Price Guarantee||Yes||No||No|
|Free VCE Simulator||Yes||No||No|