[Free] 2018(Jan) EnsurePass Passguide Oracle 1z0-058 Dumps with VCE and PDF 11-20

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-058
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/1z0-058.html

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

Question No: 11

You want to check an ACFS for consistency on the Linux platform. Which command-line tool would you use to do this?

  1. advmutil

  2. asmcmd

  3. fsck

  4. acfsutil

  5. fdisk

    Answer: C Explanation:

    Dismounting an Oracle ACFS File System

    You can dismount a file system without deregistering the file system or disabling the volume on which the file system is mounted.

    For example, you can dismount a file system and run fsck to check the file system.

    # /bin/umount /u01/app/acfsmounts/myacfs

    # /sbin/fsck -a -v -y -t acfs /dev/asm/volume1-123

    After you dismount a file system, you must explicitly mount the file system.

    1. Use umount on Linux systems or acfsdismount on Windows systems. For information about the commands to dismount a file system, see quot;umountquot; or quot;acfsdismountquot;.

    2. Use fsck on Linux systems or acfschkdsk on Windows systems to check a file system. For information about the commands to check a file system, see quot;fsckquot; or quot;acfschkdskquot;.

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

      Question No: 12

      Under which account(s) can the Oracle Clusterware processes run for the Linux platform?

      1. only the root account

      2. only the Grid Infrastructure owner account

      3. only the database software owner account

      4. some under the Grid Infrastructure owner account and some under the root account

      5. some under the database software owner account and some under the root account

Answer: D

Explanation: Because Oracle Clusterware works closely with the operating system, system administrator privileges are required for some installation tasks. In addition, some Oracle Clusterware processes must run as the special operating system user, root.

Oracle Database 2 Day Real Application Clusters Guide

Question No: 13

The original cluster on RACNODE1, RACNODE 2, RACNODE 3, and RACNODE4 had the

Oracle Grid Infrastructure installed to support Grid Naming Service (GNS).

What should be done to verify that the two new nodes called RACNODE5, RACNODE6 are physically connected?

  1. cluvfy stage -post crsinst -n RACNODE5,RACNODE6 -verbose

  2. cluvfy stage -post nodeadd -n RACNODE5,RACNODE6 -verbose

  3. cluvfy stage -post hacfg -verbose

  4. cluvfy stage -post nodeadd -n all -verbose

Answer: B Explanation:

Completing OUI Silent Node Addition Perform integrity checks on the cluster.

[grid@host01]$ cluvfy stage -post nodeadd -n host03 -verbose D60488GC11

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

Question No: 14

: 4

You are in the planning stages for upgrading your Oracle RAC database from Oracle Database 10g Release 2 to Oracle Database 11g Release 2 to run under the Oracle Grid Infrastructure.

You decide to use an administrator-managed configuration because the cluster is fairly small.

Which statement is correct about this configuration?

  1. A parent pool of the GENERIC server pool will be used.

  2. You must define a new server pool called MANUAL.

  3. A subpool of the GENERIC server pool will be used.

  4. A subpool of the FREE server pool will be used.

Answer: C

Explanation: With Oracle RAC 11g Release 2, there is only a database resource define to Oracle Clusterware. This resource will contain the Oracle Home, the spfile, the server pool(s) and the ASM diskgroup(s) required for the database. The database resource will

have a weak start dependency on the VIP which means it will try to start the VIP for the node when the instance starts however if the VIP does not start successfully, the instance will still be started. When reviewing the database resource for an administrator Managed database, you will see a server pool defined with the same name as the Oracle database. This pool will be part of a special Oracle defined server pool called Generic. The Generic server pool is managed by Oracle to support Administrator Managed databases. The server pools that are part of Generic will be automatically created or removed when you add or remove an Administrator Managed database.

Oracle Database 11gR2 Upgrade Companion (Version 2.70)

Question No: 15

The Global Cache Block Access Latency chart shows high elapsed times. What are two possible causes for this?

  1. badly written SQL statements

  2. storage network bottlenecks

  3. a large number of requested blocks not cached in any instance

  4. slow or faulty interconnect

Answer: A,D Explanation:

About Global Cache Block Access Latency Chart

If the Global Cache Block Access Latency chart shows high latencies (high elapsed times), then this can be caused by any of the following:

A high number of requests caused by SQL statements that are not tuned.

A large number of processes in the queue waiting for the CPU, or scheduling delays. Slow, busy, or faulty interconnects. In these cases, check your network connection for dropped packets, retransmittals, or cyclic redundancy check (CRC) errors.

Oracle庐 Database 2 Day Real Application Clusters Guide 11g Release 2 (11.2)

Question No: 16

You use the following command to create a disk group:

CREATE DISRGROUP DATA NORMAL REDUNDANCY

FAILGROUP fg_f ra_l DISK #39;/dev/sda6#39; NAME FRA_DISKl, #39;/dev/sda7#39; NAME FRA_DISK2 FAILGROUP fg_fra_2 DISK #39;/dev/sdb1#39; NAME FRA_DISK3, #39;/dev/sdb2#39; NAME FRA_DISK4 FAILGROUP fg_fra_3 DISK #39;/dev/sdc1#39; NAME FRA_DISK5, #39;/dev/sdc2#39; NAME FRA_DISK6 ATTRIBUTES

#39;AU_SIZE#39; = #39;4M#39;

#39;compatible.rdbms#39; = #39;11.1.0#39;;

Which two statements are true about the data disk group?

  1. Each disk in a failure group is a mirror of the corresponding disk in the other failure groups. For example,

    FRA_DISK2 is a mirror of FRA_DISK4 and FRA_DISK6.

  2. By default, the files created in this disk group must have, for each extent, one primary copy and two mirror copies; one on each of the failure groups.

  3. Because the size clause is not used, the disk group uses the same amount of space on each disk.

  4. The #39;compatible. rdbms#39; attribute specifies the minimum COMPATIBLE setting for any database using this disk group.

  5. If the FRA_DISK2 disk fails, there are mirrored copies in one of the other failure groups for any primary extents that are on FRA_DISK2.

  6. The allocation unit, AU_SIZE, sets the size of the disk read and write to ASM diskgroups.

Answer: D,E Explanation:

About Mirroring and Failure Groups

Mirroring protects data integrity by storing copies of data on multiple disks. When you create a disk group, you specify an Oracle ASM disk group type based on one of the following three redundancy levels:

Normal for 2-way mirroring High for 3-way mirroring

External to not use Oracle ASM mirroring, such as when you configure hardware RAID for redundancy

The redundancy level controls how many disk failures are tolerated without dismounting the disk group or losing data. The disk group type determines the mirroring levels with which Oracle creates files in a disk group.

For information about disk group types and templates, see quot;Managing Disk Group Templatesquot;.

Oracle ASM mirroring is more flexible than traditional RAID mirroring. For a disk group specified as NORMAL redundancy, you can specify the redundancy level for each file. For example, two files can share the same disk group with one file being mirrored while the other is not.

When Oracle ASM allocates an extent for a mirrored file, Oracle ASM allocates a primary copy and a mirror copy. Oracle ASM chooses the disk on which to store the mirror copy in a different failure group than the primary copy. Failure groups are used to place mirrored copies of data so that each copy is on a disk in a different failure group. The simultaneous failure of all disks in a failure group does not result in data loss.

You define the failure groups for a disk group when you create an Oracle ASM disk group. After a disk group is created, you cannot alter the redundancy level of the disk group. If you omit the failure group specification, then Oracle ASM automatically places each disk into its own failure group, except for disk groups containing disks on Oracle Exadata cells. Normal redundancy disk groups require at least two failure groups. High redundancy disk groups require at least three failure groups. Disk groups with external redundancy do not use failure groups.

Allocation Units

Every Oracle ASM disk is divided into allocation units (AU). An allocation unit is the fundamental unit of allocation within a disk group. A file extent consists of one or more allocation units. An Oracle ASM file consists of one or more file extents.

When you create a disk group, you can set the Oracle ASM allocation unit size with the AU_SIZE disk group attribute. The values can be 1, 2, 4, 8, 16, 32, or 64 MB, depending on

the specific disk group compatibility level. Larger AU sizes typically provide performance advantages for data warehouse applications that use large sequential reads.

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

Question No: 17

The Oracle Grid Infrastructure administrator runs ocrconfig -backupioc lt;new_locationgt; after completing the installation of the Grid Infrastructure. What are the two reasons for doing this

  1. The master node may change if the node running the master CRS daemon shuts down causing another node to become the master. Because the default location is a nonshared storage, and only the master node performs backups, the backups could be spread around on many nodes making management or recovery more difficult.

  2. The cluster node currently acting as the master node for CRS is the only node that backs up the OCR to the default location, and by changing the location, all cluster nodes will then take backups.

  3. This is done to move the backup location into an ASM Cluster File System directory so that the backups benefit from ASM striping and mirroring.

  4. If for any reason CRS must be stopped on all nodes for a time spanning a scheduled backup, then on restart, the backup timer will be reset. This could result in longer time duration between automatic backups than the standard four-hour interval.

Answer: A,D Explanation:

Changing the Automatic OCR Backup Location

The automatic backup location should be changed to a location shared by all nodes.

# ocrconfig -backuploc lt;path to shared CFS or NFSgt;

The backup location will be used for both automatic and manual backups.

It is recommended that these files be included in routine scheduled backups to an offline location.

If CRS has been stopped on all nodes, the schedule of backups is suspended. On restart, a backup is not immediately taken and the backup timer is reset.

D60488GC11

Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 3 – 12

Question No: 18

Which command will set full debugging for the communications and resource management components; of the CRS module on nodes host01 and host03?

  1. srvctl set log -m CRS -C CRSCTI 5, CRSCOMM 5 -n host0l,host03

  2. ocrconfig set log CRS quot;CRSRTI,CRSCOMM:5 quot; -nodelist host01,host03

  3. crsctl set log CRS quot;CRSRTI:5,CRSCOMM:5quot; -nodelist host0l,host03

  4. crsctl lsmodules crs set log CRSRTI:5,CRSCOMM:5 -nodelist host0l, host03

Answer: C

Explanation: crsctl set log

Use the crsctl set log command to set log levels for Oracle Clusterware.

You can enable debugging for Oracle Clusterware modules and their components, and for resources, by setting environment variables or by running crsctl set log commands, using the following syntax:

Syntax

crsctl set {log | trace} module_name quot;component:debugging_level [,component:debugging_level][,…]quot;

Usage Notes

You can set log levels for various components of the three modules, CRS, CSS, and EVM. If you choose the all option, then you can set log levels for all components of one module with one command. Use the crsctl lsmodules command to obtain a list of components for each module. Enter a comma-delimited list of component name-log level pairs enclosed in double quotation marks (quot;quot;).

The log_level is a number from 1 to 5 that sets the log level for the component or resource, where 1 is the least amount of log output and 5 provides the most detailed log output. The default log level is 2.

To set log levels for resources, specify the name of a particular resource, or a comma- delimited list of resource name-log level pairs enclosed in double quotation marks (quot;quot;). To set debugging levels on specific cluster nodes, include the -nodelist keyword and the names of the nodes, as follows:

crsctl set log crs quot;CRSRTI:1,CRSCOMM:2quot; -nodelist node1,node2 Oracle Clusterware Administration and Deployment Guide

Question No: 19

As part of your data center#39;s high availability strategy, you are creating resource definitions to control the management of a web-based application by the Oracle Grid Infrastructure clusterware stack.

The application and its VIP are normally online on one node of a four-node cluster due to the CARDINALITY of the resource type being set to 1.

You have chosen a policy-managed resource type for the application by using a server pool that uses only RACNODE3 and RACNODE4. The START ATTEMPTS attribute for the resource is set to 2 and FAILURE

INTERVAL is set to 60.

What is true about the attributes that may be set to control the application?

  1. The clusterware will attempt to start the application on the same node twice within the server pool as long as that node is up. If the node fails, then the VIP and the application will be failed over to the other node in the server pool immediately.

  2. The clusterware will attempt to start the application on the same node twice within the server pool as long as that node is up. If the node fails, then the VIP and the application will be failed over to the other node in the server pool only after two 60-second intervals have elapsed.

  3. The clusterware will attempt to start the application on the same node twice within the server pool as long as that node is up. If the application fails to start after 60 seconds, but the node is still up, then the VIP and the application will NOT be failed over to the other node in the server pool.

  4. The clusterware will attempt to start the application on the same node twice within the server pool as long as that node is up. If the application fails to start immediately but the node is still up, then the VIP and the application will NOT be failed over to the other node in the server pool.

Answer: A Explanation: CARDINALITY

The number of servers on which a resource can run, simultaneously. This is the upper limit for resource cardinality.

RESTART_ATTEMPTS

The number of times that Oracle Clusterware attempts to restart a resource on the

resource#39;s current server before attempting to relocate it. A value of 1 indicates that Oracle Clusterware only attempts to restart the resource once on a server. A second failure causes Oracle Clusterware to attempt to relocate the resource. A value of 0 indicates that there is no attempt to restart but Oracle Clusterware always tries to fail the resource over to another server.

FAILURE_INTERVAL

The interval, in seconds, before which Oracle Clusterware stops a resource if the resource has exceeded the number of failures specified by the FAILURE_THRESHOLD attribute. If the value is zero (0), then tracking of failures is disabled.

FAILURE_THRESHOLD

The number of failures of a resource detected within a specified FAILURE_INTERVAL for the resource before Oracle Clusterware marks the resource as unavailable and no longer monitors it. If a resource fails the specified number of times, then Oracle Clusterware stops the resource. If the value is zero (0), then tracking of failures is disabled. The maximum value is 20.

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

Question No: 20

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

  1. 2 KB

  2. 4 KB

  3. 8 KB

  4. 16 KB

  5. 32 KB

Answer: C

Explanation: Type of LimitLimit Value

Minimum2k.Must be a multiple of operating system physical block size MaximumOperating 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 created 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

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

EnsurePass 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

Leave a Reply

Your email address will not be published. Required fields are marked *