1Z0-058 | how many questions of 1Z0-058 exam question?
Q71. From a command line, you can create an ASM volume with the same properties by using either SQL or ASMCMD. Which two commands will create a 500 MB volume called TESTVOL in the ACFSDG ACFS diskgroup by storing only one copy of the volume file extents in the diskgroup
A. SQL> alter diskgroup ACFSDG add volume TESTVOL size 500M unprotected;
B. ASMCMD> volcreate -G ASMFS -s 500M
C. SQL> alter diskgroup ACFS add volume TESTVOL size 500M;
D. ASMCMD> volcreate -G ACFSDG -s 500M --redundancy unprotected TESTVOL
E. SQL> create volume TESTVOL diskgroup ACFSDG size 500M unprotected;
Answer: A,D
Explanation: The ALTER DISKGROUP VOLUME SQL statements enable you to manage
Oracle ADVM volumes, including the functionality to add, modify, resize, disable, enable, and drop volumes.
You can create an Oracle ASM Dynamic Volume Manager (Oracle ADVM) volume in a disk group. The volume device associated with the dynamic volume can then be used to host an
Oracle ACFS file system.
If the volume is hosting an Oracle ACFS file system, then you cannot resize that volume with the SQL ALTER DISKGROUP statement. Instead you must use the acfsutil size command.
volcreate
Creates an Oracle ADVM volume in the specified disk group.
Syntax and Description
volcreate -G diskgroup -s size [ --column number ] [ --width stripe_width ]
[--redundancy {high|mirror|unprotected} ]
Redundancy of the Oracle ADVM volume which can be specified for normal redundancy disk groups. The range of values is as follows: unprotected for non-mirrored redundancy, mirror for double-mirrored redundancy, or high for triple-mirrored redundancy. If redundancy is not specified, the setting defaults to the redundancy level of the disk group.
Q72. 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
Q73. 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
Q74. Which three predefined database-type templates already include the data files when creating an Oracle Cluster database?
A. General Purpose
B. Transaction Processing
C. Custom Database
D. Data Warehouse
E. OLAP Database
Answer: A,B,D
Explanation:
Creating an Oracle RAC Database with DBCA Oracle ships templates for the following two workload types: General purpose or transaction processing Data warehouse For more complex environments, you can select the Custom Database option. This option does not use templates and results in a more extensive interview, which means that it takes longer to create your database.
Oracle. Real Application Clusters Installation Guide 11g Release 2 (11.2) for Linux and UNIX
Q75. 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
Q76. You plan to remove a node called RACNODE4 from a four-node cluster.
The cluster is running Oracle Grid Infrastructure 11g Release 2 and there is also a database home with cluster databases running Oracle Database version 11g Release 1. This older home supports different applications that have not been certified to run on the latest release.
The cluster databases for Oracle Database 11g Release 1 each had four Instances at one time, but currently only the first two nodes, RACNODE1 and RACNODE2, are running instances of those databases.
Which two additional steps are required when deleting a node from a cluster in this situation?
A. Run crsctl pin css -n RACNODE1, RACNODE2 as root if the nodes are unpinned.
B. Run crsctl pin css -n RACNODE4 as the Grid Infrastructure owner if RACNODE4 is unpinned.
C. Run olsnodes -t -n to list all cluster nodes that are pinned.
D. Run crsctl unpin css - RACNODE4 as the Grid Infrastructure owner if RACNODE4 is pinned.
E. Run crsctl unpin css - RACNODE4 as root if RACNODE 4 is pinned.
F. Run crsctl nodelist -t -n to list all cluster nodes that are pinned.
Answer: C,E
Explanation:
Deleting a Cluster Node on Linux and UNIX Systems
1. Ensure that Grid_home correctly specifies the full directory path for the Oracle
Clusterware home on each node, where Grid_home is the location of the installed Oracle Clusterware software.
2. Run the following command as either root or the user that installed Oracle Clusterware to determine whether the node you want to delete is active and whether it is pinned: $ olsnodes -s -t If the node is pinned, then run the crsctl unpin css command. Otherwise, proceed to the next step. Oracle. Clusterware Administration and Deployment Guide 11g Release 2 (11.2)
Q77. In an ASM instance, there are several parameters that have meanings specific to the ASM. Which parameter is mandatory?
A. ASM_DISKGROUP
B. ASM_DISKSTRING
C. INSTANCE_TYPE
D. CLUSTER_DATABASE
E. MEMORY_TARGET
F. ASM_POWER_LIMIT
Answer: C
Explanation: Oracle ASM Parameter Setting Recommendations
This section contains information about the following parameters for Oracle ASM: ASM_DISKGROUPS ASM_DISKSTRING ASM_POWER_LIMIT ASM_PREFERRED_READ_FAILURE_GROUPS DB_CACHE_SIZE DIAGNOSTIC_DEST INSTANCE_TYPE uk.co.certification.simulator.questionpool.PList@9387e00 LARGE_POOL_SIZE PROCESSES REMOTE_LOGIN_PASSWORDFILE SHARED_POOL_SIZE
Oracle. Automatic Storage Management Administrator's Guide
Q78. The high availability services provided by Oracle Clusterware are used to protect Oracle resources, such as RAC database instances, RAC database services, and other components of the Oracle Grid Infrastructure, and non-Oracle resources as well.
Which two statements are true about the high availability capabilities of Oracle HA services?
A. RAC databases may have their instances failed over in some cases.
B. 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.
C. If a node fails, then all resources that were active on that node will be failed over to a surviving node if any exists.
D. 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.
E. HA services will only fail over a resource upon failure of the node where the resource was active.
Answer: D,E
Explanation:
Resource Types
Local resource: These are server-centric resources; the type name is local_resource.
These run locally on individual servers of the cluster and are not relevant outside of the scope of the server.
Cluster resource: Cluster-aware resource types (type name is cluster_resource) are aware of the cluster environment and are subject to cardinality and cross-server switchover and failover. The state of cluster resources is relevant in the context of the cluster.
D60488GC11
Oracle 11g: RAC and Grid Infrastructure Administration
Q79. 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
Q80. 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?
A. The vip application must be active on the same subnet and ethernet adaptor as the Interconnect.
B. The vip application must be active on the same subnet and ethernet adaptor as the public ip Address.
C. The vip application must not be online on the same node as any of the scan vips.
D. 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.
E. 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