[Free] 2018(Jan) Latesttests Testking Oracle 1z0-058 Dumps with VCE and PDF Download 41-50

Latesttests 2018 Jan Oracle Official New Released 1z0-058
100% Free Download! 100% Pass Guaranteed!
http://www.Latesttests.com/1z0-058.html

Oracle Real Application Clusters 11g Release 2 and Grid Infrastructure Administration

Question No: 41

: 10

Which two statements are true about ACFS snapshots?

  1. They can be created for ACFS file systems only if the ASM disk group hosting the ADVM volume file used by the file system has free space available.

  2. They can be created for ACFS file systems only if the ADVM volume file used by the file system has free space available.

  3. They can be created only if the ASM disk group hosting the ADVM volume used by the file system has no other ASM files contained in the disk group.

  4. They can be created when ACFS is used both on clusters and on stand-alone servers.

  5. They are accessible only on the cluster node that was used when creating the snapshot.

Answer: B,D Explanation:

About Oracle ACFS Snapshots

Oracle ACFS snapshot storage is maintained within the file system, eliminating the management of separate storage pools for file systems and snapshots. Oracle ACFS file systems can be dynamically resized to accommodate additional file and snapshot storage requirements.

Oracle庐 Automatic Storage Management Administrator#39;s Guide 11g Release 2 (11.2)

Question No: 42

Examine the following output:

[oracle@gr5153~]$srvctl add service -d RACDB -s erp -g pool1 -c uniform -y manual

[oracle0gr5153~]$srvctl start service -d RACDB -s ERP

[oracle@gr5153~]$crsctl stat res ora.racdb.erp.svc NAME=ora.racdb.erp.svc TYPE=ora.service.type

TARGET=ONLINE, ONLINE, ONLINE STATE=ONLINE on gr5118, ONLINE on gr5152,

ONLINE on gr5153

[oracle@gr5153~]$ srvctl config database -d RACDB Database unique name: RACDB

Database name: RACDB

Oracle home:/u01/app/oracle/product/11.2.0/dbhome_1 Oracle user:oracle Spfile: DATA/RACDB/spfileRACDB.ora

Domain:

Start options:open Stop options:immediate

Database role:PRIMARY Management policy:AUTOMATIC Server pools:POOL 1

Database instances: Disk Groups:DATA, FRA Services:ERP

Database is policy managed

$srvctl stop database -d RACDB -o immediate

Which two statements are true regarding the srvctl stop command?

  1. It will shut down all the instances of the RACDB database.

  2. It will shut down only the RACDB instance and the ERP service on the node on which the Command is executed.

  3. It will shut down only the database instance on the node on which the command is executed.

  4. It will stop the ERP service related to the RACDB database on all the nodes.

Answer: A,D

Explanation: Shut down all Oracle RAC instances on all nodes. To shut down all Oracle RAC instances for a database, enter the following command, where db_name is the name of the database:

srvctl stop database -d db_name

Stops a database, its instances, and its services. When the database later restarts, services with AUTOMATIC management start automatically but services with MANUAL management policy must be started manually.

Oracle Real Application Clusters Administration and Deployment Guide

Question No: 43

You need to set up a three-Instance RAC database. The data files and fast recovery area will be stored in ASM diskgroups called data and fra, respectively. The ASM disk groups will be mounted on all ASM Instances.

Which are the two best location options for archivelogs so that they can be accessed during recovery without DBA intervention?

  1. Cluster File System with each instance writing to a shared location

  2. Cluster File System with each instance writing to a separate location as long as all the locations are in directories under the same mount point

  3. the ASM diskgroup fra with the db_recovery_file_dest parameter set to the same value on all instances

  4. a raw or block device

Answer: A,C

Explanation: The primary consideration when configuring archiving is to ensure that all archived redo logs can be read from every node during recovery, and if possible during backups. During recovery, because the archived log destinations are visible from the node that performs the recovery, Oracle RAC can successfully recover the archived redo log data.

The fast recovery area for an Oracle RAC database must be placed on an Oracle ASM disk group, a cluster file system, or on a shared directory that is configured through a network file system file for each Oracle RAC instance. In other words, the fast recovery area must be shared among all of the instances of an Oracle RAC database. The preferred

configuration for Oracle RAC is to use Oracle Automatic Storage Management (Oracle ASM) for storing the fast recovery area, using a different disk group for your recovery set than for your data files.

The location and disk quota must be the same on all instances. Oracle recommends that you place the fast recovery area on the shared Oracle ASM disks. In addition, you must set the DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE parameters to the same values on all instances.

Oracle Database 2 Day Real Application Clusters Guide

Question No: 44

Identify the three forms of link aggregation that are supported by Oracle Ciusterware for the interconnect.

  1. single switch active/standby configuration to increase redundancy for high availability

  2. single switch active/active configuration to increase bandwidth for performance

  3. multiswitch active/standby configuration to increase redundancy for high availability

  4. multiswitch active/active configuration to increase bandwidth for performance

Answer: A,B,C Explanation:

Interconnect Link Aggregation: Single Switch

->Link aggregation can be used to increase redundancy for higher availability with an Active/Standby configuration.

->Link aggregation can be used to increase bandwidth for performance with an

Active/Active configuration.

Interconnect Link Aggregation: Multiswitch

->Redundant switches connected with an Inter-Switch Trunk may be used for an enhanced highly available design.

->This is the best practice configuration for the interconnect.

With the single switch solutions presented in the previous slide, a failure at the switch level would bring down the entire interconnect. A better highly available (HA) design would be to implement a redundant switch strategy as illustrated in the slide, with an Inter-Switch Trunk connecting the switches. This is the best practice design for the Oracle Clusterware interconnect. Only Active/Standby mode is supported in this configuration.

D60488GC11

Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 1 – 12,13,14

Question No: 45

Which two statements are true regarding undo management in the RAC environment?

  1. You can use Automatic Undo Management (AUM) in some of the instances and manual undo management in the rest of the instances in a RAC database.

  2. In a policy-managed RAC database, Oracle automatically allocates the undo tablespace even the Oracle Managed Files (OMF) is disabled in a database.

  3. In a policy-managed RAC database, Oracle automatically allocates the undo tablespace if the database is OMF enabled.

  4. You can dynamically switch undo tablespace assignments by executing the ALTER SYSTEM SET UNDO_TABLESPACE statement from any instance in a administrator managed database.

Answer: C,D

Explanation: You assign undo tablespaces in your Oracle RAC administrator-managed database by specifying a different value for the UNDO_TABLESPACE parameter for each instance in your SPFILE or individual PFILEs. For policy-managed databases, Oracle automatically allocates the undo tablespace when the instance starts if you have Oracle Managed Files enabled.

You can switch from using one undo tablespace to another. Because the UNDO_TABLESPACE initialization parameter is a dynamic parameter, the ALTER SYSTEM SET statement can be used to assign a new undo tablespace.

Question No: 46

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?

  1. 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.

  2. 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.

  3. 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.

  4. Neither the Cluster Ready Services Daemon (crsd) nor the Cluster Synchronization Services Daemon (cssd) is running on RACNODE3.

Answer: A

Explanation: 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 management 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 No: 47

Which three statements are true about ASM performance and scalability?

  1. Disks in a diskgroup may be of varying speed and capacity without affecting performance.

  2. Disks in a diskgroup should match in speed and capacity for best performance.

  3. A database seldom needs more than two diskgroups: one for data and the other for a fast recovery area.

  4. A database needs a separate diskgroup for each major tablespace, redo logs, and fast recovery area.

  5. Multiple databases that use the same diskgroup make the best use of space.

  6. Multiple databases that use a separate diskgroup for each database make the best use of space.

Answer: B,C,E Explanation: Section: (none)

Performance, Scalability, and Manageability Considerations for Disk Groups Create separate disk groups for database files and fast recovery area.

Disks in a disk group should have the same size and performance characteristics.

  • Allows the disk group to deliver consistent performance

  • Allows ASM to use disk space most effectively

  • Allows operations with different storage requirements to be matched with different disk groups effectively

Using separate disk groups for each database as opposed to having multiple databases in a disk group has various benefits and drawbacks.

Housing multiple databases in a single disk group affords the most efficient use of space. However, any faults or maintenance that affects the disk group may affect many databases. Separate disk groups provide greater isolation from the effects of a fault or maintenance operation. However, to achieve this may consume more disk space and may require more disk group maintenance to balance disk resources.

D60488GC11

Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 8 – 37

Question No: 48

: 8

Some new non-ASM shared storage has been made available by the storage administrator, and the Oracle Grid Infrastructure administrator decides to move the voting disks, which do not reside in ASM, to this new non-ASM location. How can this be done?

  1. by running crsctl add css votedisk lt;path_to_new_locationgt; followed by crsctl delete css

    -votedisk lt;path_to_old_locationgt;

  2. by running crsctl replace css votedisk lt;path_to_old_location,path_to_new_locationgt;

  3. by running srvctl replace css votedisk lt;path_to_old_location, path_to_new_locationgt;

  4. by running srvctl add css votedisk lt;path_to_new_locationgt; followed by srvctl delete css votedisk lt;path_to_old_locationgt;

Answer: A Explanation:

Adding, Deleting, or Migrating Voting Disks

Modifying voting disks that are stored in Oracle ASM

To migrate voting disks from Oracle ASM to an alternative storage device, specify the path to the non-Oracle

ASM storage device with which you want to replace the Oracle ASM disk group using the following command:

$ crsctl replace votedisk path_to_voting_disk

You can run this command on any node in the cluster.

To replace all voting disks not stored in Oracle ASM with voting disks managed by Oracle ASM in an Oracle

ASM disk group, run the following command:

$ crsctl replace votedisk asm_disk_group

Modifying voting disks that are not stored on Oracle ASM:

To add one or more voting disks, run the following command, replacing the path_to_voting_disk variable with one or more space-delimited, complete paths to the voting disks you want to add:

$ crsctl add css votedisk path_to_voting_disk […]

To replace voting disk A with voting disk B, you must add voting disk B, and then delete voting disk A. To add a new disk and remove the existing disk, run the following command, replacing the path_to_voting_diskB variable with the fully qualified path name of voting disk B:

$ crsctl add css votedisk path_to_voting_diskB -purge

The -purge option deletes existing voting disks.

To remove a voting disk, run the following command, specifying one or more space- delimited, voting disk FUIDs or comma-delimited directory paths to the voting disks you want to remove:

$ crsctl delete css votedisk {FUID | path_to_voting_disk[…]}

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

Question No: 49

: 9

Which three statements are true about using RMAN with ASM?

  1. RMAN is the only supported method to back up database files stored in ASM.

  2. RMAN is the only supported method to back up ACFS files.

  3. RMAN can use ASM storage for backups.

  4. RMAN cannot use ASM storage for backups.

  5. Using RMAN, database files can be migrated to ASM from a file system.

  6. Using RMAN, database files cannot be moved from ASM to a file system

Answer: A,C,E Explanation:

->RMAN is also critical to Automatic Storage Management (ASM). Since ASM is

critical to GRID operations, RMAN is then critical for GRID based systems. In ASM, RMAN is responsible for tracking the ASM filenames and for performing the deletion of obsolete ASM files. ASM files cannot, however, be accessed through normal operating system interfaces; therefore, RMAN is the preferred means of copying ASM files. It is also possible to use FTP through XDB, but generally, RMAN will be less complex. It is important to learn to use RMAN first because RMAN is the only method for performing backups of a database containing ASM files.

->Setting Initialization Parameters for ASM

The procedure for creating a duplicate database to an ASM location is similar to the procedure described in quot;Settings and Restrictions for OMF Initialization Parametersquot; on page 25-4. The difference is that you must identify the initialization parameters that control the location where files are created and set these parameters to an ASM disk group. For example, set DB_CREATE_FILE_DEST, DB_CREATE_ONLINE_DEST_n,and CONTROL_FILES to DISK1.

->To take advantage of Automatic Storage Management (ASM) with an existing

database you must migrate that database into ASM. This migration is performed

using Recovery Manager (RMAN) even if you are not using RMAN for your primary backup and recovery strategy.

Oracle庐 Database Backup and Recovery Advanced User#39;s Guide

Question No: 50

Which two statements are true regarding the Average Active Sessions chart on the performance page

  1. It shows active aggregate wait class statistics across all the instances In the cluster database.

  2. It shows active aggregate wait class per instance for all the instances In the cluster database.

  3. If the Average Active Sessions chart displays a large number of sessions waiting, indicating internal contention, but the throughput is high, then the situation may be acceptable.

  4. If the Average Active Sessions chart displays a large number of sessions waiting, indicating internal contention, but the throughput is low, then the CPU needs to be upgraded

Answer: A,C

Explanation: Chart for Average Active Sessions

The Average Active Sessions chart in the Cluster Database Performance page shows potential problems inside the database. Verifying the Interconnect Settings for Oracle RAC Categories, called wait classes, show how much of the database is using a resource, such as CPU or disk I/O. Comparing CPU time to wait time helps to determine how much of the response time is consumed with useful work rather than waiting for resources that are potentially held by other processes.

Compare the peaks on the Average Active Sessions chart with those on the Database Throughput charts. If the Average Active Sessions chart displays a large number of sessions waiting, indicating internal contention, but throughput is high, then the situation may be acceptable.

Oracle Database 2 Day Real Application Clusters Guide

100% Free Download!
Download Free Demo:1z0-058 Demo PDF
100% Pass Guaranteed!
Download 2018 Latesttests 1z0-058 Full Exam PDF and VCE

Latesttests ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2018 Latesttests IT Certification PDF and VCE