Oracle 1Z0-058 Online Practice Questions and Exam Preparation

Oracle 1Z0-058 Online Questions & Answers

• Question 111:

  You have a four-node cluster with four node VIPS and three scan VIPS already In use after Oracle Grid Infrastructure installation. You plan to manage a customer-developed, web-based application with the Oracle Grid Infrastructure to provide high availability. Which two statements are true about the vip application resource that must be created?

  A. The vip application must be active on the same subnet and ethernet adaptor as the Interconnect.
  B. The vip application must be active on the same subnet and ethernet adaptor as the public ip Address.
  C. The vip application must not be online on the same node as any of the scan vips.
  D. The vip application must be active on a different node than the application depending on Che by using the dispersion start dependency in the resource definition.
  E. The vip application must be enabled to run as the root user.
  B. The vip application must be active on the same subnet and ethernet adaptor as the public ip Address.
  E. The vip application must be enabled to run as the root user.

  ---

  If clients of an application access the application through a network, and the placement policy for the application allows it to fail over to another node, then you must register a virtual internet pro- tocol address (VIP) on which the application depends. An application VIP is a cluster resource that Oracle Clusterware manages (Oracle Clusterware provides a standard VIP agent for applica- tion VIPs). You should base any new application VIPs on this VIP type to ensure that your sys- tem experiences consistent behavior among all of the VIPs that you deploy in your cluster A VIP resource is typically owned by root because VIP related operations require root privileges. You must assign a VIP address to each node in the cluster. Each VIP address must be on the same subnet as the public IP address for the node and should be an address that is assigned a name in the DNS Oracle Clusterware Administration and Deployment Guide

• Question 112:

  You are managing a three-instance policy-managed RAC database PROD. You created a service called GL for the PROD database by using the following command: oracle@gr7597~]$srvctl add service d PROD -s GL g SP1 -c singleton -y manual Examine the following output: (oracle@gr7597~]$srvctl config database -d PROD -a Database unique name: PROD base name: PROD Oracle home: /u0l/app/oracle/product/11.2.0/dbhome_l cle user: oracle Spfile: +DATA/PROD/spfil6RACDB.ora Domain: Start options: open Stop options: immediate Database role: PRIMARY Management policy: AUTOMATIC Server pools: SPl Database instances: Disk Groups: DATA, FRA Services:

  Database is enabled Database is policy managed [oracle@gr?597~]$ crsctl stat res ora.PROD.db NAME=ora.PROD.db TYPE=cluster__resource TARGET=ONLlNE STATE^ONLINE on gr7597 ONLINE on gr7602 ONLINE on gr7633 [oracle@gr7597~]S crsctl stat serverpool ora.SPl NAME=ora.SPl ACTIVE_SERVERS=gr7S97 gr7 602 gr7633

  [oracle@gr7597-JS crsctl NAME=ora.prod.gl.svc TYPE=ora.service - type TARGET=ONLINE STATE=ONLlNE on gr7597

  Which three steps are required to enable ODP.NET clients that connect to the GL services to receive FAN High Availability Events?

  A. Enable Advanced Queuing notifications by using SRVCTL as shown in the following command: srvctl modify service -d prod --s gl --q TRUE -j LONG
  B. Execute the following statement for the users that will be connecting by way of the -Net Application, where user_name is the user name: EXECUTE DBMS_AQADM.GRANT_QUEUE_PRIVILEGE(`DEQUEUE`,`SYS.SYSSSERVICE_METRI CS' user_name);
  C. Enable Transparent Application Failover (TAF), either on the client or for the service.
  D. Enable Fast Connection Failover for ODP.NET connection pools by subscribing to FAN High Availability events. Do this by setting the HA events connection string attribute to true at connection time.
  E. Link client applications with the client thread or operating system library.
  A. Enable Advanced Queuing notifications by using SRVCTL as shown in the following command: srvctl modify service -d prod --s gl --q TRUE -j LONG
  B. Execute the following statement for the users that will be connecting by way of the -Net Application, where user_name is the user name: EXECUTE DBMS_AQADM.GRANT_QUEUE_PRIVILEGE(`DEQUEUE`,`SYS.SYSSSERVICE_METRI CS' user_name);
  D. Enable Fast Connection Failover for ODP.NET connection pools by subscribing to FAN High Availability events. Do this by setting the HA events connection string attribute to true at connection time.

  ---

  Perform the following steps to enable FAN for ODP.NET clients:

  1.

  Enable Advanced Queuing notifications for a service by using SRVCTL as shown in the following example:

  srvctl modify service -d crm -s odpnet.example.com -q TRUE

  2.

  Grant permissions on the internal event queue table by executing the following command for the users that will be connecting by way of the ODP.NET application, where user_name is the database user name:

  EXECUTE

  DBMS_AQADM.GRANT_QUEUE_PRIVILEGE('DEQUEUE','SYS.SYS$SERVICE_ METR ICS', user_name);

  3.

  Enable Fast Connection Failover for ODP.NET connection pools by subscribing to FAN high availability events. To enable FCF, include "HA Events=true" and "pooling=true" (the default value) in the connection string, as shown in the

  following example where user_name is the name of the database user and password is the password for that user:

  con.ConnectionString = "User Id=user_name;Password=password;Data Source=odpnet;" + "Min Pool Size=10;Connection Lifetime=120;Connection Timeout=60;" + "HA Events=true;Incr Pool Size=5;Decr Pool Size=2";

  Oracle Real Application Clusters Administration and Deployment Guide

• Question 113:

  A Grid Plug and Play (GPnP) software image must contain at least three items. Which three items are required?

  A. operating system software
  B. Oracle Database software
  C. GPnP software
  D. security certificate of the provisioning authority
  E. application software
  A. operating system software
  C. GPnP software
  D. security certificate of the provisioning authority

  ---

  GPnP Components

  Software image

  A software image is a read-only collection of software to berun on nodes of the same type.

  At a minimum, the image must contain:

  -An operating system

  -The GPnP software

  -A security certificate from the provisioning authority

  - Other software required to configure the node when it starts up

  D60488GC11 Oracle 11g: RAC and Grid Infrastructure Administration

• Question 114:

  Which two statements are true about instance recovery in a RAC environment?

  A. Parallel instance recovery will work even if the recovery_parallelism initialization parameter set to 0 or 1.
  B. Increasing the size of the default buffer cache can speed up instance recovery because instance recovery may use as much as 50 percent of the default buffer cache for recovery buffers.
  C. The fast_start_mttr_target initialization parameter includes both instance startup and recovery time.
  D. The fast__start_mttr_target initialization parameter specifies only the instance recovery time.
  B. Increasing the size of the default buffer cache can speed up instance recovery because instance recovery may use as much as 50 percent of the default buffer cache for recovery buffers.
  D. The fast__start_mttr_target initialization parameter specifies only the instance recovery time.

  ---

  Many sites run with too few redo logs that are too small. Small redo logs cause system check- points to continuously put a high load on the buffer cache and I/O system. If there are too few redo logs, then the archive cannot keep up, and the

  database will wait for the archive process to catch up. With the Fast-Start Fault Recovery feature, the FAST_START_MTTR_TARGET initialization parameter simplifies the configuration of recovery time from instance or system failure.

  FAST_START_MTTR_TARGET specifies a target for the expected mean time to recover (MTTR), that is, the time (in seconds) that it should take to start up the instance and perform cache recovery.

  Oracle Database Performance Tuning Guide

• Question 115:

  You have an ASM cluster and you want to terminate all the ASM instances. Assume that the database Instances supported by the ASM are already shut down. What must you know to select the appropriate command for this operation?

  A. Are the OCR and voting disk files stored In ASM diskgroups?
  B. Are the SYSTEM and SYSAUS tablespaces stored In ASM diskgroups?
  C. Is the undo tablespace stored in ASM diskgroups?
  D. Are the redo log files stored in ASM diskgroups?
  A. Are the OCR and voting disk files stored In ASM diskgroups?

  ---

  Oracle strongly recommends that you shut down all database instances that use the Oracle ASM instance and dismount all file systems mounted on Oracle ASM Dynamic Volume Manager (Oracle ADVM) volumes before attempting to shut down the Oracle ASM instance. If Oracle Cluster Registry (OCR) or voting files are stored in a disk group, the disk group can only be dismounted by shutting down the Oracle ASM instance as part of shutting down the clusterware on a node. To shut down the clusterware, run crsctl stop crs. Oracle Automatic Storage Management Administrator's Guide

• Question 116:

  In the high availability services' provided by Oracle Clusterware are used to protect Oracle resource such as RAC database instances, RAC database services, and other components of the Oracle 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.

• Question 117:

  You are creating a resource definition called WEBAPP for a web-based application that requires an application called WEBVIP.

  Both WEBVIP and WEBAPP are normally active on a single node, but may fail over if required to another cluster node in your eight-node cluster.

  A second VIP application resource called appsvip exists, used by a second application resource called secapp. webvip and webapp must start In the correct sequence.

  Which two start dependencies would you use for the WEBAPP application resource definition?

  A. hard(SECAPP)
  B. pullup(SECAPP)
  C. pullup (WEBVIP)
  D. hard(WEBVlP)
  E. dispersion(WEBVIP)
  F. weak (WEBVIP)
  C. pullup (WEBVIP)
  D. hard(WEBVlP)

  ---

  Start Dependencies hard Define a hard start dependency for a resource if another resource must be running before the dependent resource can start. For example, if resource A has a hard start dependency on resource B, then resource B must be running before resource A can start. Note: Oracle recommends that resources with hard start dependencies also have pullup start dependencies. weak If resource A has a weak start dependency on resource B, then an attempt to start resource A attempts to start resource B, if resource B is not running. The result of the attempt to start resource B is, however, of no consequence to the result of starting resource A. attraction If resource A has an attraction dependency on resource B, then Oracle Clusterware prefers to place resource A on servers hosting resource B. Dependent resources, such as resource A in this case, are more likely to run on servers on which resources to which they have attraction dependencies are running. Oracle Clusterware places dependent resources on servers with resources to which they are attracted. pullup Use the pullup start dependency if resource A must automatically start whenever resource B starts. This dependency only affects resource A if it is not running. As is the case for other dependencies, pullup may cause the dependent resource to start on any server. Use the pullup dependency whenever there is a hard stop dependency, so that if resource A depends on resource B and resource B fails and then recovers, then resource A is restarted. dispersion If you specify the dispersion start dependency for a resource, then Oracle Clusterware starts this resource on a server that has the fewest number of resources to which this resource has dispersion. Resources with dispersion may still end up running on the same server if there are not enough servers to disperse them to. Oracle?Clusterware Administration and Deployment Guide 11g Release 2 (11.2)

• Question 118:

  Which three statements are true about Clusterware resource debugging?

  A. The crsctl command can be used to set debugging for Clusterware resources by using the following syntax: crsctl set log resource "resource_name:logging_level".
  B. Enabling logging for Clusterware resources can negatively affect cluster performance, so it should be used only when required.
  C. After collecting debugging data for a specific Clusterware resource, terminate the collection of debugging data by issuing the crsctl set log resource "resource_name:stop" command.
  D. Although the crsctl command can be used to dynamically affect logging for Clusterware resources, you can also configure resource debugging automatically by specifying a logging_ievel clause in the Grid_Home/log/hostname/admin/ clscfg.ini file.
  E. Debugging cannot be set for user-defined resources.
  A. The crsctl command can be used to set debugging for Clusterware resources by using the following syntax: crsctl set log resource "resource_name:logging_level".
  B. Enabling logging for Clusterware resources can negatively affect cluster performance, so it should be used only when required.
  D. Although the crsctl command can be used to dynamically affect logging for Clusterware resources, you can also configure resource debugging automatically by specifying a logging_ievel clause in the Grid_Home/log/hostname/admin/ clscfg.ini file.

  ---

  Enabling Resource Debugging

  Change the USR_ORA_DEBUG resource attribute to 1 for specific resources:

  # crsctl set log res "ora.host01.vip:1"

  After you capture all trace information, change the debug attribute back to 0:

  # crsctl set log res "ora.host01.vip:0"

  You can use an initialization file to configure debugging. The initialization file name includes the name of the process that you are debugging (process_name.ini).

  The file is located in the /log/host_name/admin/ directory.

  Oracle Support may request that you enable tracing to capture additional information for problem resolution with Oracle Clusterware resources. Because the procedures described here may affect performance, perform these activities only

  with the assistance of Oracle Support. The initialization file name includes the name of the process that you are debugging (process_name.ini). The file is located in the /log/host_name/admin/ directory. For example, the name

  for the CLSCFG debugging initialization file on node1 would be:

  /log/node1/admin/clscfg.ini

  D60488GC11

  Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 6 - 13

• Question 119:

  Which statement describes the requirements for the network interface names, such as eth0, in Oracle Clusterware?

  A. Only the public interface names must be the same for all nodes.
  B. Only the private interface names must be the same for all nodes.
  C. Both the public interface name and the private interface name must be the same for all nodes.
  D. Both the public interface name and the private interface name can vary on different nodes.
  E. Only the private interface names can be different on different nodes.
  F. Only the public interface names can be different on different nodes.
  C. Both the public interface name and the private interface name must be the same for all nodes.

  ---

  Checking Network Requirements

  Each node must have at least two network interface cards (NICs).

  Interface names must be the same on all nodes.

  Public NIC must support TCP/IP and Private NIC UDP.

  Public IP must be registered in the domain name server (DNS) or the /etc/hosts file.

  # cat /etc/hosts

  ##### Public Interfaces eth0 (odd numbers)####

  xxx.xxx.100.11 host01.example.com host01

  xxx.xxx.100.13 host02.example.com host02 IF GNS is used, the Cluster GNS address must be registered in the DNS. Prevent public network failures when using NAS devices or NFS mounts by starting the Name Service Cache Daemon. # /sbin/service nscd start

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

• Question 120:

  Examine the following details from the AWR report for your three-instance RAC database: Which inferences is correct?

  

  A. There are a large number of requests for cr blocks or current blocks currently in progress.
  B. Global cache access is optimal without any significant delays.
  C. The log file sync waits are clue to cluster interconnect latency.
  D. To determine the frequency of two-way block requests you must examine other events In the report.
  B. Global cache access is optimal without any significant delays.

  ---

  Analyzing Cache Fusion Transfer Impact Using GCS Statistics This section describes how to monitor GCS performance by identifying objects read and modified frequently and the service times imposed by the remote access. Waiting for blocks to arrive may constitute a significant portion of the response time, in the same way that reading from disk could increase the block access delays, only that cache fusion transfers in most cases are faster than disk access latencies. The following wait events indicate that the remotely cached blocks were shipped to the local instance without having been busy, pinned or requiring a log flush:

  gc current block 2-way gc current block 3-way gc cr block 2-way gc cr block 3-way

  The object statistics for gc current blocks received and gc cr blocks received enable quick identification of the indexes and tables which are shared by the active instances. As mentioned earlier, creating an ADDM analysis will, in most cases, point you to the SQL statements and database objects that could be impacted by interinstance contention. Any increases in the average wait times for the events mentioned in the preceding list could be caused by the following occurrences: High load: CPU shortages, long run queues, scheduling delays Misconfiguration: using public instead of private interconnect for message and block traffic If the average wait times are acceptable and no interconnect or load issues can be diagnosed, then the accumulated time waited can usually be attributed to a few SQL statements which need to be tuned to minimize the number of blocks accessed. Oracle?Real Application Clusters Administration and Deployment Guide 11g Release 2 (11.2)