Exam 1Z0-051 Oracle Database 11g: SQL Fundamentals I has just been released in full production.
This new exam is part of the Oracle Certified Oracle Database 11g Administrator track, combining training, experience, and testing to endorse candidates with a strong foundation and expertise in the industry’s most advanced database management system.
Exam 1Z0-051 covers topics such as:
- retrieving data using SQL select statements
- reporting aggregated data using group functions
- displaying data from multiple tables
- using subqueries to solve queries
- using set operator
- manipulating data
- using DDL statements to create and manage tables, and
- creating schema objects.
The exam contains 65 questions, 2 hours (120 minutes) allowed for completion, and requires a score of 60% to pass. Cost is $95 USD, with immediate registration available through Prometric testing centers worldwide.
Paul Sorensen,
Director, Oracle Certification
QUICK LINKS
- Register for Exam: www.prometric.com/oracle
- Certification Exam information: 1Z0-051 Oracle Database 11g: SQL Fundamentals I
- Certification Track information: Oracle Certified Oracle Database 11g Administrator
Comments (19)
while the contents of this exam is on the web can someone suggest from where a detailed study guide i can get ?
cheers!
ankur
Posted by ankur | November 12, 2008 7:21 AM
There are course materials for the "Oracle Database 11g: SQL Fundamentals I: and "Oracle Database 11g: Introduction to SQL" courses that is given to the attendees. Links to these courses are on the exam page at http://bit.ly/qpHp.
Good luck!
- Harold
Posted by Harold Green | November 12, 2008 10:30 AM
hi
i wnt to give exam of 11g sql fundamental 1 so plz anyone help me to give info abt study guide and test demo
Posted by vaibhavi | February 24, 2009 9:37 PM
Hello,
I purchased the book OCA Oracle Database 11g: SQL Fundamentals I Exam Guide (Exam 1Z0-051) and the practice exam that comes with the book requires an 80% score to pass but on the Oracle University site it says 60% is a passing score. Do you know if this just an error in the book or have the passing requirements changed?
Steve
Posted by S Bair | March 2, 2009 10:35 AM
Hi Steve - 60% is the correct number. I think that 80% might just be a figure for the practice test in the book itself [not for the real exam].
Cheers,
- Harold
Posted by Harold Green | March 2, 2009 1:58 PM
Thanks for the information Harold!
Posted by S Bair | March 2, 2009 5:42 PM
hi
i wnt to practise exam of 11g sql so plz anyone help me to give info abt study guide and test demo
Posted by T.GOPINATH | March 3, 2009 1:19 AM
Hello everybody, someone knows if the Practice Test in the book is similiar (easier, harder, etc) compared with the Real Exam 1Z0-051???? I mean the level of the questions...
Posted by praxGT | March 7, 2009 12:24 PM
Our team is planning to appear for SQL PLSQL 11g certification. Could you please help us for the syllabus and course material of same.
Thanks and Regards
Posted by Anurag Arun Edlabadkar | March 16, 2009 6:36 AM
Hi Anurag - good news: we have all this information in one place at http://bit.ly/ghz2.
Good luck!
-- Harold
Posted by Harold Green | March 16, 2009 6:46 AM
Hi,
I had failed it once for the first time. I just gave this exam and passed it. Do I receive a certificate? I took the non proctored version.
Thanks
Rahul
Posted by Rahul | April 6, 2009 12:16 AM
I have this book and am not very impressed with it.
The practice exam included on the CD has errors in it, for example:
one question in particular has a multiple choice of A,B,C or D.
You choose D as the correct answer, but it is marked incorrect.
The study guide states:
Correct answer: A,B & C
Explanation:
D is the correct answer because....
There are a number of similar faults with this and the bonus downloadable practice test.
I took the test once so far and failed it, extremely suprised at how different the questions are to the practice tests. This book does not strike me as a very good exam guide at all.
I'd be interested to know if anyone else has been as unimpressed as I have with this book?
Posted by Steve | April 10, 2009 12:00 AM
Hi Steve - that sounds quite frustrating! I'm not sure which book you're referring to. as this blog post is about an exam. Can you help clarify?
Cheers,
- Harold
Posted by Harold Green | April 10, 2009 6:32 AM
Is this exam all in multiple choice? thx
Posted by DBA starter | July 23, 2009 11:04 AM
Hi DBA starter - yes.
Posted by Harold Green | July 23, 2009 2:02 PM
Hi I want to give the sql fundamentals 1 exam , so which book will be good for me to study. Harold do you suggest any???
Chandra
Posted by Chandra | August 20, 2009 10:33 AM
Hi Chandra - so far I'm only aware of the materials that Oracle itself has published as part of the class. I haven't yet seen any standalone study guides.
Posted by Paul Sorensen
|
August 24, 2009 12:13 PM
Hi All,
some of the links in this article are outdated. Prometric no longer hosts the exams. Pearson VUE is the testing partner now:
http://www.pearsonvue.com/oracle/
Erik
Posted by arciitek | October 16, 2009 4:31 AM
I just took this test unproctored online and failed. It was extremely difficult in my opinion. Very few of the questions were straighforward. Seemed more tailored to the developer crowd. I have already passed the Admin tests but tthis one has me worried. Any suggestions on how to prepare. I used Transcender's testing suite but obviously that didn't work. Any other suggestions would be appreciated.
Posted by Tom K. | November 19, 2009 12:00 AM