Notes for taking the 1Z0-061 Oracle Exam - Oracle Database 12c: SQL Fundamentals

oracle_1Z0-061_notes.md

Introduction

I have compiled these notes whilst revising for the Oracle 1Z0-061 Exam - Oracle Database 12c: SQL Fundamentals. They should also be relevant to the 1Z0-051 - Oracle Database 11g: SQL Fundamentals exam. Revision was most conducted using the excellent and highly recommended "OCA Oracle Database 12c SQL Fundamentals I Exam Guide" by Roopesh Ramklass.

I have aimed to include include in these notes common "gotchas" and easy to forget functionality rather than documenting everything required for the exam. This can then be used as a quick refresher before walking into the exam.

The content is broken up into sections with each heading mapping to the relevant Oracle 1Z0-061 exam topics.

Thanks for the notes! How was the test? I am studying for it right now and going through the required course at a local college. Im also new to the DBA world and was moved into a JrDBA spot in June.

This notes are wonderful, Please share your exam experience too. I have passed 1z0-051 and now I am applying to 1z0-061 or 1z0-071. I have passed the previous test with the help of online practice exams. I will try the same for 1Z0-061.

Fantastic, thank you so much for putting this together! Exactly the refresher I needed.

Wonderful! Did you use any practice test software ? If so could you please share which one

Brill thanks, how was the exam? I'm sitting mine in November....eek!

Validate your 1z0-061 Exam learning and preparation with our most updated 1z0-061 dumps. (Dumpspdf.com) has experienced IT experts who gather and approve a huge range of Oracle 1z0-061 Questions Answers for Oracle Database 12c Certification seekers. Practicing our 100% updated 1z0-061 Practice Tests is a guaranteed way towards your success in Oracle 1z0-061 PDF Dumps.

Fantastic!!!

Don't believe.
Can you put examples of:

• HAVING can come before or after the GROUP BY.
• Group functions ignore NULLs (try COUNT(*) on columns with nulls)
  ?

And once more: "must be upper case (even if entered lower case they will be converted to upper)''
Please create the objects with the same name but one with upper case and the second lower case. You'll see two objects in SQL Developper.