Limited Time Discount Offer 30% Off - Ends in 02:00:00


Oracle 1z0-053 Exam - Oracle Database 11g: Administration II

Download Free Oracle 1z0-053 Exam Questions

Questions & Answers for Oracle 1z0-053

Showing 1-15 of 698 Questions

Question #1 - Topic 1

As DBA for the Rebalance, you have decided that you need to facilitate some redundancy
in your database. Using ASM, you want to create a disk group that will provide for the
greatest amount of redundancy for your ASM data (you do not have advanced SAN
mirroring technology available to you, unfortunately).
Which of the following commands would create a disk group that would offer the maximum
in data redundancy?

A. Option A

B. Option B

C. Option C

D. Option D

E. Option E

No SAN mirroring available means no external redundancy available.
The highest redundancy of ASM is the HIGH redundancy with 3 mirror copies.

Question #2 - Topic 1

Which background process coordinates the rebalance activity for disk groups?





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 #3 - Topic 1

What is the proper command to shut down the database in a consistent manner?

A. shutdown abort

B. shutdown kill

C. shutdown nowait

D. shutdown immediate

E. shutdown halt

Question #4 - Topic 1

You are maintaining the SALES database. You have added a new disk to a disk group.
Automatic Storage Management performs the rebalancing activity. You want to speed up
the rebalancing activity.
Which parameter should you specify to control the speed of the rebalancing activity?





Question #5 - Topic 1

After executing the command
You issue the following command from the ASM instance:
SELECT group_number, COUNT(*) FROM v$asm_operation;
What is the implication if the query against V$ASM_OPERATION returns zero rows?

A. The drop disk operation is still proceeding and you cannot yet run the undrop disks operation.

B. The drop disk operation is complete and you can run the undrop disks command if needed.

C. The drop disk operation is complete and you cannot run the undrop disks command.

D. The query will fail since there is not a V$ASM_OPERATION view available in an ASM instance.

E. None of the above is true.

Once the DROP DISK operation is completed, you CANNOT run the UNDROP DISKS
command any more.

Question #6 - Topic 1

Examine the following command:
In which scenario can you use the above command to mount the disk group?

A. when ASM disk goes offline

B. when one or more ASM files are dropped

C. when some disks in a disk group are offline

D. when some disks in a failure group for a disk group are rebalancing

In the FORCE mode, Oracle ASM attempts to mount the disk group even if it cannot
discover all of the devices that belong to the disk group. This setting is useful if some of the
disks in a normal or high redundancy disk group became unavailable while the disk group
was dismounted. When MOUNT FORCE succeeds, Oracle
ASM takes the missing disks offline.
If Oracle ASM discovers all of the disks in the disk group, then MOUNT FORCE fails.
Therefore, use the MOUNT FORCE setting only if some disks are unavailable. Otherwise,
In normal- and high-redundancy disk groups, disks from one failure group can be
unavailable and MOUNT FORCE will succeed. Also in high-redundancy disk groups, two
disks in two different failure groups can be unavailable and MOUNT FORCE will succeed.
Any other combination of unavailable disks causes the operation to fail, because Oracle
ASM cannot guarantee that a valid copy of all user data or metadata exists on the available
Refer to here

Question #7 - Topic 1

You are managing an Oracle Database 11g ASM instance with a disk group dg01 having
three disks. One of the disks in the disk group becomes unavailable because of power
failure. You issued the following command to change the DISK_REPAIR_TIME attribute
from 3.6 hours to 5 hours:
ALTER DISKGROUP dg01 SET ATTRIBUTE 'disk_repair_time' = '5h';
To which disks in the disk group will the new value be applicable?

A. all disks in the disk group

B. all disks that are currently in OFFLINE mode

C. all disks that are not currently in OFFLINE mode

D. all disks in the disk group only if all of them are ONLINE

Check out the answer options, it is tricky. The NOT OFFLINE disks equals ONLINE disks.
Refer to Set the DISK_REPAIR_TIME Disk Group Attribute Appropriately.
The DISK_REPAIR_TIME disk group attribute specifies how long a disk remains offline
before Oracle ASM drops the disk. If a disk is made available before the
DISK_REPAIR_TIME parameter has expired, the storage administrator can issue the
ONLINE DISK command and Oracle ASM resynchronizes the stale data from the mirror
side. In Oracle Database 11g, the online disk operation does not restart if there is a failure
of the instance on which the disk is running. You must reissue the command manually to
bring the disk online.

Question #8 - Topic 1

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





Refer to here
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

Question #9 - Topic 1

What is the result of increasing the value of the parameter ASM_POWER_LIMIT during a
rebalance operation?

A. The ASM rebalance operation will likely consume fewer resources and complete in a shorter amount of time.

B. The ASM rebalance operation will consume fewer resources and complete in a longer amount of time.

C. The ASM rebalance operation will be parallelized and should complete in a shorter amount of time.

D. There is no ASM_POWER_LIMIT setting used in ASM.

E. None of the above

Question #10 - Topic 1

If you use ALTER DISKGROUP ... ADD DISK and specify a wildcard for the discovery
string, what happens to disks that are already a part of the same or another disk group?

A. The command fails unless you specify the FORCE option.

B. The command fails unless you specify the REUSE option.

C. The command must be reissued with a more specific discovery string.

D. The other disks, already part of the disk group, are ignored.

Refer to an Oracle Example for adding disk to diskgroup (link)
How A Disk is Discovered
While an ASM instance is initialized, ASM discovers and examines the contents of all of the
disks that are in the paths that you designated with values in the ASM_DISKSTRING
initialization parameter. Disk discovery also occurs when you:
DISK commands
✑ Query the V$ASM_DISKGROUP and V$ASM_DISK views
Disk Discovery Rules(link)
The rules for discovering ASM disks are as follows:
✑ ASM can discover up to 10,000 disks. That is, if more than 10,000 disks match the
ASM_DISKSTRING initialization parameter, then ASM discovers only the first
✑ ASM only discovers disks that contain a partition table.
ASM does not discover a disk that contains an operating system partition table, even if the
disk is in an ASM disk string search path and ASM has read and write permission for the
✑ When adding a disk, the FORCE option must be used if ASM recognizes that the
disk was managed by Oracle. Such a disk appears in the V$ASM_DISK view with
a status of FOREIGN. In this case, you can only add the disk to a disk group by
using the FORCE keyword.
In addition, ASM identifies the following configuration errors during discovery:
✑ Multiple paths to the same disk
In this case, if the disk is part of a disk group, then disk group mount fails. If the disk is
being added to a disk group with the ADD DISK or CREATE DISKGROUP command, then
the command fails. To correct the error, adjust the ASM_DISKSTRING value so that ASM
will not discover multiple paths to the same disk. Or if you are using multipathing software,
then ensure that you include only the pseudo-device name in the ASM_DISKSTRING
value. See "ASM and Multipathing".
✑ Multiple ASM disks with the same disk header
This can be caused by having copied one disk onto another. In this case, the disk group
mount operation fails.

Question #11 - Topic 1

View Exhibit1 to examine the CRS11G disk group when all the disks are online.
View Exhibit2 to examine the CRS11G disk group when one disk is offline.
Why is the rebalancing not performed and the content of the disk group not empty in
ASM-disk-group-1 (exhibit):

ASM-disk-group-2 (exhibit):

A. Because the disk group is created with NORMAL redundancy

B. Because the disk repair time attribute is set to a nonzero value

C. Because the mirrored extents cannot be rebalanced across the other three disks

D. Because the other three disks have 60% free space, the disk rebalancing is delayed

Key points:
2. The DISK_REPAIR_TIME is set to non-zero. by default it is 3.6hr.
Refer to here.
Note: To use this feature, the disk group compatibility attributes must be set to 11.1 or
higher. For more information, refer to "Disk Group Compatibility".
Oracle ASM fast resync keeps track of pending changes to extents on an OFFLINE disk
during an outage. The extents are resynced when the disk is brought back online.
By default, Oracle ASM drops a disk in 3.6 hours after it is taken offline. You can set the
DISK_REPAIR_TIME disk group attribute to delay the drop operation by specifying a time
interval to repair the disk and bring it back online.

Question #12 - Topic 1

Which background process of a database instance, using Automatic Storage Management
(ASM), connects as a foreground process into the ASM instance?





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 #13 - Topic 1

You are managing an Oracle Database 11g database with ASM storage. The ASM disk
group has the COMPATIBLE.ASM attribute set to 11.1.
Which statements are true regarding extent management and allocation units in the ASM
disk group? (Choose all that apply.)

A. The au_size disk group attribute determines the size of allocation units in the disk group.

B. The allocation unit size may vary but the extent size is fixed.

C. The allocation unit size and extent size are fixed for all the disks in a disk group and cannot be changed.

D. Extent management is completely automated.

Question #14 - Topic 1

Which type of database file is spread across all disks in a disk group?

A. All types of files are spread across all disks in the disk group.

B. Datafiles

C. Redo log files

D. Archived redo log files

E. Control files

Question #15 - Topic 1

What are the advantages of variable extent size support for large ASM files? (Choose two.)

A. It improves resync operations when the disk comes online after being taken offline for maintenance purposes.

B. It improves performance in the extended cluster configuration by reading from a local copy of an extent.

C. Fewer extent pointers are needed to describe the file and less memory is required to manage the extent maps in the shared pool.

D. This feature enables faster file opens because of the reduction in the amount of memory that is required to store file extents.


Exam-Labs Special Discount
You save

Enter Your Email Address to Receive Your 30% Discount Code


Exam-Labs Special Discount
You save

Use Discount Code:

A confirmation link was sent to your e-mail.

Please check your mailbox for a message from [email protected]com and follow the directions.

Download Free Demo of VCE Exam Simulator

Experience Avanset VCE Exam Simulator for yourself.

Simply submit your e-mail address below to get started with our interactive software demo of your free trial.

  • Realistic exam simulation and exam editor with preview functions
  • Whole exam in a single file with several different question types
  • Customizable exam-taking mode & detailed score reports