Act now and download your Oracle 1Z0-058 test today! Do not waste time for the worthless Oracle 1Z0-058 tutorials. Download Update 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
Q71. You are in the planning stages for upgrading your Oracle RAC database from Oracle Database 10g Release 2 to Oracle Database 11g Release 2 to run under the Oracle Grid Infrastructure.
You decide to use an administrator-managed configuration because the cluster is fairly small.
Which statement is correct about this configuration?
A. A parent pool of the GENERIC server pool will be used.
B. You must define a new server pool called MANUAL.
C. A subpool of the GENERIC server pool will be used.
D. A subpool of the FREE server pool will be used.
Answer: C
Explanation: With Oracle RAC 11g Release 2, there is only a database resource define to Oracle Clusterware. This resource will contain the Oracle Home, the spfile, the server pool(s) and the ASM diskgroup(s) required for the database. The database resource will have a weak start dependency on the VIP which means it will try to start the VIP for the node when the instance starts however if the VIP does not start successfully, the instance will still be started. When reviewing the database resource for an administrator Managed database, you will see a server pool defined with the same name as the Oracle database. This pool will be part of a special Oracle defined server pool called Generic. The Generic server pool is managed by Oracle to support Administrator Managed databases. The server pools that are part of Generic will be automatically created or removed when you add or remove an Administrator Managed database.
Oracle Database 11gR2 Upgrade Companion (Version 2.70)
Q72. How does the Oracle Grid Infrastructure administrator determine the location of the Oracle Clusterware voting disk?
A. Run cat /etc/oracle/vote.loc from any node.
B. Run srvctl query css votedisk from any node.
C. Run crsctl query css votedisk from any node.
D. Run select name, path from v$votedisk from any RAC database instance of any database on the cluster.
Answer: C
Explanation:
Determining the Location of Oracle Clusterware Configuration Files You can determine the location of the voting disk by using the crsctl query css votedisk command on any node. D60488GC11 Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 3 – 7
Q73. I he ASM instance in your environment can support databases from version 10.2.0.4 through 11.2.0.1 You want to use all ASM functionality possible for each database, including OCR and voting files In the ASM. What is the proper setting for the ASM diskgroup attribute on diskgroups being used by all the instances?
A. Set compatible.asm to 11.2 and compatible.rdbms to 10.2
B. Set compatible.asm to 10.2 and compatible.rdbms to 10.2
C. Set compatible.asm to 11.2 and compatible.rdbms to 11.2
D. Set compatible.asm to 10.2 and compatible.rdbms to 11.2
Answer: A
Explanation: Disk Group Compatibility Attributes 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. This setting also affects the format of the data structures for the Oracle ASM metadata on the disk. The format of other file contents is determined by Oracle ASM Dynamic Volume Manager (Oracle ADVM) and the database instance.
For Oracle ASM in Oracle Database 11g, 10.1 is the default setting for the COMPATIBLE.ASM attribute when using the SQL CREATE DISKGROUP statement, the ASMCMD mkdg command, and Oracle Enterprise Manager Create Disk Group page. When creating a disk group with ASMCA, the default setting is 11.2.
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. Before advancing the COMPATIBLE.RDBMS attribute, ensure that the values for the COMPATIBLE initialization parameter for all of the databases that access the disk group are set to at least the value of the new setting for COMPATIBLE.RDBMS.
For example, if the COMPATIBLE initialization parameters of the databases are set to either 11.1 or 11.2, then COMPATIBLE.RDBMS can be set to any value between 10.1 and 11.1 inclusively.
Oracle. Automatic Storage Management Administrator's Guide
11g Release 2 (11.2)
Q74. Which command will set full debugging for the communications and resource management components of the CRS module on nodes host01 and host03?
A. srvctl set log -m CRS -c CRSCTI 5, CRSCOMM 5 -m host01,host03
B. ocrconfig set log CRS "CRSRTI, CRSCOMM: 5" -nodelist host01,host03
C. crsctl set log CRS "CRSRTI: 5, CRSCOMM: 5" -nodelist host01,host03
D. 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 "component_name=log_level, [...]"] |
[all=log_level]}
You can also set log levels for the agents of specific resources, as follows:
crsctl set log res "resource_name=log_level, [...]"
untitled
Oracle. Clusterware Administration and Deployment Guide 11g Release 2 (11.2)
Q75. mounted: DATA and DATA2, but the results of the SHOW PARAMETER ASM_DISKGROUPS command show only DATA as below:
What could have caused the DATA2 dlskgroup to be mounted based on the information injthe V $ASM_DISKGROUP view?
A. The DATA2 diskgroup contains the database files required to start a database instance that depends on this ASM instance.
B. The DATA2 diskgroup contains the voting files required for this cluster.
C. The DATA diskgroup has mirrored objects in the DATA2 diskgroup.
D. The DATA value In the parameter implies all diskgroup strings starting with data.
E. The DATA2 diskgroup contains the SPFILE needed to start the ASM instance.
Answer: B
Explanation:
Disk Groups Mounted at Startup
At startup, the Oracle ASM instance attempts to mount the following disk groups:
Disk groups specified in the ASM_DISKGROUPS initialization parameter Disk group used by Cluster Synchronization Services (CSS) for voting files Disk groups used by Oracle Clusterware for the Oracle Cluster Registry (OCR) Disk group used by the Oracle ASM instance to store the ASM server parameter file (SPFILE)
D60488GC11 Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 7 - 5
Q76. Assuming a RAC database called ORCL, select three statements that correctly demonstrate management actions for the AP service.
A. To start the AP service, execute: srvctl start service -d ORCL -s AP
B. To disable the AP service on the ORCL4 instance, execute: srvctl disable service -d ORCL -s AP -i ORCL4
C. To stop the AP service, execute: srvctl stop service -s AP
D. To make ORCL5 a preferred instance for the AP service, execute: srvctl set service -d ORCL -s AP -i ORCL5 -r
E. To relocate the AP service from the ORCL5 instance to the ORCL4 instance, execute: srvctl relocate service -d ORCL -s AP -i ORCL5 -t ORCL4
Answer: A,B,E
Explanation:
SRVCTL Command Reference
srvctl start service -d db_unique_name
[-s "service_name_list" [-n node_name | -i instance_name]]
[-o start_options]
srvctl disable service -d db_unique_name
-s "service_name_list" [-i instance_name | -n node_name]
srvctl stop service -d db_unique_name [-s "service_name_list"
[-n node_name | -i instance_name] [-f]
srvctl relocate service -d db_unique_name -s service_name
{-c source_node -n target_node | -i old_instance_name -t new_instance_name}
[-f]
Oracle. Real Application Clusters Administration and Deployment Guide
11g Release 2 (11.2)
Q77. 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)
A. In the event of an instance failure, the database will become partially available In 100 seconds.
B. In the event of an instance failure, the database will become fully available in 100 seconds.
C. In the event of an instance failure, the failed instance will become fully available In 300 seconds.
D. In the event of an instance failure, the database will become partially available in 200 seconds.
E. In the event of an instance failure, the failed instance will become available In 300 seconds.
Answer: A,E
Explanation: FAST_START_MTTR_TARGET
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)
Q78. Which three statements are true about ASM dynamic volume manager (ADVM)?
A. ADVM provides volume management services and a standard disk device driver interface to file system drivers.
B. The administrator can use ADVM to create volumes that contain bootable vendor operating systems.
C. File systems and other disk-based applications issue I/O requests to ADVM volume devices as they would to other storage devices on a vendor operating system.
D. ADVM extends ASM by providing a disk driver interface to storage backed by an ASM volume.
E. To use the ADVM driver, the oraclesacfs, oradeoks, and oracleadvm drivers must be loaded, but an ASM instance is not required.
Answer: A,C,D
Explanation:
At the operating system (OS) level, the ASM instance provides the disk group, which is a logical container for physical disk space. The disk group can hold ASM database files and ASM dynamic volume files. The ASM Dynamic Volume Manager (ADVM) presents the volume device file to the operating system as a block device. The mkfs utility can be used to create an ASM file system in the volume device file. Four OS kernel modules loaded in the OS provide the data service. On Linux, they are: oracleasm, the ASM module; oracleadvm, the ASM dynamic volume manager module; oracleoks, the kernel services module; and oracleacfs, the ASM file system module. These modules provide the ASM Cluster File System, ACFS snapshots, the ADVM, and cluster services. The ASM volumes are presented to the OS as a device file at /dev/asm/<volume name>-<number>. ADVM provides volume management services and a standard disk device driver interface to clients. Clients, such as file systems and other disk-based applications, issue I/O requests to ADVM volume devices as they would to other storage devices on a vendor operating system. ADVM extends ASM by providing a disk driver interface to storage backed by an ASM file. The administrator can use the ADVM to create volumes that contain file systems. These file systems can be used to support files beyond Oracle database files such as executables, report files, trace files, alert logs, and other application data files. With the addition of ADVM and ACFS, ASM becomes a complete storage solution of user data for both database and non-database file needs. ACFS is intended as a general file system accessible by the standard OS utilities. ACFS can be used in either a single server or a cluster environment. Note: Oracle ACFS file systems cannot be used for an Oracle base directory or an Oracle grid infrastructure home that contains the software for Oracle Clusterware, ASM, Oracle ACFS, and Oracle ADVM components. Oracle ACFS file systems cannot be used for an OS root directory or boot directory. ASM volumes serve as containers for storage presented as a block device accessed through ADVM. File systems or user processes can do I/O on this “ASM volume device” just as they would on any other device. To accomplish this, ADVM is configured into the operating system. A volume device is constructed from an ASM file.
D60488GC11 Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 10 - 3,4,5
Q79. You plan to use Enterprise Manager to locate and stage patches to your Oracle Home.
The software library has been configured to be downloaded to /u01/app/oracle and your "My Oracle Support" credentials have been entered.
You want to start the provisioning daemon in order to use the deployment procedure manager to view, edit, monitor, and run deployment procedures.
How would you start the provisioning daemon?
A. using pafctl start
B. using crsctl start paf
C. using srvctl start paf
D. using emctl start paf
Answer: A
Explanation:
Starting the Provisioning Daemon The provisioning daemon is started with: $ pafctl start Enter repository user password : Enter interval [default 3]: Provisioning Daemon is Up, Interval = 3 D60488GC11 Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 4 – 26
Q80. 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?
A. Install a new image of the OS, then configure SSH for the root user.
B. Install a cloned image of the OS that at least matches the existing node images for drivers, patches, and updates.
C. 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.
D. Install a new image of the OS that at least matches the existing node Images for drivers.
E. 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' 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)