Oracle 1Z0-058 Online Practice Questions and Exam Preparation

Oracle 1Z0-058 Online Questions & Answers

• Question 61:

  Which are the key factors that you should consider before converting a single-Instance database Oracle Real Application Cluster (RAC) database to guarantee a successful media recovery?

  A. If the database is in archive log mode, the archive file format requires a thread number.
  B. The archive logs from all nodes must be accessible to all nodes in the cluster database.
  C. The storage option must be Automatic Storage Management (ASM).
  D. All database files must be migrated to Oracle Managed Files (OMF).
  A. If the database is in archive log mode, the archive file format requires a thread number.
  B. The archive logs from all nodes must be accessible to all nodes in the cluster database.

  ---

  Issues for Converting Single Instance Databases to Oracle RAC Backup procedures should be available before conversion takes place. Archiving in Oracle RAC environments requires a thread number in the archive file format. The archived logs from all instances of an Oracle RAC database are required for media recovery. By default, all database files are migrated to Oracle Managed Files (OMF).

  D60488GC11 Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 11 - 24

• Question 62:

  After Oracle Grid Infrastructure has been installed, you should take a few moments to verify the installation. Which two actions would be useful in verifying the installation?

  A. Run the crsctl status resource t command to confirm that all necessary cluster resources are online.
  B. Use the operating system utilities to verify that your SCAN addresses are being properly resolved.
  C. Start Oracle Enterprise Manager and check all monitored targets.
  D. Run the cluvfy comp nodecon n all verbose command to verify the entire Grid Infrastructure installation.
  A. Run the crsctl status resource t command to confirm that all necessary cluster resources are online.
  B. Use the operating system utilities to verify that your SCAN addresses are being properly resolved.

  ---

  Verifying the Grid Infrastructure Installation

  Execute the crsctl command as shown in the slide to confirm that all cluster resources are up and running. root@racnode01 ~]# /u01/app/11.2.0/grid/bin/crsctl stat res -t In addition, you should confirm that your DNS is properly forwarding

  address requests for your application and SCAN VIPs to your GNS and that they are resolved properly. You can do this with dig. Execute the dig command with DNS and VIP addresses as shown:

  # dig @myDNS.example.com racnode01-cluster01.example.com ...

  ;;

• Question 63:

  You decide to create a snapshot of your ACFS for backup and recovery purposes. Which two tools are available to do this?

  A. ASMCMD
  B. SQL*Plus
  C. ACFSUTIL
  D. ADVMUTIL
  E. Enterprise Manager
  C. ACFSUTIL
  E. Enterprise Manager

  ---

  About Oracle ACFS Snapshots Oracle ACFS snapshots are administered with the acfsutil snap commands. For information about the acfsutil snap commands, refer to "acfsutil snap create", "acfsutil snap delete", and "acfsutil snap info". You can also manage Oracle ACFS snapshots with Oracle Enterprise Manager. For information about using Oracle Enterprise Manager, see "Managing Oracle ACFS Snapshots with Oracle Enterprise Manager".

  Oracle?Automatic Storage Management Administrator's Guide 11g Release 2 (11.2)

• Question 64:

  Which three statements are true about the logging or tracing of Java-based Oracle tools?

  A. By default, Oracle logs actions for DBCA and DBUA.
  B. For tools such as SRVCTL and CLUVFY, tracing can be enabled by setting srvm trace = true your shell environment before executing the commands.
  C. The srvm_trace environment variable can be set only in the user's shell environment file.
  D. To disable tracing for Java-based tools, unset the srvm_trace variable: export srvm_trace=
  A. By default, Oracle logs actions for DBCA and DBUA.
  B. For tools such as SRVCTL and CLUVFY, tracing can be enabled by setting srvm trace = true your shell environment before executing the commands.
  D. To disable tracing for Java-based tools, unset the srvm_trace variable: export srvm_trace=

  ---

  Enabling Tracing for Java-Based Tools and Utilities in Oracle RAC All Java-based tools and utilities that are available in Oracle RAC are called by executing scripts of the same name as the tool or utility. This includes the Cluster Verification Utility (CVU), Database Configuration Assistant (DBCA), the Net Configuration Assistant (NETCA), Server Control Utility (SRVCTL), and the Global Services Daemon (GSD). For example to run DBCA, enter the command dbca. By default, Oracle Database enables traces for DBCA and the Database Upgrade Assistant (DBUA). For the CVU, GSDCTL, and SRVCTL, you can set the SRVM_TRACE environment variable to TRUE to make Oracle Database generate traces. Oracle Database writes traces to log files. For example, Oracle Database writes traces to log files in Oracle home/ cfgtoollogs/dbca and Oracle home/cfgtoollogs/dbua for DBCA and DBUA, re- spectively. Oracle?Real Application Clusters Administration and Deployment Guide

• Question 65:

  A policy-managed RAC database that hosts the ACCOUNTS service has only three instances running rather than the usual four on a six-node cluster. Five of the six cluster nodes are active and the sixth (RACNODE6) is down for maintenance. You decide to check the state of the servers in the server pools to see if there are problems with the OLTP pool to which the ACCOUNTS service has been assigned. You used the crsctl status server-f command and see that the RACNODE3 node has STATE=VISIBLE.

  What is true about this situation?

  A. The Cluster Synchronization Services Daemon (cssd) is running and RACNODE3 is considered to be part of the cluster, but the Cluster Ready Services Daemon (crsd) is currently not running.
  B. Both the Cluster Ready Services Daemon (crsd) and the Cluster Synchronization Service Daemon (cssd) are running on RACNODE3, but RACNODE3 is currently being moved to another server pool.
  C. The Cluster Ready Services Daemon (crsd) is running and RACNODE3 is considered to be a part of the cluster, but the Cluster Synchronization Services Daemon (cssd) is currently not running.
  D. Neither the Cluster Ready Services Daemon (crsd) nor the Cluster Synchronization Services Daemon (cssd) is running on RACNODE3.
  A. The Cluster Synchronization Services Daemon (cssd) is running and RACNODE3 is considered to be part of the cluster, but the Cluster Ready Services Daemon (crsd) is currently not running.

  ---

  Cluster Synchronization Service daemon (CSSD)

  An Oracle Clusterware component that discovers and tracks the membership state of each node by providing a common view of membership across the cluster. CSS also monitors process health, specifically the health of the database

  instance. The Global Enqueue Service Monitor (LMON), a background process that monitors the health of the cluster database environment and registers and de- registers from CSS.

  Cluster Ready Services Daemon (CRSD)

  The primary Oracle Clusterware process that performs high availability recovery and manage- ment operations, such as maintaining OCR. Also manages application resources and runs as root user (or by a user in the admin group on Mac

  OS X-based systems) and restarts automatically upon failure

  STATE=VISIBLE

  Servers that have Oracle Clusterware running, but not the Cluster Ready Services daemon (crsd), are put into the VISIBLE state. This usually indicates an intermittent issue or failure and Oracle Clusterware trying to recover (restart) the

  daemon. Oracle Clusterware cannot manage resources on servers while the servers are in this state.

  Oracle Clusterware Administration and Deployment Guide

• Question 66:

  Which two types of files can be stored In an ASM clustered file system?

  A. OCR and Voting Disk files
  B. data files for external tables
  C. Oracle database executable
  D. Grid Infrastructure executables
  E. data files for tablespaces
  F. archive log files
  B. data files for external tables
  C. Oracle database executable

  ---

  Oracle Automatic Storage Management Cluster File System (Oracle ACFS) is a multi-platform, scalable file system, and storage management technology that extends Oracle Automatic Storage Management (Oracle ASM) functionality to

  support customer files maintained outside of Oracle Database. Oracle ACFS supports many database and application files, including executables, database trace files, database alert logs, application reports, BFILEs, and configuration files.

  Other supported files are video, audio, text, images, engineering drawings, and other gener- al-purpose application file data.

  Notes:

  Oracle ASM is the preferred storage manager for all database files. It has been specific- ally designed and optimized to provide the best performance for database file types.

  Oracle ACFS is the preferred file manager for non-database files. It is optimized for gen- eral purpose files. Oracle ACFS does not support any file type that can be directly stored in Oracle ASM, except where explicitly noted in the

  documentation.

  Not supported means Oracle Support Services does not take calls and development does not fix bugs associated with storing unsupported file types in Oracle ACFS.

  Starting with Oracle Automatic Storage Management 11g Release 2 (11.2.0.3), Oracle ACFS supports RMAN backups (BACKUPSET file type), archive logs (ARCHIVELOG file type), and Data Pump dumpsets (DUMPSET file type). Note that

  Oracle ACFS snap- shots are not supported with these files.

  Oracle ACFS does not support files for the Oracle Grid Infrastructure home.

  Oracle ACFS does not support Oracle Cluster Registry (OCR) and voting files.

• Question 67:

  Examine the set of commands given below:

  

  Which statement is true in this scenario?

  A. All the instances of the RACDB will have the TRACE_ENABLED parameter with the value TRUE because this parameter must have the same value on all the instances.
  B. All the instances of the RACDB will have the TRACE_ENABLED parameter with the value TRUE except the RACDB_1 instance, which will have the value FALSE for this parameter.
  C. All the instances of the RACDB will have the TRACE_ENABLED parameter with the value TRUE because the first ALTER statement has higher precedence.
  D. All the instances of the RACDB will nave the TRACE_ENABLED parameter with the value FALSE because the second ALTER statement has higher precedence.
  B. All the instances of the RACDB will have the TRACE_ENABLED parameter with the value TRUE except the RACDB_1 instance, which will have the value FALSE for this parameter.

  ---

  Section: (none)

  SPFILE Parameter Values and RAC

  

• Question 68:

  You have configured your eight-node cluster to use GNS. The network administrator has established delegated subdomain for the Custer which is MYCLUSTER.EXAMPLE.COM. DHCP has been configured so that the cluster now manages IP addresses within the cluster. Select three responses that describe the VIPs that will exist in this configuration.

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

  ---

  Implementing GNS If you use GNS, then you must specify a static IP address for the GNS VIP address, and delegate a subdomain to be delegated to that static GNS VIP address. Dynamic IP address assignment using Oracle Grid Naming Service (GNS) If you select this option, then network administrators assign static IP address for the physical host name and dynamically allocated IPs for the Oracle Clusterware managed VIP addresses. In this case, IP addresses for the VIPs are assigned by a DHCP and resolved using a multicast do- main name server configured as part of Oracle Clusterware within the cluster. If you plan to use GNS, then you must have the following: A DHCP service running on the public network for the cluster Enough addresses on the DHCP to provide 1 IP address for each node's virtual IP, and 3 IP addresses for the cluster used by the Single Client Access Name (SCAN) for the cluster Oracle Grid Infrastructure Installation Guide

• Question 69:

  You are allocating space from the ASM disk group for an ADVM volume. What will be the volume extent and Volume Allocation Unit (VAU) if the stripe column is 4 and AU is 1 MB? Which are the default values?

  A. The volume extent is 64 MB and the VAU will be 512 MB.
  B. The volume extent is 64 MB and the VAU will be 256 MB.
  C. The volume extent is 32 MB and the VAU will be 256 MB.
  D. It is not possible to calculate these values with the given information.
  B. The volume extent is 64 MB and the VAU will be 256 MB.

  ---

  Stripe column and stripe width are two important attributes that can be specified for a volume de- termining how space is allocated for a volume and how space is allocated within a volume after ACFS or third party file system is created on a volume and a file is created or extended on the file system built on that volume. Both attributes are specified at volume creation time and cannot be changed later. If there is no value a default value is used. Stripe column specifies the number of stripes a value from 1 to 8. The default is 4.

  Stripe width specifies the size of the stripe can vary from 4K,8K, 16K,32K,64K,128K, 256K, 512K, 1M. Default is 128K.

  Volume Allocation Unit (VAU) is the smallest allocation for a volume. Whenever a volume is created or extended space is allocated in multiple of VAU. VAU size is determined by the Volume Extent (VE) and the stripe column. VAU is the product of VE and the stripe column. Volume Extent is based on the Allocation Unit (AU) specified on a disk group and for AU with size of 1MB the VE is 64MB. Whenever a VAU is allocated VE are allocated in a round robin fashion across the disks in a disk group. Volume size is always multiple of the VAU. For example if a volume is requested with size 200MB and stripe column is 4 and AU is 1MB one VAU with size 256MB will be allocated and the volume size will be 256MB

• Question 70:

  You want to create an ACFS on an ADVM volume using a shell script and the appropriate command-line utilities. These are the requirements:

  1.

  The dynamic volume file must use space in the VOLFILE disk group with a size of 500 M and be called prodvol.

  2.

  The mount point called /acfs already exists.

  Which four steps must be performed to achieve this?

  A. As the Grid Infrastructure owner, run mount -t acfs /dev/asm/prodvol-417 /acfs to mount the file system.
  B. As the Grid Infrastructure owner, run asmcmd volinfo -d volfile prodvol to determine the volume information.
  C. As the Grid Infrastructure owner, run asmcmd volcreate -d volfile -s 500M prodvol to create the volume file.
  D. As the Grid Infrastructure owner, run mkfs -t acfs /dev/asm/prodvol-417 to create the file system.
  E. As root, run mount -t acfs /dev/asm/prodvol-417 /acfs to mount the file system.
  F. As root, run mkfs -t acfs /dev/asm/prodvol-417 to create the file system.
  B. As the Grid Infrastructure owner, run asmcmd volinfo -d volfile prodvol to determine the volume information.
  C. As the Grid Infrastructure owner, run asmcmd volcreate -d volfile -s 500M prodvol to create the volume file.
  E. As root, run mount -t acfs /dev/asm/prodvol-417 /acfs to mount the file system.
  F. As root, run mkfs -t acfs /dev/asm/prodvol-417 to create the file system.

  ---

  Creating an ACFS Volume

  Create the volume:

  $ asmcmd volcreate -G DATA -s 100M testvol

  View the volume information:

  $ asmcmd volinfo -G DATA testvol

  Make a mount point directory:

  $ mkdir /u01/app/oracle/acfsdata/testvol

  Make the file system (as root):

  # mkfs -t acfs /dev/asm/testvol-403

  Mount the file system to the mount point:

  # mount -t acfs /dev/asm/testvol-403 \

  /u01/app/oracle/acfsdata/testvol

  D60488GC11

  Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 10 - 13 Create a file system with the Oracle ACFS mkfs command. Create a file system using an existing volume device.

  For example:

  $ /sbin/mkfs -t acfs /dev/asm/volume1-123

  mkfs.acfs: version = 11.2.0.1.0.0

  mkfs.acfs: on-disk version = 39.0

  mkfs.acfs: volume = /dev/asm/volume1-123

  mkfs.acfs: volume size = 10737418240

  mkfs.acfs: Format complete.

  See "mkfs" (Linux or UNIX) or "acfsformat" (Windows). The root privilege is not required. The ownership of the volume device file dictates who can run this command.

  Oracle?Automatic Storage Management Administrator's Guide 11g Release 2 (11.2)