Oracle 1Z0-058 Online Practice Questions and Exam Preparation

Oracle 1Z0-058 Online Questions & Answers

• Question 91:

  You are managing RAC database with policy managed services. The database is started by using an SPILE. Which two statements are true regarding initialization parameters In a RAC environment?

  A. All initialization parameters must have identical settings on all instances.
  B. All instances in the cluster database use the same SPFILE.
  C. To change values for initialization parameters for an instance, you must log in to that instance.
  D. All initialization parameters for all instances can be changed from any instance In a RAC database.
  B. All instances in the cluster database use the same SPFILE.
  D. All initialization parameters for all instances can be changed from any instance In a RAC database.

  ---

  RAC Initialization Parameter Files

  An SPFILE is created if you use the DBCA.

  The SPFILE must be created in an ASM disk group or a cluster file system file.

  All instances use the same SPFILE.

  If the database is created manually, create an SPFILE from a PFILE.

  SPFILE Parameter Values and RAC

  You can change parameter settings using the ALTER SYSTEM SET command from any instance

  D60488GC11

  Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 12 - 22, 23

• Question 92:

  Which two statements are true regarding the Average Active Sessions chart on the performance page

  A. It shows active aggregate wait class statistics across all the instances In the cluster database.
  B. It shows active aggregate wait class per instance for all the instances In the cluster database.
  C. If the Average Active Sessions chart displays a large number of sessions waiting, indicating internal contention, but the throughput is high, then the situation may be acceptable.
  D. If the Average Active Sessions chart displays a large number of sessions waiting, indicating internal contention, but the throughput is low, then the CPU needs to be upgraded
  A. It shows active aggregate wait class statistics across all the instances In the cluster database.
  C. If the Average Active Sessions chart displays a large number of sessions waiting, indicating internal contention, but the throughput is high, then the situation may be acceptable.

  ---

  Chart for Average Active Sessions The Average Active Sessions chart in the Cluster Database Performance page shows potential problems inside the database. Verifying the Interconnect Settings for Oracle RAC Categories, called wait classes, show how much of the database is using a resource, such as CPU or disk I/O. Comparing CPU time to wait time helps to determine how much of the response time is con- sumed with useful work rather than waiting for resources that are potentially held by other pro- cesses. Compare the peaks on the Average Active Sessions chart with those on the Database Throughput charts. If the Average Active Sessions chart displays a large number of sessions waiting, indicat- ing internal contention, but throughput is high, then the situation may be acceptable. Oracle Database 2 Day + Real Application Clusters Guide

• Question 93:

  Which two network addresses are required to be static, non-dhcp addresses when using the Grid Naming?

  A. GNS VIP Address
  B. SCAN VIP Address
  C. Node VIP Address
  D. Node Public Address
  E. Node Private Address
  A. GNS VIP Address
  D. Node Public Address

  ---

  2.6.2 IP Address Requirements Before starting the installation, you must have at least two network adapters configured on each node: One for the private IP address and one for the public IP address. You can configure IP addresses with one of the following options: Dynamic IP address assignment using Oracle Grid Naming Service (GNS). If you select this op- tion, then network administrators assign static IP address for the physical host name and dynam- ically allocated IPs for the Oracle Clusterware managed VIP addresses. Oracle?Grid Infrastructure Installation Guide

  Implementing GNS To implement GNS, you must collaborate with your network administrator to obtain an IP ad- dress on the public network for the GNS VIP. DNS uses the GNS VIP to forward requests for ac- cess to the cluster to GNS. You must also collaborate with your DNS administrator to delegate a domain to the cluster. This can be a separate domain or a subdomain of an existing domain. The DNS server must be configured to forward all requests for this new domain to the GNS VIP. Since each cluster has its own GNS, it must be allocated a unique domain of which to be in con- trol. Oracle?Clusterware Administration and Deployment Guide

• Question 94:

  I he ASM instance in your environment can support databases from version 10.2.0.4 through 11.2.0.1 You want to use all ASM functionality possible for each database, including OCR and voting files In the ASM. What is the proper setting for the ASM diskgroup attribute on diskgroups being used by all the instances?

  A. Set compatible.asm to 11.2 and compatible.rdbms to 10.2
  B. Set compatible.asm to 10.2 and compatible.rdbms to 10.2
  C. Set compatible.asm to 11.2 and compatible.rdbms to 11.2
  D. Set compatible.asm to 10.2 and compatible.rdbms to 11.2
  A. Set compatible.asm to 11.2 and compatible.rdbms to 10.2

  ---

  Disk Group Compatibility Attributes COMPATIBLE.ASM The value for the disk group COMPATIBLE.ASM attribute determines the minimum software version for an Oracle ASM instance that can use the disk group. This setting also affects the format of the data structures for the Oracle ASM metadata on the disk. The format of other file contents is determined by Oracle ASM Dynamic Volume Manager (Oracle ADVM) and the database instance.

  For Oracle ASM in Oracle Database 11g, 10.1 is the default setting for the COMPATIBLE.ASM attribute when using the SQL CREATE DISKGROUP statement, the ASMCMD mkdg command, and Oracle Enterprise Manager Create Disk Group page. When creating a disk group with ASMCA, the default setting is 11.2.

  COMPATIBLE.RDBMS The value for the disk group COMPATIBLE.RDBMS attribute determines the minimum COMPATIBLE database initialization parameter setting for any database instance that is allowed to use the disk group. Before advancing the COMPATIBLE.RDBMS attribute, ensure that the values for the COMPATIBLE initialization parameter for all of the databases that access the disk group are set to at least the value of the new setting for COMPATIBLE.RDBMS.

  For example, if the COMPATIBLE initialization parameters of the databases are set to either 11.1 or 11.2, then COMPATIBLE.RDBMS can be set to any value between 10.1 and 11.1 inclusively. Oracle?Automatic Storage Management Administrator's Guide 11g Release 2 (11.2)

• Question 95:

  Which three statements are true about the management of Oracle Services?

  A. To manage workloads or a group of applications, you can define services for a particular application or a subset of an application's operations.
  B. Similar work can be categorized under services to ease workload management.
  C. Users who share a service should have different service-level requirements.
  D. Oracle Enterprise Manager or SRVCTL should be used to control cluster-managed services, not DBMS_SERVICE.
  A. To manage workloads or a group of applications, you can define services for a particular application or a subset of an application's operations.
  B. Similar work can be categorized under services to ease workload management.
  D. Oracle Enterprise Manager or SRVCTL should be used to control cluster-managed services, not DBMS_SERVICE.

  ---

  Using Oracle Services To manage workloads or a group of applications, you can define services that you assign to a particular application or to a subset of an application's operations. You can also group work by type under services. For example, online users can use one service, while batch processing can use another and reporting can use yet another service to connect to the database. Oracle recom- mends that all users who share a service have the same service level requirements. You can define specific characteristics for services and each service can represent a separate unit of work. There are many options that you can take advantage of when using services. Although you do not have to implement these options, using them helps optimize application performance. Oracle does not recommend using the DBMS_SERVICE package for use with services used by an Oracle RAC database. Use SRVCTL or Oracle Enterprise Manager to create database services for Oracle RAC. Oracle Real Application Clusters Administration and Deployment Guide

• Question 96:

  Choose three correct statements about ASM disk group attributes set from the ASMCA Create Disk Group

  A. The field labeled ASM Compatibility sets the compatible.asm attribute.
  B. When creating a disk group with ASMCA, the default setting for the ASM Compatibility field (compatible.asm) is 10.1.
  C. The Database Compatibility field (compatible.rdbms) sets the minimum version level for any database instance that is allowed to mount the disk group.
  D. To use ADVM volumes, ADVM Compatibility (compatible.advm) must be set to 11.2.0 or later and ASM Compatibility must be 11.2.0 or later.
  E. Advancing the values for disk group compatibility attributes can be reversed if desired.
  A. The field labeled ASM Compatibility sets the compatible.asm attribute.
  C. The Database Compatibility field (compatible.rdbms) sets the minimum version level for any database instance that is allowed to mount the disk group.
  D. To use ADVM volumes, ADVM Compatibility (compatible.advm) must be set to 11.2.0 or later and ASM Compatibility must be 11.2.0 or later.

  ---

  COMPATIBLE.ASM The value for the disk group COMPATIBLE.ASM attribute determines the minimum software version for an Oracle ASM instance that can use the disk group. COMPATIBLE.RDBMS The value for the disk group COMPATIBLE.RDBMS attribute determines the minimum COM- PATIBLE database initialization parameter setting for any database instance that is allowed to use the disk group. COMPATIBLE.ADVM The value for the disk group COMPATIBLE.ADVM attribute determines whether the disk group can contain Oracle ASM volumes. The value must be set to 11.2 or higher. Before setting this attribute, the COMPATIBLE.ASM value must be

  11.2 or higher The default disk group compatibility settings are 11.2 for Oracle ASM compatibility, 10.1 for database compatibility, and no value for Oracle ADVM compatibility. The disk group compatib- ility settings can only be advanced; you cannot revert to a lower compatibility setting. Oracle Database Storage Administrator's Guide

• Question 97:

  Your production environment cluster is running Oracle Enterprise Linux and currently has four nodes. You are asked to plan for extending the cluster to six nodes. Which three methods are available to add the new nodes?

  A. silent cloning using crsctl clone cluster and ssh
  B. a GUI interface from Enterprise Manager
  C. with the Oracle Universal Installer using runInstaller clone
  D. silent cloning using perl clone.plsilent either with parameters in a file or in line
  E. using addNode.sh
  B. a GUI interface from Enterprise Manager
  D. silent cloning using perl clone.plsilent either with parameters in a file or in line
  E. using addNode.sh

  ---

  Login to the Enterprise Manager Grid Control Console. Click on the "Deployments" tab. Under the "Deployments" --> "General" --> "Cloning" section, click on "Clone Oracle Home". "Clone Oracle Home: Source Home" page allows us to select the Oracle Home we want to clone. Once the selection has been made, click on "Next" to proceed. You can also use cloning to add nodes to a cluster. Prepare Node 2. Run the clone.pl script located in the Grid_home/clone/bin directory on Node 2. To set up the new Oracle Clusterware environment, the clone.pl script requires you to provide several setup values for the script. You can provide the variable values by either supplying input on the com- mand line when you run the clone.pl script, or by creating a file in which you can assign values to the cloning variables. To extend the Grid Infrastructure home to the node3, navigate to the Grid_home/oui/bin directory on node1 and run the addNode.sh script

• Question 98:

  The Global Cache Block Access Latency chart shows high elapsed times. What are two possible causes for this?

  A. badly written SQL statements
  B. storage network bottlenecks
  C. a large number of requested blocks not cached in any instance
  D. slow or faulty interconnect
  A. badly written SQL statements
  D. slow or faulty interconnect

  ---

  About Global Cache Block Access Latency Chart

  If the Global Cache Block Access Latency chart shows high latencies (high elapsed times), then this can be caused by any of the following:

  A high number of requests caused by SQL statements that are not tuned. A large number of processes in the queue waiting for the CPU, or scheduling delays. Slow, busy, or faulty interconnects. In these cases, check your network

  connection for dropped packets, retransmittals, or cyclic redundancy check (CRC) errors. Oracle?Database 2 Day + Real Application Clusters Guide 11g Release 2 (11.2)

• Question 99:

  ETH0 is the public interface on all your RAC nodes.

  ETH1 is the private interface on all your RAC nodes for use with the cluster interconnect. ETH2 is used on all the RAC nodes for accessing storage on a filer using network attached storage (NAS).

  With which interface are the SCAN and node VIPs (Virtual IP addresses) associated?

  A. ETH0 for the node VIPs and ETH1 for the SCAN VIPs
  B. ETH0 for both the node VIPs and the SCAN VIPs
  C. ETH1 for both the node VIPs and the SCAN VIPs
  D. ETH1 for the node VIPs and ETH0 for the SCAN VIPs
  E. with both ETH0 and ETH1 for both the node VIPs and the SCAN VIPs
  B. ETH0 for both the node VIPs and the SCAN VIPs

  ---

  2.7.2 IP Address Requirements

  Before starting the installation, you must have at least two interfaces configured on each node:

  One for the private IP address and one for the public IP address. You can configure IP addresses with one of the following options:

  Dynamic IP address assignment using Oracle Grid Naming Service (GNS). If you select this option, then network administrators assign static IP address for the physical host name and dynamically allocated IPs for the Oracle Clusterware

  managed VIP addresses. In this case, IP addresses for the VIPs are assigned by a DHCP and resolved using a multicast domain name server configured as part of Oracle Clusterware within the cluster. If you plan to use GNS, then you must

  have the following:

  -A DHCP service running on the public network for the cluster

  - Enough addresses on the DHCP to provide 1 IP address for each node's virtual IP, and 3 IP addresses for the cluster used by the Single Client Access Name (SCAN) for the cluster

  Static IP address assignment. If you select this option, then network administrators assign a fixed IP address for each physical host name in the cluster and for IPs for the Oracle Clusterware managed VIPs. In addition, domain name server (DNS) based static name resolution is used for each node. Selecting this option requires that you request network administration updates when you modify the cluster.

  Note: Oracle recommends that you use a static host name for all server node public hostnames. Public IP addresses and virtual IP addresses must be in the same subnet. Oracle only supports DHCP-assigned networks for the default network, not for any subsequent networks. Oracle?Grid Infrastructure Installation Guide 11g Release 2 (11.2) for Linux

• Question 100:

  Under which account(s) can the Oracle Clusterware processes run for the Linux platform?

  A. only the root account
  B. only the Grid Infrastructure owner account
  C. only the database software owner account
  D. some under the Grid Infrastructure owner account and some under the root account
  E. some under the database software owner account and some under the root account
  D. some under the Grid Infrastructure owner account and some under the root account

  ---

  Because Oracle Clusterware works closely with the operating system, system administrator priv- ileges are required for some installation tasks. In addition, some Oracle Clusterware processes must run as the special operating system user, root. Oracle Database 2 Day + Real Application Clusters Guide