Oracle SQL Certification: 1Z0-051 or 1Z0-061?

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 considerably more seasoned exam 1Z0-007: Introduction to Oracle9i SQL. In any case, the 11g variant of the SQL Fundamentals exam, 1Z0-051, is as yet accessible. Having two proportionate exams underway prompts a considerable measure of disarray 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-061 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. Nonetheless, 1Z0-047 is a significantly harder exam than either 1Z0-051 or 1Z0-061. This is an alternative that ought to just be considered in the event that you have worked with Oracle SQL widely. This article concentrates on the SQL essentials exams.

The 11g and 12c SQL Fundamentals exams are practically indistinguishable as far as substance secured and prerequisites fulfilled for Oracle confirmations. 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 accreditation track that has a SQL necessity. For instance, the SQL test I assumed control over 10 years prior was 1Z0-001: Introduction to Oracle: SQL and PL/SQL. That test has been resigned for a considerable length of time, however could at present 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-051 and 1Z0-061 contain forty-one points. Of those, thirty-six are regular to both exams. This implies the tests have around 88% shared characteristic by subject tally. The last area of the 11g exam (Creating Other Schema Objects) was expelled from the exam in the 12c rendition. The points shrouded in that area are:

Make straightforward and complex perspectives

Recover information from perspectives

Make, keep up, and utilize groupings

Make and keep up lists

Make private and open equivalent words

For the 1Z0-061 exam, Oracle University included another “Presentation” area with the accompanying four themes:

Depict the components of Oracle Database 12c

Depict the striking components of Oracle Cloud 12c

Clarify the hypothetical and physical parts of a social database

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

They additionally added one more point to the “Overseeing Tables utilizing DML explanations” segment:

Truncate information

I need to state that I am exceptionally baffled with Oracle University’s choice to put TRUNCATE (which is a DDL operation) under an area particularly about DML articulations. 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 devastated to learn of my dissatisfaction.

The 1Z0-061 exam has nine a greater number of inquiries than 1Z0-051 (75 versus 66) and a marginally higher passing score (65% versus 60%). This does not really imply that the test is harder to pass, however. The points that have been included are ones that are probably going to have questions that are more direct than the subjects that were evacuated. OU has a specific target rate of hopefuls that they need to breeze through each test on a first endeavor. In the event that they raised the passing score, it was on the grounds that they felt the refreshed test had simpler 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 greater part of the subjects are as yet pertinent. There may be a tad bit of long haul advantage in having the 12c exam on your record instead of 11g, just in light of the fact that 12c will be around after 11g is resigned. Nonetheless, 11g is as of now the standard database utilized as a part of generation situations. Not very many organizations will have moved to 12c yet. Likewise, none of my managers 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 certain 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 *