1Z0-058 Exam Questions
136 real 1Z0-058 exam questions with expert-verified answers and explanations. Page 2 of 3.
- Question #53
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...
- Question #54
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...
- Question #55
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...
- Question #56
Choose four tools that can be used to create ASM disk groups.
- Question #57
Which three statements are true about ASM dynamic volume manager (ADVM)?
- Question #58
For which two purposes would you recommend an ASM clustered file system (ACFS)?
- Question #59
A Grid Plug and Play (GPnP) software image must contain at least three items. Which three items are required?
- Question #60
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...
- Question #61
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...
- Question #62
You want to check an ACFS for consistency on the Linux platform. Which command-line tool would you use to do this?
- Question #63
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...
- Question #64
Which three fragments will complete this statement correctly? In a cluster environment, an ACFS volume _____________.
- Question #65
Which command will set full debugging for the communications and resource management components of the CRS module on nodes host01 and host03?
- Question #66
Which statement describes the requirements for the network interface names, such as eth0, in Oracle Clusterware?
- Question #67
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...
- Question #68
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...
- Question #69
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...
- Question #70
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...
- Question #71
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...
- Question #72
Examine the set of commands given below: Which statement is true in this scenario?
- Question #73
Which three programs or utilities can be used to convert a single-instance database to a Real Application Cluster database?
- Question #74
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...
- Question #75
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...
- Question #76
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...
- Question #77
Which three predefined database-type templates already include the data files when creating an Oracle Cluster database?
- Question #78
Examine the following output: [oracIe@gr5153 ~]$ sudo crsctl config crs CRS-4622: Oracle High Availability Services autostart is enabled. [oracIe@gr5153 ~]$ srvctl config database...
- Question #79
Which four statements are true about services and connection load balancing?
- Question #80
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...
- Question #81
Examine the Exhibit. ---MISSING----- Which three statements are correct?
- Question #82
Which two network addresses are required to be static, non-dhcp addresses when using the Grid Naming?
- Question #83
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...
- Question #85
Which three statements define a cluster?
- Question #86
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...
- Question #87
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...
- Question #88
Which three statements are true about using RMAN with ASM?
- Question #89
Which two statements are true about ACFS snapshots?
- Question #90
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...
- Question #91
Which two types of files can be stored In an ASM clustered file system?
- Question #92
Which four statements are true about ADVM interoperability?
- Question #93
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...
- Question #94
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...
- Question #95
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...
- Question #96
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...
- Question #97
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...
- Question #98
What are the default connect strings used by SQL*Plus and ASMCMD when connecting to ASM instances?
- Question #99
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...
- Question #101
Which three statements are true about services and the Resource Manager?
- Question #102
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...
- Question #103
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...
- Question #104
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...