Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Oracle 1z0-053

Oracle 1z0-053 Exam Practice Questions (P. 5)

  • Full Access (706 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #41
Which of the following ALTER DISKGROUP commands does not use V$ASM_OPERATION to record the status of the operation?
  1. A
    ADD DIRECTORY
  2. B
    DROP DISK
  3. C
    RESIZE DISK
  4. D
    REBALANCE
  5. E
    ADD FAILGROUP

Correct Answer:
A

Question #42
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.)
  1. A
    The disk is immediately dropped from the disk group.
  2. B
    The ASM tracks the extents that are modified during the outage.
  3. C
    The ASM migrates the extents from the unavailable disk to the remaining disks.
  4. D
    The disk automatically goes offline.

Correct Answer:
BD

Question #43
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.)
  1. 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.
  2. 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.
  3. C
    Restore the disk group with changed disk group specification, failure group specification, disk group name, and other disk attributes.
  4. 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 #44
What are the advantages of variable extent size support for large ASM files? (Choose two.)
  1. A
    It improves resync operations when the disk comes online after being taken offline for maintenance purposes.
  2. B
    It improves performance in the extended cluster configuration by reading from a local copy of an extent.
  3. C
    Fewer extent pointers are needed to describe the file and less memory is required to manage the extent maps in the shared pool.
  4. 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 #45
Which two are the uses of the ASM metadata backup and restore (AMBR) feature? (Choose two.)
  1. A
    It can be used to back up all data on ASM disks.
  2. B
    It can be used to recover the damaged ASM disk group along with the data.
  3. 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.
  4. D
    It can be used to re-create the ASM disk group with its attributes.

Correct Answer:
CD

Question #46
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.)
  1. 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.
  2. B
    RDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group.
  3. C
    The RDBMS compatibility settings for a disk group control the format of data structures for ASM metadata on the disk.
  4. D
    ASM compatibility controls which features for the ASM will be enabled.

Correct Answer:
ABD

Question #47
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?
  1. A
    It starts the ASM fast mirror resync.
  2. 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.
  3. C
    It drops all disk paths from the dga disk group.
  4. 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 #48
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.)
  1. A
    The au_size disk group attribute determines the size of allocation units in the disk group.
  2. B
    The allocation unit size may vary but the extent size is fixed.
  3. C
    The allocation unit size and extent size are fixed for all the disks in a disk group and cannot be changed.
  4. D
    Extent management is completely automated.

Correct Answer:
AD

Question #49
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?
  1. A
    The client RDBMS instance can access the file as a read-only file.
  2. B
    A new disk cannot be added to a disk group.
  3. C
    A disk in a disk group can be taken offline.
  4. D
    The client RDBMS instance cannot access the files in the disk group.

Correct Answer:
D
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 #50
In which situations will the ASM metadata backup help you recover the ASM disk in a disk group? (Choose all that apply.)
  1. A
    when one or more file directory paths are accidentally deleted from an ASM disk group
  2. B
    when one of the disks in a disk group is accidentally unplugged
  3. C
    when the data file on an ASM disk group gets corrupted
  4. D
    when one or more disks in an ASM disk group are lost

Correct Answer:
AD

Previous Questions Next Questions

All Pages