Studying for the OCA/OCP Exams – Hints and Tips
This is not a 'this is how to do it' guide, rather a 'this is how I did it and I hope it may help you' guide.
I used the Oracle Press All-in-one study Guide.
There are other resources available, such as the course books you will receive, the Oracle concepts Guide etc.
I found it easier to just use the one resource so I didn’t get confused and so I didn’t have too much material to get through in a short space of time.
The book covers everything required for the exam so you can do it just using this book.
The book is well organised into short, readable chapters.
Each chapter contains a legend which highlights general tips, specific exam tips (pay attention to these!) and workable examples.
Each chapter finishes with a questions section and also provides the answers and explanations.
One thing to point out, without sounding patronising, is that you really have to be prepared to put the work into this. It did take over my life for a week or so, but it was worth it to make sure I didn’t have to go through it all again for the re-sit!
Don’t leave the studying to the last minute, pace yourself to allow things time to sink in.
Don’t try and read through too many chapters at once, you’ll find that you’ll forget the earlier stuff.
I worked it so I was doing about 3 chapters per day. That way I was doing a steady amount over the week, and knew I would get through all 21 chapters, rather than having to do half the book the day before.
Before starting the book, I did the practice exam from the CD you get with the book. This gave me an idea of where my knowledge was currently up to.
It also highlights any areas that you need to work on.
For me it was Rman and shared server, mainly because I hadn’t used them much before.
The practice exam will also give you an idea of the style of questions to expect, so you can see what you are aiming for when reading the book.
Attempt the practice exam again once you have read the book, this will show you the improvement you have made and also highlight any areas that still need work.
Other than those two occasions, I didn’t do the practice exam much. There’s plenty of questions in the book to attempt and the questions given for the practice exam don’t vary. So by default, if you did it enough times you’d get them all right, without necessarily understanding the answers you have given!
I just used it to get a results score to use as a benchmark.
I found the best way to use the book was to read the chapter, work through the examples, then walk away.
Get a coffee or whatever, then come back and attempt the questions. I found that by answering the questions straight away, you may get most of them right, but just because you read that fact 5 mins ago.
Have a break and give the info time to sink in – you’ll get a much better idea of what you have really understood.
Attempt the questions honestly – even though you know the answers are on the next page! Peeking won’t allow you to assess how much you have understood.
If you get a lot of the questions wrong, or find a chapter difficult, mark the chapter and make a note to go back to it. Re-read the chapter then attempt the questions again.
For some of the chapters where I knew I had more work to do, such as the Rman and shared server stuff, I made my own notes as I went along. I’d read a few paragraphs, or one of the sections, close the book then try and condense what I’d learned into a few short summary lines that I could refer back to.
The questions in the book, and those in the practice exam, really do reflect the type of questions you get in the exam. If you get used to answering the questions in the book and working out the style, then nothing in the exam should come as a surprise.
When doing the practice exam, note the level of detailed knowledge required for some of the questions.
It’s generally not enough to just have a broad understanding or to skim sections as you think you know what it’s about.
You’ll find that some of the exam questions require you to not only know the different tools and techniques, but also how and when to use them.
The ‘when to use them’ bit is particularly important as there are some questions in the exam that are scenario based.
For example, one of the questions I got was along the lines of:
You have external data stored in flat files. You wish to insert the data into your Oracle database. You have clustered tables within the database. How would you do this:
A. Use the Export/import utilities
B. Use SQL*Loader direct path load
C. Use the Data Pump utility
D. Use SQL*Loader conventional path load
To answer this, you need to know the advantages/disadvantages/limitations of each of the methods.
As you have external data in flat files, it has to be done with SQL*Loader.
As there are clustered tables in the database, you can’t use the direct path load, so the answer is D.
The above question also highlights 2 other important points.
1. Read the questions carefully – I nearly got caught out a couple of times by skim reading the question. There is sometimes a tiny little detail (like the reference to clustered tables) that can make a big difference to the answer you give. Without the clustered tables, the answer to the above would have been B.
2. Don’t panic if you read a question and don’t immediately know the answer. It’s often possible to do what I call ‘reverse engineer the answer’! In the example above I arrived at the right answer by eliminating the ones I knew were wrong.
At the end of the exam, you will get the opportunity to go back and either complete unanswered questions, or review the answers you have given.
If you have time (which I’m sure you will as you get ample time to sit the exam) I strongly suggest you do this. It was reviewing the answers that highlighted where I hadn’t read the question properly and was able to change the answer.
Above all, relax and don’t panic!
I found the thought of the exam was actually far more scary than the exam itself.