Oracle 1Z0-058 Online Practice Questions and Exam Preparation

Oracle 1Z0-058 Online Questions & Answers

• Question 11:

  You have two administrator-defined server pools on your eight-node cluster called OLTP and DSS.

  Hosts RACNODE3, RACNODE4, and RACNODE5 are currently assigned to the DSS Pool. Hosts RACNODE6, RACNODE7, and RACNODE8 are assigned to the OLTP Pool. Hosts RACNODE1 and RACNODE2 are assigned to the Generic

  pool.

  You are patching the Oracle Grid Infrastructure in a rolling fashion for your cluster and you have completed patching nodes RACNODE3, RACNODE4, RACNODE5, and RACNODE6, but you have not patched nodes RACNODE1 and

  RACNODE2.

  While examining the status of RACNODE2 software, you get this output:

  $ crsctl query crs softwareversion

  Oracle Cluster-ware version on node [RACNODE2] is [11.2.0.2.0] $ crsctl query crs activeversion Oracle Clusterware active version on node [RACNODE2] is [11.2.0.1.0]

  Which two statements describe the reasons for the active versions on the nodes of the cluster?

  A. The active version is 11.2.0.2.0 on RACNODE3, RACNODE4, and RACNODE5 because all the nodes in the DSS server pool have the same installed version.
  B. The active version is 11.2.0.1.0 on RACNODE6, RACNODE7, and RACNODE8 because some nodes in the cluster still have version 11.2.0.1.0 installed.
  C. The active version is 11.2.0.1.0 on RACNODE6, RACNODE7, and RACNODE8 because some nodes in the OLTP Pool still have version 11.2.0.1.0 installed.
  D. The active version is 11.2.0.1.0 on RACNODE3, RACNODE4, and RACNODE5 because some nodes in the cluster still have version 11.2.0.1.0 installed.
  B. The active version is 11.2.0.1.0 on RACNODE6, RACNODE7, and RACNODE8 because some nodes in the cluster still have version 11.2.0.1.0 installed.
  D. The active version is 11.2.0.1.0 on RACNODE3, RACNODE4, and RACNODE5 because some nodes in the cluster still have version 11.2.0.1.0 installed.

  ---

  crsctl query crs softwareversion Use the crsctl query crs softwareversion command to display latest version of the software that has been successfully started on the specified node. crsctl query crs activeversion Use the crsctl query crs activeversion command to display the active version of the Oracle Clusterware software running in the cluster. During a rolling upgrade, however, the active version is not advanced until the upgrade is finished across the cluster, until which time the cluster operates at the pre-upgrade version.

  Oracle?Clusterware Administration and Deployment Guide 11g Release 2 (11.2)

• Question 12:

  The storage administrator is adding several disks to a pool of ASM disks. The current ASM_DISKSTRING parameter is "/dev/sda*", "/dev/sdb*", "/dev/sd*6". There are several hundred disk partitions currently.

  The new disks are /dev/sdf1, /dev/sdg1, /dev/sdh1, and /dev/sdd6. Which ASM_DISKSTRING parameter would perform the best by searching the fewest number of devices for ASM discovery?

  A. ASM_DISKSTRING="/dev/sda*", "/dev/sdb*", "/dev/sd*6","/dev/sd*1"
  B. ASM_DISKSTRING="/dev/sda*", "/dev/sdb*", "/dev/sd*6","/dev/sd*"
  C. ASM_DISRSTRING="/dev/sd*"
  D. ASM_DISKSTRING=""
  E. ASM_DISKSTRING="/dev/sda*", "/dev/sdb*", "/dev/sd*6", "/dev/sdf1", "/dev/sdg1", "/dev/sdh1"
  E. ASM_DISKSTRING="/dev/sda*", "/dev/sdb*", "/dev/sd*6", "/dev/sdf1", "/dev/sdg1", "/dev/sdh1"

  ---

  Improving Disk Discovery Time The value for the ASM_DISKSTRING initialization parameter is an operating system dependent value that Oracle ASM uses to limit the set of paths that the discovery process uses to search for disks. When a new disk is added to a disk group, each Oracle ASM instance that has the disk group mounted must be able to discover the new disk using its ASM_DISKSTRING.

  Oracle?Automatic Storage Management Administrator's Guide 11g Release 2 (11.2)

• Question 13:

  Which four statements are true about services and connection load balancing?

  A. Services provide the ability to balance client connections across the instances in an Oracle RAC configuration.
  B. There are two types of load balancing that you can implement; load balancing decisions can be made by the client and by the listener.
  C. In a RAC database environment, you should select only one load balancing method.
  D. With server-side load balancing, the listener directs a connection request to the best instance that is currently providing the service based on the load-balancing options selected by the DBA.
  E. Client-side load balancing balances the connection requests across the listeners.
  A. Services provide the ability to balance client connections across the instances in an Oracle RAC configuration.
  B. There are two types of load balancing that you can implement; load balancing decisions can be made by the client and by the listener.
  D. With server-side load balancing, the listener directs a connection request to the best instance that is currently providing the service based on the load-balancing options selected by the DBA.
  E. Client-side load balancing balances the connection requests across the listeners.

  ---

  Services and Connection Load Balancing

  The two load balancing methods that you can implement are:

  Client-side load balancing: Balances the connection requests across the listeners Server-side load balancing: The listener directs a connection request to the best instance currently providing the service by using the load balancing advisory

  (LBA). FAN, Fast Connection Failover, and LBA depend on a connection load balancing configuration that includes setting the connection load balancing goal for the service. The load balancing goal for the service can be either:

  LONG: For applications having long-lived connections. This is typical for connection pools and SQL*Forms sessions.

  SHORT: For applications that have short-lived connection Oracle Net Services provides the ability to balance client connections across the instances in an Oracle RAC configuration. You can implement two types of load balancing: client-side

  and server-side.

  Client-side load balancing balances the connection requests across the listeners. With server-side load balancing, the listener directs a connection request to the best instance currently providing the service by using the load balancing

  advisory. In a RAC database, client connections should use both types of connection load balancing.

  D60488GC11

  Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 15 12

• Question 14:

  The Oracle Grid Infrastructure administrator runs ocrconfig -backupioc after completing the installation of the Grid Infrastructure. What are the two reasons for doing this

  A. The master node may change if the node running the master CRS daemon shuts down causing another node to become the master. Because the default location is a nonshared storage, and only the master node performs backups, the backups could be spread around on many nodes making management or recovery more difficult.
  B. The cluster node currently acting as the master node for CRS is the only node that backs up the OCR to the default location, and by changing the location, all cluster nodes will then take backups.
  C. This is done to move the backup location into an ASM Cluster File System directory so that the backups benefit from ASM striping and mirroring.
  D. If for any reason CRS must be stopped on all nodes for a time spanning a scheduled backup, then on restart, the backup timer will be reset. This could result in longer time duration between automatic backups than the standard four-hour interval.
  A. The master node may change if the node running the master CRS daemon shuts down causing another node to become the master. Because the default location is a nonshared storage, and only the master node performs backups, the backups could be spread around on many nodes making management or recovery more difficult.
  D. If for any reason CRS must be stopped on all nodes for a time spanning a scheduled backup, then on restart, the backup timer will be reset. This could result in longer time duration between automatic backups than the standard four-hour interval.

  ---

  Changing the Automatic OCR Backup Location

  The automatic backup location should be changed to a location shared by all nodes.

  # ocrconfig backuploc

  The backup location will be used for both automatic and manual backups. It is recommended that these files be included in routine scheduled backups to an offline location. If CRS has been stopped on all nodes, the schedule of backups is

  suspended. On restart, a backup is not immediately taken and the backup timer is reset.

  D60488GC11

  Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 3 - 12

• Question 15:

  You want to install a database patch on your eight-node cluster by using Opatch with, the minimum amount of down time to your cluster nodes.

  You have already been prompted for the first set of nodes and you replied with node names RACNODE1 RACNODE2, and RACNODE3.

  Which two statements are true about the procedure for minimizing down time?

  A. The patch must be propagated to, applied, and the inventory updated on all the remaining nodes before restarting the instances on the first set of nodes.
  B. When the first set of nodes has been patched, the instances on the remaining nodes are shut down automatically by opatch.
  C. The instances must be started on the first set of nodes and then stopped on the remaining set to make certain that some nodes are always available.
  D. When the first set of nodes has been patched, the administrator is prompted to shut down the instances on the remaining nodes.
  E. The patch must be propagated to and the inventory updated on all the remaining nodes before restarting the instances on the first set of nodes.
  D. When the first set of nodes has been patched, the administrator is prompted to shut down the instances on the remaining nodes.
  E. The patch must be propagated to and the inventory updated on all the remaining nodes before restarting the instances on the first set of nodes.

  ---

  Installing a Patch with Minimum Down Time with OPatch In minimum down-time patching, the nodes are divided into two sets. One set of nodes is shut down and the patch is applied to those nodes. After the first set of nodes has been patched, the second set of nodes is shut down. The first set of nodes is then restarted and the patch is applied to the second set of nodes. After the patch has been applied to the second set of nodes, those nodes are restarted. This method leads to less down time for Oracle RAC, compared to having all the nodes shut down at the same time. When you use the minimum down-time patching method, the following actions occur: The local node is always patched first. The local node is used as a base to patch the other nodes. The user is prompted for the first set of nodes to patch. For each node in this first set, the user is asked to stop the instance and then the patch is propagated and applied to that node before continuing to the next node. When the first set of nodes has been patched, the user is asked to shut down Clusterware on the remaining nodes. The instances are stopped on the last set of remote nodes. The patch is propagated to the last set of nodes and the inventory is updated. You can then start up the patched nodes (the first set of nodes) before patching the remaining nodes. D60488GC11 Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 4 44

• Question 16:

  After evaluating the various methods for extending a cluster, you decide to use addNode.sh.

  The cluster originally consisted of four nodes: RACNODE1, RACNODE2, RACNODE3, and RACNODE4. Now two nodes called RACNODES and RACNODE6 have been installed and connected to the cluster by OS administrations.

  Which three actions should be performed to check whether the new nodes are ready for running addNode.sh and to help correct any problems?

  A. cluvfy stage -pre crsinst -n RACNODE5/ RACNODE6 -C + DATA -q +VOTE -orainv
  B. -fixup -verbose
  C. cluvfy stage -post hwos -n RACNODE5, RACNODE6 -verbose
  D. cluvfy comp peer -refnode RACNODE1 -n RACNODE5, RACNODE6 -orainv -osdba -verbose
  E. cluvfy stage -post hwos -n all -verbose
  F. cluvfy stage -pre nodeadd -n RACNODE5, RACNODE6 -fixup
  G. cluvfy comp peer -refnode RACNODES -n RACNODE6 -orainv -osdba -verbose
  C. cluvfy stage -post hwos -n RACNODE5, RACNODE6 -verbose
  D. cluvfy comp peer -refnode RACNODE1 -n RACNODE5, RACNODE6 -orainv -osdba -verbose
  F. cluvfy stage -pre nodeadd -n RACNODE5, RACNODE6 -fixup

  ---

  Run the following CVU command to check cluster integrity. This command verifies that any number of specified nodes has been successfully added to the cluster at the network, shared storage, and clusterware levels:

  $ cluvfy stage -post nodeadd -n node3 [-verbose]

  cluvfy comp peer

  Use the cluvfy comp peer component verification command to check the compatibility and properties of the specified nodes against a reference node. You can check compatibil- ity for non-default user group names and for different releases

  of the Oracle software. This command compares physical attributes, such as memory and swap space, as well as user and group values, kernel settings, and installed operating system packages.

  Syntax

  cluvfy comp peer -n node_list [-refnode node] [-r {10gR1 | 10gR2 | 11gR1 | 11gR2}] [- orainv orainventory_group][-osdba osdba_group] [-verbose] Usage Notes Peer comparison with the -refnode option compares the system properties of

  other nodes against the reference node. If the value does not match (the value is not equal to reference node value), then CVU flags that comparison as a deviation from the reference node. If a group or user does not exist on reference node

  as well as on the other node, CVU reports this comparison as 'passed' because there is no deviation from the reference node. Simil- arly, CVU reports as 'failed' a comparison with a node that has more total memory than the reference node.

  Verify the integrity of the cluster and node3:

  $ cluvfy stage -pre nodeadd -n node3 [-fixup [-fixupdir fixup_dir]] [-verbose] You can specify the -fixup option and a directory into which CVU prints instructions to fix the cluster or node if the verification fails.

  Oracle?Clusterware Administration and Deployment Guide

• Question 17:

  Which two statements are true about ACFS snapshots?

  A. They can be created for ACFS file systems only if the ASM disk group hosting the ADVM volume file used by the file system has free space available.
  B. They can be created for ACFS file systems only if the ADVM volume file used by the file system has free space available.
  C. They can be created only if the ASM disk group hosting the ADVM volume used by the file system has no other ASM files contained in the disk group.
  D. They can be created when ACFS is used both on clusters and on stand-alone servers.
  E. They are accessible only on the cluster node that was used when creating the snapshot.
  B. They can be created for ACFS file systems only if the ADVM volume file used by the file system has free space available.
  D. They can be created when ACFS is used both on clusters and on stand-alone servers.

  ---

  About Oracle ACFS Snapshots Oracle ACFS snapshot storage is maintained within the file system, eliminating the management of separate storage pools for file systems and snapshots. Oracle ACFS file systems can be dynamically resized to accommodate additional file and snapshot storage requirements. Oracle?Automatic Storage Management Administrator's Guide 11g Release 2 (11.2)

• Question 18:

  Identify the three valid storage options for Grid Infrastructure voting disk and Install.

  A. a certified Cluster File System (CFS)
  B. a certified Network File System (NFS)
  C. ASM Cluster File System (ACFS)
  D. Automatic Storage Management (ASM)
  E. shared disk slices (block or raw devices)
  A. a certified Cluster File System (CFS)
  B. a certified Network File System (NFS)
  D. Automatic Storage Management (ASM)

  ---

  

  D60488GC11 Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 2 - 4

• Question 19:

  The Oracle Grid Infrastructure administrator decides to make more copies of the voting disks that are currently stored in the ASM disk group +VOTE. How can this be done?

  A. by running crsctl add css votedisk to make a copy to a shared location on a shared device or file system
  B. by running crsctl add css votedisk +VOTE, thereby adding another copy of the voting disk to the +VOTE disk group
  C. by running srvctl replace votedisk +asm_disk_group on another disk group that has greater redundancy, thereby causing additional copies to be created
  D. by running crsctl replace votedisk +asm_disk_group on another disk group that has greater redundancy, thereby causing additional copies to be created
  D. by running crsctl replace votedisk +asm_disk_group on another disk group that has greater redundancy, thereby causing additional copies to be created

  ---

  Storing Voting Disks on Oracle ASM Using the crsctl replace votedisk command, you can move a given set of voting disks from one Oracle ASM disk group into another, or onto a certified file system. If you move voting disks from one Oracle ASM disk group to another, then you can change the number of voting disks by placing them in a disk group of a different redundancy level as the former disk group. Notes: You cannot directly influence the number of voting disks in one disk group. You cannot use the crsctl add | delete votedisk commands on voting disks stored in Oracle ASM disk groups because Oracle ASM manages the number of voting disks according to the redundancy level of the disk group. You cannot add a voting disk to a cluster file system if the voting disks are stored in an Oracle ASM disk group. Oracle does not support having voting disks in Oracle ASM and directly on a cluster file system for the same cluster at the same time.

  Oracle?Clusterware Administration and Deployment Guide 11g Release 2 (11.2)

• Question 20:

  Which two statements are true regarding undo management in the RAC environment?

  A. You can use Automatic Undo Management (AUM) in some of the instances and manual undo management in the rest of the instances in a RAC database.
  B. In a policy-managed RAC database, Oracle automatically allocates the undo tablespace even the Oracle Managed Files (OMF) is disabled in a database.
  C. In a policy-managed RAC database, Oracle automatically allocates the undo tablespace if the database is OMF enabled.
  D. You can dynamically switch undo tablespace assignments by executing the ALTER SYSTEM SET UNDO_TABLESPACE statement from any instance in a administrator managed database.
  C. In a policy-managed RAC database, Oracle automatically allocates the undo tablespace if the database is OMF enabled.
  D. You can dynamically switch undo tablespace assignments by executing the ALTER SYSTEM SET UNDO_TABLESPACE statement from any instance in a administrator managed database.

  ---

  You assign undo tablespaces in your Oracle RAC administrator-managed database by specifying a different value for the UNDO_TABLESPACE parameter for each instance in your SPFILE or individual PFILEs. For policy-managed databases, Oracle automatically allocates the undo ta- blespace when the instance starts if you have Oracle Managed Files enabled. You can switch from using one undo tablespace to another. Because the UNDO_TABLESPACE initialization parameter is a dynamic parameter, the ALTER SYSTEM SET statement can be used to assign a new undo tablespace.