1Z1-058 (1Z0-058 beta) 11g R2 RAC Administration Expert
If you get emails from Oracle University, you might have received a notification that 1Z1-058 (1Z0-058 beta) “Oracle 11g R2 RAC Administration” exam is now available. It earns you an 11g R2 RAC Oracle Certified Expert (OCE), but you need to be an 11g DBA Oracle Certified Professional (OCP) first to get that.
If you looked at my Bio page, you probably saw all the certifications I hold. While being certified is nice, I must admit that I enjoy the process more than the end result. The best thing about Oracle exams is that you -
a. get to know what Oracle expects of you to know to be considered an expert in that particular area, and
b. get to learn things when you study for the exam. Yes, I believe that even if you have a solid experience, there is always something to learn.
I started using Oracle RAC from version 10g R2 (around 2006 IIRC) and have never looked back. However, most of the fellow DBAs I know didn’t use Oracle clusters, one reason or another.
A couple of years ago we (the company I’m consulting) started our move to 11g, and a few months ago the move was completed and we are now on 11g R2 RAC.
11g R2 RAC is brilliant!
And as for my fellow DBAs, I am now seeing a significant change in their attitudes towards Oracle Real Application Clusters. Some of them are starting to realize all the benefits of RAC, and at the same time 11g R2 (“R2” being key here) is a substantial move forward, making it very easy to switch to RAC and focus on what’s really important.
Therefore, I believe the new 1Z0-058 exam should be very popular when more and more people and companies switch from single instances to RAC environments.
The exam consists of two parts, similar to the 1Z0-048 exam on 10g R2 RAC, namely the clusterware administration part, and RAC database administration.
One of the main differences to the previous version is that the clusterware part is now Grid Infrastructure (GI), and since GI now includes ASM, the new exam pays significantly more attention to ASM. Ironically, an 11g R2 RAC can be built on NFS (very easy and cost efficient) without any need for ASM. Of course ASM should be used in production environment as it provides countless benefits (technically speaking they can be counted) over NFS.
Anyway, let’s get to the point. If you are interested in switching from single instance to RAC, or if you have already been working with Oracle RAC for some time but do share my beliefs that exams are a great reference for studying and filling the gaps in your knowledge (however small those gaps can be), below are ten questions that should get you going.
Kevin is a database administrator at Fictional Real Estate Co. All he hears everyday is location, location, location. He is asked by one of the Sales team members about Oracle Real Application Clusters. What should he reply to his colleague’s “what is it all about”?
A. Performance, performance, performance.
B. Availability, availability, availability.
C. Redundancy, redundancy, redundancy.
D. Scalability, scalability, scalability.
E. Efficient utilization of all available resources.
Jenson is a database developer at Fictional Cluster Masters Co. He wants to pull a practical joke on the company’s DBA, so the DBA would think someone is performing a DDoS attack on the cluster. What should Jenson do in his application?
A. Only use physical IP addresses to connect to the database.
B. Only use virtual IP addresses, but not SCAN, to connect to the database.
C. Use as many sequences as possible (ideally a dedicated sequence for every ID field), with large caches.
D. Use as few sequences as possible (ideally just one sequence shared by all ID fields), with no cache.
May is a junior DBA at Fictional Calendars Co. She wants to start some RAC instances and stop some other RAC instances. What tools should she use from the list below?
B. sqlplus –mode=rac
D. srvctl -rac
E. Grid Control (if available) or Enterprise Manager
F. Grid Control (if available) but not Enterprise Manager
April is a junior DBA at Fictional Calendars Co. She asks the company’s senior DBA August what the number of UNDO and TEMP tablespaces and REDO log groups should be in a RAC environment. If August knows what he’s talking about, what will he answer?
A. 1 UNDO per instance, 1 TEMP per instance, 1 REDO per instance
B. 1 UNDO per cluster, 1 TEMP per cluster, 1 REDO per cluster
C. 2 or more UNDO per instance, 2 or more TEMP per cluster, 2 or more REDO per instance
D. 1 or more UNDO per instance, 1 or more TEMP per instance, 1 or more REDO per cluster
E. 1 UNDO per instance, 1 or more TEMP per cluster, 2 or more REDO per instance
F. 2 or more UNDO per cluster, 2 or more TEMP per cluster, 1 or more REDO per instance
Mark is a database administrator at Fictional Storage Specialists Co. He has built a 10g R2 RAC on Linux 4 before, using raw devices for voting disk and cluster repository storage, and ASM for data files. He now wants to build an 11g R2 RAC on Linux 5. What are his options when it comes to storage?
A. Raw devices for voting/OCR, ASM for data
B. Block devices for voting/OCR, NFS for data
C. OCFS2 for voting/OCR, NFS for data
D. NFS for voting/OCR, ASM for data
E. ASM for everything
F. NFS for everything
Matthew is a system administrator at Fictional Storage Specialists Co. He is going to install Linux OS as part of task to build an 11g R2 RAC. What packages and/or libraries he may need, depending on the storage options?
A. oracleasmlib, oracleasm-support, oracleasm for ASM
B. oraclenfslib, oraclenfs-support, oraclenfs for NFS
C. libasm11, libaio, sysstat for ASM
D. libnfs11, libaio, sysstat for NFS
E. libodm11 for ASM (optional)
F. libodm11 for NFS (optional)
Dorothy has more than 20 year experience administering single instance Oracle databases. She has developed an extensive library of shell scripts over all those years. She now wants to modify the scripts to work in an Oracle RAC environment. What views/columns would she use to determine instance IDs?
A. instance_id in V$ views
B. instance_id in V_$ views
C. inst_id in V$ views
D. instance_id in GV$ views
E. inst_id in V_$ views
F. inst_id in GV$ views
Tom is a network administrator and Dick is a system administrator at Fictional Links And Nets Co. They are working with the company’s DBA Harry building an 11g R2 RAC environment. They are reasonably confused about the number of network interfaces the DBA needs for the cluster, and ask for an explanation. What should Harry tell the pair of them?
A. Public interfaces are for client connections, and private interfaces are for administrator connections.
B. Public interfaces are for physical IPs, and private interfaces are for virtual IPs and SCAN.
C. Public interfaces are for client connections, and private interfaces are for cache fusion.
D. Public interfaces are for cluster-wide load balanced requests, and private interfaces are for instance-specific requests.
Lily and Daisy are junior DBAs at Fictional Bad Blocks Co. They have heard that their senior DBA Ash had performed an RMAN recovery in a 11g R2 RAC environment. They are very keen to learn if there are any differences to single instance recovery. If Ash knows what he’s talking about, what will he tell them?
A. Recovery catalogs must be used in RAC environments.
B. Recovery catalogs can but don’t have to be used in RAC environments.
C. Only the node that performs the recovery must have access to all necessary backups and archive logs.
D. All nodes must have access to all necessary backups and archive logs.
E. All the necessary backups and archive logs must be copied to the local disk(s) of the node that performs the recovery.
F. All the necessary backups and archive logs may reside either on the local disk(s) of the node that performs the recovery or in the Fast Recovery Area or in an NFS directory, as long as the node has access.
John is a database administrator at Fictional Just On Time Co. He needs to schedule various jobs against the company’s 11g R2 RAC database, and some of those jobs must run on the first node only to meet a legacy application’s requirements. What are the options?
A. Set job instance affinity with DBMS_SCHEDULER.
B. Set job node affinity with DBMS_JOB.
C. Use operating system’s commands to run legacy jobs on the first node only, connecting as “/ as sysdba”.
D. Use operating system’s commands to run legacy jobs on any node, connecting to the instance running on the first node.
Actually, let’s make it a dozen
Mario is a database administrator at Fictional Dash Nine Co. He needs to terminate a user’s session and issues an ALTER SYSTEM KILL SESSION ’123,456′ command, but receives an error that the session doesn’t exist. He realizes that he is connected to the second node and the session is running on the third node of the cluster. What is the easiest way of achieving the desired outcome?
A. Connect to the third node and re-issue the command.
B. Issue ALTER SYSTEM KILL SESSION ’123,456′ AUTO;
C. Stay on the second node and modify the parameters to ’123,456,3′
D. Stay on the second node and modify the parameters to ’123,456,@3′
E. Stay on the second node and modify the parameters to ’123,456,#3′
Summer is a database administrator at Fictional Patience Co. The company has several 11g R2 RAC databases, some are one-node, some are two-node, some three-node, and some four-node. Summer is going to review cluster-specific waiting events for each database. Which of the following statements are true?
A. One-way block request waits normally occur on one-node clusters.
B. One-way block request waits normally occur on one-or-more-node clusters.
C. Two-way block request waits normally occur on two-node clusters.
D. Two-way block request waits normally occur on two-or-more-node clusters.
E. Three-way block request waits normally occur on three-node clusters.
F. Three-way block request waits normally occur on three-or-more-node clusters.
G. Four-way block request waits normally occur on four-node clusters.
H. Four-way block request waits normally occur on four-or-more-node clusters.
Please note that all these questions are in no way an indication of the actual exam questions. Names and company names are fictional. This line is italic. Some things may or may not be obvious.