Online Access Free 1Z0-058 Exam Questions

Examine the following details for a six-Instance RAC database: What is the most prominent problem indicated by the above output?

• A.high input/output (I/O) delays
• B.misconfigured or faulty interconnect
• C.CPU saturation and memory depletion
• D.large number of untuned queries from one of the nodes

You are managing a three-instance Oracle RAC database which uses a Cluster File System for shared storage.
Which two options can you use to ensure that the redo logs from all the instances are available during RMAN recovery from any instance?

• A.Set the LOG_ARCHIVE_DEST_1 parameter to a single location on the Cluster File System for each of the three instances and leave the LOG_ARCHIVE_FORMAT parameter with the default value.
• B.Set the LOG_ARCHIVE_DEST_1 parameter to a single location on the Cluster File System for each of the three instances, and the LOG_ARCHIVE_FORMAT parameter for each instance, to the same format including the thread number.
• C.Set the LOG_ARCHIVE_DEST_1 parameter to a single location on the Cluster File System, and set LOG_ARCHIVE_FORMAT parameter on only one instance.
• D.Set only the LOG_ARCHIVE_DEST_1 parameter to a single location on the Cluster File System for any one of the three instances and leave the LOG_ARCHIVE_FORMAT parameter with the default value.

How does the Oracle Grid Infrastructure administrator determine the location of the Oracle Clusterware voting disk?

• A.Run crsctl query css votedisk from any node.
• B.Run cat /etc/oracle/vote.loc from any node.
• C.Run select name, path from v$votedisk from any RAC database instance of any database on the cluster.
• D.Run srvctl query css votedisk from any node.

An ASM diskgroup that contains database tablespaces with six disks and normal redundancy is nearing 90% capacity. You want to add additional capacity to the diskgroup. A set of six additional disks has been made available, and appears as CANDIDATE disks in the V$ASM_DISK view.
What steps are required to increase the diskgroup capacity?

• A.Set the rebalance power limit (or allow it to default).
  Add the disks to the diskgroup.
• B.Shut down the database instances using the diskgroup.
  Add the disks to the diskgroup.
  Start the database instances using the diskgroup.
• C.Shut down all database instances and ASM instances.
  Back up the ASM diskgroup.
  Start the ASM instances.
  Add the disks to the diskgroup.
  Issue a rebalance command.
  Start the database instances.
• D.Export the database objects.
  Drop the diskgroup.
  Create a new diskgroup.
  Import the database objects.

Choose four tools that can be used to create ASM disk groups.

• A.ASMCA
• B.SRVCTL
• C.ASMCMD
• D.Enterprise Manager
• E.SQL*Plus
• F.CRSCTL