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

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: 51

Which two actions in a warehousing RAC database may cause concurrent cross-instance calls leading to I/O contention?

  1. truncate table statements

  2. select statements referring to non-partitioned tables

  3. drop table statements

  4. insert statements where each instance inserts into different partitions of a partitioned table

Answer: A,C Explanation:

Concurrent Cross-Instance Calls: Considerations

In data warehouse and data mart environments, it is not uncommon to see a lot of TRUNCATE operations.

These essentially happen on tables containing temporary data. In a RAC environment, truncating tables concurrently from different instances does not scale well, especially if, in conjunction, you are also using direct read operations such as parallel queries.

As shown in the slide, a truncate operation requires a cross-instance call to flush dirty blocks of the table that may be spread across instances. This constitutes a point of serialization. So, while the first TRUNCATE command is processing, the second has to wait until the first one completes.

There are different types of cross-instance calls. However, all use the same serialization mechanism.

For example, the cache flush for a partitioned table with many partitions may add latency to a corresponding parallel query. This is because each cross-instance call is serialized at the cluster level, and one crossinstance call is needed for each partition at the start of the parallel query for direct read purposes.

D60488GC11

Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 14 – 27

What Application Design considerations should I be aware of when moving to Oracle RAC? The general principals are that fundamentally no different design and coding practices are required for RAC however application flaws in execution or design have a higher impact in RAC. The performance and scalability in RAC will be more sensitive to bad plans or bad schema design. Serializing contention makes applications less scalable. If your customer uses standard SQL and schema tuning, it solves gt; 80% of performance problems

Some of the scaleability pitfalls they should look for are:

* Serializing contention on a small set of data/index blocks

-gt; monotonically increasing key

-gt; frequent updates of small cached tables

-gt; segment without automatic segment space management (ASSM) or Free List Group (FLG)

  • Full table scans

    -gt; Optimization for full scans in 11g can save CPU and latency

  • Frequent invalidation and parsing of cursors

    -gt; Requires data dictionary lookups and synchronizations

  • Concurrent DDL ( e.g. truncate/drop ) Look for:

  • Indexes with right-growing characteristics

    -gt; Use reverse key indexes

    -gt; Eliminate indexes which are not needed

  • Frequent updated and reads of “small” tables

    -gt; “small”=fits into a single buffer cache

    -gt; Use Sparse blocks ( PCTFREE 99 ) to reduce serialization

  • SQL which scans large amount of data

-gt; Perhaps more efficient when parallelized

-gt; Direct reads do not need to be globally synchronized ( hence less CPU for global cache

)

RAC: Frequently Asked Questions [ID 220970.1]

Question No: 52

You are creating a resource definition called WEBAPP for a web-based application that requires an application called WEBVIP.

Both WEBVIP and WEBAPP are normally active on a single node, but may fail over if required to another cluster node in your eight-node cluster.

A second VIP application resource called appsvip exists, used by a second application resource called secapp. webvip and webapp must start In the correct sequence.

Which two start dependencies would you use for the WEBAPP application resource definition?

  1. hard(SECAPP)

  2. pullup(SECAPP)

  3. pullup (WEBVIP)

  4. hard(WEBVlP)

  5. dispersion(WEBVIP)

  6. weak (WEBVIP)

Answer: C,D Explanation:

Start Dependencies hard

Define a hard start dependency for a resource if another resource must be running before the dependent resource can start. For example, if resource A has a hard start dependency on resource B, then resource B must be running before resource A can start.

Note:

Oracle recommends that resources with hard start dependencies also have pullup start dependencies. weak

If resource A has a weak start dependency on resource B, then an attempt to start resource A attempts to start resource B, if resource B is not running. The result of the attempt to start resource B is, however, of no consequence to the result of starting resource A.

attraction

If resource A has an attraction dependency on resource B, then Oracle Clusterware prefers to place resource A on servers hosting resource B. Dependent resources, such as resource A in this case, are more likely to run on servers on which resources to which they have attraction dependencies are running. Oracle Clusterware places dependent resources on servers with resources to which they are attracted.

pullup

Use the pullup start dependency if resource A must automatically start whenever resource B starts. This dependency only affects resource A if it is not running. As is the case for other dependencies, pullup may cause the dependent resource to start on any server. Use the pullup dependency whenever there is a hard stop dependency, so that if resource A depends on resource B and resource B fails and then recovers, then resource A is restarted.

dispersion

If you specify the dispersion start dependency for a resource, then Oracle Clusterware starts this resource on a server that has the fewest number of resources to which this resource has dispersion. Resources with dispersion may still end up running on the same server if there are not enough servers to disperse them to.

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

Question No: 53

A third party application has provided files containing the command syntax required to register and manage the application for high availability with Oracle Grid Infrastructure.

The command to define the application is as follows: crsctl add resource LongApp -type cluster_resource -attr

quot;ACTION_SCRIPT=’/u01/ogi/scripts/longapp.scr’ , PLACEMENT=’restricted’ ,

HOSTING_MEMBERS=’RACNODE1 RACNODE2 , CHECK_INTERVAL=’30

,START_DEPENDENCIES=’hard(LongAppvip)’ , STOP_DEPENDENCIES=’hard (LongAppvip)’, RESTART_ATTEMPTS=’2quot;

Which two statements are true about the behavior of this resource after it is added?

  1. It will be a policy-managed resource using the server pool containing nodes RACNODE1 and RACNODE2.

  2. The LongAppvip vip resource must be activated to successfully activate this resource, but wl not be activated automatically if not already active.

  3. The LongAppvip vip resource must be stopped before this resource is stopped.

  4. It will be an administrator-managed resource hosted by nodes RACNODE1 and RACNODE2.

Answer: B,D Explanation:

Configurable Resource Attributes

HOSTING_MEMBERS

A space-separated, ordered list of cluster server names that can host a resource. This attribute is required only when using administrator management, and when the value of the PLACEMENT attribute is set to favored or restricted. When registering applications as Oracle Clusterware resources, use the SERVER_POOLS attribute, instead.

START_DEPENDENCIES

hard([intermediate:][global:]{resource_name | type:resource_type})-Specify a hard start dependency for a resource when you want the resource to start only when a particular resource or resource of a particular type starts. weak([concurrent:][global:][uniform:]{resource_name | type:resource_type})-Specify a

weak start dependency for a resource when you want that resource to start despite whether named resources are running, or not. An attempt to start this resource also attempts to start any resources on which this resource depends if they are not running.

STOP_DEPENDENCIES

hard([intermediate:][global:][shutdown:]{resource_name | type:resource_type})-Specify a hard stop dependency for a resource that you want to stop when named resources or resources of a particular resource type stop.

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

Question No: 54

In the high availability services#39; provided by Oracle Clusterware are used to protect Oracle resource such as RAC database instances, RAC database services, and other components of the Oracle Infrastructure, and non-Oracle resources as well.

Which two statements are true about the high availability capabilities of Oracle HA services?

  1. RAC databases may have their instances failed over in some cases.

  2. ASM instances may be failed over if fewer than three nodes remain In the cluster, so that there are always at least three ASM instances available.

  3. If a node fails, then all resources that were active on that node will be failed over to a surviving node if any exists.

  4. If a node fails, then cluster resources that were active on that node may be failed over to a surviving node if any exists, but local resources are not failed over.

  5. HA services will only fail over a resource upon failure of the node where the resource was active.

Answer: D,E

Question No: 55

You have defined two server pools.

One is called OLTP with MIN_SIZE=3, MAX_SIZE =5 and IMPORTANCE=3.

The other is called DSS with MIN_SIZE =2, MAX_SIZE =4 and IMPORTANCE =5.

Your cluster currently has four nodes with two nodes in each of the pools. A fifth node is added to the cluster. What is true about the server pool to which the node will be assigned?

  1. The node will have the server assigned to the DSS pool because the current size is less than MAX_SIZE and the DSS pool has a greater importance than the OLTP pool.

  2. The node will have the server assigned to the OLTP pool because the OLTP pool#39;s MAX_SIZE is greater than MAX_SIZE of the DSS pool.

  3. The node will have the server assigned to the OLTP pool because the OLTP pool#39;s current size is less than its MIN_SIZE and the DSS pool has enough servers to equal its own MIN_SIZE.

  4. The node will have the server assigned to the DSS pool on the basis of having a greater IMPORTANCE.

Answer: C Explanation:

Oracle Clusterware continues to assign servers to server pools until the following conditions are met:

Until all server pools are filled in order of importance to their minimum (MIN_SIZE). Until all server pools are filled in order of importance to their maximum (MAX_SIZE). By default, any servers not placed in a server pool go into the Free server pool.

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

Question No: 56

What is the recommended procedure to shut down an ASM instance with a mounted ACFS file system at /u01/app/oracle/acfsmounts/vol1, where the volume name is VOL1 and the disk group name is DATA?

  1. Issue the synchronize command for the file system twice. Then stop the ASM Instance with the SQL*Plus SHUTDOWN ABORT command.

  2. Use the advmutil dismount /all /DATA command. Then stop the ASM instance with the SQL*Plus SHUTDOWN IMMEDIATE command.

  3. Use the /bin/umount /u01/app/oracle/acfsmounts/vol1 command. Then shut down the

    ASM instance with the SQL*PIus SHUTDOWN IMMEDIATE command.

  4. Use the SQL ALTER DISKGROUP VOLULE VOL1 DISMOUNT command. Then stop the ASM instance with the SQL*Plus SHUTDOWN IMMEDIATE command.

  5. Stop the ASM instance with the SQL*Plus SHUTDOWN IMMEDIATE command.

Answer: C Explanation:

Oracle ACFS and Dismount or Shutdown Operations

It is important to dismount any active file system configured with an Oracle ADVM volume device file before an Oracle ASM instance is shutdown or a disk group is dismounted. After the file systems are dismounted, all open references to Oracle ASM files are removed and associated disk groups can be dismounted or the instance shut down.

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

Question No: 57

You have a four-node cluster with four node VIPS and three scan VIPS already In use after Oracle Grid Infrastructure installation.

You plan to manage a customer-developed, web-based application with the Oracle Grid Infrastructure to provide high availability.

Which two statements are true about the vip application resource that must be created?

  1. The vip application must be active on the same subnet and ethernet adaptor as the Interconnect.

  2. The vip application must be active on the same subnet and ethernet adaptor as the public ip Address.

  3. The vip application must not be online on the same node as any of the scan vips.

  4. The vip application must be active on a different node than the application depending on Che by using the dispersion start dependency in the resource definition.

  5. The vip application must be enabled to run as the root user.

Answer: B,E

Explanation: If clients of an application access the application through a network, and the placement policy for the application allows it to fail over to another node, then you must register a virtual internet protocol address (VIP) on which the application depends. An application VIP is a cluster resource that Oracle Clusterware manages (Oracle Clusterware

provides a standard VIP agent for application VIPs). You should base any new application VIPs on this VIP type to ensure that your system experiences consistent behavior among all of the VIPs that you deploy in your cluster

A VIP resource is typically owned by root because VIP related operations require root privileges.

You must assign a VIP address to each node in the cluster. Each VIP address must be on the same subnet as the public IP address for the node and should be an address that is assigned a name in the DNS

Oracle Clusterware Administration and Deployment Guide

Question No: 58

Choose the two correct commands that will successfully create an ASM cluster file system (ACFS) and register the mount point on a Linux/UNIX system.

  1. mkfs -t asm /dev/asm/testvol-461 -n quot;testvolquot;

  2. mkfs -t acfs /dev/asm/testvol-461 quot;testvolquot;

  3. crsctl -r mountpoint /dev/asm/testvol-461 /u01/app/grid/acfsmounts/acfs_testvol

  4. acfsutil registry -a -f /dev/asm/testvol-461 /u01/app/grid/acfsmounts/acfs_testvol

Answer: B,D Explanation: mkfs Purpose

Creates an Oracle ACFS file system.

Syntax and Description mkfs -t acfs -h

mkfs [-v] [-f]-t acfs [-b blocksize] [-n name ] volume_device [size]

Table 13-3 Options for the Linux mkfs command Option Description

Latesttests 2018 PDF and VCE

untitled

acfsutil registry

Purpose

Registers an Oracle ACFS file system with the Oracle ACFS mount registry.

Syntax and Description acfsutil registry -h acfsutil registry

acfsutil registry -a [-f] [-n { nodes|all } ] [-o moptions] device mount_point

acfsutil registry -d {device | mount_point} acfsutil registry -l [device | mount_point] acfsutil registry -m device

acfsutil registry -h displays help text and exits.

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

Question No: 59

You are managing a policy-managed database called RACDB. Examine the output given below:

Latesttests 2018 PDF and VCE

You used these commands to add the service erp:

Latesttests 2018 PDF and VCE

Which statement is true regarding the srvctl stop instance command?

  1. It will shut down the racdb_1 instance and the ERP service running on node gr7597.

  2. It will shut down the racdb_1 instance, and the ERP service will fail over to an available Instance.

  3. It will shut down the racdb_1 instance, but the ERP service will keep running on node gr7597

  4. It will shut down the racdb_1 instance and the ERP service running on ih.il Instance However Oracle Clusterware can restart the ERP service running on node gr7597.

  5. It will shut down the racdb_1 instance and stop the ERP service on all the nodes

Answer: A

Explanation: Stops instances and stops any services running on specified instances, unless you specify the -f option. If you specify -f, then the services fail over to an available instance when the instance stops.

Syntax and Options

Use the srvctl stop instance command with the following syntax:

srvctl stop instance -d db_unique_name {[-n node_name]|[-i quot;instance_name_listquot;]} [-o stop_options] [-f]

Oracle Real Application Clusters Administration and Deployment Guide

Question No: 60

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

  1. ASMCMD

  2. SQL*Plus

  3. ACFSUTIL

  4. ADVMUTIL

  5. Enterprise Manager

Answer: C,E Explanation:

About Oracle ACFS Snapshots

Oracle ACFS snapshots are administered with the acfsutil snap commands. For information about the acfsutil snap commands, refer to quot;acfsutil snap createquot;, quot;acfsutil snap deletequot;, and quot;acfsutil snap infoquot;.

You can also manage Oracle ACFS snapshots with Oracle Enterprise Manager. For information about using Oracle Enterprise Manager, see quot;Managing Oracle ACFS Snapshots with Oracle Enterprise Managerquot;.

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

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