Oracle 1Z0-593 Online Practice Questions and Exam Preparation

Oracle 1Z0-593 Online Questions & Answers

• Question 31:

  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

• Question 32:

  When can a wildcard character be used to change a directory with the ASMCMD CD command?

  A. Always
  B. If the wildcard character causes a match to a single directory
  C. If the wildcard character causes a match to multiple directories
  D. Never
  B. If the wildcard character causes a match to a single directory

  ---

  *

  If a wildcard pattern matches only one directory when using wildcard characters with cd, then cd changes the directory to that destination. If the wildcard pattern matches multiple directories, then ASMCMD does not change the directory but

  instead returns an error.

  *

  The wildcard characters * and % match zero or more characters anywhere within an absolute or relative path, which saves typing of the full directory or file name. The two wildcard characters behave identically. There are various ASMCMD

  commands that accept wildcards. These include cd, du, find, ls, lsattr, lsdg, lsdsk, lsgrp, lsusr, and rm.

  Note: ASMCMD is a command-line utility that you can use to manage Oracle ASM instances, disk groups, file access control for disk groups, files and directories within disk groups, templates for disk groups, and volumes.

  You can run the ASMCMD utility in either interactive or noninteractive mode. Reference: About ASMCMD, Wildcard Characters

• Question 33:

  List the two granularity levels supported by the Cluster Verification Utility (CVU).

  A. Component
  B. Stage
  C. Composite
  D. CVU only supports one level; just run it
  E. Object
  A. Component
  B. Stage

  ---

  A:

  *

  Use component mode to diagnose components after ClusterWare installation.

  *

  To verify the minimal system requirements on the nodes prior to installing Oracle Clusterware or Oracle RAC, use the sys component verification command as follows: cluvfy comp sys [ -n node_list ] -p { crs | database } } [-r { 10gR1 | 10gR2 | 11gR1} ] [ -osdba osdba_group ] [ -orainv orainventory_group ] [-verbose]

  B:

  * * Use stage mode during installation/upgrade

  * To verify whether your system meets all of the criteria for an Oracle Clusterware installation, use the -pre crsinst command for the Oracle Clusterware installation stage as follows:

  cluvfy stage -pre crsinst -n node_list

  [ -c ocr_location ] [-r { 10gR1 | 10gR2 | 11gR1} ][ -q voting_disk ] [ -osdba osdba_group ] [ -orainv orainventory_group ] [-verbose]

• Question 34:

  Which step will you have to perform on Windows to restore the OCR that you did not do on Linux?

  A. Identify existing backups with the -backup option
  B. Use the Service Control Panel to stop services
  C. Review the contents of the backup with the ocrdump command
  D. Make sure that the restored OCR files are valid
  B. Use the Service Control Panel to stop services

  ---

  See step 2) below.

  Restoring the Oracle Cluster Registry on Windows-Based Systems

  Use the following procedure to restore the OCR on Windows-based systems:

  1.

  Identify the OCR backups using the ocrconfig -showbackup command. Review the contents of the backup using ocrdump -backupfilefile_name where file_name is the name of the backup file.

  2.

  On all of the remaining nodes, disable the following OCR clients and stop them using the Service Control Panel: OracleClusterVolumeService,OracleCSService, , and the OracleEVMService. OracleCRService

  3.

  Execute the restore by applying an OCR backup file that you identified in Step 1 with the ocrconfig - restore file name command. Make sure that the OCR devices that you specify in the OCR configuration exist and that these OCR devices are valid.

  4.

  Start all of the services that were stopped in step 2. Restart all of the nodes and resume operations in cluster mode.

  5.

  Run the following command to verify the OCR integrity where the -n all argument retrieves a listing of all of the cluster nodes that are configured as part of your cluster:

  cluvfy comp ocr -n all [-verbose]

  Note:

  Restoring the Oracle Cluster Registry on UNIX-Based Systems

  Use the following procedure to restore the OCR on UNIX-based systems:

  1.

  Identify the OCR backups using the ocrconfig -showbackup command. Review the contents of the backup using ocrdump -backupfilefile_name where file_name is the name of the backup file.

  2.

  Stop Oracle Clusterware on all the nodes in your Oracle RAC cluster by running the following command as root:

  3.

  # crsctl stop crs

  Repeat this command on each node in your Oracle RAC cluster.

  Note:

  Prior to running the crsctl start crs command in step 4, run the following except init.cssd fatal are inactive:

  command to verify that all processes

  ps -ef|grep cssd

  4.

  Perform the restore by applying an OCR backup file that you identified in Step 1 using the following command where file_name is the name of the OCR that you want to restore. Make sure that the OCR devices that you specify in the OCR

  configuration exist and that these OCR devices are valid before running this command.

  5.

  ocrconfig -restore file_name

  6.

  Start Oracle Clusterware on all the nodes in your Oracle RAC cluster by running the following command as root:

  7.

  # crsctl start crs

  Repeat this command on each node in your Oracle RAC cluster.

  8.

  Run the following command to verify the OCR integrity where the -n all argument retrieves a listing of all of the cluster nodes that are configured as part of your cluster:

  9.

  cluvfy comp ocr -n all [-verbose]

  Reference: Oracle Database Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide

• Question 35:

  Multipathing software_________.

  A. cannot improve system availability
  B. cannot improve system performance
  C. is inherently built into all storage products
  D. is supported by ASM
  D. is supported by ASM

  ---

  Although ASM is not designed with multipathing functionality, ASM does operate with multipathing technologies. Multipathing technologies are available from many sources. Storage vendors offer multipathing products to support their specific storage products, while software vendors usually develop multipathing products to support several server platforms and storage.

  Note:

  * Multipathing solutions provide failover by using redundant physical path components. These components include adapters, cables, and switches that reside between the server and the storage subsystem. If one or more of these components fails, then applications can still access their data, eliminating a single point of failure with the Storage Area Network (SAN), Host Bus Adapter, interface cable, or host port on a multiported storage array.

  Reference: Oracle Database Storage Administrator's Guide, ASM and Multipathing

• Question 36:

  You are preparing for a Grid Infrastructure and Oracle Database (with the RAC option) installation.

  Which two network requirements must be met?

  A. All IP addresses planned to be used for the public or the private network should be unused.
  B. All IP addresses for the public and the private network should be in the same subnet
  C. All IP addresses should be registered in DNS.
  D. The IP addresses for the SCAN-IPs (part of SCAN) need to be in the same subnet as the node VIPs.
  C. All IP addresses should be registered in DNS.
  D. The IP addresses for the SCAN-IPs (part of SCAN) need to be in the same subnet as the node VIPs.

  ---

  C: * On each node in the cluster, assign a public IP address with an associated network name to one network adapter. The public name for each node should be registered with your domain name system (DNS).

  D: During installation a SCAN for the cluster is configured, which is a domain name that resolves to all the SCAN addresses allocated for the cluster. The IP addresses used for the SCAN addresses must be on the same subnet as the VIP addresses.

  Note:

  * To perform a typical installation, which does not use GNS. You must configure the following addresses manually in your corporate DNS:

  A public IP address for each node A virtual IP address for each node Three single client access name (SCAN) addresses for the cluster

  Reference: Preparing Your Cluster, Preparing Your Cluster

• Question 37:

  You are creating a RAC database with DBCA. Which of these is NOT a main area of initialization parameters you can configure as part of the process?

  A. Memory
  B. page size
  C. Character set
  D. Connection mode
  B. page size

  ---

  The Initialization Parameters page appears. By default, the Initialization Parameters page shows only the basic parameters, and only enables you to change the parameter file definition if you are using raw storage. Each tab on the Initialization Parameters page provides different sets of information that you can add or modify as follows:

  a.

  Memory Tab.

  b.

  Sizing Tab: Use this page to select the database standard block size and process count.

  c.

  Character Sets Tab: Use this page to set the database character set value.

  d.

  Connection Mode Tab: You can use this tab to select either dedicated or shared database connections to your database.

  e.

  Parameter File Tab: This tab will only appear if you are using raw storage. Use this tab to enter a raw device name for the location of the server parameter file.

  Reference: Oracle Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide 10g Release 2 (10.2) for Microsoft Window, Creating an Oracle Real Application Clusters Database with DBCA

• Question 38:

  Which two privileged operating system groups should be defined during the installation of the Oracle Database software (with the RAC option)?

  A. Database Administrator group
  B. Database Operator group
  C. System Administrator group
  D. ASM administrator group
  E. System Architect group
  A. Database Administrator group
  B. Database Operator group

  ---

  The following O/S groups will be created: Database Administrator Database Operator Oracle Inventory and Software Owner Oracle Automatic Storage Management Group ASM Database Administrator Group ASM Operator Group

• Question 39:

  Which two options are checked by the Oracle Universal Installer, when you first install Oracle Software on a system?

  A. if the OFA-compliant path is available
  B. oraInst.loc should exist
  C. that the user running the installation has permissions to write to the designated path
  D. that you are running OUI as a DBA user
  A. if the OFA-compliant path is available
  B. oraInst.loc should exist

  ---

  A:

  *

  When installing an OFA-compliant database using Oracle Universal Installer, ORACLE_BASE is set to / pm/app/oracle by default.

  *

  All Oracle products on CD-ROM are OFA-compliant; that is, Oracle Universal Installer places Oracle products in directory locations that follow OFA guidelines

  B: Every Oracle software installation has an associated Central Inventory where the details of all the Oracle products installed on a host are registered. The Central Inventory is located in the directory that the inventory pointer file specifies. Each Oracle software installation has its own Central Inventory pointer file that is unknown to another Oracle software installation.

  Default Inventory Pointer File Locations

  Platform Default Inventory Pointer Location Linux LinuxPPC /etc/oraInst.loc AIX /etc/oraInst.loc Solaris SPARC HPUX-IA64 HPUX-PARISC /var/opt/oracle/oraInst.loc Windows Windows.X64 Windows.IA64 HKEY_LOCAL_MACHINE/Software/Oracle/inst.loc

• Question 40:

  Which two requests can be fulfilled with the oifcfg getif command?

  A. Identifying the public network interface
  B. Verifying the proper format for network interface names
  C. Obtaining local and global configuration settings
  D. Identifying the cluster_interconnect interface
  A. Identifying the public network interface
  D. Identifying the cluster_interconnect interface

  ---

  * oifcfg getif

  Displays the interfaces for which an interface type has been defined with the setif command, along with the type for that interface.

  * Example Retrieving Network Information

  You can also retrieve specific OIFCFG information with a getif command.

  oifcfg getif [ [-global | -node nodename] [-if if_name[/subnet]] [-type if_type] ] For example, after you install Oracle Clusterware, you can verify that the public and cluster interconnect have been set to the desired values by entering the following

  commands as root:

  $ oifcfg getif

  This command should return values for global public and global cluster_interconnect. For example:

  en0 144.25.68.0 global public

  hme0 139.185.141.0 global cluster_interconnect