1Z0-058 Exam Questions

You have defined two server pools. One is called OLTP with MIN_SIZE=3, MAX_SIZE =5 and IMPORTANCE=3. The other is called DSS with MIN_SIZE =2, MAX_SIZE =4 and IMPORTANCE =5. Your c...

An ASM diskgroup that contains database tablespaces with six disks and normal redundancy is nearing 90% capacity. You want to add additional capacity to the diskgroup. A set of six...

As part of your data center's high availability strategy, you are creating resource definitions to control the management of a web-based application by the Oracle Grid Infrastructu...

Choose four tools that can be used to create ASM disk groups.

Which three statements are true about ASM dynamic volume manager (ADVM)?

For which two purposes would you recommend an ASM clustered file system (ACFS)?

A Grid Plug and Play (GPnP) software image must contain at least three items. Which three items are required?

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 Install...

The storage administrator is adding several disks to a pool of ASM disks. The current ASM_DISKSTRING parameter is "/dev/sda*", "/dev/sdb*", "/dev/sd*6". There are several hundred d...

You want to check an ACFS for consistency on the Linux platform. Which command-line tool would you use to do this?

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 t...

Which three fragments will complete this statement correctly? In a cluster environment, an ACFS volume _____________.

Which command will set full debugging for the communications and resource management components of the CRS module on nodes host01 and host03?

Which statement describes the requirements for the network interface names, such as eth0, in Oracle Clusterware?

A policy-managed RAC database that hosts the ACCOUNTS service has only three instances running rather than the usual four on a six-node cluster. Five of the six cluster nodes are a...

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...

Which command will resize an ACFS file system on the DATA diskgroup? -The ADVM volume is named VOL1. -The mount point is >/u01/app/oracle/afsmounts/vol1. -The new, larger size is 2...

You use the following command to create a disk group: CREATE DISRGROUP DATA NORMAL REDUNDANCY FAILGROUP fg_f ra_l DISK '/dev/sda6' NAME FRA_DISKl, '/dev/sda7' NAME FRA_DISK2 FAILGR...

Your cluster was originally created with nodes RACNODE1 and RACNODE2 three years ago. Last year, nodes RACNODE3 and RACNODE4 were added. These nodes have faster processors and more...

Examine the set of commands given below: Which statement is true in this scenario?

Which three programs or utilities can be used to convert a single-instance database to a Real Application Cluster database?

Your RAC database has a high volume of inserts into the SALES table. Sequence SALES_SEQ is used to generate primary key values. Examine the following query output: SQL> SELECT sequ...

You are managing a three-instance Oracle RAC database which uses a Cluster File System for shared storage. Which two options can you use to ensure that the redo logs from all the i...

You are managing a three-Instance RAC database. In the AWR report, you notice a gc current block busy wait event on one of the database Instances, in the cluster top timed events s...

Which three predefined database-type templates already include the data files when creating an Oracle Cluster database?

Examine the following output: [oracIe@gr5153 ~]$ sudo crsctl config crs CRS-4622: Oracle High Availability Services autostart is enabled. [oracIe@gr5153 ~]$ srvctl config database...

Which four statements are true about services and connection load balancing?

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 a...

Examine the Exhibit. ---MISSING----- Which three statements are correct?

Which two network addresses are required to be static, non-dhcp addresses when using the Grid Naming?

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 Infrastructur...

Which three statements define a cluster?

You want to create an ACFS on an ADVM volume using a shell script and the appropriate command-line utilities. These are the requirements: 1. The dynamic volume file must use space...

Some new non-ASM shared storage has been made available by the storage administrator, and the Oracle Grid Infrastructure administrator decides to move the voting disks, which do no...

Which three statements are true about using RMAN with ASM?

Which two statements are true about ACFS snapshots?

Your cluster Is subject to a service-level agreement that allows for little scheduled down time You want to use patching and maintenance methods that permit the Oracle Grid Infrast...

Which two types of files can be stored In an ASM clustered file system?

Which four statements are true about ADVM interoperability?

Your four-node cluster was originally purchased, installed, and configured three years ago. You recently added another four nodes to the cluster. Now you want to remove two of the...

Your production environment cluster is running Oracle Enterprise Linux and currently has four nodes. You are asked to plan for extending the cluster to six nodes. Which three metho...

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 softw...

You enter the following command: crsctl status resource MyApp You get this output: NAME=MyApp TYPE=cluster_resource TARGET=ONLINE STATE=ONLINE on RACNODE4 MyApp is a policy-managed...

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 RACNOD...

What are the default connect strings used by SQL*Plus and ASMCMD when connecting to ASM instances?

You want to install a database patch on your eight-node cluster by using Opatch with, the minimum amount of down time to your cluster nodes. You have already been prompted for the...

Which three statements are true about services and the Resource Manager?

You notice that there is a very high percentage of wait time for the 'enq:HW-contention' event in your RAC database that has frequent insert operations. Which two recommendations m...

You are managing RAC database with policy managed services. The database is started by using an SPILE. Which two statements are true regarding initialization parameters In a RAC en...

You need to set up a three-Instance RAC database. The data files and fast recovery area will be stored in ASM diskgroups called +data and +fra, respectively. The ASM disk groups wi...