. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Posted in Digital Marketing

Oracle Exam 1Z0-007 Retired – What Does That Mean For Me?

Oracle Certification announced the retirement of several exams on March 13, including 1Z0-007: Introduction to Oracle9i SQL. This is one of the most popular exams offered by Oracle because it satisfies the SQL requirement for several certification tracks. With his retirement imminent, many people have been wondering what this will mean for their path to certification. In this article, I’ll take a look at what it means based on what stage of the certification process you’re in.

  • You’ve already passed 1Z0-007 — If this is the case, withdrawal from the exam has no effect on you. Oracle does not invalidate exam results when they are withdrawn. By withdrawing the exam, they are simply setting a date after which the exam will no longer be offered to new test takers. Exam 1Z0-001: Introduction to SQL and PL/SQL was retired several years ago. However, people who have passed that exam can still use it to satisfy their SQL requirement in certification tracks.

  • You are currently studying for 1Z0-007 — If you have been preparing for this exam and intend to take it, then you have until July 31 to do so. After that date, the exam can no longer be scheduled. I wouldn’t wait until the last few days. If something ends up preventing you from taking the test when you plan to take it, you cannot take the test after that date. This is true even if the problem is not your fault, such as a test center outage. If you cannot take the 1Z0-007 before the deadline, you will need to change to the 1Z0-051.

  • You were planning to study for 1Z0-007 — If you haven’t started the study process yet, I would recommend taking the newer exam, 1Z0-051: Oracle Database 11g: SQL Fundamentals I. This exam is about 80% similar to 1Z0-007.

When comparing the exams, the two have thirty-four topics that are comparable or identical. Eight of the themes in 1Z0-007 do not exist in 1Z0-051. Three of them are in iSQL*Plus, which is no longer shipped with the current version of Oracle. Four of the other five not on the 1Z0-051 exam are for minor subjects that were consolidated into more comprehensive subject areas on the 11G test. Finally, a topic was taken from the Fundamentals exam and placed on the SQL Expert test.

The 1Z0-051 exam has six topics that are not in 1Z0-007. Three of them involve the use of the SET (INTERSECTION, UNION, MINUS) operators. One topic covers the use of conditional operators (DECODE and CASE) and another is about cartesian products. The final topic covers the structure of the Oracle table. Each of the new subject areas on the 1Z0-051 exam are valuable additions, making it a better test than the one it is replacing.

admin

Leave A Comment