The Oracle SQL platform involves the use of statements that allow programs and program users to access data in a database. The language includes SQL (Structured Query Language) and PL/SQL (Procedural Language for SQL). SQL as a language is limited and can only execute single queries/updates/inserts/delete. PL/SQL can do multiple updates/inserts/selects/deletes, and it has some added functionalities that ensure speed, scalability, and high performance. There are certificates and exams designed for those professionals who demonstrate their expertise in running these SQL and PL/SQL platforms.

The certifications are divided into the associate and professional levels as described below:

• Oracle SQL Associate Level

The candidates can follow one of two options provided to attain this certification. The first option is to pass the Oracle 1Z0-071 exam and attain the Oracle Database 12c SQL Certified Associate credential. The second option involves passing either the 1Z0-071 exam (Oracle Database 12c SQL) or the 1Z0-061 exam (Oracle Database 12c: SQL Fundamentals) retiring on 30 November, 2019. Once the candidates pass one of these tests, they can now register and pass the 1Z0-144 exam (Oracle Database: Advanced PL/SQL). The second option leads to the Oracle PL/SQL Developer Certified Associate certification.

• Oracle SQL Professional Level

To qualify for this credential, the students must have passed any of the following exams: 1Z0-061, 1Z0-071, 1Z0-144, 1Z0-063 (Oracle Database 12c: Advanced Administration), or 1Z0-053 (Oracle Database 11g: Administration II). Once the individuals have met this requirement, they are allowed to sit for the 1Z0-148 certification test. This leads to the award of the Oracle Database PL/SQL Developer Certified Professional credential.

Each of the relevant exams comes with the multiple-choice question. These tests are offered through Pearson VUE. All candidates must accept and adhere to the Oracle stipulated exam rules and regulations. The exam preparation process includes recommended training, use of study guides, and practice tests. The students who fail their exams are allowed to retake them after 14 days. There are no restrictions to the number of times that one can retake the test. The Oracle credentials do not expire.