Oracle 1Z0-593 Online Practice Questions and Exam Preparation

Oracle 1Z0-593 Online Questions & Answers

• Question 1:

  In the end of the database creation process using DBCA which two options can you choose from?

  A. Create database
  B. Generate database creation scripts
  C. Initialize the database instance
  D. Configure the database initialization parameters such as memory target, character set, etc.
  A. Create database
  C. Initialize the database instance

  ---

  Database Creation Options

  Check any of the following options for creating the database:

  *

  Create Database--Check to create your database at this time.

  *

  Save as a Database Template--Check to save the database definition as a template to use at another time.

  *

  Generate Database Creation Scripts--Check to generate a SQL database creation script that you can run at a later time. Reference: Creating a Database with DBCA

• Question 2:

  What would be the total space required for Clusterware files when stopping them in the ASM Diskgroup configured with NORMAL redundancy? (Assume each OCR and voting Disk files uses 300 MB.)

  A. 1.5 GB
  B. 2.4 GB
  C. 600 MB
  D. 900 MB
  A. 1.5 GB

  ---

  When you use normal redundancy, Oracle Clusterware automatically maintains two copies of the OCR file and three copies of the voting disk file. Reference: About Oracle Clusterware

• Question 3:

  Which two statements are true about starting and stopping all instances of a RAC database simultaneously with a single command?

  A. The user must be SYSDBA.
  B. The user must be a member of the OSDBA group.
  C. The user can use SQL* Plus from local node.
  D. The user can use SRVCTL.
  A. The user must be SYSDBA.
  D. The user can use SRVCTL.

  ---

  *

  Connecting as SYSOPER or SYSDBA enables you to perform privileged operations, such as instance startup and shutdown.

  *

  When you use SRVCTL to perform configuration operations on your cluster, SRVCTL stores configuration data in the Oracle Cluster Registry (OCR). SRVCTL performs other operations, such as starting and stopping instances, by calling SQL*Plus on each node.

  Reference: Overview of Administering Oracle Real Application Clusters with SQL*Plus

• Question 4:

  In the following line, which is the result of a "crsctl query css votedisk" command (which is missing the column headers in the output) what does the [DATA] indicate?

  1. ONLINE 62a46a99b0434f8abf16f338c85203160 (/dev/xvdc1) [DATA]

  A. It Indicates that the Voting Disk contains Oracle Cluster ware data
  B. It Indicates that the Voting Disk is managed in the ASM diskgroup "DATA"
  C. It Indicates that the Voting Disk "DATA" is online on disk /dev/xvdc1
  D. It indicates that the ASM diskgroup "DATA" stores only the Voting Disk
  B. It Indicates that the Voting Disk is managed in the ASM diskgroup "DATA"

  ---

  See example below. Note:

  *

  Use the crsctl query css votedisk command to display the voting disks used by Cluster Synchronization Services, the status of the voting disks, and the location of the disks, whether they are stored on Oracle ASM or elsewhere.

  *

  Example:

  The crsctl query css votedisk command returns output similar to the following:

  $ crsctl query css votedisk

  ## STATE File Universal Id File Name Disk group

  1.

  ONLINE 296641fd201f4f3fbf3452156d3b5881 (/ocfs2/host09_vd3) []

  2.

  ONLINE 8c4a552bdd9a4fd9bf93e444223146f2 (/netapp/ocrvf/newvd) []

  3.

  ONLINE 8afeee6ae3ed4fe6bfbb556996ca4da5 (/ocfs2/host09_vd1) [] Located 3 voting disk(s). Reference: Oracle Clusterware Administration and Deployment Guide , CRSCTL Utility Reference

• Question 5:

  When installing the Oracle Database with OUI, when are configuration scripts executed?

  A. Before installation begins
  B. After prerequisites check finished
  C. After the software has been installed
  D. Automatically throughout the installation process
  C. After the software has been installed

  ---

  If prompted, execute the root.sh script as the root user to complete the installation, and click OK. Note:

  * Oracle Universal Installer (OUI)

  Reference: Oracle Database Client Installation Guide

• Question 6:

  Which command can be used to stop Oracle Clusterware and Oracle ASM instances on all nodes in the cluster running in Linux/UNIX?

  A. #emcrsctl stop crs all
  B. srvctl stop cluster all
  C. #crsctl stop cluster all
  D. #crsctl stop crs d database
  C. #crsctl stop cluster all

  ---

  To stop Oracle Clusterware on all nodes in the cluster, execute the following command on any node: crsctl stop cluster all Reference: Stopping Oracle Clusterware

• Question 7:

  Which two statements are true for crsctl and srvctl?

  A. crsctl is used to manage resources defined in the OCR
  B. srvctl can manage Clusterware daemons
  C. crsctl is used to manage CSS and CRS
  D. only srvctl can manage nodeapps
  E. srvctl is used to determine the status of Clusterware installation
  C. crsctl is used to manage CSS and CRS
  D. only srvctl can manage nodeapps

  ---

  C:

  *

  CRSCTL is an interface between you and Oracle Clusterware, parsing and calling Oracle Clusterware APIs for Oracle Clusterware objects.

  *

  CSS- Cluster Synchronization Services - a daemon process that is used for synchronization between different RAC nodes and synchronization between ASM and Oracle database instances.

  *

  CRS - Oracle Clusterware is run by Cluster Ready Services (CRS)

  D: SRVCTL Node-Level Tasks

  The node-level tasks are:

  Adding and deleting node level applications.

  Setting and unsetting the environment for node-level applications.

  Administering node applications.

  Administering ASM instances.

  Starting and stopping a group of programs that includes virtual IP addresses, Listeners, Oracle Notification Services, and Oracle Enterprise Manager agents (for maintenance purposes).

  Note: The Server Control (SRVCTL) utility is installed on each node by default. You can use SRVCTL to start and stop the database and instances, manage configuration information, and to move or remove instances and services. You can

  also use SRVCTL to add services. SRVCTL also manages configuration information.

  Some SRVCTL operations store configuration information in the Oracle Cluster Registry (OCR). SRVCTL performs other operations, such as starting and stopping instances, by sending requests to the Oracle Clusterware process (CRSD),

  which then starts or stops the Oracle Clusterware resources.

  Incorrect:

  Not A:

  * OCR - Oracle Cluster Registry

• Question 8:

  You have configured your eight-node cluster to use the GRID Naming Service (GNS). The network administrator has established a delegated subdomain for the cluster, which is MYCLUSTER.COMPANY.COM. DHCP has been configured as that the cluster now manages IP addresses within it.

  Select three responses that describe the VIPs that will exist in this configuration.

  A. 1 GNS VIP
  B. 3 GNS VIPs
  C. 1 SCAN VIP
  D. 3 SCAN VIPs
  E. 3 Node VIPs
  F. 8 Node VIPs
  A. 1 GNS VIP
  D. 3 SCAN VIPs
  F. 8 Node VIPs

  ---

  A: As part of the Grid Infrastructure installation process, optionally we can also provide Grid Naming Service (GNS) information, which includes the GNS Sub Domain Name and the GNS VIP Address.

  Using GNS assumes that a DHCP server is running on the public network with enough available addresses to assign the required IP addresses and the SCAN VIP. Only one static IP address is required to be configured and it should be in the DNS domain.

  D:

  *

  The node VIP and the three SCAN VIPs are obtained from the DHCP server when using GNS.

  *

  RAC instances register to SCAN listeners as remote listeners. Oracle recommends assigning 3 addresses to SCAN, which will create 3 SCAN listeners, though the cluster has got dozens of nodes.. SCAN is a domain name registered to at least one and up to three IP addresses, either in DNS (Domain Name Service) or GNS (Grid Naming Service). The SCAN must resolve to at least one address on the public network. For high availability and scalability, Oracle recommends configuring the SCAN to resolve to three addresses.

  SCAN components in a cluster:

  SCAN Name

  SCAN IPs (3)

  SCAN Listeners (3)

  F:

  *

  One VIP address for each node.

  *

  Node listeners on each node which connect clients to the chosen instance these listeners are not normally contacted by the clients at the initial connection request and not referenced by the REMOTE_LISTENER parameter except for upgraded RAC databases from prior releases. Each local listener also has a vip and these are examples of "LOCAL RESOURCES" in the OCR.

  *

  The node VIP and the three SCAN VIPs are obtained from the DHCP server when using GNS.

• Question 9:

  Which action is not available when right-clicking a ADVM volume in the ASM Configuration Assistant?

  A. Enable
  B. Disable
  C. Version
  D. Resize
  E. Delete
  C. Version

  ---

  Right click a selected volume in the Oracle ASM Configuration Assistant screen to display the configuration options menu. The menu options include: Enable a disabled volume Disable an enabled volume Resize a volume that has not been mounted on an Oracle ACFS file system Delete a volume

  

  Reference: Managing Oracle ADVM Volumes with Oracle ASM Configuration Assistant

• Question 10:

  You want to move a service from one instance to another. Which utility would you use?

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

  ---

  The Server Control (SRVCTL) utility is installed on each node by default. You can use SRVCTL to start and stop the database and instances, manage configuration information, and to move or remove instances and services. You can also

  use SRVCTL to add services. SRVCTL also manages configuration information.

  Incorrect:

  Not A: Cluster Verification Utility (CVU)

  A tool that verifies a wide range of Oracle RAC components such as shared storage devices, networking configurations, system requirements, Oracle Clusterware, groups, and users.

  Not C: CRSCTL is an interface between you and Oracle Clusterware, parsing and calling Oracle Clusterware APIs for Oracle Clusterware objects.

  You can use CRSCTL commands to perform several operations on Oracle Clusterware, such as:

  Starting and stopping Oracle Clusterware resources

  Enabling and disabling Oracle Clusterware daemons

  Checking the health of the cluster

  Managing resources that represent third-party applications Integrating Intelligent Platform Management Interface (IPMI) with Oracle Clusterware to provide failure isolation support and to ensure cluster integrity

  Debugging Oracle Clusterware components

  Not D: The Oracle Interface Configuration Tool (OIFCFG) command-line interface helps you to define and administer network interfaces.