Friday, 18 April 2014

How to pass 1z0-047 sql expert exam

Bismillahir Rahmanir Raheem.

First of all, this exam title attracts many guys looking for some certificate.
Because the title specifies you as SQL expert guy.

To pass this exam you have to score atleast 66% out of 70 questions which means about 47 correct answers. 

After doing my Java Programmer certificate  I wanted to have this title.
So I purchased Steve O' Hearn book , which is very good one.

I already had some knowledge of SQL , but not much only about create,insert,update,delete and that also , not in depth knowledge.

It was not only the certificate , I also wanted to study sql in detail.

 What I used as Study Material

I prepared from Steve O'Hearn SQL expert exam book , this book does not contain everything.
Some of the topic is not there in this book but this is not much of issue , you can read it somewhere else
Its really not an issue.
I also used Jason Price 11g Database administrator book
and Roopesh Ramklass ,John Watson 11g SQL Fundamentals book 
And I spent time searching on internet also , when I was not sure about some topics.
What is not there in Steve`s Book
View with grant option , read only option is not in this book
Alternative quote operator is not in this book
Single and Double Ampersand Substitution operator are not there in this book.
Although Updateable view is there in the book but you might not understand it .
And It might be possible that you don`t understand what you read from the book
topics like hierarchical retrieval It took me quite a time to understand how it works and prior keyword

Which topics took long time for me to understand
Various Timezone functions
Hierarchical retrieval , Reporting Aggregated data using Group Functions
Flashback Feature

Yes ! You can pass this exam 
Yes you can pass this exam. Yes exam is tough ,but you can still pass this exam.
All you have to do is to study hard ,  practice .

---------------Please Don`t Take this exam Lightly------------
If you take it , there is good amount of probability that you will fail  this exam

How much Time it will  take
I started one year before ,but not able to study regularly.
In between studied the book and left studied and left studied and left.
But then eventually I made My mind no matter what I am going to take this test in first week of April
I read some other guys stories , they only prepared for 1 months or even a weak or two.
And wrote the paper and passed it.

Don`t Hurry
Yes Don`t hurry.
It might happen that you get frustrated by keep studying books .
And not able to feel that confidance to pass the exam.
Don`t hurry by taking chance , hoping that you will pass this exam.
If you have good knowledge and lacking in some topics then you can still hope , but by not preparing for it and then hoping that you will pass this exam .I don`t think so thats going to happen
Take your time

About Real  Exam 
Two hours will be enough to answer every question
I was able to answer all question and review some questions .
But some questions were very ambiguous and that took some of my exam time.
In some questions not a single options seems to  be correct but then question asks you to select two correct answer , it was very scary.
So except ambiguous questions on exam and aim for scoring 100%.
When I left the exam center I felt and thought I failed this exam.
As I was not sure of many of my answers.
But with the grace of Allah I was able to pass.
I nearly passed this exam with 69% and I was aiming for 100%.

Good luck for your preparations , Believe in yourself and Go for it.

Sunday, 6 April 2014

My OCAJP6 Java Certificate

Bismillahir Rahmanir Raheem.

Thanks To Almighty  Allah that I passed this exam.

I remember those days for preparing for this exam.

My SQL Expert Certificate

Bismillahir Rahmanir Raheem.

Thanks to All mighty dear Allah that I passed this exam.

I will  soon write a blog for the preparation of this exam.