In conditions of content covered and requirements satisfied for Oracle certifications, these two exams are almost the same. It truly is no surprise that the two generate a significant amount of dilemma and questions from applicants trying to decide which they should take. In this article, I will discuss the two tests and point out why you might choose one over the other. 70-534 dumps

Either of these tests will meet the SQL requirement for the “Oracle PL/SQL Developer Qualified Associate” or “Oracle Repository 11g Administrator Certified Associate” tracks. DBA and Creator prospects must either take one of these two tests or a third exam option: “70-534 : Oracle Database SQL Expert”. The SQL Expert test is considerably more difficult than either 70-534 . It is a practical option to gratify the SQL requirement, but requires considerably greater knowledge of Oracle SQL. In this article I’ll deal just with the two SQL fundamentals exams.

The dissimilarities involving the two tests can be summarized in two words, age and content. A two-word summary isn’t really useful to you in making a decision, nevertheless , so I’ll break it out a little further than that. v

The 1Z0-007 test was written against Oracle 9i as the name suggests. Oracle 10G was released in 2004, and Oracle 11G in the year of 2007. While Oracle Corporation has not provided a release date for the 12c version of the data source, it’s liable to be some time reasonably soon. 70-534  has never recently been updated for newer emits and has an acceptable chance of being retired quickly. In one sense old age of the test does not matter, as Oracle certifications do not expire. My first DBA recognition was in Oracle 7. 3, for example. That recognition is still not expired. Nevertheless , it is also no longer relevant because no person is using Oracle 7. 3. In that context, obtaining the 9i version of test means that your SQL recognition has a within the on becoming irrelevant. By comparison, 70-534  was written specifically for Oracle 11G. Since it is approximately eight years newer than the 9i version, this test is unlikely to be retired for many years to come.

The 9i test has forty-two subject areas compared to forty-one for 11G. Of those, thirty-four matters are either identical between the two or comparable. In one case an individual topic in 9i is split into two subject areas for 11G. Of the eight issues in 9i that do not exist in 11G, three are on iSQL*Plus. This application was eliminated in the current release of Oracle. Four of the other five subjects not in the 11G exam are for minor subject areas which were consolidated into broader subject matter in the 11G test. For example, ‘Describe a view’ became part of the topic “Create simple and complex views”. The last of the eight matters was moved to the SQL Expert test.

There are six matters in the 11G test that are not in the 9i one. Of those, 3 involve using the COLLECTION operators (UNION, INTERSECT, MINUS) Another of the subject areas is about the use of conditional operators in SQL (CASE and DECODE). One of the subject areas is about queries that generate Cartesian products. The final topic is on the Oracle stand structure. All of these are valuable additions to the SQL fundamentals test.

While the two tests have about 80% commonality in content covered, of the 20% that is different, the 1Z0-051 exam beats 1Z0-007 hands-down when it comes to the significance of the information. Unless you have a very valid reason for choosing the 9i version, I are unable to imagine choosing it over the 11G exam. In case you are incredibly simple with Oracle 9i and are comfortable using iSQL plus, then I are able to see possibly choosing the older version. Nevertheless , if you are coming at Oracle SQL cold, then I strongly recommend pursuing the newer version of the SQL Fundamentals exam. Whichever one you choose, good luck on the test.

Leave a Reply

Your email address will not be published. Required fields are marked *