For Oracle professionals who are pursuing the Oracle PL/SQL Programmer Certified Associate qualification, there are two tests that will please the PL/SQL demand: “1Z0-147: Program with PL/SQL” and the newer variation: “1Z0-144: Oracle Database 11g: Program with PL/SQL”. There is a fair amount of complication amongst prospects looking for accreditation over whether they ought to take one examination, or the other, or both. The intent of this post is to help explain the two tests, their similarities and distinctions, as well as why you could take one over the other.
One thing needs to be explained from the start: there is never a factor to take both tests. Unlike the DBA track, Oracle PL/SQL accreditations are not tied to the data source release. You do not come to be accredited in launch X of Oracle PL/SQL and afterwards have a demand to take upgrade exams. Because either of these two examinations will certainly satisfy the OCA-level PL/SQL need, passing the various other would certainly provide no certification advantage. That said, you SQL Course London need to choose which of the two tests to seek. The 1Z0-147 test is numerous years older than 1Z0-144. Unless there is a particular factor that taking the older test will certainly benefit you, your far better option is to choose the 11G variation of the exam. Until Oracle retires 1Z0-147, nevertheless, the option is your own.
Both tests have a good deal of commonality between them. This makes good sense as they are for basically the very same subject. What is surprising is the variety of distinctions that exist in between the two. 1Z0-144 is not merely a remake of the earlier test with new PL/SQL functions from versions 10G as well as 11G tacked on. There is a completely different feel to the examination and the topics covered. There are a number of sections that do not exist in 1Z0-147 which cover attributes that did not exist in 9i. However, the majority of the new areas in 1Z0-144 cover core subjects of PL/SQL shows that arguably should have been in the earlier examination. Several of the sorts of information covered in 1Z0-144 yet not 1Z0-147 include:
The benefits of making use of PL/SQL
Programming essentials, consisting of variables, conventions, attributes, as well as lexical devices
Use of SQL features in PL/SQL
Implicit vs. explicit data conversion
Use labels, impression, and whitespace to make more readable code
Using DML in PL/SQL
Making use of control structures as well as Loopholes
Using cursors as well as cursor characteristics
The use of the FOR UPDATE stipulation
PL/SQL Design considerations
Compound information kinds
BULK SQL operations
PL/SQL compiler modifications
The variety of topics covered in 1Z0-147 that are not covered in 1Z0-144 is a lot smaller sized. However, the first three are surprising taking into consideration the noticable shift to PL/SQL principles in the 11G examination:
Privileges called for to perform treatments
Criterion settings and DEFAULT worths
Specification passing techniques– by reference vs. by worth
A much larger focus on triggers
Much more references to client-side PL/SQL (1Z0-144 mostly overlooks client-side).
Much more concentrate on PL/SQL dependencies as well as invalidations.
Big items and also using the DBMS_LOB package.
If you wind up seeking 1Z0-147, make certain to research using the Oracle 9i documentation. Abilities that were included in PL/SQL in 10G or 11G will not be on that examination. Having actually investigated the topics for both examinations, I consider 1Z0-144 to be the far better test from the perspective of the details tested. The topic is a better mix of what is very important for an entry-level PL/SQL designer to recognize. New programmers researching for this exam will bring out an extra rounded and total understanding of PL/SQL fundamentals. Whichever examination you pursue, make sure to research each of the exam subjects provided on the Oracle Education website before arranging the exam. Best of luck on the test.