Oracle 1Z0-593 Online Practice Questions and Exam Preparation

Oracle 1Z0-593 Online Questions & Answers

• Question 21:

  Which command can be used to modify and configure voting files?

  A. crsctl add votedisk . . .
  B. crsctl add css votedisk . . .
  C. crsctl query css votedisk
  D. You cannot modify voting disks if the cluster is down.
  B. crsctl add css votedisk . . .

  ---

  Add a voting disk, as follows:

  $ crsctl add css votedisk path_to_voting_disk

  Note:

  * You can manage and monitor OCR and voting files with the following:

  / The CRSCTL and ocrconfig command-line tools

  The CRSCTL and ocrconfig commands enable the placement of OCR storage and Cluster Synchronization Services (CSS) voting files inside the disk groups managed by Oracle ASM.

  /CREATE/ALTER DISKGROUP SQL Statements

  / V$ASM views

  Incorrect:

  Not C: To display the voting disk FUID and file path of each current voting disk, run the crsctl query css votedisk command to display output similar to the following:

  $ crsctl query css votedisk

  ## STATE File Universal Id File Name Disk group

  1. ONLINE 7c54856e98474f61bf349401e7c9fb95 (/dev/sdb1) [DATA]

• Question 22:

  Which three items can be stored on the ACFS (Oracle ASM Cluster File System)?

  A. Oracle Database Homes (shared home approach)
  B. Any type of application-related configuration or log files
  C. The Oracle Grid Infrastructure Home
  D. Oracle Backup Sets (RMAN backup sets)
  A. Oracle Database Homes (shared home approach)
  B. Any type of application-related configuration or log files
  D. Oracle Backup Sets (RMAN backup sets)

  ---

  Oracle ASM Cluster File System (ACFS) is a general purpose cluster file system implemented as part of ASM. It can be used to store almost anything, including the database executables. The only things that should not be stored in ACFS are the Grid Infrastructure home and any Oracle files that can be directly stored in Oracle ASM.

  Reference: Oracle ASM Cluster File Systems (ACFS) in Oracle Database 11g Release 2

• Question 23:

  Which tool can be used to specify network interfaces and to retrieve component configuration information?

  A. CVU
  B. SRVCTL
  C. CRSCTL
  D. OIFCFG
  D. OIFCFG

  ---

  The Oracle Interface Configuration (OIFCFG) command-line interface helps you to define and administer network interfaces. You can issue OIFCFG commands in single-instance and Oracle Clusterware environments to:

  Allocate and deallocate network interfaces to components Direct components to use specific network interfaces Retrieve component configuration information

  Reference: Oracle Interface Configuration (OIFCFG) Command Reference

• Question 24:

  What is the difference between running the CVU in stage mode and component mode?

  A. Stage mode checks all nodes automatically.
  B. Component mode is used for an individual node prior to Installation.
  C. Component mode requires a list of nodes, whereas stage mode does not.
  D. Component mode is designed to be run after a database is installed with RAC and is active
  D. Component mode is designed to be run after a database is installed with RAC and is active

• Question 25:

  Which OCRCONFIG command backs up the OCR to the -backuploc location?

  A. overwrite
  B. backuploc pathname
  C. manualbackup
  D. export
  C. manualbackup

  ---

  ocrconfig -manualbackup

  Use the ocrconfig -manualbackup command to back up OCR on demand in the location you specify with the -backuploc option.

  Incorrect:

  Not C: This command just defines the backuploc location.

  ocrconfig -backuploc

  Use the ocrconfig -backuploc command to specify an OCR backup directory location.

  Syntax ocrconfig [-local] -backuploc file_name Example

  To specify an OCR backup location in a directory: # ocrconfig -backuploc $Grid_home/cdata/cluster3 Reference: Oracle Cluster Registry Utility Reference

• Question 26:

  Which two statements about the Single Client Access Name (SCAN) feature are correct?

  A. In typical Grid Infrastructure Installation, the SCAN name defaults to the cluster name
  B. A SCAN listener runs on every cluster node
  C. SCAN is available with any version of Oracle 11g RAC
  D. SCAN provides location Independence of Oracle RAC databases in the cluster
  A. In typical Grid Infrastructure Installation, the SCAN name defaults to the cluster name
  B. A SCAN listener runs on every cluster node

  ---

  SCAN components in a cluster:

  SCAN Name

  SCAN IP, Oracle recommends 3 IP addresses for SCAN for a cluster SCAN Listener

  SCAN Name will represent the cluster in the network. SCAN Name needs to be registered in DNS and resolved using round-robin

  algorithm. To test the round-robin algorithm, perform nslookup on the SCAN Name. The DNS server should return those 3 set of IP

  Address in different order each time

  Incorrect:

  Not C: Only from R2:

  Prior to Oracle 11g R1 RAC, client connection to RAC Cluster will use each node VIP (virtual IP) address.

  So each

  time a node is added to the cluster, the client tnsnames.ora file needs to be updated with the new VIP addition.

  Oracle 11g R2 RAC introduces SCAN (Single Client Access Name) to handle that problem. SCAN provides single

  name from clients to access the database running in the cluster.

• Question 27:

  Choose two options that are not suitable for shared storage in a RAC 11g Release 2 database created using DBCA.

  A. Block device
  B. Raw device
  C. ASM
  D. CFS
  A. Block device
  B. Raw device

  ---

  Before you use DBCA to convert a single-instance database to an Oracle RAC or an Oracle RAC One Node database, ensure that your system meets the following conditions:

  / It is a supported hardware and operating system software configuration.

  / It has shared storage: either Oracle Cluster File System (CFS) (not D) or Oracle ASM (not C) is available and accessible from all nodes. On Linux on POWER systems, ensure that GPFS is available and accessible from all nodes.

  / Your applications have no design characteristics that preclude their use with cluster database processing.

  Note:

  * DBCA (Database Configuration Assistant) is a utility used for creating, configuring and removing Oracle Databases. Reference: Creating Oracle Real Application Clusters Databases with Database Configuration Assistant Reference: Converting to Oracle RAC and Oracle RAC One Node with DBCA

• Question 28:

  Which two statements about the SRVCTL utility are correct?

  A. SRVCTL must be run from the RAC database ORACLE_HOME/bin directory when used to manage that dababase.
  B. The SRVCTL command cannot be used to manage Oracle Grid Infrastructure.
  C. Every command requires an object on which to operate.
  D. A comma-delimited list should be enclosed in single quotes.
  A. SRVCTL must be run from the RAC database ORACLE_HOME/bin directory when used to manage that dababase.
  C. Every command requires an object on which to operate.

  ---

  A: Always use SRVCTL from the Oracle_home of the database that you are administering.

  C: SRVCTL expects the following command syntax:

  srvctl command object options

  Incorrect:

  Not B: Guidelines for Using SRVCTL in Oracle Real Application Clusters Not D: On the Windows platform, when specifying a comma-delimited list, you must enclose the list within double-quotes ("...,...").

• Question 29:

  Which two answers are correct with respect to Oracle cluslerware configuration files and their purpose?

  A. OCR records the cluster configuration.
  B. OCR records the number of instances.
  C. OCR records the number of databases.
  D. A voting disk records the node membership information.
  E. A voting disk records the cluster configuration.
  F. A voting disk records the number of instances.
  A. OCR records the cluster configuration.
  D. A voting disk records the node membership information.

  ---

  Oracle Clusterware requires two configuration files: a voting disk to record node membership information and the OCR to record cluster configuration information. Reference: Oracle Clusterware Administration and Deployment Guide

• Question 30:

  Which two statements are true regarding the functionality of the remap command in ASMCMD?

  A. It repairs blocks by always reading them from the mirror copy and writing them to the original location.
  B. It repairs blocks that have read disk I/O errors.
  C. It checks whether the alias metadata directory and the- file directory are linked correctly.
  D. It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate location on disk if the blocks on the original location cannot be read properly.
  B. It repairs blocks that have read disk I/O errors.
  D. It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate location on disk if the blocks on the original location cannot be read properly.

  ---

  *

  remap Purpose Marks a range of blocks as unusable on the disk and relocates any data allocated in that range.

  *

  remap Command

  The remap command only relocates blocks. It does not correct or repair blocks that contain corrupted contents. The command uses a physical block size based on the disk group attribute. SECTOR_SIZE Purpose Repairs a range of physical blocks on a disk. The remap command only repairs blocks that have read disk I/O errors. It does not repair blocks that contain corrupted contents, whether or not those blocks can be read. The command assumes

  a physical block size of 512 bytes and supports all allocation unit sizes (1 to 64 MB).