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

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

As part of the preinstatlation process for adding two new nodes to your four-node UNIX cluster, you are in discussions with the OS administrators about the operating system Installation and setup for the two new nodes called RACNODE5 and RACNODE6.

The nodes have already been connected to the network infrastructure and the administrators are ready for the OS installation. Which two methods fulfill the installation requirements?

  1. Install a new image of the OS, then configure SSH for the root user.

  2. Install a cloned image of the OS that at least matches the existing node images for drivers, patches, and updates.

  3. Install a new image of the OS, that at least matches an existing node for drivers, patches, and updates, and create the necessary OS users and groups with user and group IDs matching those on the existing nodes.

  4. Install a new image of the OS that at least matches the existing node Images for drivers.

  5. Install a new image of the OS, and create the necessary OS users and groups with any user and group IDs.

    Answer: B,C Explanation:

    Prerequisite Steps for Adding Cluster Nodes

    1. Make physical connections.

      Connect the nodes#39; hardware to the network infrastructure of your cluster. This includes establishing electrical connections, configuring network interconnects, configuring shared disk subsystem connections, and so on. See your hardware vendor documentation for details about this step.

    2. Install the operating system.

      Install a cloned image of the operating system that matches the operating system on the other nodes in your cluster. This includes installing required service patches, updates, and drivers. See your operating system vendor documentation for details about this process.

      Note: Oracle recommends that you use a cloned image. However, if the installation fulfills the installation requirements, then install the operating system according to the vendor documentation.

    3. Create Oracle users.

      You must create all Oracle users on the new node that exist on the existing nodes. For example, if you are adding a node to a cluster that has two nodes, and those two nodes have different owners for the Grid Infrastructure home and the Oracle home, then you must create those owners on the new node, even if you do not plan to install an Oracle home on the new node.

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

      Question No: 62

      You notice that there is a very high percentage of wait time for the gc current split event in your RAC database that has frequent insert operations.

      Which two recommendation would you make to reduce this problem?

      1. shorter transactions

      2. using hash partitioned global indexes

      3. uniform and large extent sizes

      4. automatic segment space management

      5. smaller extent sizes

      6. increasing sequence cache sizes

Answer: D,F

Question No: 63

You are ready to add two new nodes called RACNODE 5 and RACNODE 6 to your existing four-node cluster by using addNode.sh.

You have run cluvfy -peer to check the new nodes against a reference node.

When you originally created the cluster, the network administrators chose to statically define the SCAN VIP addresses in the corporate DNS server, and you installed the Oracle Grid Infrastructure without using GNS.

What is the correct way to silently add the nodes?

  1. addNode.sh -silent “CLUSTER_NEW_NODES={RACNODE5, RACNODE6} quot;

  2. addNode.sh -silent quot; CLUSTER_NEW_VIRTUAL_HOSTNAMES={RACNODE5-VIP, RACNODE6-VIP} quot;

  3. addNode.sh -silent “CLUSTER_NEW_NODES={RACNODE5, RACNODE6}quot; quot;CLUSTER_NEW_VIRTUAL_HOSTNAMES={RACNODE5-VIP, RACNODE6-VIP}quot;

  4. addNode.sh -silent -responseFile mynewnodes.txt with the response file containing only “CLUSTER_NEW_NODES={RACNODE5, RACNODE6} quot;

  5. addNode.sh -silent -responseFile mynewnodes.txt With the response file containing quot;CLUSTER_NEW_VIRTUAL_HOSTNAMES={RACNODE3-VIP, RACNODE4-VIP}quot;

Answer: C Explanation:

Adding a Cluster Node on Linux and UNIX Systems

If you are not using GNS, run the following command:

$ ./addNode.sh quot;CLUSTER_NEW_NODES={node3}quot; quot;CLUSTER_NEW_VIRTUAL_HOSTNAMES={node3-

vip}quot;

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

Question No: 64

The DBA has executed the command:

srvctl add service -d PROD -s BATCH -g SP2 -c singleton -y manual What is the result of this command?

  1. Creates a singleton service named batch using the server pool sp2 with a manual service management policy.

  2. Creates a singleton service named batch for the prod database by using only server pool SP2 with a manual service management policy.

  3. Creates a singleton service named batch, which runs by default in the prod database by using the server pool SP2 with a manual service management policy, but can fail over to other databases.

  4. Creates a singleton service, which is only used for batch workloads for the prod database by using only server pool sp2 with a manual service management policy.

Answer: B Explanation: srvctl add service

Adds services to a database and assigns them to instances. If you have multiple instances of a cluster database on the same node, then always use only one instance on that node for all of the services that node manages.

Latesttests 2018 PDF and VCE

untitled

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

Question No: 65

You are managing a three-instance policy-managed RAC database PROD. You created a service called GL for the PROD database by using the following command:

oracle@gr7597~]$srvctl add service -d PROD -s GL -g SP1 -c singleton -y manual

Examine the following output: (oracle@gr7597~]$srvctl config database -d PROD -a Database unique name: PROD

base name: PROD

Oracle home: /u0l/app/oracle/product/11.2.0/dbhome_l cle user: oracle Spfile:

DATA/PROD/spfil6RACDB.ora Domain:

Start options: open Stop options: immediate

Database role: PRIMARY Management policy: AUTOMATIC Server pools: SPl Database instances: Disk Groups: DATA, FRA

Services:

Database is enabled Database is policy managed [oracle@gr?597~]$ crsctl stat res ora.PROD.db NAME=ora.PROD.db

TYPE=cluster resource TARGET=ONLlNE

STATE^ONLINE on gr7597 ONLINE on gr7602 ONLINE on gr7633

[oracle@gr7597~]S crsctl stat serverpool ora.SPl NAME=ora.SPl

ACTIVE_SERVERS=gr7S97 gr7 602 gr7633

[oracle@gr7597-JS crsctl NAME=ora.prod.gl.svc TYPE=ora.service – type

TARGET=ONLINE STATE=ONLlNE on gr7597

Which three steps are required to enable ODP.NET clients that connect to the GL services to receive FAN High Availability Events?

  1. Enable Advanced Queuing notifications by using SRVCTL as shown in the following command:

    srvctl modify service -d prod -s gl -q TRUE -j LONG

  2. Execute the following statement for the users that will be connecting by way of the -Net Application, where user_name is the user name:

    EXECUTE DBMS_AQADM.GRANT_QUEUE_PRIVILEGE(‘DEQUEUE’,’SYS.SYSSSERVICE_METRI

    CS’ user_name);

  3. Enable Transparent Application Failover (TAF), either on the client or for the service.

  4. Enable Fast Connection Failover for ODP.NET connection pools by subscribing to FAN High Availability events. Do this by setting the HA events connection string attribute to true at connection time.

  5. Link client applications with the client thread or operating system library.

Answer: A,B,D

Explanation: Perform the following steps to enable FAN for ODP.NET clients:

->Enable Advanced Queuing notifications for a service by using SRVCTL as shown in the following example:

srvctl modify service -d crm -s odpnet.example.com -q TRUE

->Grant permissions on the internal event queue table by executing the following command for the users that will be connecting by way of the ODP.NET application, where user_name is the database user name:

EXECUTE DBMS_AQADM.GRANT_QUEUE_PRIVILEGE(#39;DEQUEUE#39;,#39;SYS.SYS$SERVICE_METR

ICS#39;, user_name);

->Enable Fast Connection Failover for ODP.NET connection pools by subscribing to FAN high availability events. To enable FCF, include quot;HA Events=truequot; and quot;pooling=truequot; (the default value) in the connection string, as shown in the following example where user_name is the name of the database user and password is the password for that user: con.ConnectionString = quot;User Id=user_name;Password=password;Data Source=odpnet;quot; quot;Min Pool Size=10;Connection Lifetime=120;Connection Timeout=60;quot; quot;HA Events=true;Incr Pool Size=5;Decr Pool Size=2quot;;

Oracle Real Application Clusters Administration and Deployment Guide

Question No: 66

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 -m host01,host03

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

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

  4. crsctl lsmodules crs set log CRSRTX : 5, CRSCOMM: 5 -nodelist host01, host03

Answer: C Explanation:

Dynamic Debugging

This section includes the following CRSCTL commands that aid in debugging: crsctl set log

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

Syntax

crsctl set log {[crs | css | evm quot;component_name=log_level, […]quot;] | [all=log_level]}

You can also set log levels for the agents of specific resources, as follows: crsctl set log res quot;resource_name=log_level, […]quot;

Latesttests 2018 PDF and VCE

untitled

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

Question No: 67

Which three statements are true about cluster (OCR) and local registries (OLR)?

  1. The ocrdump command can be used to dump the contents of either the cluster registry (OCR) or the local registry (OLR).

  2. Information in the OCR is organized by keys that are associated with privileges. Therefore, the root user will see more information when using ocrdump than the grid user.

  3. After the cluster is created, the size of the OCR is static unless the Clusterware software

    Is upgraded.

  4. The ocrdump command can be used to dump information for a single OCR key.

Answer: A,B,D Explanation:

->This section explains how to use the OCRDUMP utility to view OCR and Oracle

Local Registry (OLR) content for troubleshooting. The OCRDUMP utility enables you to view OCR and OLR contents by writing the content to a file or stdout in a readable format.

You can use several options for OCRDUMP. For example, you can limit the output to a key and its descendents. You can also write the contents to an XML file that you can view using a browser. OCRDUMP writes the OCR keys as ASCII strings and values in a data type format. OCRDUMP retrieves header information based on a best effort basis.

Displays OCR content in the terminal window in XML format

ocrdump -stdout -backupfile Grid_home/cdata/cluster_name/file_name

Displays the content of the in the Grid_home/cdata/ cluster_name/ file_ name directory. You must run this command as root to be able to view all of the keys.

Oracle Clusterware Administration and Deployment Guide

Question No: 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.

  1. 3 GNS VIPs

  2. 8 Node VIPs

  3. 3 SCAN VIPs

  4. 1 GNS VIP

  5. 3 Node VIPs

Answer: B,C,D

Explanation: 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 domain 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#39;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 No: 69

Your Apache-based application resource called MyApp has a VIP application resource definition and an application resource definition.

The application is administrator managed and is currently active on nodeRACNODE3.

You want to move it to host RACNODE4, which is one of the HOSTING_MEMBERS in the resource definition.

What is the most efficient method to move the application and the VIP?

  1. Run crsctl relocate resource MyApp – n RACNODE4 – f.

  2. Run crsctl stop resource MyApp -n RACNODE3 -f followed by crsctl start MyApp -n RACNODE4 -f.

  3. Run crsctl stop resource MyApp -n RACNODE3 -f followed by crsctl relocate resource MyApp -n RACNODE4.

  4. Run crsctl relocate resource MyApp -n RACNODE4.

Answer: A Explanation:

Relocating Applications and Application Resources

Use the crsctl relocate resource command to relocate applications and application resources. For example, to relocate the Apache Web server application to a server named rac2, run the following command:

# crsctl relocate resource myApache -n rac2

Each time that the action program is called, the crsctl relocate resource command waits for the duration specified by the value of the SCRIPT_TIMEOUT resource attribute to receive notification of success or failure from the action program. A relocation attempt fails if:

The application has required resources that run on the initial server Applications that require the specified resource run on the initial server

To relocate an application and its required resources, use the -f option with the crsctl relocate resource command. Oracle Clusterware relocates or starts all resources that are required by the application regardless of their state.

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

Question No: 70

In your two-instance RAC database, you find that FAST_START_MTTR_TARGET is set to 300 on both the nodes. The ESTD_CLUSTER_AVAILABLE_TIME column in the V$INSTANCE_RECOVERY view shows the value 100.

What is the correct interpretation? (Choose 2)

  1. In the event of an instance failure, the database will become partially available In 100 seconds.

  2. In the event of an instance failure, the database will become fully available in 100 seconds.

  3. In the event of an instance failure, the failed instance will become fully available In 300 seconds.

  4. In the event of an instance failure, the database will become partially available in 200 seconds.

  5. In the event of an instance failure, the failed instance will become available In 300 seconds.

Answer: A,E Explanation:

FAST_START_MTTR_TARGET

Latesttests 2018 PDF and VCE

untitled

FAST_START_MTTR_TARGET enables you to specify the number of seconds the database takes to perform crash recovery of a single instance. When specified, FAST_START_MTTR_TARGET is overridden by LOG_CHECKPOINT_INTERVAL.

V$INSTANCE_RECOVERY

Estimated time (in seconds) that the cluster would become partially available should this instance fail. This column is only meaningful in an Oracle Real Application Clusters (Oracle RAC) environment. In a non-Oracle

RAC environment, the value of this column is null.

Oracle庐 Database Reference 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