Home » Other » Training & Certification » Oracle Certification (Oracle 11g)
Oracle Certification [message #617622] Wed, 02 July 2014 05:17 Go to next message
VladGab
Messages: 11
Registered: March 2014
Junior Member
Good day!!
Next week I'll give exam Oracle database SQL Expert(1Z0-047). Had anyone passed this exam? And I would to know your opinion about this exam.
Thanks..
Re: Oracle Certification [message #617625 is a reply to message #617622] Wed, 02 July 2014 05:48 Go to previous messageGo to next message
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
Get really good at subquery correlation.
Re: Oracle Certification [message #617635 is a reply to message #617625] Wed, 02 July 2014 07:11 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
Have good hold on GROUPING functions, hierarchical queries and Regular expression functions.
Re: Oracle Certification [message #617643 is a reply to message #617622] Wed, 02 July 2014 08:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

And carefully read the questions, more carefully than you read each our forum purposes and post in the wrong one. Razz

Re: Oracle Certification [message #617657 is a reply to message #617643] Wed, 02 July 2014 09:53 Go to previous messageGo to next message
VladGab
Messages: 11
Registered: March 2014
Junior Member
Thanks guys!!! Special thanks to Michel Cadot I think it is the best advice Smile)))))
Re: Oracle Certification [message #617715 is a reply to message #617643] Wed, 02 July 2014 22:36 Go to previous messageGo to next message
matthewmorris68
Messages: 258
Registered: May 2012
Location: Orlando, FL
Senior Member

Quote:
And carefully read the question...


With 047, you need to emphasize carefully reading the answers as well...

I remember some where the answers were extremely similar and more than one was a 'correct' answer (where 'correct' is defined as a query that would return valid data). However one answer was a hair better than the others based on specifically what was requested.
Re: Oracle Certification [message #617977 is a reply to message #617715] Sun, 06 July 2014 03:14 Go to previous messageGo to next message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
You should be confident in all of the listed topics, but beyond that the exam is a test of time management. You will probably start too slowly by reading and re-reading questions and spending too much time on questions to which you do not know the answer. Set yourself a target for half-time (1 hour). I suggest half way though is a good goal (35 questions). If you don't meet that target then you need a new strategy, because the last thing you want is to leave questions unread - they might have been easy ones.

If you are in timing trouble (eg. Q30 after 1 hour), I suggest the following strategy.
- If a question seems fairly straightforward, it probably is. Answer it and move on immediately.
- If a question is VERY long, read the first line and the 5-6 responses, provide an educated guess without reading the entire question and move on. This will be hard to do, but you are already in time trouble and reading and understanding this question in full may cost you three questions at the end.
- If you get a tricky one (select ALL correct responses) on a subject that you are not expert in, guess it, tag it, and move on. If you get time then come back, but don't waste time on a question you will probably get wrong anyway.

Having said that that, there is enough time allocated to carefully read every question and response and to provide your answer(s) with a very small amount of time for thinking. If you have been staring at a question for 30 seconds or are re-reading it for the third time then it is time to move on. You don't need to get EVERY question right, so be prepared walk on by questions that are too hard.

Ross Leishman
Re: Oracle Certification [message #618151 is a reply to message #617622] Tue, 08 July 2014 09:50 Go to previous messageGo to next message
VladGab
Messages: 11
Registered: March 2014
Junior Member
Thanks you all!!! I passed the exam and scored 80%. The main difficulty was multiple answer questions, when asked choose all that apply or choose three!!
Re: Oracle Certification [message #618153 is a reply to message #618151] Tue, 08 July 2014 10:01 Go to previous message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
Congrats mate! Keep learning and sharing Smile
Previous Topic: dba online training and placement
Next Topic: Database Administrator Online Training
Goto Forum:
  


Current Time: Thu Mar 28 05:51:01 CDT 2024