Oracle 1Z0-058 Online Practice Questions and Exam Preparation

Oracle 1Z0-058 Online Questions & Answers

• Question 21:

  Which three fragments will complete this statement correctly? In a cluster environment, an ACFS volume _____________.

  A. Will be automatically mounted by a node on reboot by default
  B. Must be manually mounted after a node reboot
  C. Will be automatically mounted by a node if it is defined as cluster stack startup if it is in- cluded in the ACFS mount registry.
  D. Will be automatically mounted to all node if it is defined as cluster resource when dependent cluster resources requires access
  E. Will be automatically mounted to all node in the cluster when the file system is registered
  F. Must be mounted before it can be registered
  A. Will be automatically mounted by a node on reboot by default
  C. Will be automatically mounted by a node if it is defined as cluster stack startup if it is in- cluded in the ACFS mount registry.
  E. Will be automatically mounted to all node in the cluster when the file system is registered

  ---

  The Oracle ACFS registry resource actions are designed to automatically mount a file system only one time for each Oracle Grid Infrastructure initialization to avoid potential conflicts with administrative actions to dismount a given file system.

  Reference: Oracle Automatic Storage Management Administrator's Guide

• Question 22:

  A policy-managed RAC database that hosts the ACCOUNTS service has only three instances running rather than the usual four on a six-node cluster. Five of the six cluster nodes are active and the sixth (RACNODE6) is down for maintenance. You decide to check the state of the servers in the server pools to see if there are problems with the OLTP pool to which the ACCOUNTS service has been assigned. You used the crsctl status server-f command and see that the RACNODE3 node has STATE=VISIBLE.

  What is true about this situation?

  A. The Cluster Synchronization Services Daemon (cssd) is running and RACNODE3 is considered to be part of the cluster, but the Cluster Ready Services Daemon (crsd) is currently not running.
  B. Both the Cluster Ready Services Daemon (crsd) and the Cluster Synchronization Service Daemon (cssd) are running on RACNODE3, but RACNODE3 is currently being moved to another server pool.
  C. The Cluster Ready Services Daemon (crsd) is running and RACNODE3 is considered to be a part of the cluster, but the Cluster Synchronization Services Daemon (cssd) is currently not running.
  D. Neither the Cluster Ready Services Daemon (crsd) nor the Cluster Synchronization Services Daemon (cssd) is running on RACNODE3.
  A. The Cluster Synchronization Services Daemon (cssd) is running and RACNODE3 is considered to be part of the cluster, but the Cluster Ready Services Daemon (crsd) is currently not running.

  ---

  Cluster Synchronization Service daemon (CSSD)

  An Oracle Clusterware component that discovers and tracks the membership state of each node by providing a common view of membership across the cluster. CSS also monitors process health, specifically the health of the database

  instance. The Global Enqueue Service Monitor (LMON), a background process that monitors the health of the cluster database environment and registers and de- registers from CSS.

  Cluster Ready Services Daemon (CRSD)

  The primary Oracle Clusterware process that performs high availability recovery and manage- ment operations, such as maintaining OCR. Also manages application resources and runs as root user (or by a user in the admin group on Mac

  OS X-based systems) and restarts automatically upon failure

  STATE=VISIBLE

  Servers that have Oracle Clusterware running, but not the Cluster Ready Services daemon (crsd), are put into the VISIBLE state. This usually indicates an intermittent issue or failure and Oracle Clusterware trying to recover (restart) the

  daemon. Oracle Clusterware cannot manage resources on servers while the servers are in this state.

  Oracle Clusterware Administration and Deployment Guide

• Question 23:

  Which three statements ate true about services and Transparent Application Failover (TAF)?

  A. If TAF has been configured for a service, sessions using that service fail over to a surviving instance when an outage occurs.
  B. The TAF setting on a service can be NONE, BASIC, PRECONNECT, or POSTCONNECT, and overrides any TAF setting in the client connection definition.
  C. TAF can restart a query after failover has completed but for other statements, such as INSERT, UPDATE, or DELETE, the application must resubmit the transaction.
  D. The TAF setting for a client connection overrides any TAF setting in the service definition.
  E. Services simplify the deployment of TAF because by defining a TAF policy for a service, all connections using this service will automatically have TAF enabled.
  A. If TAF has been configured for a service, sessions using that service fail over to a surviving instance when an outage occurs.
  B. The TAF setting on a service can be NONE, BASIC, PRECONNECT, or POSTCONNECT, and overrides any TAF setting in the client connection definition.
  E. Services simplify the deployment of TAF because by defining a TAF policy for a service, all connections using this service will automatically have TAF enabled.

  ---

  Services and Transparent Application Failover

  Services simplify the deployment of Transparent Application Failover (TAF). You can define a TAF policy for a service and all connections using this service will automatically have TAF enabled. The TAF setting on a service can be NONE,

  BASIC, or PRECONNECT and overrides any TAF setting in the client connection definition.

  To define a TAF policy for a service, the srvctl utility can be used as shown below:

  srvctl modify service -s gl.example.com -q TRUE -P

  BASIC -e SELECT -z 180 -w 5 -j LONG

  Where -z is the number of retries, -w is the delay between retry attempts and -j is the connection load balancing goal.

  When Oracle Net Services establishes a connection to an instance, the connection remains open until the client closes the connection, the instance is shut down, or a failure occurs. If you configure TAF for the connection, then Oracle

  Database moves the session to a surviving instance when an outage occurs. TAF can restart a query after failover has completed but for other types of transactions, such as INSERT, UPDATE, or DELETE, the application must roll back the

  failed transaction and resubmit the transaction. You must re-execute any session customizations, in other words, ALTER SESSION statements, after failover has occurred. However, with TAF, a connection is not moved during normal

  processing, even if the workload changes over time.

  D60488GC11

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

• Question 24:

  Examine the following output:

  [oracIe@gr5153 ~]$ sudo crsctl config crs CRS-4622: Oracle High Availability Services autostart is enabled. [oracIe@gr5153 ~]$ srvctl config database -d RACDB -a Database unique name: RACDB Database name: RACDB Oracle home : /u01/app/oracle/product/l11.2.0/dbhome_1 Oracle user: oracle Spfile: +DATA/ RACDB /spfileRACDB.ora Domain: Start options: open Stop options: immediate Database role: PRIMARY Management policy: AUTOMATIC Server pools: POOL1 Database instances: Disk Groups: DATA, FRA Services: Database is enabled Database is policy managed

  Oracle Clusterware is started automatically after the system boot. Which two statements are true regarding the attributes of RACDB?

  A. Oracle Clusterware automatically starts RACDB.
  B. You must manually start RACDB.
  C. Database resource is managed by crsd for high availability and may be automatically restarted in place if it fails.
  D. Database resource Is not managed by crsd for high availability and needs to be restarted manually if it fails.
  A. Oracle Clusterware automatically starts RACDB.
  C. Database resource is managed by crsd for high availability and may be automatically restarted in place if it fails.

  ---

  Switch Between the Automatic and Manual Policies By default, Oracle Clusterware is configured to start the VIP, listener, instance, ASM, database services, and other resources during system boot. It is possible to modify some resources to have their profile parameter AUTO_START set to the value 2. This means that after node reboot, or when Oracle Clusterware is started, resources with AUTO_START=2 need to be started manually via srvctl. This is designed to assist in troubleshooting and system maintenance. When changing resource profiles through srvctl, the command tool automatically modifies the profile attributes of other dependent resources given the current prebuilt dependencies. The command to accomplish this is: srvctl modify database -d -y AUTOMATIC|MANUAL

  D60488GC11 Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 15 3

  3.4.1 Benefits of Using Oracle Clusterware

  Oracle Clusterware provides the following benefits:

  Tolerates and quickly recovers from computer and instance failures. Simplifies management and support by means of using Oracle Clusterware together with Oracle Database. By using fewer vendors and an all Oracle stack you gain better

  integration compared to using third-party clusterware.

  Performs rolling upgrades for system and hardware changes. For example, you can apply Oracle Clusterware upgrades, patch sets, and interim patches in a rolling fashion, as follows:

  Upgrade Oracle Clusterware from Oracle Database 10g to Oracle Database 11g Upgrade Oracle Clusterware from Oracle Database release 11.1 to release 11.2 Patch Oracle Clusterware from Oracle Database 11.1.0.6 to 11.1.0.7 Patch

  Oracle Clusterware from Oracle Database 10.2.0.2 Bundle 1 to Oracle Database 10.2.0.2 Bundle 2

  Automatically restarts failed Oracle processes.

  Automatically manages the virtual IP (VIP) address so when a node fails then the node's VIP address fails over to another node on which the VIP address can accept connections. Automatically restarts resources from failed nodes on

  surviving nodes.

  Controls Oracle processes as follows:

  For Oracle RAC databases, Oracle Clusterware controls all Oracle processes by default. For Oracle single-instance databases, Oracle Clusterware allows you to configure the Oracle processes into a resource group that is under the control

  of Oracle Clusterware. Provides an application programming interface (API) for Oracle and non-Oracle applications that enables you to control other Oracle processes with Oracle Clusterware, such as restart or react to failures and certain

  rules. Manages node membership and prevents split-brain syndrome in which two or more instances attempt to control the database.

  Provides the ability to perform rolling release upgrades of Oracle Clusterware, with no downtime for applications.

  Oracle?Database High Availability Overview

  11g Release 2 (11.2)

• Question 25:

  Which three statements are true about services and the Resource Manager?

  A. The Resource Manager can manage the relative priority of services within an instance by binding services directly to consumer groups if services are mapped to consumer groups by the DBA.
  B. When a client connects using a service, the service can be mapped to a consumer group, enabling the Resource Manager to manage work requests by service in the order of their importance.
  C. The srvctl utility is used to map services to consumer groups.
  D. The Resource Manager offers benefits In managing workloads because priority is given to business functions rather than the sessions that support those business functions.
  A. The Resource Manager can manage the relative priority of services within an instance by binding services directly to consumer groups if services are mapped to consumer groups by the DBA.
  B. When a client connects using a service, the service can be mapped to a consumer group, enabling the Resource Manager to manage work requests by service in the order of their importance.
  D. The Resource Manager offers benefits In managing workloads because priority is given to business functions rather than the sessions that support those business functions.

  ---

  A resource consumer group (consumer group) is a collection of user sessions that are grouped to- gether based on their processing needs. When a session is created, it is automatically mapped to a consumer group based on mapping rules that you set up. As a database administrator (DBA), you can manually switch a session to a different consumer group. Before you enable the Resource Manager, you must specify how user sessions are assigned to re- source consumer groups. You do this by creating mapping rules that enable the Resource Man- ager to automatically assign each session to a consumer group upon session startup, based upon session attributes. Oracle Database Resource Manager (the Resource Manager) enables you to manage multiple workloads within a database that are contending for system and database resources. In addition, the Database Resource Manager can map services to consumer groups. Therefore, you can automatically manage the priority of one service relative to others. You can use con- sumer groups to define relative priority in terms of either ratios or resource consumption. Oracle Database Administrator's Guide

• Question 26:

  You have created four top-level server pools called OLTP, BATCH, DSS, and support for a policy- managed, eight-node cluster. The OLTP pool has two child pools called OLTP_CHILD1 and OLTP_CHILD2. Which two statements are true about sharing servers among the various server pools on your cluster?

  A. Servers are never shared and are always mutually exclusive between top-level server pools.
  B. Use the exclusive_pools attribute to prevent servers being shared between top-level server pools.
  C. Use the exclusive_pools attribute to prevent servers being shared between OLTP_CHILD1 and OLTP_CHILD2 .
  D. Use the exclusive_pools attribute to prevent servers being shared between batch, dss, support, oltp_childi, and OLTP_CHILD2.
  E. Servers are never shared and are always mutually exclusive between top-level server pools and between sibling child pool.
  A. Servers are never shared and are always mutually exclusive between top-level server pools.
  C. Use the exclusive_pools attribute to prevent servers being shared between OLTP_CHILD1 and OLTP_CHILD2 .

  ---

  Top-level server pools: Logically divide the cluster Are always exclusive, meaning that one server can only reside in one particular server pool at a certain point in time EXCLUSIVE_POOLS This optional attribute indicates if servers assigned to this server pool are shared with other server pools. A server pool can explicitly state that it is exclusive of any other server pool that has the same value for this attribute. Two or more server pools are mutually exclusive when the sets of servers assigned to them do not have a single server in common. For example, server pools A and B must be exclusive if they both set the value of this attribute to foo_A_B. Top-level server pools are mutually exclusive, by default.

• Question 27:

  For which two purposes would you recommend an ASM clustered file system (ACFS)?

  A. a shared home directory for Oracle database executables in a single-instance cluster for cold failover
  B. a shared home directory for Oracle Grid Infrastructure executables
  C. a root file system for the operating system
  D. a shared file system for RAC data files
  E. a general purpose shared file system for OS files
  F. a clustered file system for OCR and voting disk files
  A. a shared home directory for Oracle database executables in a single-instance cluster for cold failover
  E. a general purpose shared file system for OS files

  ---

  Overview of Oracle ACFS

  Oracle Automatic Storage Management Cluster File System (Oracle ACFS) is a multi-platform, scalable file system, and storage management technology that extends Oracle Automatic Storage Management (Oracle ASM) functionality to

  support customer files maintained outside of Oracle Database. Oracle ACFS supports many database and application files, including 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.

  Notes:

  Oracle ASM is the preferred storage manager for all database files. It has been specifically designed and optimized to provide the best performance for database file types. For a list of file types supported by Oracle ASM, see Table 7-1, "File

  types supported by Oracle ASM". Oracle ACFS is the preferred file manager for non-database files. It is optimized for general purpose files. Oracle ACFS does not support any file type that can be directly stored in Oracle ASM, except where

  explicitly noted in the documentation.

  Not supported means Oracle Support Services does not take calls and development does not fix bugs associated with storing unsupported file types in Oracle ACFS. Starting with Oracle Automatic Storage Management 11g Release 2

  (11.2.0.3), Oracle ACFS supports RMAN backups (BACKUPSET file type), archive logs (ARCHIVELOG file type), and Data Pump dumpsets (DUMPSET file type). Note that Oracle ACFS snapshots are not supported with these files. Oracle

  ACFS does not support files for the Oracle Grid Infrastructure home. Oracle ACFS does not support Oracle Cluster Registry (OCR) and voting files. Oracle ACFS functionality requires that the disk group compatibility attributes for ASM and

  ADVM be set to

  11.2 or greater. For information about disk group compatibility, refer to "Disk Group Compatibility".

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

• Question 28:

  A third party application has provided files containing the command syntax required to register and manage the application for high availability with Oracle Grid Infrastructure. The command to define the application is as follows: crsctl add resource LongApp -type cluster_resource -attr "ACTION_SCRIPT='/u01/ogi/scripts/longapp.scr' , PLACEMENT='restricted' , HOSTING_MEMBERS='RACNODE1 RACNODE2 , CHECK_INTERVAL='30 ,START_DEPENDENCIES='hard(LongAppvip)' , STOP_DEPENDENCIES='hard (LongApp- vip)', RESTART_ATTEMPTS='2"

  Which two statements are true about the behavior of this resource after it is added?

  A. It will be a policy-managed resource using the server pool containing nodes RACNODE1 and RACNODE2.
  B. The LongAppvip vip resource must be activated to successfully activate this resource, but wl not be activated automatically if not already active.
  C. The LongAppvip vip resource must be stopped before this resource is stopped.
  D. It will be an administrator-managed resource hosted by nodes RACNODE1 and RACNODE2.
  B. The LongAppvip vip resource must be activated to successfully activate this resource, but wl not be activated automatically if not already active.
  D. It will be an administrator-managed resource hosted by nodes RACNODE1 and RACNODE2.

  ---

  Configurable Resource Attributes

  HOSTING_MEMBERS

  A space-separated, ordered list of cluster server names that can host a resource. This attribute is required only when using administrator management, and when the value of the PLACEMENT attribute is set to favored or restricted. When

  registering applications as Oracle Clusterware resources, use the SERVER_POOLS attribute, instead.

  START_DEPENDENCIES

  hard([intermediate:][global:]{resource_name | type:resource_type})--Specify a hard start dependency for a resource when you want the resource to start only when a particular resource or resource of a particular type starts.

  weak([concurrent:][global:][uniform:]{resource_name | type:resource_type})--Specify a weak start dependency for a resource when you want that resource to start despite whether named resources are running, or not. An attempt to start this

  resource also attempts to start any resources on which this resource depends if they are not running.

  STOP_DEPENDENCIES

  hard([intermediate:][global:][shutdown:]{resource_name | type:resource_type})--Specify a hard stop dependency for a resource that you want to stop when named resources or resources of a particular resource type stop.

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

• Question 29:

  mounted: DATA and DATA2, but the results of the SHOW PARAMETER ASM_DISKGROUPS command show only DATA as below:

  

  What could have caused the DATA2 dlskgroup to be mounted based on the information injthe V $ASM_DISKGROUP view?

  A. The DATA2 diskgroup contains the database files required to start a database instance that depends on this ASM instance.
  B. The DATA2 diskgroup contains the voting files required for this cluster.
  C. The DATA diskgroup has mirrored objects in the DATA2 diskgroup.
  D. The DATA value In the parameter implies all diskgroup strings starting with data.
  E. The DATA2 diskgroup contains the SPFILE needed to start the ASM instance.
  B. The DATA2 diskgroup contains the voting files required for this cluster.

  ---

  Disk Groups Mounted at Startup

  At startup, the Oracle ASM instance attempts to mount the following disk groups:

  Disk groups specified in the ASM_DISKGROUPS initialization parameter Disk group used by Cluster Synchronization Services (CSS) for voting files Disk groups used by Oracle Clusterware for the Oracle Cluster Registry (OCR) Disk group

  used by the Oracle ASM instance to store the ASM server parameter file (SPFILE)

  D60488GC11

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

• Question 30:

  Which three statements are true about cluster (OCR) and local registries (OLR)?

  A. The ocrdump command can be used to dump the contents of either the cluster registry (OCR) or the local registry (OLR).
  B. Information in the OCR is organized by keys that are associated with privileges. Therefore, the root user will see more information when using ocrdump than the grid user.
  C. After the cluster is created, the size of the OCR is static unless the Clusterware software Is upgraded.
  D. The ocrdump command can be used to dump information for a single OCR key.
  A. The ocrdump command can be used to dump the contents of either the cluster registry (OCR) or the local registry (OLR).
  B. Information in the OCR is organized by keys that are associated with privileges. Therefore, the root user will see more information when using ocrdump than the grid user.
  D. The ocrdump command can be used to dump information for a single OCR key.

  ---

  This section explains how to use the OCRDUMP utility to view OCR and Oracle Local Registry (OLR) content for troubleshooting. The OCRDUMP utility enables you to view OCR and OLR contents by writing the content to a file or stdout in a readable format. You can use several options for OCRDUMP. For example, you can limit the output to a key and its descendents. You can also write the contents to an XML file that you can view using a browser. OCRDUMP writes the OCR keys as ASCII strings and values in a data type format. OCRDUMP retrieves header information based on a best effort basis. Displays OCR content in the terminal window in XML format ocrdump -stdout -backupfile Grid_home/cdata/ cluster_name/ file_name Displays the content of the in the Grid_home/cdata/ cluster_name/ file_ name directory. You must run this command as root to be able to view all of the keys. Oracle Clusterware Administration and Deployment Guide