Oracle 1Z0-593 Online Practice Questions and Exam Preparation

Oracle 1Z0-593 Online Questions & Answers

• Question 51:

  The Oracle Cluster Health Monitor can't _________.

  A. Detect and analyze OS and duster resource for problems in Oracle Clusterware and RAC cluster
  B. Track OS resource consumption at each node, process, and device level continuously
  C. Be installed on Windows Server 20O3 SP1
  D. Collect and analyze the cluster-wide data
  C. Be installed on Windows Server 20O3 SP1

  ---

  Incorrect:

  Oracle Cluster Health Monitor is designed to detect and analyze operating system (OS) and cluster resource related degradation and failures in order to bring more explanatory power to many issues that occur in clusters where Oracle

  Clusterware and Oracle RAC are running such as node eviction. It continuously tracks the OS resource consumption at each node, process, and device level. It collects and analyzes this cluster-wide data. In real time mode, when thresholds

  are hit, an alert is shown to the operator. For root cause analysis, historical data can be replayed to understand what was happening at the time of failure.

• Question 52:

  Which is not a node app?

  A. ASM
  B. ONS
  C. GSD
  D. VIP
  A. ASM

  ---

  Note:

  *

  srvctl modify nodeapps Options Option Description -n node_name Node name. -o clusterware_home Oracle Clusterware home for node applications such as VIP, ONS, and GSD. -A new_vip_address The node level VIP address (name|ip/netmask[/if1[|if2|...]]).

  *

  srvctl config nodeapps Option

  Option Description -n node_name Node name. -a Displays the VIP address configuration. -g Displays the GSD configuration. -s Displays the ONS configuration.

  Displays the listener configuration.

  Reference: Oracle Real Application Clusters Administration and Deployment Guide, A Server Control Utility Reference

• Question 53:

  Which option should you use to find out if the Oracle Inventory directory exists in a Linux/UNIX environment?

  A. # show /etc/oraInst.loc
  B. # more /etc/oraInst.loc
  C. # more /etc/oraInst
  D. # more oraInst.loc
  B. # more /etc/oraInst.loc

  ---

  When you install Oracle software on the system for the first time, the Installer creates the oraInst.loc file. This file identifies the name of the Oracle Inventory group and the path of the Oracle Inventory directory. To determine whether the Oracle Inventory group exists, enter the following command:

  # more /etc/oraInst.loc

• Question 54:

  Once OUI recognizes a set of nodes in a cluster, which three choices does it offer when installing the Oracle Database 11g Release 2 software?

  A. You can only install the Oracle Database with the RAC option on selected nodes.
  B. OUI forces you to configure ASM for shared storage before proceeding.
  C. You can install the Oracle Database as a single instance or with the RAC option on all the nodes.
  D. You can install the Oracle Database as a single instance or with the RAC option on selected nodes.
  E. You can install Oracle RAC One Node.
  B. OUI forces you to configure ASM for shared storage before proceeding.
  D. You can install the Oracle Database as a single instance or with the RAC option on selected nodes.
  E. You can install Oracle RAC One Node.

  ---

  B, D: Complete the prerequisite tasks for converting to an Oracle RAC database: Oracle Clusterware and Oracle Database software is installed on all target nodes. Oracle Clusterware is started.

  (D)

  The Oracle Database binary is enabled for Oracle RAC on all target nodes.

  (B)

  Shared storage is configured and accessible from all nodes.

  User equivalency is configured for the operating system user performing the conversion.

  Enterprise Manager agents are configured and running on all nodes, and are configured with the cluster and host information.

  The database being converted has been backed up successfully.

  E: Installing Oracle RAC One Node is available starting with Oracle Database 11g Release 2 (11.2.0.2).

  Note:

  * By default, the standard Oracle Database 11g software installation process installs the Oracle RAC option when OUI recognizes that you are performing the installation on a cluster.

• Question 55:

  How many Oracle Clusterware interconnect networks are required and why?

  A. Only one; minimum requirement
  B. Two; redundancy is required
  C. One per node in the cluster
  D. One per database in the cluster
  C. One per node in the cluster

  ---

  Oracle Clusterware requires a cluster interconnect configured for inter-node communication. Note:

  *

  The Oracle Clusterware interconnect is a non-traditional interconnect and should be considered, in shared global cache applications, such as Oracle RAC, to be an I/O subsystem for inter-node global cache buffer transfers with the latency and bandwidth requirements of high performance cluster computing.

  *

  The interconnect network is a private network using a switch (or multiple switches) that only the nodes in the cluster can access. And Oracle Clusterware requires that you connect the nodes in the cluster to a private network by way of a private interconnect. The private interconnect is a separate network that you configure between cluster nodes. The interconnect used by

  Oracle RAC is the same interconnect that Oracle Clusterware uses. This interconnect should be a private interconnect, meaning it is not accessible to nodes that are not members of the cluster. Reference: Oracle Real Application Clusters (RAC) and Oracle Clusterware Interconnect Virtual Local Area Networks (VLANs) Deployment Considerations

• Question 56:

  Why do you need SSH to install Oracle Database with the RAC option on Linux?

  A. To authenticate the installation user
  B. To copy software to other nodes in the cluster
  C. Oracle Clusterware processes require SSH for post-install authentication across nodes
  D. To authenticate the listener process for inter-node communication
  B. To copy software to other nodes in the cluster

  ---

  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 57:

  How many OCR locations are allocated if you choose an ASM diskgroup using external redundancy?

  A. 1
  B. 2
  C. 3
  D. You cannot use external redundancy for OCR files.
  A. 1

  ---

  Note: *

  *

  Oracle Cluster Registry (OCR)

  *

  External redundancy

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

• Question 58:

  Which three types of files can be stored in Oracle ASM without extending it with ACFS?

  A. Voting disks
  B. OCR files
  C. Oracle clusterware binaries
  D. Database files
  E. Trace files
  F. Operating system files
  A. Voting disks
  B. OCR files
  D. Database files

  ---

  *

  ASM supports most file types required by the database. However, you cannot store some administrative file types on ASM disk groups. These include trace files (not E) , audit files, alert logs, export files, tar files, operating system files (not F), and core files (not C).

  *

  File Types Supported by Automatic Storage Management: Control files Datafiles Redo log files Archive log files emporary files Datafile backup pieces Datafile incremental backup pieces Archive log backup piece Datafile copy Persistent initialization parameter file (SPFILE) Disaster recovery configurations Flashback logs Change tracking file Data Pump dumpset Automatically generated control file backup Cross-platform transportable datafiles

• Question 59:

  You are beginning the Installation of an Oracle Database, 11g Release 1. The OUI detects that you are installing onto a cluster. Which two choices does it give you?

  A. The ability to install a single node non cluster Installation on the local node
  B. The ability to select the nodes to install the RAC enabled Oracle database software
  C. the ability to install clusterware
  D. The ability to install RAC on some nodes and a single instance Oracle database on others
  A. The ability to install a single node non cluster Installation on the local node
  B. The ability to select the nodes to install the RAC enabled Oracle database software

  ---

  A: On the Select Database Management Option page, if you have already completed the Grid Control Management Agent installation, then you can select either Grid or Local Database control. Otherwise, only Local Database control for database management is supported for Oracle RAC.

  B: You can install Oracle RAC One Node on two or more nodes in the cluster. An Oracle RAC One Node installation starts up an instance on one of the nodes you select as an Oracle RAC One Node pool member. If that instance goes down, then the Oracle RAC One Node instance is started up on another pool member using Online Database Relocation. This feature migrates database instances and connections to other cluster nodes for high availability.

  Note:

  When you run OUI, you can select the Typical or the Advanced Install type.

  The Typical install type installs a default configuration of Oracle Database, with basic configuration choices. Oracle recommends that most users select Typical as their installation type.

  The Advanced installation type is for customized installations, and should be used only when you have a specific requirement for it, such as requiring different passwords for the SYS, SYSMAN, SYSTEM and DBSNMP accounts, or using a different database character set than is in use on your servers, changing product languages, or other nonstandard configuration

• Question 60:

  Name the option(s) that are fully supported by the DBCA (Database Configuration Assistant).

  A. Oracle DBCA can be used to manage database services with 11g Release 1 onward.
  B. Configure Database Vault and Label Security.
  C. Create the database and register it with the default listener and SCAN with Oracle RAC 11g Release 2.
  D. Modify a Single Instance database and convert it to Oracle RAC.
  B. Configure Database Vault and Label Security.

  ---

  Note:

  *

  Configuring Database Options with DBCA

  In the Operations window, select Configure Database Options to change various aspects of your database configu- ration. For example, you can change the database from a dedicated server to a shared server. You can add data- base options that have not been previously configured for use with your database, for example, Oracle Label Secu- rity or Oracle OLAP.

  *

  DBCA has the following primary database functions:

  Create and delete databases Add and delete database instances Set up network configurations for databases and their instances Configure database options, such as Oracle Database Vault Register databases in Oracle Enterprise Manager Grid Control or configure Database Control Start up databases and their instances