1z0-053: Oracle Database 11g: Administration II - Free download from Exam Files

A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows:

SQL> CREATE DISKGROUP dgroup1 NORMAL REDUNDANCY

FAILGROUP controller1 DISK '/devices/diska1', '/devices/diska2'

FAILGROUP controller2 DISK '/devices/diskb1', '/devices/diskb2';

What happens when the whole CONTROLLER1 Failure group is damaged?

The transactions that use the disk group will halt.
The mirroring of allocation units occurs within the CONTROLLER2 failure group.
The data in the CONTROLLER1 failure group is shifted to the CONTROLLER2 failure group and implicit rebalancing is triggered.
The ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the CONTROLLER2 failure group.

Correct answer: C

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

Correct answer: B

What are three benefits of using ASM? (Choose three.)

Ease of disk administration and maintenance
Load balancing across physical disks
Software RAID-1 data redundancy with double or triple mirrors
Automatic recovery of failed disks

Correct answer: ABC

What components are present in an ASM instance? (Choose three.)

SGA
Database processes
Database datafiles
Control files
Database parameter file or SPFILE

Correct answer: ABE

Which of the following is a benefit of ASM fast disk resync?

Failed disks are taken offline immediately but are not dropped.
Disk data is never lost.
By default, the failed disk is not dropped from the disk group ever, protecting you from loss of that disk.
The failed disk is automatically reformatted and then resynchronized to speed up the recovery process.
Hot spare disks are automatically configured and added to the disk group.

Correct answer: A

Explanation:

ASM Fast Mirror Resync

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

Correct answer: C

What is the default AU size of an ASM disk group? What is the maximum AU size in an ASM disk group?

100KB default, 10TB maximum
256KB default, 1024MB maximum
10MB default, 126PB maximum
64KB default, 1EB maximum
1MB default, 64MB maximum

Correct answer: E

Explanation:

The AU size is determined at creation time with the allocation unit size (AU_SIZE) disk group attribute. The values can be 1, 2, 4, 8, 16, 32, and 64 MB.

Which initialization parameter in an ASM instance specifies the disk groups to be automatically mounted at instance startup?

ASM_DISKMOUNT
ASM_DISKGROUP
ASM_DISKSTRING
ASM_MOUNTGROUP

Correct answer: B

Explanation:

When you run the STARTUP command, this command attempts to mount the disk groups specified by the initialization parameter ASM_DISKGROUPS. If you have not entered a value for ASM_DISKGROUPS, then the ASM instance starts and Oracle displays an error that no disk groups were mounted. You can then mount disk groups with the ALTER DISKGROUP...MOUNT command.

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?

TRANSACTIONAL
IMMEDIATE
ABORT
NORMAL

Correct answer: A

When starting up your ASM instance, you receive the following error:

SQL> startup pfile=$ORACLE_HOME/dbs/init+ASM.ora

ASM instance started

Total System Global Area 104611840 bytes

Fixed Size 1298220 bytes

Variable Size 78147796 bytes

ASM Cache 25165824 bytes

ORA-15032: not all alternations performed

ORA-15063: ASM discovered an insufficient number of disks for diskgroup “DGROUP3”

ORA-15063: ASM discovered an insufficient number of disks for diskgroup “DGROUP2”

ORA-15063: ASM discovered an insufficient number of disks for diskgroup “DGROUP1”

In trying to determine the cause of the problem, you issue this query:

SQL> show parameter asm

What is the cause of the error?

The ASM_DISKGROUPS parameter is configured for three disk groups: DGROUP1, DGROUP2, and DGROUP3.The underlying disks for these disk groups have apparently been lost.
The format of the ASM_DISKGROUPS parameter is incorrect. It should reference the disk group numbers, not the names of the disk groups
The ASM_POWER_LIMIT parameter is incorrectly set to 1. It should be set to the number of disk groups being attached to the ASM instance.
The ASM_DISKSTRING parameter is not set; therefore disk discovery is not possible.
There is insufficient information to solve this problem.

Correct answer: D

Explanation:

ASM_DISKSTRING specifies an operating system-dependent value used by Automatic Storage Management to limit the set of disks considered for discovery. When a new disk is added to a disk group, each Automatic Storage Management instance that has the disk group mounted must be able to discover the new disk using the value of ASM_DISKSTRING. In most cases, the default value will be sufficient. Using a more restrictive value may reduce the time required for Automatic Storage Management to perform discovery, and thus improve disk group mount time or the time for adding a disk to a disk group. A "?" at the beginning of the string gets expanded to the Oracle home directory. Depending on the operating system, wildcard characters can be used. It may be necessary to dynamically change ASM_DISKSTRING before adding a disk so that the new disk will be discovered. An attempt to dynamically modify ASM_DISKSTRING will be rejected and the old value retained if the new value cannot be used to discover a disk that is in a disk group that is already mounted.

ASM_DISKSTRING specifies an operating system-dependent value used by Automatic Storage Management to limit the set of disks considered for discovery. When a new disk is added to a disk group, each Automatic Storage Management instance that has the disk group mounted must be able to discover the new disk using the value of ASM_DISKSTRING.

In most cases, the default value will be sufficient. Using a more restrictive value may reduce the time required for Automatic Storage Management to perform discovery, and thus improve disk group mount time or the time for adding a disk to a disk group. A "?" at the beginning of the string gets expanded to the Oracle home directory. Depending on the operating system, wildcard characters can be used. It may be necessary to dynamically change ASM_DISKSTRING before adding a disk so that the new disk will be discovered.

An attempt to dynamically modify ASM_DISKSTRING will be rejected and the old value retained if the new value cannot be used to discover a disk that is in a disk group that is already mounted.