The first of the Oracle 12c accreditation exams to go into generation is 1Z0-061: Oracle Database 12c: SQL Fundamentals. Prophet University put this exam into creation at the same time with the retirement of the significantly more seasoned exam 1z0-066: Introduction to Oracle9i SQL. In any case, the 11g variant of the SQL Fundamentals exam, 1z0-066, is as yet accessible. Having two proportional exams underway prompts a considerable measure of perplexity among accreditation hopefuls. In this article I will examine the two exams, what is distinctive amongst them, and how to pick one over the other.  1z0-066 dumps 

Either will fulfill the SQL necessity for the “Prophet Database 11g Administrator Certified Associate” or “Prophet PL/SQL Developer Certified Associate” tracks. The SQL necessity can likewise be fulfilled by passing 1Z0-047: Oracle Database SQL Expert. Be that as it may, 1Z0-047 is a significantly harder exam than either 1z0-066. This is a choice that ought to just be considered on the off chance that you have worked with Oracle SQL broadly. This article concentrates on the SQL essentials exams.

The 11g and 12c SQL Fundamentals exams are practically indistinguishable as far as substance secured and necessities fulfilled for Oracle affirmations. Prophet does not oblige you to utilize the 12c SQL Fundamentals while seeking after the 12c DBA track or the 11g exam for the DBA track in that discharge. Any Oracle SQL exam (counting resigned ones) can be utilized for any Oracle confirmation track that has a SQL necessity. For instance, the SQL test I assumed control over 10 years prior was 1z0-066: Introduction to Oracle: SQL and PL/SQL. That test has been resigned for a considerable length of time, however could in any case be connected for the 12c track.

While the substance of the two exams is fundamentally the same as, there are a couple of contrasts. Both 1z0-066 contain forty-one points. Of those, thirty-six are regular to both exams. This implies the tests have around 88% shared characteristic by point number. The last area of the 11g exam (Creating Other Schema Objects) was expelled from the exam in the 12c adaptation. The points shrouded in that segment are:

Make basic and complex perspectives

Recover information from perspectives

Make, keep up, and utilize successions

Make and keep up files

Make private and open equivalent words

For the 1z0-066 exam, Oracle University included another “Presentation” area with the accompanying four subjects:

Depict the components of Oracle Database 12c

Depict the striking elements of Oracle Cloud 12c

Clarify the hypothetical and physical parts of a social database

Depict Oracle server’s usage of RDBMS and protest social database administration framework (ORDBMS)

They likewise added one more subject to the “Overseeing Tables utilizing DML explanations” area:

Truncate information

I need to state that I am extremely frustrated with Oracle University’s choice to put TRUNCATE (which is a DDL operation) under an area particularly about DML explanations. This is not something that bodes well in a test intended for individuals who are new to SQL. I am certain that OU would be crushed to learn of my dissatisfaction.

The 1z0-066 exam has nine a greater number of inquiries than 1z0-066 (75 versus 66) and a somewhat higher passing score (65% versus 60%). This does not really imply that the test is harder to pass, however. The themes that have been included are ones that are probably going to have questions that are more direct than the points that were evacuated. OU has a specific target rate of hopefuls that they need to breeze through each test on a first endeavor. On the off chance that they raised the passing score, it was on account of they felt the refreshed test had less demanding inquiries.

I need to state that picking one test over the other is truly a hurl up. The 11g exam is not especially dated and the majority of the subjects are as yet applicable. There may be a tad bit of long haul advantage in having the 12c exam on your record as opposed to 11g, just on the grounds that 12c will be around after 11g is resigned. Be that as it may, 11g is right now the standard database utilized as a part of creation situations. Not very many organizations will have moved to 12c yet. What’s more, none of my bosses have asked (or minded) about the particular tests I took to pick up my Oracle accreditations. Pick the exam that sounds good to you and you can be sure that you are not committing an error. Whichever one you pick, good fortunes on the test.

Leave a Reply

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