For Oracle specialists who are going after the Oracle PL/SQL Designer Licensed Associate qualification, there are two tests that will certainly satisfy the PL/SQL need: “1Z0-147: Program with PL/SQL” and the more recent variation: “1Z0-144: Oracle Data Source 11g: Program with PL/SQL”. sources from There is a reasonable quantity of confusion among prospects looking for accreditation over whether they need to take one examination, or the various other, or both. The intent of this short article is to help describe the two tests, their resemblances as well as differences, and also why you may take one over the various other.

Something ought to be made clear from the start: there is never ever a reason to take both examinations. Unlike the DBA track, Oracle PL/SQL accreditations are not linked to the data source launch. You do not come to be certified in launch X of Oracle PL/SQL and after that have a need to take upgrade tests. Since either of these 2 examinations will please the OCA-level PL/SQL demand, passing the other would certainly offer no accreditation advantage. That said, you need to decide which of both examinations to go after. The 1Z0-147 test is numerous years older than 1Z0-144. Unless there is a particular reason that taking the older examination will benefit you, your much better choice is to choose the 11G version of the exam. Up until Oracle retires 1Z0-147, nonetheless, the option is yours.

The two examinations have a large amount of commonality between them. This makes sense as they are for basically the same subject. What is unexpected is the variety of distinctions that exist between both. 1Z0-144 is not just a remake of the earlier test with brand-new PL/SQL attributes from versions 10G and 11G added. There is a totally various feel to the test and the subjects covered. sources from rwandair There are several sections that do not exist in 1Z0-147 which cover functions that did not exist in 9i. Nevertheless, the majority of the new sections in 1Z0-144 cover core subjects of PL/SQL programs that probably must have been in the earlier test. Several of the types of info covered in 1Z0-144 however not 1Z0-147 consist of:

The advantages of using PL/SQL
Setting fundamentals, consisting of variables, conventions, attributes, and also lexical units
Use of SQL features in PL/SQL
Implied vs. explicit data conversion
Use labels, imprint, and also whitespace to make more readable code
The use of DML in PL/SQL
Making use of control structures as well as Loops
Using arrows and cursor features
The use of the FOR UPDATE provision
Exception Handling
PL/SQL Layout considerations
Composite information types
Self-governing deals
MASS SQL operations
PL/SQL compiler changes
The variety of subjects covered in 1Z0-147 that are not covered in 1Z0-144 is a lot smaller sized. However, the very first three are unexpected thinking about the obvious shift to PL/SQL fundamentals in the 11G test:

Opportunities required to perform procedures
Parameter modes as well as DEFAULT values
Criterion passing approaches– by reference vs. by value
A much larger focus on triggers
Much more references to client-side PL/SQL (1Z0-144 largely ignores client-side).
Much more focus on PL/SQL reliances and invalidations.
Large things and also making use of the DBMS_LOB plan.
If you end up going after 1Z0-147, make sure to examine making use of the Oracle 9i documentation. Abilities that were contributed to PL/SQL in 10G or 11G will not be on that examination. Having actually researched the subjects for both examinations, I think about 1Z0-144 to be the far better test from the perspective of the info tested. The topic is a far better mix of what is very important for an entry-level PL/SQL programmer to know. New designers studying for this examination will certainly bring out an extra rounded as well as complete understanding of PL/SQL basics. Whichever test you pursue, be sure to research each of the examination topics noted on the Oracle Education site before setting up the exam. Best of luck on the examination.

How to Prevent Disastrous SQL Injection Attacks