Oracle 1Z0-058 Online Practice Questions and Exam Preparation

Oracle 1Z0-058 Online Questions & Answers

• Question 131:

  You want to check an ACFS for consistency on the Linux platform. Which command-line tool would you use to do this?

  A. advmutil
  B. asmcmd
  C. fsck
  D. acfsutil
  E. fdisk
  C. fsck

  ---

  Dismounting an Oracle ACFS File System

  You can dismount a file system without deregistering the file system or disabling the volume on which the file system is mounted.

  For example, you can dismount a file system and run fsck to check the file system.

  # /bin/umount /u01/app/acfsmounts/myacfs

  # /sbin/fsck -a -v -y -t acfs /dev/asm/volume1-123

  After you dismount a file system, you must explicitly mount the file system.

  1.

  Use umount on Linux systems or acfsdismount on Windows systems. For information about the commands to dismount a file system, see "umount" or "acfsdismount".

  2.

  Use fsck on Linux systems or acfschkdsk on Windows systems to check a file system. For information about the commands to check a file system, see "fsck" or "acfschkdsk".

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

• Question 132:

  Which two Cluster ware stack administration actions must be performed as the root user?

  A. checking the health of the Clusterware on one node
  B. starting the Clusterware manually on one node
  C. disabling the Clusterware from automatic start at node reboot
  D. checking the health and viability of the Clusterware on all nodes
  E. listing the location of the voting disks
  B. starting the Clusterware manually on one node
  C. disabling the Clusterware from automatic start at node reboot

  ---

  Controlling Oracle Clusterware The crsctl utility can be used to control Oracle Clusterware. To start or stop Oracle Clusterware on a specific node: # crsctl start crs # crsctl stop crs To enable or disable Oracle Clusterware on a specific node: # crsctl enable crs # crsctl disable crs

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

• Question 133:

  You are in the planning stages for upgrading your Oracle RAC database from Oracle Database 10g Release 2 to Oracle Database 11g Release 2 to run under the Oracle Grid Infrastructure. You decide to use an administrator-managed configuration because the cluster is fairly small. Which statement is correct about this configuration?

  A. A parent pool of the GENERIC server pool will be used.
  B. You must define a new server pool called MANUAL.
  C. A subpool of the GENERIC server pool will be used.
  D. A subpool of the FREE server pool will be used.
  C. A subpool of the GENERIC server pool will be used.

  ---

  With Oracle RAC 11g Release 2, there is only a database resource define to Oracle Clusterware. This resource will contain the Oracle Home, the spfile, the server pool(s) and the ASM diskgroup(s) required for the database. The database resource will have a weak start dependency on the VIP which means it will try to start the VIP for the node when the instance starts however if the VIP does not start successfully, the instance will still be started. When reviewing the data- base resource for an administrator Managed database, you will see a server pool defined with the same name as the Oracle database. This pool will be part of a special Oracle defined server pool called Generic. The Generic server pool is managed by Oracle to support Administrator Man- aged databases. The server pools that are part of Generic will be automatically created or re- moved when you add or remove an Administrator Managed database. Oracle Database 11gR2 Upgrade Companion (Version 2.70)

• Question 134:

  Which three statements define a cluster?

  A. is a group of independent, but interconnected computers that act as a single system
  B. can be deployed to increase availability and performance
  C. can be deployed to balance a dynamically changing workload
  D. should appear to an application as multiple servers
  A. is a group of independent, but interconnected computers that act as a single system
  B. can be deployed to increase availability and performance
  C. can be deployed to balance a dynamically changing workload

  ---

  Oracle Real Application Clusters Oracle Real Application Clusters (Oracle RAC) is a database clustering technology whose shared storage capabilities allow multiple machines to work in parallel on the same data, reducing processing time significantly. Oracle RAC also offers resilience, al- lowing processing to continue in the event of one or more machines being unavailable be- cause of planned or unplanned downtime. Computer cluster A computer cluster consists of a set of loosely connected computers that work together so that in many respects they can be viewed as a single system. The components of a cluster are usually connected to each other through fast local area networks, each node running its own instance on an operating system. Computer clusters emerged as a result of convergence of a number of computing trends including the avail- ability of low cost microprocessors, high speed networks, and software for high perform- ance distributed computing. Clusters are usually deployed to improve performance and availability over that of a single computer, while typically being much more cost-effective than single computers of comparable speed or availability

• Question 135:

  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 ctsctl 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 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 Services 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 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 RACNODE3 is considered to be part of the cluster, but the Cluster Ready Services Daemon (CRSD) is currently not running.

  ---

  

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

• Question 136:

  Examine the following output:

  [oracle@gr5153~]$srvctl add service -d RACDB -s erp -g pool1 -c uniform -y manual [oracle0gr5153~]$srvctl start service -d RACDB -s ERP [oracle@gr5153~]$crsctl stat res ora.racdb.erp.svc NAME=ora.racdb.erp.svc TYPE=ora.service.type TARGET=ONLINE, ONLINE, ONLINE STATE=ONLINE on gr5118, ONLINE on gr5152, ONLINE on gr5153 [oracle@gr5153~]$ srvctl config database -d RACDB Database unique name: RACDB Database name: RACDB Oracle home:/u01/app/oracle/product/11.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:POOL 1 Database instances: Disk Groups:DATA, FRA Services:ERP Database is policy managed $srvctl stop database -d RACDB -o immediate

  Which two statements are true regarding the srvctl stop command?

  A. It will shut down all the instances of the RACDB database.
  B. It will shut down only the RACDB instance and the ERP service on the node on which the Command is executed.
  C. It will shut down only the database instance on the node on which the command is executed.
  D. It will stop the ERP service related to the RACDB database on all the nodes.
  A. It will shut down all the instances of the RACDB database.
  D. It will stop the ERP service related to the RACDB database on all the nodes.

  ---

  Shut down all Oracle RAC instances on all nodes. To shut down all Oracle RAC instances for a database, enter the following command, where db_name is the name of the database:

  srvctl stop database -d db_name

  Stops a database, its instances, and its services. When the database later restarts, services with AUTOMATIC management start automatically but services with MANUAL management policy must be started manually.

  Oracle Real Application Clusters Administration and Deployment Guide

• Question 137:

  Which two actions in a warehousing RAC database may cause concurrent cross-instance calls leading to I/ O contention?

  A. truncate table statements
  B. select statements referring to non-partitioned tables
  C. drop table statements
  D. insert statements where each instance inserts into different partitions of a partitioned table
  A. truncate table statements
  C. drop table statements

  ---

  Concurrent Cross-Instance Calls: Considerations In data warehouse and data mart environments, it is not uncommon to see a lot of TRUNCATE operations. These essentially happen on tables containing temporary data. In a RAC environment, truncating tables concurrently from different instances does not scale well, especially if, in conjunction, you are also using direct read operations such as parallel queries. As shown in the slide, a truncate operation requires a cross-instance call to flush dirty blocks of the table that may be spread across instances. This constitutes a point of serialization. So, while the first TRUNCATE command is processing, the second has to wait until the first one completes. There are different types of cross-instance calls. However, all use the same serialization mechanism. For example, the cache flush for a partitioned table with many partitions may add latency to a corresponding parallel query. This is because each cross-instance call is serialized at the cluster level, and one crossinstance call is needed for each partition at the start of the parallel query for direct read purposes.

  D60488GC11 Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 14 27

  What Application Design considerations should I be aware of when moving to Oracle RAC? The general principals are that fundamentally no different design and coding practices are required for RAC however application flaws in execution or design have a higher impact in RAC. The performance and scalability in RAC will be more sensitive to bad plans or bad schema design. Serializing contention makes applications less scalable. If your customer uses standard SQL and schema tuning, it solves > 80% of performance problems Some of the scaleability pitfalls they should look for are:

  *

  Serializing contention on a small set of data/index blocks --> monotonically increasing key --> frequent updates of small cached tables

  --> segment without automatic segment space management (ASSM) or Free List Group (FLG)

  *

  Full table scans

  --> Optimization for full scans in 11g can save CPU and latency

  *

  Frequent invalidation and parsing of cursors

  --> Requires data dictionary lookups and synchronizations

  *

  Concurrent DDL ( e.g. truncate/drop )

  Look for:

  *

  Indexes with right-growing characteristics

  --> Use reverse key indexes

  --> Eliminate indexes which are not needed

  *

  Frequent updated and reads of "small" tables

  --> "small"=fits into a single buffer cache

  --> Use Sparse blocks ( PCTFREE 99 ) to reduce serialization

  *

  SQL which scans large amount of data

  --> Perhaps more efficient when parallelized

  --> Direct reads do not need to be globally synchronized ( hence less CPU for global cache ) RAC:

  Frequently Asked Questions [ID 220970.1]

• Question 138:

  You need to set up a three-Instance RAC database. The data files and fast recovery area will be stored in ASM diskgroups called +data and +fra, respectively. The ASM disk groups will be mounted on all ASM Instances. Which are the two best location options for archivelogs so that they can be accessed during recovery without DBA intervention?

  A. Cluster File System with each instance writing to a shared location
  B. Cluster File System with each instance writing to a separate location as long as all the locations are in directories under the same mount point
  C. the ASM diskgroup +fra with the db_recovery_file_dest parameter set to the same value on all instances
  D. a raw or block device
  A. Cluster File System with each instance writing to a shared location
  C. the ASM diskgroup +fra with the db_recovery_file_dest parameter set to the same value on all instances

  ---

  The primary consideration when configuring archiving is to ensure that all archived redo logs can be read from every node during recovery, and if possible during backups. During recovery, because the archived log destinations are visible from the node that performs the recovery, Oracle RAC can successfully recover the archived redo log data. The fast recovery area for an Oracle RAC database must be placed on an Oracle ASM disk group, a cluster file system, or on a shared directory that is configured through a network file system file for each Oracle RAC instance. In other words, the fast recovery area must be shared among all of the instances of an Oracle RAC database. The preferred configuration for Oracle RAC is to use Oracle Automatic Storage Management (Oracle ASM) for storing the fast recov- ery area, using a different disk group for your recovery set than for your data files. The location and disk quota must be the same on all instances. Oracle recommends that you place the fast recovery area on the shared Oracle ASM disks. In addition, you must set the DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE parameters to the same values on all instances. Oracle Database 2 Day + Real Application Clusters Guide

• Question 139:

  Identify the three forms of link aggregation that are supported by Oracle Ciusterware for the interconnect.

  A. single switch active/standby configuration to increase redundancy for high availability
  B. single switch active/active configuration to increase bandwidth for performance
  C. multiswitch active/standby configuration to increase redundancy for high availability
  D. multiswitch active/active configuration to increase bandwidth for performance
  A. single switch active/standby configuration to increase redundancy for high availability
  B. single switch active/active configuration to increase bandwidth for performance
  C. multiswitch active/standby configuration to increase redundancy for high availability

  ---

  Interconnect Link Aggregation: Single Switch

  Link aggregation can be used to increase redundancy for higher availability with an Active/Standby configuration. Link aggregation can be used to increase bandwidth for performance with an Active/Active configuration.

  Interconnect Link Aggregation: Multiswitch

  Redundant switches connected with an Inter-Switch Trunk may be used for an enhanced highly available design. This is the best practice configuration for the interconnect.

  With the single switch solutions presented in the previous slide, a failure at the switch level would bring down the entire interconnect. A better highly available (HA) design would be to implement a redundant switch strategy as illustrated in the slide, with an Inter-Switch Trunk connecting the switches. This is the best practice design for the Oracle Clusterware interconnect. Only Active/Standby mode is supported in this configuration.

  D60488GC11 Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 1 - 12,13,14