Oracle 1Z0-058 Online Practice Questions and Exam Preparation

Oracle 1Z0-058 Online Questions & Answers

• Question 121:

  Examine the Exhibit.

  *** Exhibit is Missing ***

  Which three statements are correct?

  A. Global Cache Block Access Latency indicates how many block transfers incurred a delay (busy) or an unexpected longer delay (congested).
  B. Global Cache Block Access Latency indicates how many block transfers received blocks cached by other instances as well as blocks read from disk.
  C. Global Cache Block Transfer Rate shows the total aggregated number of blocks received by all instances in the cluster over the interconnect.
  D. Global Cache Block Transfer Rate is essentially a profile of how much work is performed in the local buffer cache, rather than the portion of remote references and physical reads, which both have higher latencies.
  E. Global Cache Block Transfers and Physical Reads shows the percentage of read operations that retrieved blocks from disk, and the buffer cache of other instances using Cache Fusion.
  F. Global Cache Block Transfers and Physical Reads shows the aggregated number of data blocks received by all instances in the cluster over the interconnect.
  A. Global Cache Block Access Latency indicates how many block transfers incurred a delay (busy) or an unexpected longer delay (congested).
  C. Global Cache Block Transfer Rate shows the total aggregated number of blocks received by all instances in the cluster over the interconnect.
  E. Global Cache Block Transfers and Physical Reads shows the percentage of read operations that retrieved blocks from disk, and the buffer cache of other instances using Cache Fusion.

  ---

  Global Cache Block Access Latency The global cache access latency represents the end-to-end elapsed time for a block request. The request is timed from when the request is initiated until it completes. Cache transfer indicates how many current and CR blocks per block class were received from remote instances, including how many transfers incurred a delay (busy) or an unexpected longer delay (congested).

  If accessing a database block of any class does not locate a buffered copy in the local cache, a global cache operation is initiated. Before reading a block from disk, an attempt is made to find the block in the buffer cache of another instance. If the block is present in another instance, a version of the block may be shipped. Two different kinds of blocks are distinguished: current and consistent read blocks. The average block receive time represents the end-to-end elapsed time or latency for a block request.

  Global Cache Block Transfer Rate The global cache block transfer rate shows the total aggregated number of data blocks received by all instances in the cluster by way of an interconnect. If a logical read fails to find a copy of the buffer in the local cache, it attempts to find the buffer in the database cache of a remote instance. If the block is present in another database, it is sent to the current instance.

  Global Cache Block Transfers and Physical Reads The chart represents the percentage of logical reads that read data from the buffer cache of other instances via Direct Memory Access and from disk. It is essentially a profile of how much work is performed in the local buffer cache, rather than the portion of non-local references that incur some latency overhead.

  Active Sessions for Cluster Wait Class The chart represents the active sessions for the cluster wait class. You can view the top modules and top SQL for a time period by selecting the time period in the active sessions chart. Oracle Enterprise Manager Online Help

• Question 122:

  The original cluster on RACNODE1, RACNODE 2, RACNODE 3, and RACNODE4 had the Oracle Grid Infrastructure installed to support Grid Naming Service (GNS). What should be done to verify that the two new nodes called RACNODE5, RACNODE6 are physically connected?

  A. cluvfy stage -post crsinst -n RACNODE5,RACNODE6 -verbose
  B. cluvfy stage -post nodeadd -n RACNODE5,RACNODE6 -verbose
  C. cluvfy stage -post hacfg -verbose
  D. cluvfy stage -post nodeadd -n all verbose
  B. cluvfy stage -post nodeadd -n RACNODE5,RACNODE6 -verbose

  ---

  Completing OUI Silent Node Addition Perform integrity checks on the cluster. [grid@host01]$ cluvfy stage post nodeadd n host03 -verbose D60488GC11 Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 4 - 8

• Question 123:

  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 -n host0l,host03
  B. ocrconfig set log CRS "CRSRTI,CRSCOMM:5 " -nodelist host01,host03
  C. crsctl set log CRS "CRSRTI:5,CRSCOMM:5" -nodelist host0l,host03
  D. crsctl lsmodules crs set log CRSRTI:5,CRSCOMM:5 -nodelist host0l, host03
  C. crsctl set log CRS "CRSRTI:5,CRSCOMM:5" -nodelist host0l,host03

  ---

  crsctl set log Use the crsctl set log command to set log levels for Oracle Clusterware. You can enable debugging for Oracle Clusterware modules and their components, and for resources, by setting environment variables or by running crsctl set log commands, using the following syntax: Syntax crsctl set {log | trace} module_name "component:debugging_level [,component:debugging_level][,...]" Usage Notes You can set log levels for various components of the three modules, CRS, CSS, and EVM. If you choose the all option, then you can set log levels for all components of one module with one command. Use the crsctl lsmodules command to obtain a list of components for each module. Enter a comma-delimited list of component name-log level pairs enclosed in double quotation marks (""). The log_level is a number from 1 to 5 that sets the log level for the component or resource, where 1 is the least amount of log output and 5 provides the most detailed log output. The default log level is 2. To set log levels for resources, specify the name of a particular resource, or a comma-delimited list of resource name-log level pairs enclosed in double quotation marks (""). To set debugging levels on specific cluster nodes, include the -nodelist keyword and the names of the nodes, as follows: crsctl set log crs "CRSRTI:1,CRSCOMM:2" -nodelist node1,node2 Oracle Clusterware Administration and Deployment Guide

• Question 124:

  Which three statements are true about ASM performance and scalability?

  A. Disks in a diskgroup may be of varying speed and capacity without affecting performance.
  B. Disks in a diskgroup should match in speed and capacity for best performance.
  C. A database seldom needs more than two diskgroups: one for data and the other for a fast recovery area.
  D. A database needs a separate diskgroup for each major tablespace, redo logs, and fast recovery area.
  E. Multiple databases that use the same diskgroup make the best use of space.
  F. Multiple databases that use a separate diskgroup for each database make the best use of space.
  B. Disks in a diskgroup should match in speed and capacity for best performance.
  C. A database seldom needs more than two diskgroups: one for data and the other for a fast recovery area.
  E. Multiple databases that use the same diskgroup make the best use of space.

  ---

  Section: (none)

  Performance, Scalability, and Manageability Considerations for Disk Groups Create separate disk groups for database files and fast recovery area. Disks in a disk group should have the same size and performance characteristics.

  Allows the disk group to deliver consistent performance Allows ASM to use disk space most effectively Allows operations with different storage requirements to be matched with different disk groups effectively

  Using separate disk groups for each database as opposed to having multiple databases in a disk group has various benefits and drawbacks.

  Housing multiple databases in a single disk group affords the most efficient use of space. However, any faults or maintenance that affects the disk group may affect many databases. Separate disk groups provide greater isolation from the

  effects of a fault or maintenance operation. However, to achieve this may consume more disk space and may require more disk group maintenance to balance disk resources.

  D60488GC11

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

• Question 125:

  As part of your data center's high availability strategy, you are creating resource definitions to control the management of a web-based application by the Oracle Grid Infrastructure clusterware stack. The application and its VIP are normally

  online on one node of a four-node cluster due to the CARDINALITY of the resource type being set to 1.

  You have chosen a policy-managed resource type for the application by using a server pool that uses only RACNODE3 and RACNODE4. The START ATTEMPTS attribute for the resource is set to 2 and FAILURE INTERVAL is set to 60.

  What is true about the attributes that may be set to control the application?

  A. The clusterware will attempt to start the application on the same node twice within the server pool as long as that node is up. If the node fails, then the VIP and the application will be failed over to the other node in the server pool immediately.
  B. The clusterware will attempt to start the application on the same node twice within the server pool as long as that node is up. If the node fails, then the VIP and the application will be failed over to the other node in the server pool only after two 60-second intervals have elapsed.
  C. The clusterware will attempt to start the application on the same node twice within the server pool as long as that node is up. If the application fails to start after 60 seconds, but the node is still up, then the VIP and the application will NOT be failed over to the other node in the server pool.
  D. The clusterware will attempt to start the application on the same node twice within the server pool as long as that node is up. If the application fails to start immediately but the node is still up, then the VIP and the application will NOT be failed over to the other node in the server pool.
  A. The clusterware will attempt to start the application on the same node twice within the server pool as long as that node is up. If the node fails, then the VIP and the application will be failed over to the other node in the server pool immediately.

  ---

  CARDINALITY

  The number of servers on which a resource can run, simultaneously. This is the upper limit for resource cardinality.

  RESTART_ATTEMPTS

  The number of times that Oracle Clusterware attempts to restart a resource on the resource's current server before attempting to relocate it. A value of 1 indicates that Oracle Clusterware only attempts to restart the resource once on a server.

  A second failure causes Oracle Clusterware to attempt to relocate the resource. A value of 0 indicates that there is no attempt to restart but Oracle Clusterware always tries to fail the resource over to another server.

  FAILURE_INTERVAL

  The interval, in seconds, before which Oracle Clusterware stops a resource if the resource has exceeded the number of failures specified by the FAILURE_THRESHOLD attribute. If the value is zero (0), then tracking of failures is disabled.

  FAILURE_THRESHOLD

  The number of failures of a resource detected within a specified FAILURE_INTERVAL for the resource before Oracle Clusterware marks the resource as unavailable and no longer monitors it. If a resource fails the specified number of times,

  then Oracle Clusterware stops the resource. If the value is zero (0), then tracking of failures is disabled. The maximum value is 20.

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

• Question 126:

  Which four statements about mounting ASM cluster file systems are true?

  A. An ACFS volume can be mounted by using ASMCA.
  B. The standard Linux/UNIX mount command can be used to mount an ACFS volume, provided the ACFS type is specified; (mount -t acfs).
  C. ACFS volumes can be mounted by using the ASMCMD utility.
  D. The acfsmountvol command can be used to mount ACFS volumes on Windows platforms.
  E. Oracle Enterprise Manager can be used to mount ACFS volumes.
  A. An ACFS volume can be mounted by using ASMCA.
  B. The standard Linux/UNIX mount command can be used to mount an ACFS volume, provided the ACFS type is specified; (mount -t acfs).
  D. The acfsmountvol command can be used to mount ACFS volumes on Windows platforms.
  E. Oracle Enterprise Manager can be used to mount ACFS volumes.

  ---

  Oracle ASM Configuration Assistant enables you to create or configure an Oracle ACFS file system. Some commands require root privileges, such as mounting a file system. Oracle ASM Configuration Assistant generates the command for you to run manually as root or as a privileged user. There are buttons for Create, Show Mount All, and Show Dismount All commands mount attaches a file system to the Oracle ACFS hierarchy at the mount point that is the name of a directory. The mount happens on the node where the mount command was is- sued. The mount command returns an error if the file system is not in a dismounted state on this node root privilege is required to run mount. acfsmountvol attaches an Oracle ACFS to the file system hierarchy at the specified path name or drive letter. dir must be an empty directory. Oracle ACFS mount points can be created on any empty directory and they can be hierarchical (nested). Windows Administrator privileges are required to mount an Oracle ACFS ASM Cluster File System tab in Oracle Enterprise Manager. This tab lists all of the Oracle ACFS associated with the Oracle ASM instance. On this page, you can choose to mount, dismount, delete, create snapshot, view content, register, and deregister a selected file system. In addition, you can create a file system, mount all file systems, or dismount all file systems. Oracle?Automatic Storage Management Administrator's Guide

• Question 127:

  Which three are components of Oracle HA Framework for protecting third-party applications using Oracle Clusterware?

  A. resources
  B. action programs
  C. voting disks
  D. application VIPS
  E. SCAN VIPS
  A. resources
  B. action programs
  D. application VIPS

  ---

  Oracle Clusterware HA Components

  

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

• Question 128:

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

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

  ---

  Determining the Location of Oracle Clusterware Configuration Files You can determine the location of the voting disk by using the crsctl query css votedisk command on any node. D60488GC11 Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 3 7

• Question 129:

  Which two statements are true regarding the Automatic Workload Repository (AWR) In a RAC environment?

  A. The AWR includes time model statistics based on time usage for activities displayed In the VSSYS_TIME_MODEL and VSSESS_TIHE_HODEL views.
  B. The AWR is controlled by the statistics_level initialization parameter and it must be set to TYPICAL or BASIC
  C. The Manageability Monitor Processes (MMON) process gathers statistics every hour from every instance and creates an AWR snapshot and stores it In the SGA.
  D. The MMON process gathers statistics from its' own instance and kicks off statistics collection form other instances every hour from other instances and creates an AWR snapshot which is written to the sysaux tablespace.
  A. The AWR includes time model statistics based on time usage for activities displayed In the VSSYS_TIME_MODEL and VSSESS_TIHE_HODEL views.
  D. The MMON process gathers statistics from its' own instance and kicks off statistics collection form other instances every hour from other instances and creates an AWR snapshot which is written to the sysaux tablespace.

  ---

  The Automatic Workload Repository (AWR) collects, processes, and maintains performance statistics for problem detection and self-tuning purposes. This data is both in memory and stored in the database. The gathered data can be displayed in both reports and views. The statistics collected and processed by AWR include: Object statistics that determine both access and usage statistics of database segments Time model statistics based on time usage for activities, displayed in the V$SYS_TIME_MODEL and V$SESS_TIME_MODEL views Some of the system and session statistics collected in the V$SYSSTAT and V$SESSTAT views SQL statements that are producing the highest load on the system, based on criteria such as elapsed time and CPU time Active Session History (ASH) statistics, representing the history of recent sessions Activity MMON (Memory Monitor) is a background process that gathers memory statistics (snapshots) stores this information in the AWR (automatic workload repository). MMON is also responsible for issuing alerts for metrics that exceed their thresholds. Oracle Database Performance Tuning Guide

• Question 130:

  What does a high "gc current block busy" event value indicate?

  A. Access to cached data blocks was delayed because they were busy either in the remote or the local cache.
  B. A large number of requested blocks were not cached In any instance.
  C. Asynchronous input/output (I/O) is disabled.
  D. Delay in processing has occurred In the GCS, caused by CPU saturation and would have to be solved by additional CPUs and load-balancing.
  A. Access to cached data blocks was delayed because they were busy either in the remote or the local cache.

  ---

  The gc current block busy wait event indicates that the access to cached data blocks was delayed because they were busy either in the remote or the local cache. This could be caused by any of the following: The blocks were pinned The blocks were held up by sessions The blocks were delayed by a log write on a remote instance A session on the same instance was already accessing a block which was in transition between instances and the current session needed to wait behind it (for example, gc current block busy) Oracle Real Application Clusters Administration and Deployment Guide