Oracle 1Z0-593 Online Practice Questions and Exam Preparation

Oracle 1Z0-593 Online Questions & Answers

• Question 61:

  Select two Clusterware administration tasks that must be performed as the root user.

  A. List the location of the voting disks.
  B. Check the health and viability of the Clusterware on all nodes.
  C. Disable the Clusterware from automatic start at node reboot.
  D. Start the Clusterware manually on one node.
  E. Check the health of the Clusterware on one node.
  C. Disable the Clusterware from automatic start at node reboot.
  D. Start the Clusterware manually on one node.

• Question 62:

  You are running ASMCMD in a non Interactive mode. Which statement is correct?

  A. After the specified command has run, you are returned to the ASMCMD prompt.
  B. You cannot run scripts in non Interactive mode ASMCMD
  C. You can have arguments when running ASMCMD in non-interactive mode
  D. You always run ASMCMD from the ASM home directory when running in non-interactive mode
  A. After the specified command has run, you are returned to the ASMCMD prompt.

  ---

  In noninteractive mode, you run a single ASMCMD command by including the command and command options on the command line when invoking ASMCMD. ASMCMD runs the command, generates output if any, and then exits.

  Incorrect:

  Not B: The noninteractive mode is especially useful for running scripts.

• Question 63:

  Which command lists all the service-related information for the specified service? (crmdb is the cluster database name and crms is the service name)

  A. #crsctl config services d cmdb s crms
  B. #srvctl config service d cmdb s crms
  C. #srvctl getenv service d crmdb s crms
  D. #crsctl status service d crm s crm v
  B. #srvctl config service d cmdb s crms

  ---

  *

  The srvctl config command displays the Oracle Restart configuration of the specified component or set of components.

  *

  srvctl config service For the specified database, displays the Oracle Restart configuration information for the specified database service or for all database services

  Incorrect: Not C: getenv

  Gets and displays environment variables and their values from the Oracle Restart configuration for a database, listener, or Oracle ASM instance.

  srvctl getenv Summary

  Command Description

  *

  srvctl getenv asm Displays the configured environment variables for the Oracle ASM instance

  *

  srvctl getenv database Displays the configured environment variables for the specified database instance

  *

  srvctl getenv listener Displays the configured environment variables for the specified listener Reference: SRVCTL Command Reference for Oracle Restart

• Question 64:

  What does the Oracle Validated Configuration RPM do?

  A. Configures parameters and adds new packages, where necessary
  B. Validates hardware configuration for RAC
  C. Performs cluster integrity checks
  D. Installs pre-validated Oracle Database and Grid Infrastructure software
  D. Installs pre-validated Oracle Database and Grid Infrastructure software

  ---

  The Oracle-Validated rpm automatize the install of the numerous components required to setup OCW and RAC on Linux, and execute most of the required OS configuration steps.

• Question 65:

  Is not a valid option for configuring redundancy for ASM disk groups?

  A. Internal
  B. Normal
  C. High
  D. External
  A. Internal

  ---

  There are three types of disk groups based on the ASM redundancy level. he redundancy levels are:

  *

  External redundancy

  ASM does not provide mirroring redundancy and relies on the storage system to provide RAID functionality. Any write error cause a forced dismount of the disk group. All disks must be located to successfully mount the disk group.

  *

  Normal redundancy

  ASM provides two-way mirroring. By default all files are mirrored so that there are two copies of every data extent. A loss of one ASM disk is tolerated.

  *

  High redundancy

  ASM provides triple mirroring by default. A loss of two ASM disks in different failure groups is tolerated.

  Reference: Oracle Database Storage Administrator's Guide, ASM Mirroring and Disk Group Redundancy

• Question 66:

  You want to install Grid Infrastructure for a cluster and the Oracle Database software (with the RAC option). Do you need SSH user equivalency?

  A. Yes, to ensure security during the installation.
  B. Yes, to set up administrative privileges for the DBA.
  C. Yes, to allow the use of SSH and SCP without being prompted for a pass phrase.
  D. No, you don't need SSH user equivalency.
  C. Yes, to allow the use of SSH and SCP without being prompted for a pass phrase.

  ---

  During the installation of Oracle RAC, OUI needs to copy files to and execute programs on the other nodes in the cluster. In order to allow OUI to do that, you must configure SSH to allow user equivalence. Establishing user equivalence with SSH provides a secure means of copying files and executing programs on other nodes in the cluster without requiring password prompts.

• Question 67:

  Identify three valid storage options for the OCR and voting disk for it new installation of Infrastructure 11g Release 2.

  A. A certified Cluster File System (CFS)
  B. A certified Network File System (NFS)
  C. ASM Cluster File System (ACFS)
  D. Automatic Storage Management (ASM)
  E. Shared disk slices (block or raw devices)
  A. A certified Cluster File System (CFS)
  B. A certified Network File System (NFS)
  D. Automatic Storage Management (ASM)

  ---

  Reference: General Storage Considerations for Oracle Grid Infrastructure

• Question 68:

  Which statement about the Oracle Grid Infrastructure Home is correct?

  A. The directory path must be the same as an Oracle Home directory.
  B. The directory path can be different on different nodes.
  C. The directory cannot be created before you install your Oracle software.
  D. To create an Oracle Grid Infrastructure path, ensure that it is in a separate path, and not under an existing Oracle base.
  D. To create an Oracle Grid Infrastructure path, ensure that it is in a separate path, and not under an existing Oracle base.

  ---

  D: If you choose to create an Oracle grid infrastructure home manually, then do not create the Oracle grid infrastructure home for a cluster under either the grid installation owner Oracle base or the Oracle Database installation owner Oracle base. Creating an Oracle Clusterware installation in an Oracle base directory will cause succeeding Oracle installations to fail.

  / Requirements for Creating an Oracle Grid Infrastructure Home Directory

  During installation, you are prompted to provide a path to a home directory to store Oracle grid infrastructure software. Ensure that the directory path you provide meets the following requirements:

  *

  (not a) It should be created in a path outside existing Oracle homes, including Oracle Clusterware homes.

  *

  It should not be located in a user home directory.

  *

  It should be created either as a subdirectory in a path where all files can be owned by root, or in a unique path.

  *

  (not C) If you create the path before installation, then it should be owned by the installation owner of Oracle grid infrastructure (typically oracle for a single installation owner for all Oracle software, or grid for role-based Oracle installation owners), and set to 775 permissions.

• Question 69:

  You are creating an Oracle Cluster database using DBCA. The "Memory size (SGA and PGA)" field is supplied on value of 2000 MB. The default Block used for the database is __________.

  A. 2 KB
  B. 4 KB
  C. 8 KB
  D. 16 KB
  E. 32 KB
  C. 8 KB

  ---

  Note:

  * In the Block Size list, enter the size in bytes or accept the default. Oracle Database data is stored in these blocks. One data block corresponds to a specific number of bytes of physical space on disk. While using pre-defined templates, this field is not enabled since the database will be created with the default block size of 8 KB. But while using the custom option, you can change block size. Selecting a block size other than the default 8 KB value requires advanced knowledge and should only be done when absolutely required.

• Question 70:

  Which step must you take before restoring from an OCR backup?

  A. Set the proper directory with the -backuploc option
  B. Identify the existing backups with the -backup option
  C. Review the contents of the backup with the ocrdump command
  D. Stop Oracle Clusterware on all nodes
  D. Stop Oracle Clusterware on all nodes

  ---

  For recovering OCR from physical automated backup needs all cluster, RAC instances and RAC database bring down before performing recovery of OCR. Here you can find out command reference for Recovery of OCR from physical backup copy.

  $ocrconfig -showbackup $srvctl -stop database -d RACDB (Shutdown all RAC instances and RAC database) $crsctl stop crs (Shutdown Cluster) #rm -f /u01/oradata/racdb/OCRFile #cp /dev/null /u01/oradata/racdb/OCRFile #chown root /u01/oradata/racdb/OCRFile #chgrp oinstall /u02/oradata/racdb/OCRFile #chmod 640 /u01/oradata/racdb/OCRFile #ocrconfig -restore /u02/apps/crs/cdata/crs/backup00.ocr $crsctl start crs (After issuing start cluster check status of cluster using 'crs_stat -t') $srvctl start database - d RACDB (Start Oracle RAC database and RAC instances)

  Reference: How to Recover OCR from PHYSICAL Backup?