Want to know Examcollection 1Z0-058 Exam practice test features? Want to lear more about Oracle Oracle Real Application Clusters 11g Release 2 and Grid Infrastructure certification experience? Study Virtual Oracle 1Z0-058 answers to Renewal 1Z0-058 questions at Examcollection. Gat a success with an absolute guarantee to pass Oracle 1Z0-058 (Oracle Real Application Clusters 11g Release 2 and Grid Infrastructure) test on your first attempt.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1Z0-058 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW 1Z0-058 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/1Z0-058-exam-dumps.html
Q31. Which four statements about mounting ASM cluster file systems are true?
A. An ACFS volume can be mounted by using ASMCA.
B. The standard Linux/UNIX mount command can be used to mount an ACFS volume, provided the ACFS type is specified; (mount -t acfs).
C. ACFS volumes can be mounted by using the ASMCMD utility.
D. The acfsmountvol command can be used to mount ACFS volumes on Windows platforms.
E. Oracle Enterprise Manager can be used to mount ACFS volumes.
Answer: A,B,D,E
Explanation: . Oracle ASM Configuration Assistant enables you to create or configure an Oracle ACFS file system. Some commands require root privileges, such as mounting a file system. Oracle ASM Configuration Assistant generates the command for you to run manually as root or as a privileged user.
There are buttons for Create, Show Mount All, and Show Dismount All commands . mount attaches a file system to the Oracle ACFS hierarchy at the mount point that is the name of a directory. The mount happens on the node where the mount command was issued. The mount command returns an error if the file system is not in a dismounted state on this node root privilege is required to run mount. . acfsmountvol attaches an Oracle ACFS to the file system hierarchy at the specified path name or drive letter. dir must be an empty directory. Oracle ACFS mount points can be created on any empty directory and they can be hierarchical (nested).
Windows Administrator privileges are required to mount an Oracle ACFS . ASM Cluster File System tab in Oracle Enterprise Manager. This tab lists all of the Oracle ACFS associated with the Oracle ASM instance.
On this page, you can choose to mount, dismount, delete, create snapshot, view content, register, and deregister a selected file system. In addition, you can create a file system, mount all file systems, or dismount all file systems.
Oracle. Automatic Storage Management Administrator's Guide
Q32. 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?
A. addNode.sh -silent “CLUSTER_NEW_NODES={RACNODE5, RACNODE6} "
B. addNode.sh -silent " CLUSTER_NEW_VIRTUAL_HOSTNAMES={RACNODE5-VIP, RACNODE6-VIP} "
C. addNode.sh -silent “CLUSTER_NEW_NODES={RACNODE5, RACNODE6}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={RACNODE5-VIP, RACNODE6-VIP}"
D. addNode.sh -silent -responseFile mynewnodes.txt with the response file containing only “CLUSTER_NEW_NODES={RACNODE5, RACNODE6} "
E. addNode.sh -silent -responseFile mynewnodes.txt With the response file containing "CLUSTER_NEW_VIRTUAL_HOSTNAMES={RACNODE3-VIP, RACNODE4-VIP}"
Answer: C
Explanation:
Adding a Cluster Node on Linux and UNIX Systems If you are not using GNS, run the following command: $ ./addNode.sh "CLUSTER_NEW_NODES={node3}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={node3-vip}"
Oracle. Clusterware Administration and Deployment Guide 11g Release 2 (11.2)
Q33. 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:
[oracIe@gr7597~]$ srvctl add service -d PROD -s GL -g SP1 -c singleton -y manual Examine the following output: [oracIe@gr7597~]$ srvctl config database -d PROD -a Database unique name: PROD Database name: PROD Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1 Oracle user: oracle Spfile: +DATA/PROD/spfileRACDB.ora Domain: Start options: open Stop options: immediate Database role: PRIMARY Management policy: AUTOMATIC Server pools: SP1 Database instances: Disk Groups: DATA, FRA Services: Database is enabled Database is policy managed [oracIe@gr7597~]$ crsctl stat res ora.PROD.db NAME=ora.PROD.db TYPE=cluster_resource TARGET=ONLINE STATE=ONLINE on gr7597 ONLINE on gr7602 ONLINE on gr7633 [oracIe@gr7597~]$ crsctl stat serverpool ora.SP1
NAME=ora.SP1
ACTIVE_SERVERS=gr7597 gr7602 gr7633
[oracle.gr7597-]$ crsctl stat res ora.prod.gl.svc
NAME=ora.prod.gl.svc
TYFE=ora.service.type
TARGET=ONLINE
STATE=ONLINE on gr7597
Which three steps are required to enable ODP.NET clients that connect to the GL service to receive FAN High Availability Events?
A. Enable Advanced Queuing notifications by using SRVCTL as shown in the following
command: $ srvctl modify service -d prod -s gl -q TRUE -j LONG
B. 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.SYS$SERVICE_METRICS',
user_name ) ;
C. Enable Transparent Application Failover (TAF), either on the client or for the service.
D. 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.
E. Link client applications with the client thread or operating system library.
Answer: A,B,D
Explanation:
Enabling ODP.NET Clients to Receive FAN High Availability Events 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('DEQUEUE','SYS.SYS$SERVICE_METRI CS', user_name);
Enable Fast Connection Failover for ODP.NET connection pools by subscribing to FAN high availability events. To enable FCF, include "HA Events=true" and "pooling=true" (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 =
"User Id=user_name;Password=password;Data Source=odpnet;" +
"Min Pool Size=10;Connection Lifetime=120;Connection Timeout=60;" +
"HA Events=true;Incr Pool Size=5;Decr Pool Size=2";
Oracle. Real Application Clusters Administration and Deployment Guide
11g Release 2 (11.2)
Q34. Which two Cluster ware stack administration actions must be performed as the root user?
A. checking the health of the Clusterware on one node
B. starting the Clusterware manually on one node
C. disabling the Clusterware from automatic start at node reboot
D. checking the health and viability of the Clusterware on all nodes
E. listing the location of the voting disks
Answer: B,C
Explanation:
Controlling Oracle Clusterware The crsctl utility can be used to control Oracle Clusterware. To start or stop Oracle Clusterware on a specific node: # crsctl start crs # crsctl stop crs To enable or disable Oracle Clusterware on a specific node: # crsctl enable crs # crsctl disable crs
D60488GC11
Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 3 - 5
Q35. Which three actions are required to create a general purpose ASM cluster file system (ACFS) to be automatically mounted by Oracle Clusterware?
A. Format an ASM volume with an ASM cluster file system.
B. Create mount points on all cluster nodes where the ASM cluster file system will be mounted.
C. Manually add an entry to /etc/fstab defining the volume, mount point, and mount options on each node in the cluster.
D. Register the mount point.
Answer: A,B,D
Explanation:
. File systems that are to be mounted persistently (across reboots) can be registered with the Oracle ACFS mount registry. In cluster configurations, registered Oracle ACFS file systems are automatically mounted by the mount registry, similar to a clusterwide mount table. However, in Oracle Restart configurations the automatic mounting of registered Oracle ACFS file systems is not supported.
By default, an Oracle ACFS file system that is inserted into the cluster mount registry is automatically mounted on all cluster members, including cluster members that are added after the registry addition. However, the cluster mount registry also accommodates single-node and multi-node (subset of cluster nodes) file system registrations. The mount registry actions for each cluster member mount only registered file systems that have been designated for mounting on that member. The Oracle ACFS registry resource actions are designed to automatically mount a file system only one time for each Oracle Grid Infrastructure initialization to avoid potential conflicts with administrative actions to dismount a given file system.
Oracle Automatic Storage Management Administrator's Guide
Q36. 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
Answer: B,C,D
Explanation:
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)
Q37. What does a high “gc current block busy” event value indicate?
A. Access to cached data blocks was delayed because they were busy either in the remote or the local cache.
B. A large number of requested blocks were not cached In any instance.
C. Asynchronous input/output (I/O) is disabled.
D. Delay in processing has occurred In the GCS, caused by CPU saturation and would have to be solved by additional CPUs and load-balancing.
Answer: A
Explanation: The gc current block busy wait event indicates that the access to cached data blocks was delayed because they were busy either in the remote or the local cache. This could be caused by any of the following:
.The blocks were pinned
The blocks were held up by sessions The blocks were delayed by a log write on a remote instance A session on the same instance was already accessing a block which was in transition between instances and the current session needed to wait behind it (for example, gc current block busy)
Oracle Real Application Clusters Administration and Deployment Guide
Q38. Which three statements ate true about services and Transparent Application Failover (TAF)?
A. If TAF has been configured for a service, sessions using that service fail over to a surviving instance when an outage occurs.
B. The TAF setting on a service can be NONE, BASIC, PRECONNECT, or POSTCONNECT, and overrides any TAF setting in the client connection definition.
C. TAF can restart a query after failover has completed but for other statements, such as INSERT, UPDATE, or DELETE, the application must resubmit the transaction.
D. The TAF setting for a client connection overrides any TAF setting in the service definition.
E. Services simplify the deployment of TAF because by defining a TAF policy for a service, all connections using this service will automatically have TAF enabled.
Answer: A,B,E
Explanation:
Services and Transparent Application Failover Services simplify the deployment of Transparent Application Failover (TAF). You can define a TAF policy for a service and all connections using this service will automatically have TAF enabled. The TAF setting on a service can be NONE, BASIC, or PRECONNECT and overrides any TAF setting in the client connection definition. To define a TAF policy for a service, the srvctl utility can be used as shown below: srvctl modify service -s gl.example.com -q TRUE -P BASIC -e SELECT -z 180 -w 5 -j LONG Where -z is the number of retries, -w is the delay between retry attempts and -j is the connection load balancing goal.
When Oracle Net Services establishes a connection to an instance, the connection remains open until the client closes the connection, the instance is shut down, or a failure occurs. If you configure TAF for the connection, then Oracle Database moves the session to a surviving instance when an outage occurs.
TAF can restart a query after failover has completed but for other types of transactions, such as INSERT, UPDATE, or DELETE, the application must roll back the failed transaction and resubmit the transaction. You must re-execute any session customizations, in other words, ALTER SESSION statements, after failover has occurred. However, with
TAF, a connection is not moved during normal processing, even if the workload changes over time.
D60488GC11
Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 15 – 13
Q39. Which two statements are true about ACFS snapshots?
A. 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.
B. They can be created for ACFS file systems only if the ADVM volume file used by the file system has free space available.
C. 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.
D. They can be created when ACFS is used both on clusters and on stand-alone servers.
E. 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's Guide 11g Release 2 (11.2)
Q40. 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?
A. Enable Advanced Queuing notifications by using SRVCTL as shown in the following command: srvctl modify service -d prod —s gl —q TRUE -j LONG
B. 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);
C. Enable Transparent Application Failover (TAF), either on the client or for the service.
D. 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.
E. 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('DEQUEUE','SYS.SYS$SERVICE_METR
ICS', user_name); . Enable Fast Connection Failover for ODP.NET connection pools by subscribing to FAN high availability events. To enable FCF, include "HA Events=true" and "pooling=true" (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 = "User Id=user_name;Password=password;Data Source=odpnet;" + "Min Pool Size=10;Connection Lifetime=120;Connection Timeout=60;" + "HA Events=true;Incr Pool Size=5;Decr Pool Size=2";
Oracle Real Application Clusters Administration and Deployment Guide