Oracle Advanced PL/SQL Developer Certified Professional 1z0-146
I took Oracle beta 1z1-146 exam in the end of January, 2009. Several days ago I checked prometric.com and discovered that this exam was passed. Now I’m one of the first Oracle Advanced PL/SQL Developer Certified Professional all over the world!!! it’s my second OCP :)
I did not find any dumps, any mock exams or any sample questions, while I was preparing for this exam. I used only these http://rapidshare.com/files/127182353/D52601GC10_netbks.com.rar official Oracle preparation slides (remember to switch comments – it’s a book). 1z1-146 exam was really tough. 165 questions in 180 minutes. Production exam requirements: time – 90 min, questions – 68. There is a difference, is not it?
If you are going to take one of Oracle beta exams and you have time and ability to stay calm, you are not interested to economize some money I suggest waiting for a production one. Pluses: 1) You will probably get results two weeks earlier then beta-takers 2) More time, less questions 3) It’s not so stressful 4) The probability to pass is much higher.
Do you agree? What is your experience in taking certification exams? :)
–
If you enjoy reading this article please leave your thoughts in the comment area. Moreover you may subscribe to this blog’s RSS feed. This article is probably not the last one. I suggest to glance over the advertisements at the bottom of the page.
Hi All,
I have cleared OCA few months back and now planning for OCP. Can anyone please forward me useful dumps for exam code 1z0.146 at the below id.
sohini_kolkata_2006@yahoo.co.in
Thanks in advance
[Reply]
Sohini
29 Aug 10 at 7:23 am
Hi
I am planning to take 1z0-146 exam in the next week
could you please send me the 1z0-146 dumps
to mail id —- shreenivas_g_us@yahoo.com
thanks
shreenivas
[Reply]
shreenivas
17 Jun 10 at 4:41 am
Hi,
I want to appear for PL/SQL Exam in next few weeks. Could you send me document/eBook on parry0843@yahoo.com?
Thanks,
Parag
[Reply]
Parry
4 May 10 at 2:47 pm
Hi Friends,
I would like to write Oracle 11g Advanced PL/SQL
1Z0-146. Could you help me finding e-books/tutorial.
Please help me in this.
My email id is : santu_439@yahoo.co.in
[Reply]
santhosh
26 Feb 10 at 12:07 am
Hey i got the full version of 1z0-146 dumps for free download
http://dumpsquestions.com/dumps/1Z0-146.html
.doc version Enjoy !
[Reply]
1Z0-146 Dumps
4 Jan 10 at 4:20 pm
Please give exam tips, topicwise !
[Reply]
sunil
15 Dec 09 at 6:27 am
Hi everybody
I am planing to take the 1z0-146. Could anyone send me the links to get Material or suggest some books.
mail: fennane@gmail.com
Thanks
[Reply]
Nabil
30 Oct 09 at 11:56 am
Hi, can someone please help me with the study material for this exam.
I tried the link posted but it seems like it doesnt exist on rapidsher. My email address is vnigala@gmail.com
Thanks in adavance
[Reply]
Sam
16 Oct 09 at 4:20 pm
First Congs to all who have cleared OCP 11g.
I am also planning for this certification.If any one is having any valuable suggestion or study material or any useful links please do help me with that.
My email is is chetansoni79@redifmail.com.
Thanks in Advance.
ReEgards
[Reply]
Chetan
9 Oct 09 at 6:42 am
Hi,
I am an Oracle 9i Certified Associate. I just wanted to know that If I pass 1z0-146 exam will I become OCP 11g or I have to pass 1zo-051 and 1z1-144 also to qualify for OCP 11g Advance Pl/sql Developer????
Thanks in advance!!!
Reagrds
Saurabh
[Reply]
Saurabh
2 Oct 09 at 11:27 am
Hi,
Can anyone of you please send me the study material to rsuravarapu@gmail.com. Looks like rapidshare have removed the content. :(
I’m planning to take the exam next month.
Much Appreciated.
[Reply]
RAKESH
25 Sep 09 at 3:49 pm
Hi,
Congrats on clearing the exam.
Can you please send me the file received from rapid share to logicz69@gmail.com. Looks like rapidshare have removed the content. :(
Thanks in Advance.
[Reply]
Kavitha
23 Sep 09 at 2:59 am
Hi
I am planing to take ocp 1z0-146 exam could anyone please send the links to get good material or suggest good books and how the exam questions will be.
mailid:mmraju.r@gmail.com
Thanks
[Reply]
raj
1 Sep 09 at 11:19 am
Hi, Roman!
I’ve successfuly passed this exam last week. The exam wasn’t too difficult, although I’ve spent all the time for questions and had an only second left for review. So, no review, as a result, ;-) and 87% grade.
Using the materials on the link provided above has helped greatly! That is for sure, thanks for the blog, URL link and an email response for the question types!!!
I’ve also used the equivalent materials from the course 10g: Advanced PL/SQL and OTN materials, in major. Those Articles by Sushma Jagannath on 11g contain some sample questions, so that was also taken for preparation. Most of the questions had a prompt to chose 2 aswers of 4-5, the rest contained “choose all that apply”, 1 or 3, etc.
Tha “accurate knowledge”, as you’ve said, was really in a need! I hate those questions about DBMS_ASSERT!
As for you question for our experience, I’ve successfuly passed the following exams in the direct order: 1Z0-007, 1Z0-147, 1Z0-047, 1Z0-146.
So I’m one of those OCEs and new PL/SQL OCPs now!
Thanks a lot and good luck!
Also good luck for everyone who is reading this now!
[Reply]
Abhishek Reply:
August 31st, 2009 at 2:52 pm
@Ilia Gitsailo, Hi, Congratulations on passing the exam. I am also planning to appear for this exam. Can you send me the study material with dumps(if any) for this exam? It would be very helpful for me. My email id is engabhishek@gmail.com
Thanks a lot in advance.
[Reply]
Ilia Gitsailo Reply:
September 9th, 2009 at 10:41 am
@Abhishek,
Hi! Actually I didn’t find any dumps for this exam. I only used the materials, linked above and some articles from OTN, that happily contained some sample questions (please, see my initial response above).
Good luck passing this exam!
[Reply]
raj Reply:
September 1st, 2009 at 11:21 am
Could you please send the material for ocp 1zo-146 or suggest how you face the exam.
mailid:mmraju.r@gmail.com
[Reply]
Ilia Gitsailo Reply:
September 9th, 2009 at 10:57 am
@raj,
Hi! As for study materials, please, see my responses above.
Some words how you should face the exam: prepare carefully and pay attention to details (as rdrapeko says). I have spent a lot of preparation time for various subrogram compilation options (PLSCOPE_SETTINGS, PLSQL_OPTIMIZE_LEVEL, PLSQL_WARNINGS, etc.), code analysis and SQL-injections – and that was not a waste time. Do not ignore your own or company’s 11g RDBMS installation and experience with it. Anyway, it is more interesting, than 10g, for sure! ;-) Also read as many articles on either 10g or 11g performance, as you can find (OTN will help).
The exam is interesting in sense there are no or very few dummy answers, so no much deduction is available. The topic for external C procedures (is what I was afraid most of all, as I didn’t manage to configure my home listener by then and test it a lot enough to prepare) had very few questions. Be cautious, passing this exam. A lot of questions require the sample code review in 2 child windows. Those windows sizing also takes the time, by the way.
Good luck! and wait your comments after passing
[Reply]
nimesh Reply:
December 14th, 2009 at 7:23 am
@Ilia Gitsailo, Hi All,
Can someone please send me the study material and dumps for Oracle 11g Advanced PL/SQL (1z0-146)?
Thanks,
Nimesh
[Reply]
ram Reply:
December 15th, 2009 at 6:29 am
@Ilia Gitsailo,
Whats the weightage of each topic
[Reply]
Ilia Gitsailo
10 Aug 09 at 11:31 am
Hi,
first of all congratulations for clearing this certification.
i have finished the preperation but would like to go through some sample/actual test papers before going for the exam. Can you help me on this
Regards
ashish gogia
[Reply]
ashish gogia
22 Jul 09 at 5:03 am
Is this enuf to take and pass 146?
[Reply]
Eshwar
18 Jul 09 at 12:08 pm
165 questions in 180 minutes. Production exam requirements: time – 90 min, questions – 68. There is a difference, is not it?
—
It is not :)
90*2 – 136 question
165-136 = 29 question
so only 14 questions more (1/5 of all for production exam).
You exaggerate a little :)
[Reply]
rdrapeko Reply:
June 16th, 2009 at 2:43 pm
@Lechu Wałęsa,
ok :)
First of all why are you dividing into two? :) 29 is two hours difference.. 14 – is one hour difference. Is this difference not big enough for only one hour? :) you have only 45 questions for one hour in production exam. So it’s 1/3 of a production exam. You have 80 seconds for a question in production and 65 seconds for a question in test.
Secondly, lets say that we have a third type of the exam: 40 questions in one hour. The duration of exam is 8 hours.. You have to solve 320 questions in 8 hours. I can affirm that this type of exam is much easier than a production one regarding to your logics. Is it so? What will you choose if you have to choose? :)
[Reply]
Lechu Wałęsa Reply:
June 17th, 2009 at 6:57 pm
@rdrapeko,
:)
not exactly what i meant
once again then:
“165 questions in 180 minutes. Production exam requirements: time – 90 min, questions – 68. There is a difference, is not it?”
it makes:
beta exam – 180 minutes (3 hours)
production exam – 90 minutes (1.5 h. – twice less)
beta exam – 165 questions
production exam – 68 questions
and now (OK, i know that 3 hours exam is not the same as 1,5 hours exam :)), but:
(1/2)*beta exam time = 90 minutes = production exam
(1/2)*beta exam number of questions = 82.5
production exam number of questions = 68
82-68 = 14 (within 90 minutes)
14/68 ~ 0.2 = 1/5
so you had only 14 questions more during 90 minutes.
You also wrote “I spend only 10-15 second for each of the last 15 questions”.
So I’d like to say that you spent almost the same time (and if we take into account your last sentence – the numbers of questions are comparable) as others have to. Of course it’s only rough comparison (you had 2 productive exams in a row). So generally I don’t agree that production exam is easier as the one you passed. You had twice more questions, twice more chances ;) – on the other hand, you was twice more tired, you had twice more chances to make a mistake.
OK, now the conclusion – I think that your exam was tough as the production exam is. I appreciate your achievement, but I don’t agree that your exam was tougher ;) I think that you exaggerate in that point ;) I don’t like to offend you nor belittle your achievements. You are very good, but, in my opinion, you can discourage people from takeing the beta exam if you write that beta exam is more tough than it really is (in my opinion it is not). Thanks for attention. And congratulations once again :)
[Reply]
rdrapeko Reply:
June 17th, 2009 at 7:43 pm
sorry, i did some mistakes in my calculations :) but, it does not matter :)
the facts are:
1) 65 seconds for one question in beta exam and 80 seconds for one question in production ===> you have 23% more time for one question in production exam
2) the second reason is the whole time.. it’s 100% longer, and 143% more questions
but i do not want to dispute :) if you take beta exam in the future please share you opinion.. it will be quite interesting :) i also passed SCJP for 1.6 platform exam last year and it was really tougher (but i had been preparing only for one week) than all oracle exams (i also have administrator ocp and sql expert certificates), but this beta exam (i had been preparing for 1.5 month) was really tougher than scjp. :) buuut… it’s my story
[Reply]
Lechu Wałęsa Reply:
June 17th, 2009 at 8:42 pm
respect :)
[Reply]
Lechu Wałęsa
16 Jun 09 at 12:24 pm
Hi, Could you tell me how to check your result on prometric.com
[Reply]
rdrapeko Reply:
June 13th, 2009 at 7:43 pm
@Pankaj,
1. go to http://prometric.com
2. choose Oracle under Information technology (in fact there is no difference what you choose if i’m not mistaken)
3. click ’start’ in ‘get started’ block of new window
4. go to candidate history
5. login and see table of results
[Reply]
Pankaj
13 Jun 09 at 2:10 pm
Hi,
I took the same exam at the end of january too :)
I checked at register.prometric.com and see status “passed” too. May be you are the first and i may be the second :)
I have not received any result papers or certificates yet. Did you receive results via mail?
[Reply]
rdrapeko Reply:
June 11th, 2009 at 9:25 am
@axxo,
Heh :) Congratulations.. nope, i have not received yet..
[Reply]
axxo
11 Jun 09 at 6:51 am
Great post! Thanks a lot, I’ve been looking for this info for quite a while now :)
[Reply]
rdrapeko Reply:
June 13th, 2009 at 7:44 pm
@deemashlayer,
thanks for response :)
[Reply]
deemashlayer
4 Jun 09 at 10:36 am
Congrats ..
I was searching the for some input for new OCP exam 1Z0-146 .. and there is nothing useful in the internet … until I hit your page. It is a great help for my test preparation.
Thanks again.. And I suggest u change the title to include ‘1Z0-146′ You will get more hits in your page.
-Deb
[Reply]
rdrapeko Reply:
May 14th, 2009 at 10:18 pm
Thanks for response. I have to say that I found this link and unfortunately I don’t remember what was the address of that blog. So the real hero is not me! It happens quite often in this world :(
[Reply]
Deb
14 May 09 at 9:54 pm
Hi,
Congrats !!! Even I’m planning to take up this exam. As I’m unable to open the given link, can you pls mail the book/pdf to ng_padma@yahoo.com
Also can you pls tell me about other study materials/books available.
Thanks !
[Reply]
rdrapeko Reply:
May 12th, 2009 at 4:07 pm
Hi, thanks. Unfortunately I don’t have a possibility to send it to everyone directly. Check this link http://www.sendspace.com/file/9gg9a8. I hope it will help you.
[Reply]
Anonymous
12 May 09 at 7:05 am
Hi,
Congratulations. Could you tell me how many % of the questions was really tough? As still no sample questions are not available in the market, can you share some of the questions which you faced.
Congrats again.
Thanks.
[Reply]
rdrapeko Reply:
May 11th, 2009 at 8:15 pm
hi,
there were no questions tougher than your question is. ;) Most of the questions (95%) required only accurate knowledge. If you know, you mark the right answer. If you don’t, you guess – your logical thinking won’t help you very much. I can not say that this exam was really tough – no.. just learn these slides/comments and you will succeed. When you read, pay attention to the details. If you took SCJP exam, you would probably understand me. For example, if you read about collections just think and test what will be if you don’t initialize it, if you pass invalid parameters etc. I had the biggest problem with the time. I spend only 10-15 second for each of the last 15 questions. But fortunately, you will take a production exam. Look through these slides minutely and you will pass without any problems! Thanks for congratulations and good luck!
[Reply]
Shantu Reply:
July 8th, 2009 at 7:49 am
Hi
Could you please provide me study material and exam papers for clearing 1z0-146 exam. I have serached almost all the torrents but could not find anything useful.
Thanks.
[Reply]
Dibyendu Chakraborty
11 May 09 at 9:19 am
Hi, nice post. I have been thinking about this topic,so thanks for writing. I will certainly be subscribing to your blog.
[Reply]
brussl
4 May 09 at 10:07 am