Oracle 1Z0-053 real exam prep : Oracle Database 11g: Administration II

You are managing an Oracle Database 11g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group , you issued the following ASMCMD command:
ASMCMD> lsdsk -I -d DATA
Which statement is true regarding the outcome of this command?

• A. The command succeeds and retrieves information by scanning the disk headers based on an ASM_DISKSTRING value.
• B. The command produces an error because the ASM instance is down.
• C. The command succeeds but it retrieves only the disk names.
• D. The command succeeds but it shows only the status of the ASM instance.

You executed the following PL/SQL block successfully: The above command produces Automatic Database Diagnostic Monitor (ADDM) analysis ____.

• A. with the CPU Usage finding for snapshots not between 150 and 162
• B. with the CPU Usage finding for snapshots below 90
• C. with the CPU Usage finding if it is less than 90
• D. without the CPU Usage finding if it is less than 90

Using the LIST command in Recovery Manager (RMAN), which two pieces of information in the RMAN repository can be listed? (Choose two.)

• A. stored scripts in the recovery catalog
• B. backups that do not have the AVAILABLE status in the RMAN repository
• C. backups that can be deleted from disk
• D. backup sets and image copies are obsolete

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

• A. It can be used to re-create the ASM disk group with its attributes.
• B. It can be used to back up all data on ASM disks.
• C. It can be used to recover the damaged ASM disk group along with the data.
• D. 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.

The following databases are registered in the base recovery catalog: PROD1, PROD2, and PROD3.The database user CATOWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1 database and create a virtual private catalog.
The RVPC user can do which of the following? (Choose all that apply.)

• A. Not be connected to with the RMAN command-line catalog parameter for backup or recovery purposes
• B. See all database-related metadata in the recovery catalog if they are granted access to that database
• C. Unregister databases from the RVPC catalog that were not granted to the RVPC catalog owner with the grant command
• D. See all databases in the recovery-catalog schema
• E. Register databases if granted the register database privilege