Oracle 1Z0-058 Online Practice Questions and Exam Preparation

Oracle 1Z0-058 Online Questions & Answers

• Question 51:

  Your Apache-based application resource called MyApp has a VIP application resource definition and an application resource definition.

  The application is administrator managed and is currently active on nodeRACNODE3. You want to move it to host RACNODE4, which is one of the HOSTING_MEMBERS in the resource definition. What is the most efficient method to move

  the application and the VIP?

  A. Run crsctl relocate resource MyApp - n RACNODE4 - f.
  B. Run crsctl stop resource MyApp -n RACNODE3 -f followed by crsctl start MyApp -n RACNODE4 -f.
  C. Run crsctl stop resource MyApp -n RACNODE3 -f followed by crsctl relocate resource MyApp n RACNODE4.
  D. Run crsctl relocate resource MyApp -n RACNODE4.
  A. Run crsctl relocate resource MyApp - n RACNODE4 - f.

  ---

  Relocating Applications and Application Resources

  Use the crsctl relocate resource command to relocate applications and application resources. For example, to relocate the Apache Web server application to a server named rac2, run the following command:

  # crsctl relocate resource myApache -n rac2

  Each time that the action program is called, the crsctl relocate resource command waits for the duration specified by the value of the SCRIPT_TIMEOUT resource attribute to receive notification of success or failure from the action program. A

  relocation attempt fails if:

  The application has required resources that run on the initial server Applications that require the specified resource run on the initial server To relocate an application and its required resources, use the -f option with the crsctl relocate

  resource command. Oracle Clusterware relocates or starts all resources that are required by the application regardless of their state.

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

• Question 52:

  The high availability services provided by Oracle Clusterware are used to protect Oracle resources, such as RAC database instances, RAC database services, and other components of the Oracle Grid Infrastructure, and non-Oracle resources as well. Which two statements are true about the high availability capabilities of Oracle HA services?

  A. RAC databases may have their instances failed over in some cases.
  B. ASM instances may be failed over if fewer than three nodes remain in the cluster, so that there are always at least three ASM instances available.
  C. If a node fails, then all resources that were active on that node will be failed over to a surviving node if any exists.
  D. If a node fails, then cluster resources that were active on that node may be failed over to a surviving node if any exists, but local resources are not failed over.
  E. HA services will only fail over a resource upon failure of the node where the resource was active.
  D. If a node fails, then cluster resources that were active on that node may be failed over to a surviving node if any exists, but local resources are not failed over.
  E. HA services will only fail over a resource upon failure of the node where the resource was active.

  ---

  Resource Types Local resource: These are server-centric resources; the type name is local_resource. These run locally on individual servers of the cluster and are not relevant outside of the scope of the server. Cluster resource: Cluster-aware resource types (type name is cluster_resource) are aware of the cluster environment and are subject to cardinality and cross-server switchover and failover. The state of cluster resources is relevant in the context of the cluster. D60488GC11 Oracle 11g: RAC and Grid Infrastructure Administration

• Question 53:

  Directory structure in ASM has a default of +///. The EXAMPLE tablespace was created with:

  CREATE TABLESPACE EXAMPLE DATAFILE '+DATA/ORCL/oradata/example_01.dbf'

  The asmcmd ls command shows: ASMCMD>ls -l +DATA/ORCL/oradata/* Type Redund Striped Type Sys Name N example_01.dbf => +DATA/ORCL/DATAFILE/EXAMPLE.264.695918623

  Which three statements can be verified by from the information provided?

  A. The ASM file +DATA/ORCL/oradata/example_01.dbf has an alias of +DATA/ORCL/DATAFILE/ EXAMPLE.264.695918623.
  B. The ASM system file +DATA/ORCL/DATAFILE/EXAMPLE.264.695918623 has an alias of +DATA/ ORCL/oradata/example_01.dbf.
  C. The default path indicates that the file is an oradata file belonging to the ORCL database.
  D. The default path indicates that the file is a data file belonging to the ORCL database.
  E. +DATA/ORCL/oradata/example_01.dbf is the name of the file in V$DBFILE in the database instance.
  F. +DATA/ORCL/DATAFILE/EXAMPLE.264.695918623 is the name of the file in V$DBFILE in the database instance.
  B. The ASM system file +DATA/ORCL/DATAFILE/EXAMPLE.264.695918623 has an alias of +DATA/ ORCL/oradata/example_01.dbf.
  D. The default path indicates that the file is a data file belonging to the ORCL database.
  F. +DATA/ORCL/DATAFILE/EXAMPLE.264.695918623 is the name of the file in V$DBFILE in the database instance.

  ---

  Fully Qualified ASM File Names

  Every file created in ASM gets a system-generated file name, known as the fully qualified file name.

  You cannot set the fully qualified file name.

  ASM guarantees uniqueness within the ASM environment. The fully qualified file name is used in database views that display Oracle Database file names.

  D60488GC11

  Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 9 - 11

• Question 54:

  Which two conditions are required by the ASM fast mirror resynchronization to track block changes for a set period of time before dropping the disk from the disk group?

  A. Redundancy is normal or high.
  B. compatibility. rdbms is set to a value of at least 11. l.
  C. disk_repair_time is set to a nondefault value.
  D. block_change_tracking IS enabled.
  E. db_block_checking is enabled.
  F. resumable_timeout is set to a nondefault value.
  A. Redundancy is normal or high.
  B. compatibility. rdbms is set to a value of at least 11. l.

  ---

  ASM Fast Mirror Resync Enabled when COMPATIBLE.RDBMS >= 11.1 Whenever ASM is unable to write an extent, ASM takes the associated disk offline. If the corresponding disk group uses ASM mirroring (NORMAL or HIGH redundancy), at least one mirror copy of the same extent exists on another disk in the disk group. Before Oracle Database 11g, ASM assumed that an offline disk contains only stale data and no longer reads from such disks. Shortly after a disk is put offline, ASM drops it from the disk group by re-creating the extents allocated to the disk on the remaining disks in the disk group using mirrored extent copies. This process is quite resource intensive and can take hours to complete. If the disk is replaced or the failure is repaired, the disk must be added again and another rebalance operation must take place.

  D60488GC11 Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 8 - 32

• Question 55:

  You enter the following command:

  crsctl status resource MyApp

  You get this output:

  NAME=MyApp

  TYPE=cluster_resource TARGET=ONLINE STATE=ONLINE on RACNODE4 MyApp is a policy-managed resource using a server pool with two nodes called RACNODE3 and RACNODE4 and has a cardinality of 1.

  What are the meanings of the target and state status values?

  A. MyApp is currently active on RACNODE4 and is meant to be active only on RACNODE4.
  B. MyApp is meant to be active, is currently active on RACNODE4, but the Grid Infrastructure may start MyApp on RACNODE3 due to failovers.
  C. MyApp is active on RACNODE4 and was manually started.
  D. MyApp should also be online on RACNODE3 because it is a cluster_resources type that must be active on at least two nodes in the cluster, thereby overriding the CARDINALITY attribute.
  B. MyApp is meant to be active, is currently active on RACNODE4, but the Grid Infrastructure may start MyApp on RACNODE3 due to failovers.

  ---

  Resource Attributes

  NAME

  A case-sensitive alphanumeric string that names the resource. Oracle recommends a naming convention that starts with an alphanumeric prefix, such as myApache, and complete the name with an identifier to describe it.

  A resource name can contain any platform-supported characters except the exclamation point (!) and the tilde

  (~). A resource name cannot begin with a period (.) nor with the string ora.

  TYPE

  The type of resource indicated when you create a resource. This attribute is required when creating a resource.

  Local resource: Instances of local resources--type name is local_resource--run on each server of the cluster. When a server joins the cluster, Oracle Clusterware automatically extends local resources to have instances tied to the new server.

  When a server leaves the cluster, Oracle Clusterware automatically sheds the instances of local resources that ran on the departing server. Instances of local resources are pinned to their servers; they do not fail over from one server to

  another. Cluster resource: Cluster-aware resource types--type name is cluster_resource--are aware of the cluster environment and are subject to cardinality and cross-server switchover and failover.

  TARGET

  An internal, read-only attribute that describes the desired state of a resource. Using the crsctl start resource_name or crsctl stop resource_name commands, however, can affect the value of this attribute.

  STATE

  An internally-managed attribute that reflects the current state of the resource as reported by Oracle Clusterware. The state of a resource can be one of the following:

  ONLINE: The resource is online and resource monitoring is enabled (see CHECK_INTERVAL). OFFLINE:

  The resource is offline and only offline resource monitoring is enabled, if configured (see OFFLINE_CHECK_INTERVAL).

  INTERMEDIATE: The resource is either partially online or was known to be online before and subsequent attempts to determine its state have failed; resource monitoring is enabled (see CHECK_INTERVAL). UNKNOWN: The resource is

  unmanageable and its current state is unknown; manual intervention is required to resume its operation. A resource in this state is not monitored.

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

• Question 56:

  Your four-node cluster was originally purchased, installed, and configured three years ago. You recently added another four nodes to the cluster.

  Now you want to remove two of the older nodes that are still accessible to be redeployed elsewhere in the data center. Which two are true regarding the procedure for removing one or more cluster nodes?

  A. The procedure requires that all commands be invoked from one of the surviving cluster nodes.
  B. All commands are run as root regardless of which nodes are used to invoke them.
  C. The procedure requires that some commands be invoked on the node or nodes to be removed and that some be invoked from all surviving cluster nodes.
  D. The procedure requires that some commands be invoked on the node or nodes to be removed and that some be invoked from one surviving cluster node.
  E. Some commands require that the name of the node or nodes to be removed are passed as arguments, and some commands require the name of existing nodes to be passed.
  D. The procedure requires that some commands be invoked on the node or nodes to be removed and that some be invoked from one surviving cluster node.
  E. Some commands require that the name of the node or nodes to be removed are passed as arguments, and some commands require the name of existing nodes to be passed.

  ---

  If you are deleting multiple nodes, then run the rootcrs.pl script on each node that you are deleting. From any node that you are not deleting, run the following command from the Grid_home/bin directory as root to delete the node from the

  cluster:

  # crsctl delete node -n node_to_be_deleted

  On the node you want to delete, run the following command as the user that installed Oracle Clusterware from the Grid_home/oui/bin directory where node_to_be_deleted is the name of the node that you are deleting:

  $ ./runInstaller -updateNodeList ORACLE_HOME=Grid_home "CLUSTER_NODES= {node_to_be_deleted}" CRS=TRUE -silent -local

  On the node that you are deleting, depending on whether you have a shared or local Oracle home, complete one of the following procedures as the user that installed Oracle Clusterware:

  For a local home, deinstall the Oracle Clusterware home from the node that you want to delete, as follows, by running the following command, where Grid_home is the path defined for the Oracle Clusterware home:

  On any node other than the node you are deleting, run the following command from the Grid_home /oui/bin directory where remaining_nodes_list is a comma-delimited list of the nodes that are going to remain part of your cluster:

  $ ./runInstaller -updateNodeList ORACLE_HOME=Grid_home "CLUSTER_NODES= {remaining_nodes_list}" CRS=TRUE -silent

  Run the following CVU command to verify that the specified nodes have been successfully deleted from the cluster:

  $ cluvfy stage -post nodedel -n node_list [-verbose] Oracle?Clusterware Administration and Deployment Guide

• Question 57:

  In an ASM instance, there are several parameters that have meanings specific to the ASM. Which parameter is mandatory?

  A. ASM_DISKGROUP
  B. ASM_DISKSTRING
  C. INSTANCE_TYPE
  D. CLUSTER_DATABASE
  E. MEMORY_TARGET
  F. ASM_POWER_LIMIT
  C. INSTANCE_TYPE

  ---

  Oracle ASM Parameter Setting Recommendations This section contains information about the following parameters for Oracle ASM: ASM_DISKGROUPS

  o The default value of the ASM_DISKGROUPS parameter is a NULL string. ASM_DISKSTRING

  o The default value of the ASM_DISKSTRING parameter is a NULL string ASM_POWER_LIMIT o Specifies the default power for disk rebalancing in a disk group. The range of val- ues is 0 to 1024. The default value is 1. A value of 0 disables rebalancing. ASM_PREFERRED_READ_FAILURE_GROUPS

  o The ASM_PREFERRED_READ_FAILURE_GROUPS parameter setting is in- stance specific. The default value is NULL. DB_CACHE_SIZE

  o You do not have to set a value for the DB_CACHE_SIZE initialization parameter if you use automatic memory management. DIAGNOSTIC_DEST

  o The default value for an Oracle ASM instance is the $ORACLE_BASE directory for the Oracle Grid Infrastructure installation. INSTANCE_TYPE

  o The INSTANCE_TYPE initialization parameter is the only required parameter in the Oracle ASM instance parameter file. LARGE_POOL_SIZE

  o You do not have to set a value for the LARGE_POOL_SIZE initialization para- meter if you use automatic memory management PROCESSES

  o The PROCESSES initialization parameter affects Oracle ASM, but the default value is usually suitable. REMOTE_LOGIN_PASSWORDFILE

  o The REMOTE_LOGIN_PASSWORDFILE initialization parameter specifies whether the Oracle ASM instance checks for a password file. SHARED_POOL_SIZE

  o You do not have to set a value for the SHARED_POOL_SIZE initialization para- meter if you use automatic memory management. Oracle?Automatic Storage Management Administrator's Guide

• Question 58:

  You notice that there is a very high percentage of wait time for the 'enq:HW-contention' event in your RAC database that has frequent insert operations. Which two recommendations may reduce this problem?

  A. shorter transactions
  B. increasing sequence cache sizes
  C. using reverse key indexes
  D. uniform and large extent sizes
  E. automatic segment space management
  F. smaller extent sizes
  D. uniform and large extent sizes
  E. automatic segment space management

  ---

  Segments have High Water Mark (HWM) indicating that blocks below that HWM have been formatted. New tables or truncated tables [that is truncated without reuse storage clause], have HWM value set to segment header block. Meaning,

  there are zero blocks below HWM. As new rows inserted or existing rows updated (increasing row length), more blocks are added to the free lists and HWM bumped up to reflect these new blocks. HW enqueues are acquired in Exclusive

  mode before updating HWM and essentially HW enqueues operate as a serializing mechanism for HWM updates. Allocating additional extent with instance keyword seems to help in non- ASSM tablespace

  Serialization of data blocks in the buffer cache due to lack of free lists, free list groups, transac- tion slots (INITRANS), or shortage of rollback segments. This is particularly common on INSERT-heavy applications, in applications that have

  raised the block size above 8K, or in applications with large numbers of active users and few rollback seg- ments. Use automatic segment-space management (ASSM) and automatic undo management to solve this problem.

  HW enqueue The HW enqueue is used to serialize the allocation of space beyond the high water mark of a segment.

  V$SESSION_WAIT.P2 / V$LOCK.ID1 is the tablespace number. V$SESSION_WAIT.P3 / V$LOCK.ID2 is the relative dba of segment header of the ob- ject for which space is being allocated. If this is a point of contention for an object, then

  manual allocation of extents solves the problem.

• Question 59:

  Which four statements are true about ADVM interoperability?

  A. Using fdisk or similar disk utilities to partition ADVM-managed volumes is not supported
  B. On Linux platforms, the raw utility can be used to map ADVM volume block devices to raw volume devices.
  C. The creation of multipath devices over ADVM devices is not supported.
  D. You may create ASMLIB devices over ADVM devices to simplify volume management.
  E. ADVM does not support ASM storage contained in Exadata.
  F. ADVM volumes cannot be used as a boot device or a root file system.
  A. Using fdisk or similar disk utilities to partition ADVM-managed volumes is not supported
  C. The creation of multipath devices over ADVM devices is not supported.
  E. ADVM does not support ASM storage contained in Exadata.
  F. ADVM volumes cannot be used as a boot device or a root file system.

  ---

  Oracle Automatic Storage Management Cluster File System (Oracle ACFS) and Oracle ASM Dy- namic Volume Manager (Oracle ADVM) extend Oracle ASM support to include database and application executables, database trace files,

  database alert logs, application reports, BFILEs, and configuration files. Other supported files are video, audio, text, images, engineering drawings, and other general-purpose application file data.

  Because of the fact that Oracle ADVM Volumes are technically spoken ASM files located on ASM Disk groups, and the fact that the Dynamic Volumes do not use the traditional device parti- tioning, it enables Oracle to extend some of the

  ASM features to the ASM Clustered File Sys- tems, which are created inside these ADVM Volumes, such as dynamic resizing or dynamically adding volumes. This makes ADVM and ACFS a far more flexible solution than traditional physical

  devices.

  Important Notes:

  Partitioning of dynamic volumes (using fdisk or similar) is not supported Do not use raw to map ADVM volume block devices into raw volumes devices Do not create multipath devices over ADVM devices Do not create ASMLIB devices over

  ADVM devices

  Oracle ADVM supports all storage solutions supported for Oracle ASM with the excep- tion of NFS and Exadata storage

  ADVM volumes cannot be used as a boot device or a root file system

• Question 60:

  Which command will set full debugging for the communications and resource management components of the CRS module on nodes host01 and host03?

  A. srvctl set log -m CRS -c CRSCTI 5, CRSCOMM 5 -m host01,host03
  B. ocrconfig set log CRS "CRSRTI, CRSCOMM: 5" -nodelist host01,host03
  C. crsctl set log CRS "CRSRTI: 5, CRSCOMM: 5" -nodelist host01,host03
  D. crsctl lsmodules crs set log CRSRTX : 5, CRSCOMM: 5 -nodelist host01, host03
  C. crsctl set log CRS "CRSRTI: 5, CRSCOMM: 5" -nodelist host01,host03

  ---

  Dynamic Debugging

  This section includes the following CRSCTL commands that aid in debugging:

  crsctl set log

  Use the crsctl set log command to set log levels for Oracle Clusterware.

  Syntax

  crsctl set log {[crs | css | evm "component_name=log_level, [...]"] | [all=log_level]} You can also set log levels for the agents of specific resources, as follows:

  crsctl set log res "resource_name=log_level, [...]"

  

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