Author Box
Articles Categories
All Categories
Articles Resources

Studying for 1Z0-050: Oracle Database 11g: New Features for Administrators

June 25, 2012 | Comments: 0 | Views: 268

Oracle 11G has been out for several years now. If you are an Oracle 10g DBA certified professional and have not yet upgraded, you really should consider doing so. I was first certified in Oracle 7, so I have taken several upgrade certifications. I have always found studying for the upgrade certifications to be valuable for learning about changes to the capabilities of Oracle that are useful to me in my work. Mind you, I will freely grant that for every new feature that is of use to me, there are another eight or nine that I really don't care about in the least. In this article I will try to provide a glimpse into some of what types of questions you will encounter on the test to help guide your preparation.

All of the topics that will be covered in the 1Z0-050 exam are listed on the Oracle Education website. There are features that are new in Oracle 11G that are not on that list. These features will not appear in test questions. The topic lists from Oracle Education are always complete. The 11G New Features exam has fifty-eight topics spread among sixteen subject areas. With 77 questions, you will generally see one or two questions per topic.

From my experience, Oracle upgrade tests bear some resemblance to marketing documents. The features that will appear most prominently on the exams will be the ones that provide Oracle with an edge over competing RDBMS platforms. These will be the features that will get the most questions asked. When you are studying for 1Z0-050, put in some extra effort on these types of enhancements. Also, keep in mind that new features exams are not really about testing your ability to use Oracle. As an Oracle Certified DBA, it is assumed that you can already use the database. For this exam, you will be expected to be able to answer questions about:

  • What new capabilities have been added to the database with 11G.
  • Specific concerns when upgrading an existing database to the new version.
  • How changes in the release affect routine administration of the database.
  • The steps required to enable, disable, or configure the new feature.

For the last, understand that the test will not have you programming PL/SQL statements or navigating a GUI interface during the test. Questions for features that involve coding or use of Oracle Enterprise Manager can only be tested indirectly. What is primarily being tested is whether or not you are aware of the existence of the new features, the purpose of the features, and the basics of enabling them. Some features might require a simple command, or new keyword to implement. If that is the case, you should know the new command or keyword. Other features might require dozens of lines of PL/SQL. In these cases, you might need to know the steps to implement, but you won't be required to look at a page full of code and determine whether or not it will work.

1Z0-050 was not one of the more complex of the Oracle certification tests that I have taken. It is almost entirely fact-based rather than being experience-based. Given the nature of the material being tested, it could hardly be otherwise. Reading the New Features manual available with the Oracle 11G documentation is a reasonable place to start studying, but is not sufficient in and of itself to pass the exam. The manual contains many features that are not on the test, and few of the tested topics are covered in enough depth for the questions that will be asked. Make sure you are comfortable with all of the topics before scheduling the exam. Good luck on the test.

Matthew is an experienced DBA and developer. He holds Oracle DBA Certifications for releases 7, 8i, 9i, 10G and 11G; and Oracle Expert Certifications for SQL and Application Express. He is the author of several Oracle certification guides, including one for 1Z0-050.

Source: EzineArticles
Was this Helpful ?

 
1
 
0
 
Rate this Article
2 vote(s)
Feedback
Print
Re-Publish

Article Tags:

1z0 050

,

1z0 055

,

11g New Features

,

Oracle Database 11g

,

Ocp

,

Oracle Certification

Windows 8 will change the way you work and play, says Microsoft and we agree. Nearly all of the previous iterations of the Windows OS have been evolutionary but Windows 8 is set to change all that.

By: Sakshi Sharma l Computers & Technology > Mobile Computing l April 03, 2013 lViews: 660

Many antivirus programs available today have various features but it entirely depends on the user to make the best choice from among these different computer virus protection programs online. Before

By: Alex l Computers & Technology > Software l December 28, 2012 lViews: 369

You can add a new color to your entertainment life with iskysoft video converter for mac & iskysoft dvd creator for mac and make your Christmas holidays all the more special. iskysoft video

By: Zaithyn Galter l Computers & Technology > Software l December 23, 2012 lViews: 1070

The choices you make regarding the type of recruiting software you choose to use are important. Being an informed consumer is essential to getting a system or components that complement systems of

By: Maria Warne l Computers & Technology > Software l December 14, 2012 lViews: 305

The Cisco certification has become the most popular IT training in recent days and it offers three different levels of these certifications include as: associate, professional and expert-level.

By: sandidas chakma l Computers & Technology > Certification Tests l December 11, 2012 lViews: 236

Millions of prospective 12th standard students are gearing up their preparations for the Joint Entrance Exam for engineering seats. From 2013, it has been decided by the IITs, CBSE, JEE organizing

By: Sarkariexam l Computers & Technology > Certification Tests l December 07, 2012 lViews: 633

The Cisco certification has become the most popular IT training in recent days and it offers three different levels of these certifications include as: associate, professional and expert-level.

By: sandidas chakmal Computers & Technology > Certification Testsl December 11, 2012 lViews: 236

Millions of prospective 12th standard students are gearing up their preparations for the Joint Entrance Exam for engineering seats. From 2013, it has been decided by the IITs, CBSE, JEE organizing

By: Sarkariexaml Computers & Technology > Certification Testsl December 07, 2012 lViews: 633

One can truly say the world has transformed into competitive place for businesspersons. In every sector one would find the flourish of businesses. Among various fast developed industries is the

By: Mukesh Kumarl Computers & Technology > Certification Testsl November 11, 2012 lViews: 199

If you ever have heard about the Cisco Certification you might be wondering why people today are so crazy about Cisco. Why not, Cisco System has built immense reputation in the entire world and the

By: Mohsen Ansaril Computers & Technology > Certification Testsl October 25, 2012 lViews: 215

Well Guys! It’s really hard to decide, which course to take up because of the number of hardware certification being available in the market. But you need not worry as long as it is certified by

By: Mohsen Ansaril Computers & Technology > Certification Testsl October 25, 2012 lViews: 216

A Cisco exam that offers students with the certification is definitely a highly paying gateway assuring brighter future, but it is one of the hardest certifications to obtain. In order to get through

By: Mukesh Kumarl Computers & Technology > Certification Testsl October 25, 2012 lViews: 214

The Oracle 11G SQL Fundamentals I exam (1Z0-051) is one of three possible tests that will satisfy the SQL requirement for several Oracle certification paths. It is one of the most commonly taken of

By: Matthew R Morrisl Computers & Technology > Certification Testsl June 26, 2012 lViews: 383

Discuss this Article

comments powered by Disqus