Oracle 1Z0-593 Online Practice Questions and Exam Preparation

Oracle 1Z0-593 Online Questions & Answers

• Question 11:

  Which two storage hardware requirements are correct for Oracle Database 11g Release 2?

  A. Oracle Database home directory needs at least 7.5 GB of disk space.
  B. Oracle Database home directory needs at least 4 GB of disk space.
  C. Grid home directory needs at least 4.5 GB of disk space.
  D. Grid home directory needs at least 1.3 GB of disk space.
  B. Oracle Database home directory needs at least 4 GB of disk space.
  C. Grid home directory needs at least 4.5 GB of disk space.

  ---

  * (Unix) You need at least 5.5 GB of available disk space for the Grid home directory, which includes both the binary files for Oracle Clusterware and Oracle Automatic Storage Management (Oracle ASM) and their associated log files, and at least 4 GB of available disk space for the Oracle Database home directory, or Oracle home directory.

• Question 12:

  ASMLIB is__________.

  A. Used to enhance disk I/O performance
  B. Used to prevent problems with persistant names and permissions after a Linux reboot.
  C. A requirement that manages ASM disks
  D. Used to provide mirroring for ASM disk groups
  A. Used to enhance disk I/O performance

  ---

  ASMLib is an optional support library for the Automatic Storage Management feature of the Oracle Database. Automatic Storage Management (ASM) simplifies database administration and greatly reduces kernel resource usage (e.g. the number of open file descriptors). It eliminates the need for the DBA to directly manage potentially thousands of Oracle database files, requiring only the management of groups of disks allocated to the Oracle Database. ASMLib allows an Oracle Database using ASM more efficient and capable access to the disk groups it is using.

  Reference: Oracle ASMLib

• Question 13:

  How do you enable automatic backup of the OCR?

  A. With the ocrconfig autobackup command
  B. With the ocrconfig -backup command
  C. With the ocrconfig -backuploc command
  D. You don't have to enable this, Oracle Clusterware does it automatically
  D. You don't have to enable this, Oracle Clusterware does it automatically

  ---

  Automatic backup of OCR is done by CRSD process and every 3 hours.

• Question 14:

  Which two statements about ASM paths and file names are correct?

  A. Absolute paths must begin from the root directory of the server.
  B. Relative paths start from the Grid Infrastructure home directory.
  C. When an Oracle ASM file is created with an alias file name, you can access the file with either name.
  D. Absolute paths can access a file or directory regardless of the current directory.
  C. When an Oracle ASM file is created with an alias file name, you can access the file with either name.
  D. Absolute paths can access a file or directory regardless of the current directory.

  ---

  C: Alias names, or aliases, are intended to provide a more user-friendly means of referring to Oracle ASM files, rather than using the system-generated filenames.

  You can create an alias for a file when you create it in the database, or you can add an alias to an existing file using the ADD ALIAS clause of the ALTER DISKGROUP statement. You can create an alias in any system-generated or user-created Oracle ASM directory. An alias must include the disk group name; you cannot create an alias at the root level (+).

• Question 15:

  Which statement about RAC services is correct?

  A. SYS$BACKGROUND and SYS$USERS are external services.
  B. Internal services can be deleted.
  C. Services are logical abstractions for managing workloads in Oracle Database.
  D. Every service has N-2 cluster resources (where N is the number of RAC instances).
  C. Services are logical abstractions for managing workloads in Oracle Database.

  ---

  A service is a logical grouping of sessions performing similar kind of work. They enable you to group database workloads and route work to the optimal instances that are assigned to offer the service.It is recommended that all the users who connect using a service have the same service- level requirements. We can use services to manage workloads or a group of applications. For example , all on-line users can use one service whereas batch users can use another service and reporting can use yet another service.

• Question 16:

  Which three statements are correct about the Oracle local Registry?

  A. OLR is Installed and configured when Oracle Clusterware Installs OCR.
  B. OLR was introduced in Oracle Database 11g Release 1.
  C. OLR is located at Grid _home/cdata/hostname.olr on each node.
  D. OLR can reside on a maximum of three nodes in the cluster.
  E. You can manage OLR using the ocrcheck, ocrdump, and ocrconfig utilities with the local option.
  A. OLR is Installed and configured when Oracle Clusterware Installs OCR.
  C. OLR is located at Grid _home/cdata/hostname.olr on each node.
  E. You can manage OLR using the ocrcheck, ocrdump, and ocrconfig utilities with the local option.

  ---

  C: The olr.loc file consist of the OLR config file location and the crs_home location.

  So, by default the location is , olrconfig_loc =/cdata/.olr.

  E: Examples:

  To manually back up OLR:

  # ocrconfig local manualbackup

  To view the contents of the OLR backup file:

  ocrdump -local -backupfile olr_backup_file_name

  To change the OLR backup location:

  ocrconfig -local -backuploc new_olr_backup_path

  To restore OLR:

  # crsctl stop crs

  # ocrconfig -local -restore file_name

  # ocrcheck -local

  # crsctl start crs

  $ cluvfy comp olr

  Incorrect:

  Not B: From 11gR2 Oracle introduced "Oracle Local Registry(OLR)", something new as part of Oracle Clusterware

  Reference: Oracle Local Registry (OLR) 11gR2

• Question 17:

  What value uniquely identifies an instance in a RAC database?

  A. Location name
  B. Node hostname
  C. Listener and port
  D. SID
  E. VIP
  D. SID

  ---

  The Oracle SID uniquely identifies the Oracle RAC database instance on the node where the instance is running.

• Question 18:

  You are setting up IP addresses for your Oracle Clusterware-based cluster. Which two types of IP addresses should be registered with DNS?

  A. Public IP address
  B. Private IP address
  C. VIP address
  D. Storage IP address
  A. Public IP address
  C. VIP address

  ---

  Reference: Oracle Clusterware Administration and Deployment Guide

• Question 19:

  Which three statements about mounting ASM cluster file systems are true?

  A. You can mount ACFS volumes with Oracle Enterprise Manager.
  B. You can mount ACFS volumes on Windows platforms by using the acfsmountvol command.
  C. You can mount ACFS volumes with the ASMCMD utility.
  D. You can mount an ACFS volume with the standard Linux/UNIX mount command (only if the ACFS type is specified).
  E. You cannot mount an ACFS volume with ASMCA.
  A. You can mount ACFS volumes with Oracle Enterprise Manager.
  B. You can mount ACFS volumes on Windows platforms by using the acfsmountvol command.
  D. You can mount an ACFS volume with the standard Linux/UNIX mount command (only if the ACFS type is specified).

  ---

  A: Log in to OEM, scroll to the bottom of the home page, then click on one of the ASM instances listed. On the resulting ASM screen, click on the "ASM Cluster File System" tab. You are then presented with the following screen. Click the

  "Create" button.

  Click the "Create ASM Volume" button.

  Enter the Volume Name and Size and click the "OK" button. Wait for the volume to be created.

  B, D: Mount the file system with the Oracle ACFS mount command. You can mount a file system before or after registering the file system. If the file system has been registered, you can wait for the file system to be mounted automatically.

  For example:

  # /bin/mount -t acfs /dev/asm/volume1-123 /u01/app/acfsmounts/myacfs See "mount" (Linux or UNIX) or "acfsmountvol" (Windows). The root privilege is required run the mount command and the Windows Administrator privilege is required to run the acfsmountvol command.

  Note:

  *

  Oracle ASM Cluster File System (ACFS) is a general purpose cluster file system implemented as part of ASM.

  *

  ASM Configuration Assistant (ASMCA),

  Incorrect:

  Not E: Probably the easiest interface to use is the ASM Configuration Assistant (ASMCA), but Enterprise Manager does allow you to see all the commands being run to perform each task. The easiest way to learn how to use the command

  line utilities is to use Enterprise Manager and click the "Show Command" button each step of the way.

  Reference: Accessing an Oracle ACFS File System on a Different Node in the Cluster

• Question 20:

  Which two options are valid choices for the ASM configuration file?

  A. init.ora
  B. init.asm
  C. asm.ini
  D. SPFILE
  A. init.ora
  D. SPFILE

  ---

  "Oracle?Automatic Storage Management Administrator's Guide 11g Release 2 (11.2) Part Number E16102-05"

  There are two parameters files: spfile.ora and init.ora as sample, in fact init+ASM.ora with default, but not mandatory names !