Act now and download your Oracle 1Z0-058 test today! Do not waste time for the worthless Oracle 1Z0-058 tutorials. Download Up to the minute Oracle Oracle Real Application Clusters 11g Release 2 and Grid Infrastructure exam with real questions and answers and begin to learn Oracle 1Z0-058 with a classic professional.
♥♥ 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
Q41. Which two types of files can be stored In an ASM clustered file system?
A. OCR and Voting Disk files
B. data files for external tables
C. Oracle database executable
D. Grid Infrastructure executables
E. data files for tablespaces
F. archive log files
Answer: B,C
Explanation: Oracle Automatic Storage Management Cluster File System (Oracle ACFS) is a multi-platform, scalable file system, and storage management technology that extends Oracle Automatic Storage Management (Oracle ASM) functionality to support customer files maintained outside of Oracle Database. Oracle ACFS supports many database and application files, including executables, database trace files, database alert logs, application reports, BFILEs, and configuration files. Other supported files are video, audio, text, images, engineering drawings, and other general-purpose application file data. Notes:
. Oracle ASM is the preferred storage manager for all database files. It has been specifically designed and optimized to provide the best performance for database file types.
. Oracle ACFS is the preferred file manager for non-database files. It is optimized for general purpose files. . Oracle ACFS does not support any file type that can be directly stored in Oracle
ASM, except where explicitly noted in the documentation. Not supported means Oracle Support Services does not take calls and development does not fix bugs associated with storing unsupported file types in Oracle ACFS.
. Starting with Oracle Automatic Storage Management 11g Release 2 (11.2.0.3), Oracle ACFS supports RMAN backups (BACKUPSET file type), archive logs (ARCHIVELOG file type), and Data Pump dumpsets (DUMPSET file type). Note that Oracle ACFS snapshots are not supported with these files.
. Oracle ACFS does not support files for the Oracle Grid Infrastructure home.
. Oracle ACFS does not support Oracle Cluster Registry (OCR) and voting files.
Q42. 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 "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=’2"
Which two statements are true about the behavior of this resource after it is added?
A. It will be a policy-managed resource using the server pool containing nodes RACNODE1 and RACNODE2.
B. The LongAppvip vip resource must be activated to successfully activate this resource, but wl not be activated automatically if not already active.
C. The LongAppvip vip resource must be stopped before this resource is stopped.
D. 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)
Q43. Choose three correct statements about ASM disk group attributes set from the ASMCA Create Disk Group
A. The field labeled ASM Compatibility sets the compatible.asm attribute.
B. When creating a disk group with ASMCA, the default setting for the ASM Compatibility field (compatible.asm) is 10.1.
C. The Database Compatibility field (compatible.rdbms) sets the minimum version level for any database instance that is allowed to mount the disk group.
D. To use ADVM volumes, ADVM Compatibility (compatible.advm) must be set to 11.2.0 or later and ASM Compatibility must be 11.2.0 or later.
E. Advancing the values for disk group compatibility attributes can be reversed if desired.
Answer: A,C,D
Explanation: COMPATIBLE.ASM
The value for the disk group COMPATIBLE.ASM attribute determines the minimum software version for an Oracle ASM instance that can use the disk group.
COMPATIBLE.RDBMS
The value for the disk group COMPATIBLE.RDBMS attribute determines the minimum COMPATIBLE database initialization parameter setting for any database instance that is allowed to use the disk group.
COMPATIBLE.ADVM
The value for the disk group COMPATIBLE.ADVM attribute determines whether the disk group can contain Oracle ASM volumes. The value must be set to 11.2 or higher. Before setting this attribute, the COMPATIBLE.ASM value must be 11.2 or higher The default disk group compatibility settings are 11.2 for Oracle ASM compatibility, 10.1 for database compatibility, and no value for Oracle ADVM compatibility. The disk group compatibility settings can only be advanced; you cannot revert to a lower compatibility setting.
Oracle Database Storage Administrator's Guide
Q44. Which three statements define a cluster?
A. is a group of independent, but interconnected computers that act as a single system
B. can be deployed to increase availability and performance
C. can be deployed to balance a dynamically changing workload
D. should appear to an application as multiple servers
Answer: A,B,C
Explanation: Oracle Real Application Clusters . Oracle Real Application Clusters (Oracle RAC) is a database clustering technology whose shared storage capabilities allow multiple machines to work in parallel on the same data, reducing processing time significantly. Oracle RAC also offers resilience, allowing processing to continue in the event of one or more machines being unavailable because of planned or unplanned downtime.
Computer cluster . A computer cluster consists of a set of loosely connected computers that work together so that in many respects they can be viewed as a single system. . The components of a cluster are usually connected to each other through fast local area networks, each node running its own instance on an operating system.
Computer clusters emerged as a result of convergence of a number of computing trends including the availability of low cost microprocessors, high speed networks, and software for high performance distributed computing.
. Clusters are usually deployed to improve performance and availability over that of a single computer, while typically being much more cost-effective than single computers of comparable speed or availability
Q45. Which four statements are true about services and connection load balancing?
A. Services provide the ability to balance client connections across the instances in an Oracle RAC configuration.
B. There are two types of load balancing that you can implement; load balancing decisions can be made by the client and by the listener.
C. In a RAC database environment, you should select only one load balancing method.
D. With server-side load balancing, the listener directs a connection request to the best instance that is currently providing the service based on the load-balancing options selected by the DBA.
E. Client-side load balancing balances the connection requests across the listeners.
Answer: A,B,D,E
Explanation:
Services and Connection Load Balancing
The two load balancing methods that you can implement are:
– Client-side load balancing: Balances the connection requests across the listeners
– Server-side load balancing: The listener directs a connection request to the best instance currently providing the service by using the load balancing advisory (LBA).
FAN, Fast Connection Failover, and LBA depend on a connection load balancing configuration that includes setting the connection load balancing goal for the service.
The load balancing goal for the service can be either:
– LONG: For applications having long-lived connections. This is typical for connection pools and SQL*Forms sessions.
– SHORT: For applications that have short-lived connection
Oracle Net Services provides the ability to balance client connections across the instances in an Oracle RAC configuration. You can implement two types of load balancing: client-side and server-side.
Client-side load balancing balances the connection requests across the listeners.
With server-side load balancing, the listener directs a connection request to the best instance currently providing the service by using the load balancing advisory.
In a RAC database, client connections should use both types of connection load balancing.
D60488GC11
Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 15 – 12
Q46. The database administrator is tasked with creating an ASM disk group. Exadata is not being used.
If failure groups are not specified when creating an ASM disk group containing 10 disks, how many failure groups are automatically created?
A. one
B. two
C. five
D. ten
Answer: D
Explanation: There are always failure groups even if they are not explicitly created. If you do not specify a failure group for a disk, then Oracle automatically creates a new failure group containing just that disk, except for disk groups containing disks on Oracle Exadata cells.
Oracle. Automatic Storage Management Administrator's Guide
Q47. Directory structure in ASM has a default of +<diskgroup>/<database>/<filetype>/<filename>.
The EXAMPLE tablespace was created with:
CREATE TABLESPACE EXAMPLE DATAFILE '+DATA/ORCL/oradata/example_01.dbf'
The asmcmd ls command shows:
ASMCMD>ls -l +DATA/ORCL/oradata/*
Type Redund Striped Type Sys Name
N example_01.dbf => +DATA/ORCL/DATAFILE/EXAMPLE.264.695918623
Which three statements can be verified by from the information provided?
A. The ASM file +DATA/ORCL/oradata/example_01.dbf has an alias of +DATA/ORCL/DATAFILE/EXAMPLE.264.695918623.
B. The ASM system file +DATA/ORCL/DATAFILE/EXAMPLE.264.695918623 has an alias of +DATA/ORCL/oradata/example_01.dbf.
C. The default path indicates that the file is an oradata file belonging to the ORCL database.
D. The default path indicates that the file is a data file belonging to the ORCL database.
E. +DATA/ORCL/oradata/example_01.dbf is the name of the file in V$DBFILE in the database instance.
F. +DATA/ORCL/DATAFILE/EXAMPLE.264.695918623 is the name of the file in V$DBFILE in the database instance.
Answer: B,D,F
Explanation:
Fully Qualified ASM File Names Every file created in ASM gets a system-generated file name, known as the fully qualified file name.
– You cannot set the fully qualified file name.
– ASM guarantees uniqueness within the ASM environment.
– The fully qualified file name is used in database views that display Oracle Database file names. D60488GC11 Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 9 - 11
Q48. The Oracle 11g Release 2 (version 11.2.0.1) ASM instance has a new diskgroup named DATA that is currently not mounted. You log in to a cluster node as the Grid Infrastructure software owner and set the environment variables to point to the ASM instance on that node. Using SQL*Plus, you issue the commands:
CONNECT / AS SYSDBA
ALTER DISKGROUP DATA MOUNT;
The system response is:
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15260: permission denied on ASM disk group
How do you diagnose this error?
A. Check v$asm_operation for operations halted by the error.
B. Check v$asm_attributes to determine the asm.compatible setting.
C. Check v$asm_usergroup to determine the owning user group for this diskgroup.
D. Check v$xs_session_role to determine the role privileges of the current user.
E. Check the connect string for the privileged role.
Answer: E Explanation: Cause
You have logged in with SYSDBA privilege that is not allowed for ASM operations
Solution
Login with SYSASM credentials for ASM operations
MOS [ID 889810.1]
Q49. The Global Cache Block Access Latency chart shows high elapsed times. What are two possible causes for this?
A. badly written SQL statements
B. storage network bottlenecks
C. a large number of requested blocks not cached in any instance
D. 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)
Q50. After evaluating the various methods for extending a cluster, you decide to use addNode.sh.
The cluster originally consisted of four nodes: RACNODE1, RACNODE2, RACNODE3, and RACNODE4. Now two nodes called RACNODES and RACNODE6 have been installed and connected to the cluster by OS administrations.
Which three actions should be performed to check whether the new nodes are ready for running addNode.sh and to help correct any problems?
A. cluvfy stage -pre crsinst -n RACNODE5/ RACNODE6 -C + DATA -q +VOTE -orainv
B. <oinstall group> -fixup -verbose
C. cluvfy stage -post hwos -n RACNODE5, RACNODE6 -verbose
D. cluvfy comp peer -refnode RACNODE1 -n RACNODE5, RACNODE6 -orainv <oinstall group> -osdba <asmdba group> -verbose
E. cluvfy stage -post hwos -n all -verbose
F. cluvfy stage -pre nodeadd -n RACNODE5, RACNODE6 -fixup
G. cluvfy comp peer -refnode RACNODES -n RACNODE6 -orainv <oinstall group> -osdba <asmdba group> -verbose
Answer: C,D,F
Explanation:
. Run the following CVU command to check cluster integrity. This command verifies that any number of specified nodes has been successfully added to the cluster at the network, shared storage, and clusterware levels: $ cluvfy stage -post nodeadd -n node3 [-verbose]
. cluvfy comp peer Use the cluvfy comp peer component verification command to check the compatibility and properties of the specified nodes against a reference node. You can check compatibility for non-default user group names and for different releases of the Oracle software. This command compares physical attributes, such as memory and swap space, as well as user and group values, kernel settings, and installed operating system packages. Syntax cluvfy comp peer -n node_list [-refnode node] [-r {10gR1 | 10gR2 | 11gR1 | 11gR2}] [-orainv orainventory_group][-osdba osdba_group] [-verbose] Usage Notes Peer comparison with the -refnode option compares the system properties of other nodes against the reference node. If the value does not match (the value is not equal to reference node value), then CVU flags that comparison as a deviation from the reference node. If a group or user does not exist on reference node as well as on the other node, CVU reports this comparison as 'passed' because there is no deviation from the reference node. Similarly, CVU reports as 'failed' a comparison with a node that has more total memory than the reference node.
. Verify the integrity of the cluster and node3: $ cluvfy stage -pre nodeadd -n node3 [-fixup [-fixupdir fixup_dir]] [-verbose] You can specify the -fixup option and a directory into which CVU prints instructions to fix the cluster or node if the verification fails. Oracle. Clusterware Administration and Deployment Guide