Oracle 1Z0-058 Online Practice Questions and Exam Preparation

Oracle 1Z0-058 Online Questions & Answers

• Question 41:

  orcl1, orcl2, and orcl3 are tnsnames that connect to predefined instances of a three-instance RAC database which uses ASM for shared storage.

  The database is in archivelog mode.

  Examine the Exhibit for the tnsnames.ora entries for orcl1, orcl2, and orcl3.

  

  You plan to execute the following RMAN commands to back up the database:

  RUN{

  ALLOCATE CHANNEL CH1 DEVICE TYPE DISK CONNECT 'user1/pwd1@orcl1'; ALLOCATE CHANNEL CH2 DEVICE TYPE DISK CONNECT 'user2/pwd2@orcl2'; ALLOCATE CHANNEL CH3 DEVICE TYPE DISK CONNECT 'user3/

  pwd3@orcl3'; BACKUP DATABASE PLUS ARCHIVELOG; }

  What should be the database mode on each of the three instances for this backup to succeed?

  A. The database can be either mounted or open on all three instances.
  B. The database must be open on all three instances.
  C. The database must be open on any one instance and mounted on the other two instances.
  D. The database must be mounted on any one of the instances and the other instances will be mounted automatically.
  A. The database can be either mounted or open on all three instances.

  ---

  connectStringSpec Purpose Use the connectStringSpec subclause to specify the user name, password, and net service name for connecting to a target, recovery catalog, or auxiliary database. The connection is necessary to authenticate the user and identify the database. Prerequisites You must have SYSDBA privileges to CONNECT to a target or auxiliary database. Do not connect to the recovery catalog database as user SYS. Usage Notes RMAN connections to a database are specified and authenticated in the same way as SQL*Plus connections to a database. The only difference is that RMAN connections to a target or auxiliary database require the SYSDBA privilege. The AS SYSDBA keywords are implied and cannot be explicitly specified. See Oracle Database Administrator's Guide to learn about database connection options when using SQL*Plus.

  Oracle?Database Backup and Recovery Reference 11g Release 2 (11.2)

• Question 42:

  What are the default connect strings used by SQL*Plus and ASMCMD when connecting to ASM instances?

  A. operating system authentication for ASMCMD; none for SQL*Plus
  B. "/ AS SYSASM" for ASMCMD; "/" for SQL*Plus
  C. "SYS/ AS SYSASM" for ASMCMD; "/ AS SYSDBA" for SQL*Pius
  D. operating system authentication for ASMCMD; operating system authentication for SQL*Plus
  E. "/ AS SYSASM" for ASMCMD; operating system authentication for SQL*Plus
  E. "/ AS SYSASM" for ASMCMD; operating system authentication for SQL*Plus

  ---

  On Linux and UNIX systems, dba is the default operating system group designated as OSASM, OSOPER, and OSDBA for Oracle ASM. On Windows systems, ora_dba is the default name des- ignated as OSASM, OSOPER, and OSDBA.

  SQL*Plus commands, ASMCMD commands, and ASMCA use operating system authentication To connect locally as SYSASM to an Oracle ASM instance using operating system authentica- tion with SQL*Plus, use the following statement:

  sqlplus / AS SYSASM

  OSASM group

  This group is granted the SYSASM privilege, which provides full administrative privileges for the Oracle ASM instance.

  You can specify the --privilege option to choose the type of connection, either SYSASM or SYS- DBA. The default value is SYSASM and is used when administering an Oracle ASM instance. Connect as SYSDBA when connecting to the

  database instance.

  For example:

  $ asmcmd --privilege sysasm

  usage: asmcmd [-V] [-v ] [--privilege ] [-p] [command]

• Question 43:

  Which three programs or utilities can be used to convert a single-instance database to a Real Application Cluster database?

  A. DBCA
  B. the SRVCTL utility
  C. Enterprise Manager
  D. the RCONFIG utility
  E. the CRSCTLl utility
  A. DBCA
  C. Enterprise Manager
  D. the RCONFIG utility

  ---

  Single Instance to RAC Conversion Single-instance databases can be converted to RAC using: DBCA Enterprise Manager RCONFIG utility

  D60488GC11 Oracle 11g: RAC and Grid Infrastructure Administration Accelerated

• Question 44:

  The Oracle 11g Release 2 (version 11.2.0.1) ASM instance has a new diskgroup named DATA that is currently not mounted. You log in to a cluster node as the Grid Infrastructure software owner and set the environment variables to point to

  the ASM instance on that node. Using SQL*Plus, you issue the commands:

  CONNECT / AS SYSDBA

  ALTER DISKGROUP DATA MOUNT;

  The system response is:

  ERROR at line 1:

  ORA-15032: not all alterations performed

  ORA-15260: permission denied on ASM disk group

  How do you diagnose this error?

  A. Check v$asm_operation for operations halted by the error.
  B. Check v$asm_attributes to determine the asm.compatible setting.
  C. Check v$asm_usergroup to determine the owning user group for this diskgroup.
  D. Check v$xs_session_role to determine the role privileges of the current user.
  E. Check the connect string for the privileged role.
  E. Check the connect string for the privileged role.

  ---

  Cause You have logged in with SYSDBA privilege that is not allowed for ASM operations Solution Login with SYSASM credentials for ASM operations MOS [ID 889810.1]

• Question 45:

  You are managing a three-instance Oracle RAC database which uses a Cluster File System for shared storage.

  Which two options can you use to ensure that the redo logs from all the instances are available during RMAN recovery from any instance?

  A. Set the LOG_ARCHIVE_DEST_1 parameter to a single location on the Cluster File System for each of the three instances and leave the LOG_ARCHIVE_FORMAT parameter with the default value.
  B. Set only the LOG_ARCHIVE_DEST_1 parameter to a single location on the Cluster File System for any one of the three instances and leave the LOG_ARCHIVE_FORMAT parameter with the default value.
  C. Set the LOG_ARCHIVE_DEST_1 parameter to a single location on the Cluster File System for each of the three instances, and the LOG_ARCHIVE_FORMAT parameter for each instance, to the same format including the thread number.
  D. Set the LOG_ARCHIVE_DEST_1 parameter to a single location on the Cluster File System, and set LOG_ARCHIVE_FORMAT parameter on only one instance.
  A. Set the LOG_ARCHIVE_DEST_1 parameter to a single location on the Cluster File System for each of the three instances and leave the LOG_ARCHIVE_FORMAT parameter with the default value.
  C. Set the LOG_ARCHIVE_DEST_1 parameter to a single location on the Cluster File System for each of the three instances, and the LOG_ARCHIVE_FORMAT parameter for each instance, to the same format including the thread number.

  ---

  Initialization Parameter Settings for the Cluster File System Archiving Scheme In the cluster file system scheme, each node archives to a directory that is identified with the same name on all instances within the cluster database (/arc_dest, in

  the following example). To configure this directory, set values for the LOG_ARCH_DEST_1 parameter, as shown in the following example:

  *.LOG_ARCHIVE_DEST_1="LOCATION=/arc_dest"

  Archived Redo Log File Conventions in Oracle RAC

  For any archived redo log configuration, uniquely identify the archived redo logs with the LOG_ARCHIVE_FORMAT parameter. The format of this parameter is operating system- specific and it can include text strings, one or more variables,

  and a filename extension. Use the %R or %r parameters to include the resetlogs identifier to avoid overwriting the logs from a previous incarnation. If you do not specify a log format, then the default is operating system-specific and includes %

  t, % s, and %r.

  Oracle?Real Application Clusters Administration and Deployment Guide 11g Release 2 (11.2)

• Question 46:

  Your cluster has Oracle Grid Infrastructure installed and working to support RAC databases and all the related resources.

  There is also a vendor HA software on the cluster providing HA services for some non-Oracle applications. You want to remove the vendor HA software and use Oracle Grid Infrastructure to provide the HA framework for your applications.

  The first application to be migrated to Oracle HA is used to display financial currency information at various fixed flat screens at a business park. This application must be owned by the Financial Application owner.

  Which three components of the framework are required to support this application for HA?

  A. an application VIP to support sending data to the screens
  B. a resource definition defining the application and various HA attributes
  C. privileges to permit the application to run as the correct user and to have the correct access rights to files
  D. an action program called by the HA framework for starting, stopping, and monitoring the application
  E. a resource dependency to make certain that the application VIP is started before the application is started and to start VIP automatically if it is down
  B. a resource definition defining the application and various HA attributes
  C. privileges to permit the application to run as the correct user and to have the correct access rights to files
  D. an action program called by the HA framework for starting, stopping, and monitoring the application

  ---

  Overview of Using Oracle Clusterware to Enable High Availability To manage your applications with Oracle Clusterware:

  1.

  Create an action script or use an existing agent.

  2.

  Register your applications as resources with Oracle Clusterware. If a single application requires that you register multiple resources, you may be required to define relevant dependencies between the resources.

  3.

  Assign the appropriate privileges to the resource.

  4.

  Start or stop your resources.

  Oracle?Clusterware Administration and Deployment Guide 11g Release 2 (11.2)

• Question 47:

  You notice that there is a very high percentage of wait time for RAC database that has frequent insert operations. Which two recommendations may reduce this problem?

  A. shorter transactions
  B. increasing sequence cache sizes
  C. using reverse key indexes
  D. uniform and large extent sizes
  E. automatic segment space management
  F. smaller extent sizes
  D. uniform and large extent sizes
  E. automatic segment space management

  ---

  Segments have High Water Mark (HWM) indicating that blocks below that HWM have been formatted. New tables or truncated tables [that is truncated without reuse storage clause], have HWM value set to segment header block. Meaning, there are zero blocks below HWM. As new rows inserted or existing rows updated (increasing row length), more blocks are added to the free lists and HWM bumped up to reflect these new blocks. HW enqueues are acquired in Exclusive mode before updating HWM and essentially HW enqueues operate as a serializing mechanism for HWM updates. Allocating additional extent with instance keyword seems to help in non- ASSM tablespace serialization of data blocks in the buffer cache due to lack of free lists, free list groups, transaction slots (INITRANS), or shortage of rollback segments. This is particularly common on INSERT-heavy applications, in applications that have raised the block size above 8K, or in applications with large numbers of active users and few rollback seg- ments. Use automatic segment-space management (ASSM) and automatic undo management to solve this problem. HW enqueue The HW enqueue is used to serialize the allocation of space beyond the high water mark of a segment. V$SESSION_WAIT.P2 / V$LOCK.ID1 is the tablespace number. V$SESSION_WAIT.P3 / V$LOCK.ID2 is the relative dba of segment header of the ob- ject for which space is being allocated. If this is a point of contention for an object, then manual allocation of extents solves the problem.

• Question 48:

  Which three describe how often OCR backups are taken and how many are retained, according to the default backup schedule?

  A. every 12 hours and the Clusterware keeps the last four copies
  B. every 4 hours and the Clusterware keeps the last three copies
  C. every day and the Clusterware keeps the last two copies
  D. every day and the Clusterware keeps the last three copies
  E. every week and the Clusterware keeps the last two copies
  B. every 4 hours and the Clusterware keeps the last three copies
  C. every day and the Clusterware keeps the last two copies
  E. every week and the Clusterware keeps the last two copies

  ---

  Locating the OCR Automatic Backups

  The OCR is backed up automatically.

  Only one node performs the backup.

  To determine the node and location of the backup:

  $ ocrconfig -showbackup auto

  host02 2009/07/28 12:20:42 /u01/app/.../cdata/cluster01/backup00.ocr host02 2009/07/28 08:20:41 /u01/ app/.../cdata/cluster01/backup01.ocr host02 2009/07/28 04:20:40 /u01/app/.../cdata/cluster01/ backup02.ocr host02 2009/07/27

  16:20:37 /u01/app/.../cdata/cluster01/day.ocr host02 2009/07/28

  00:20:39 /u01/app/.../cdata/cluster01/week.ocr

  Files could be spread across nodes due to outages. The backup frequency and retention policies are:

  Every four hours: CRS keeps the last three copies. At the end of every day: CRS keeps the last two copies. At the end of every week: CRS keeps the last two copies.

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

• Question 49:

  Which three statements are true about ASM dynamic volume manager (ADVM)?

  A. ADVM provides volume management services and a standard disk device driver interface to file system drivers.
  B. The administrator can use ADVM to create volumes that contain bootable vendor operating systems.
  C. File systems and other disk-based applications issue I/O requests to ADVM volume devices as they would to other storage devices on a vendor operating system.
  D. ADVM extends ASM by providing a disk driver interface to storage backed by an ASM volume.
  E. To use the ADVM driver, the oraclesacfs, oradeoks, and oracleadvm drivers must be loaded, but an ASM instance is not required.
  A. ADVM provides volume management services and a standard disk device driver interface to file system drivers.
  C. File systems and other disk-based applications issue I/O requests to ADVM volume devices as they would to other storage devices on a vendor operating system.
  D. ADVM extends ASM by providing a disk driver interface to storage backed by an ASM volume.

  ---

  At the operating system (OS) level, the ASM instance provides the disk group, which is a logical container for physical disk space. The disk group can hold ASM database files and ASM dynamic volume files. The ASM Dynamic Volume Manager (ADVM) presents the volume device file to the operating system as a block device. The mkfs utility can be used to create an ASM file system in the volume device file. Four OS kernel modules loaded in the OS provide the data service. On Linux, they are: oracleasm, the ASM module; oracleadvm, the ASM dynamic volume manager module; oracleoks, the kernel services module; and oracleacfs, the ASM file system module. These modules provide the ASM Cluster File System, ACFS snapshots, the ADVM, and cluster services. The ASM volumes are presented to the OS as a device file at /dev/asm/- . ADVM provides volume management services and a standard disk device driver interface to clients. Clients, such as file systems and other disk-based applications, issue I/O requests to ADVM volume devices as they would to other storage devices on a vendor operating system. ADVM extends ASM by providing a disk driver interface to storage backed by an ASM file. The administrator can use the ADVM to create volumes that contain file systems. These file systems can be used to support files beyond Oracle database files such as executables, report files, trace files, alert logs, and other application data files. With the addition of ADVM and ACFS, ASM becomes a complete storage solution of user data for both database and non-database file needs. ACFS is intended as a general file system accessible by the standard OS utilities. ACFS can be used in either a single server or a cluster environment. Note: Oracle ACFS file systems cannot be used for an Oracle base directory or an Oracle grid infrastructure home that contains the software for Oracle Clusterware, ASM, Oracle ACFS, and Oracle ADVM components. Oracle ACFS file systems cannot be used for an OS root directory or boot directory. ASM volumes serve as containers for storage presented as a block device accessed through ADVM. File systems or user processes can do I/O on this "ASM volume device" just as they would on any other device. To accomplish this, ADVM is configured into the operating system. A volume device is constructed from an ASM file.

  D60488GC11 Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 10 - 3,4,5

• Question 50:

  When creating an Oracle Cluster database using DBCA the "Memory size (SGA and PGA)" field is supplied on value of 2000 MB. Identify the default block Size used for the database.

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

  ---

  Type of Limit Limit Value Minimum 2k.Must be a multiple of operating system physical block size Maximum Operating system dependent, but never more than 32 KB DBCA tab sizing In this tab, you specify the smallest block size and the maximum number of operating system user processes that can simultaneously connect to the database. 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 cre- ated 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. Oracle?Database 2 Day DBA