Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 651:

  You are managing Oracle Database 11g with an ASM storage with high redundancy. The following command was issued to drop the disks from the dga disk group after five hours: ALTER DISKGROUP dga OFFLINE DISKS IN FAILGROUP f2 DROP AFTER 5H;

  Which statement is true in this scenario?

  A. It starts the ASM fast mirror resync.

  B. All the disks in the dga disk group would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.

  C. It drops all disk paths from the dga disk group.

  D. All the disks in the dga disk group in failure group f2 would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.

  Correct Answer: D

• Question 652:

  You are managing an Oracle Database 11g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage.

  Which statement regarding the ASM disk group compatibility attributes are true in this scenario? (Choose all that apply.)

  A. The database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances.

  B. RDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group.

  C. The RDBMS compatibility settings for a disk group control the format of data structures for ASM metadata on the disk.

  D. ASM compatibility controls which features for the ASM will be enabled.

  Correct Answer: ABD

• Question 653:

  Which two are the uses of the ASM metadata backup and restore (AMBR) feature? (Choose two.)

  A. It can be used to back up all data on ASM disks.

  B. It can be used to recover the damaged ASM disk group along with the data.

  C. It can be used to gather information about a pre-existing ASM disk group with disk paths, disk name, failure groups, attributes, templates, and alias directory structure.

  D. It can be used to re-create the ASM disk group with its attributes.

  Correct Answer: CD

• Question 654:

  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.

  Correct Answer: CD

• Question 655:

  You are managing an Oracle Database 11g instance with ASM storage. You lost an ASM disk group DATA. You have RMAN backup of data as well as ASM metadata backup. You want to re- create the missing disk group by using the ASMCMD md_restore command.

  Which of these methods would you use to achieve this? (Choose all that apply.)

  A. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, failure group configurations, and data on the disk group.

  B. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, and failure group configurations.

  C. Restore the disk group with changed disk group specification, failure group specification, disk group name, and other disk attributes.

  D. Restore metadata in an existing disk group by passing the existing disk group name as an input parameter.

  Correct Answer: BCD

  Purpose

  The md_restore command restores disk groups from a metadata backup file.

  Syntax and Description

  md_restore backup_file [--silent]

  [--full|--nodg|--newdg -o 'old_diskgroup:new_diskgroup [,...]'] [-S sql_script_file] [-G 'diskgroup

  [,diskgroup...]'] backup_file

  Reads the metadata information from backup_file.

  --silent

  Ignore errors. Typically, if md_restore encounters an error, it stops. Specifying this flag ignores any errors.

  --full

  Specifies to create a disk group and restore metadata.

  --nodg

  Specifies to restore metadata only.

  --newdg -o old_diskgroup:new_diskgroup]

  Specifies to create a disk group with a different name when restoring metadata. The -o option is required

  with

  --newdg.

  -S sql_script_file

  Write SQL commands to the specified SQL script file instead of executing the commands.

  -G diskgroup

  Select the disk groups to be restored. If no disk groups are defined, then all disk groups are restored.

• Question 656:

  You are managing an Oracle Database 11g ASM instance having three disks in a disk group with ASM compatibility attribute set to 11.1.0 and redundancy set to high. One of the disks in the disk group becomes unavailable because of power failure.

  Which statements will be true in this scenario? (Choose all that apply.)

  A. The disk is immediately dropped from the disk group.

  B. The ASM tracks the extents that are modified during the outage.

  C. The ASM migrates the extents from the unavailable disk to the remaining disks.

  D. The disk automatically goes offline.

  Correct Answer: BD

• Question 657:

  Which of the following ALTER DISKGROUP commands does not use V$ASM_OPERATION to record the status of the operation?

  A. ADD DIRECTORY

  B. DROP DISK

  C. RESIZE DISK

  D. REBALANCE

  E. ADD FAILGROUP

  Correct Answer: A

• Question 658:

  How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has already completed?

  A. Issue the ALTER DISKGROUP ... ADD DISK command.

  B. Issue the ALTER DISKGROUP ... UNDROP DISKS command.

  C. Issue the ALTER DISKGROUP ... DROP DISK CANCEL command.

  D. Retrieve the disk from the Recycle Bin after the operation completes.

  Correct Answer: A

  You cannot UNDROP DISKS if the DROP DISK command has already completed.

• Question 659:

  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

  Correct Answer: A

• Question 660:

  On the development database rac0, there are six raw devices: /dev/raw/raw1 through /dev/raw/raw6. /dev/raw/raw1 and /dev/raw/raw2 are 8GB each, and the rest are 6GB each. An existing disk group +DATA1, of NORMAL REDUNDANCY, uses /dev/raw/raw1 and /dev/raw/raw2.

  Which series of the following commands will drop one of the failure groups for +DATA1, create a new disk group +DATA2 using two of the remaining four raw devices, and then cancel the drop operation from +DATA1?

  

  A. B. C. D.

  Correct Answer: A