1Z0-058 - Oracle Real Application Clusters 11g Release 2 and Grid Infrastructure Administration

Go back to Oracle

Exam FAQ

How long is the 1Z0-058 exam? How much does the 1Z0-058 exam cost? What is the best way to study for the 1Z0-058 exam?

Example Questions

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? 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, 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-1S260: permission denied on ASM disk group How do you diagnose this error? You notice that there is a very high percentage of wait time for the gc current split event in your RAC database that has frequent insert operations. Which recommendation would you make to reduce this problem? You are managing a single-instance database and your company wants to convert the single instance database to an Oracle RAC database. You plan to use the rconfig utility to accomplish this task. What are the prerequisites for converting the single-instance database to an Oracle RAC database? The Oracle Grid Infrastructure administrator runs ocrconfig -backupioc <new_location> after completing the installation of the Grid Infrastructure. What are the two reasons for doing this You have an ASM cluster and you want to terminate all the ASM instances. Assume that the database Instances supported by the ASM are already shut down. What must you know to select the appropriate command for this operation? 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 Infrastructure and Oracle RAT Databases to be available as much as possible. Which two techniques will work some or all of the time to provide you with minimum down time? What are the default connect strings used by SQL*Plus and ASMCMD when connecting to ASM instances? 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 Group by storing only one copy of the volume file extents in the disk group. 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 older nodes that are still accessible to be redeployed elsewhere in the data center. Which two are true regarding the procedure for removing one or more cluster nodes? You have created four top-level server pools called OLTP, BATCH, DSS, and support for a policy- managed, eight-node cluster. The OLTP pool has two child pools called OLTP_CHILD1 and OLTP_CHILD2. Which two statements are true about sharing servers among the various server pools on your cluster? 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? Which two statements are true regarding the Active Session History (ASH) reports for RAC? After Oracle Grid Infrastructure has been installed, you should take a few moments to verify the installation. Which two actions would be useful in verifying the installation? You want to reorganize the DATA diskgroup while continuing database operations. The DATA diskgroup was created using normal redundancy having one disk per failure group. The two disks used are /dev/sdal and /dev/sda2. You plan to drop the existing disks and add the /dev/sdb1 and /dev/sdb2 disks to failure group FG_C and the /dev/sdcl and /dev/sdc2 disks to failure group FG_D. Which procedure would you use to minimize the effect of the I/Os of this reorganization on ongoing database operations? 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 resource using a server pool with two nodes called RACNODE3 and RACNODE4 and has a cardinality of 1. What are the meanings of the target and state status values? Which three statements are true about the management of Oracle Services? 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? 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 active and the sixth (RACNODE6) is down for maintenance. You decide to check the state of the servers In the server pools to see if there are problems with the OLTP pool to which the ACCOUNTS service has been assigned. You used the crsct1 status server -f command and see that the RACNODE3 node has STATE=VISIBLE. What is true about this situation? 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 will be mounted on all ASM Instances. Which are the two best location options for archivelogs so that they can be accessed during recovery without DBA intervention? Examine the following output: [[email protected]~]$srvctl add service -d RACDB -s erp -g pool1 -c uniform -y manual [oracle0gr5153~]$srvctl start service -d RACDB -s ERP [[email protected]~]$crsctl stat res ora.racdb.erp.svc NAME=ora.racdb.erp.svc TYPE=ora.service.type TARGET=ONLINE, ONLINE, ONLINE STATE=ONLINE on gr5118, ONLINE on gr5152, ONLINE on gr5153 [[email protected]~]$ srvctl config database -d RACDB Database unique name: RACDB Database name: RACDB Oracle home:/u01/app/oracle/product/11.2.0/dbhome_1 Oracle user:oracle Spfile:+DATA/RACDB/spfileRACDB.ora Domain: Start options: open Stop options: immediate Database role: PRIMARY Management policy: AUTOMATIC Server pools: POOL 1 Database instances: Disk Groups: DATA, FRA Services: ERP Database is policy managed $srvctl stop database -d RACDB -o immediate Which two statements are true regarding the srvctl stop command? 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: [[email protected]~]$srvctl add service –d PROD -s GL –g SP1 -c singleton -y manual Examine the following output: [[email protected]~]$srvctl config database -d PROD -a Database unique name: PROD base name: PROD Oracle home: /u0l/app/oracle/product/11.2.0/dbhome_l cle user: oracle Spfile: +DATA/PROD/spfil6RACDB.ora Domain: Start options: open Stop options: immediate Database role: PRIMARY Management policy: AUTOMATIC Server pools: SPl Database instances: Disk Groups: DATA, FRA Services: Database is enabled Database is policy managed [[email protected]~]$crsctl stat res ora.PROD.db NAME=ora.PROD.db TYPE=cluster__resource TARGET=ONLlNE STATE=ONLINE on gr7597 ONLINE on gr7602 ONLINE on gr7633 [[email protected]~]$crsctl stat serverpool ora.SPl NAME=ora.SPl ACTIVE_SERVERS=gr7S97 gr7 602 gr7633 [[email protected]~]$crsctl NAME=ora.prod.gl.svc TYPE=ora.service - type TARGET=ONLINE STATE=ONLlNE on gr7597 Which three steps are required to enable ODP.NET clients that connect to the GL services to receive FAN High Availability Events? On the OUI Grid Plug and Play information page, you can configure GRID Naming Service (GNS). What will be the SCAN Name field default to if you enter cluster01 in the cluster Name field and cluster01.example.com in the GNS Sub Domain field? Which two statements are true regarding undo management in the RAC environment? The DBA has executed the command: srvctl add service -d PROD -s BATCH -g SP2 -c singleton -y manual What is the result of this command? Choose three correct statements about ASM disk group attributes set from the ASMCA Create Disk Group 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 first set of nodes and you replied with node names RACNODE1, RACNODE2 and RACNODE3. Which two statements are true about the procedure for minimizing down time? You are managing RAC database with policy managed services. The database is started by using an SPFILE. Which two statements are true regarding initialization parameters In a RAC environment? You are managing a policy-managed Real Application Cluster (RAC) database, RACDB with Oracle Managed Files (OMF) enabled. Examine the following outputs: [[email protected]]$srvctl config database -d RACDB Database unique name: RACDB Database name: RACDB Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1 Oracle user: oracle Spfile: +DATA/RACDB/spfileRACDB.ora Domain: Start options: open Stop options: immediate Database role: PRIMARY Management policy: AUTOMATIC Server pools: POOL1 Database instances: Disk Groups: DATA, FRA Services: Database is policy managed SQL>SELECT * FROM v$active instances; INST NUMBER INST NAME 1 gr5118:RACDB_1 2 gr5l52:RACDB_2 3 gr5l53:RACDB_3 [[email protected]]$crsctl stat serverpool ora.POOL1 NAME_ora.POOL1 ACTIVE_SERVERS=gr5118 gr5152 gr5153 [[email protected]]$srvctl config srvpool -g POOL1 Server pool name: POOL1 Importance: 0, Min: 0, Max: 3 Candidate server names: You added a new server to the server pool using the following command: [[email protected]]$srvctl modify srvpool -cf POOL1 -i 0 -1 2 -u 4 -n gr5119 The instance on the newly added node is started by the Oracle Clusterware. Automatic Storage Management (ASM) is used as the storage option. Which statement is true regarding the redo log files for the instance? Which three statements are true about the logging or tracing of Java-based Oracle tools? You installed the Oracle Grid Infrastructure on a four-node cluster before discussing the network requirements with the network administrator who was on holiday. You created a single scan named mydb-scan.myclust.example.com by adding this name to the /etc/hosts file. As a result, the Grid Infrastructure has four node listeners and node VIP but only a single SCAN listener and SCAN VIP. The network administrator has returned and modified the corporate DNS server to associate three IP addresses with the mydb-scan.myclust.example.com scan name. The SCAN VIPs are on the same network as the node VIPs. You now must replace the single SCAN VIP and listener with three of each for high availability purposes and make certain that the SCANs and listeners are active. Which procedure will do this properly if run as the root user? Which three statements are true about cluster (OCR) and local registries (OLR)? Which two statements are true regarding the Automatic Workload Repository (AWR) In a rap environment ? 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 not reside in ASM, to this new non-ASM location. How can this be done? Which two statements are true about instance recovery in a RAC environment? 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 active and the sixth (RACNODE6) is down for maintenance. You decide to check the state of the servers in the server pools to see if there are problems with the OLTP pool to which the ACCOUNTS service has been assigned. You used the crsctl status server-f command and see that the RACNODE3 node has STATE=VISIBLE. What is true about this situation? You are managing a policy-managed three-instance RAC database. You ran database ADDM for the database and noticed gc current block congested and gc cr block congested waits. What are two possible reasons for these wait events? Which two Cluster ware stack administration actions must be performed as the root user? When creating an Oracle Cluster database using DBCA the "Memory size (SGA and PGA)" field is supplied on value of 2000 MB. Identify the default Block Size used for the database. You are allocating space from the ASM disk group for an ADVM volume. What will be the volume extent and Volume Allocation Unit (VAU) if the stripe column is 4 and AU is 1 MB? which are the default values? Identify the three valid storage options for Grid Infrastructure voting disk and Install. Under which account(s) can the Oracle Clusterware processes run for the Linux platform? Which two network addresses are required to be static, non-dhcp addresses when using the Grid Naming? 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? Which two statements are true regarding the Average Active Sessions chart on the performance page What does a high gc current block busy event value indicate? Assume that you want to make a connection to the ERP service associated with a newly created RAC database called PROD on a cluster called cluster01 that consists of three nodes: node1, node2 and node3. Which two connect settings are correctly configured to connect to the ERP service? Which three statements ate true about services and Transparent Application Failover (TAF)? Which three statements define a cluster? Your two-instance RAC database is running in ARCHVELOG. The instance running on node1., fails and this failure Is ejected by the instance running on node2,which indicates the recovery process for node1. Which, process will read the redo log of the failed instance to identify the database blocks that need to be recovered during the recovery process, after the configuration of enqueue and cache part of Global resource Directory (GRD)?