Hi, i first thank for the reply.... Im preparing with Jason Price and Steven O hein for theory and understanding... But i need some good practise material so that i can face the heat of this exam... many say test engines... can u or any one share an open source free test engines.... if u or anyone cleared this exam please let us know what preparation material u followed ..... pleaseWhether you intend it or not you are going to end up with a braindump or material in breach of copyright: https://blogs.oracle.com/certification/entry/0477
many say test engines... can u or any one share an open source free test enginesWhoever the many is weren't talking about free test engines. The Self Test Software and Transcender practice tests are both excellent. The vast majority of other stuff out there is trash. As bigdelboy indicated, most of it isn't just trash but brain dump material as well, so trash and illicit material that will put your certification in jeopardy. I write study guides and run across a lot of this type material while I am researching for them. I've seen a lot of examples of the 'Pass for Sure' type material while doing so. They contain questions and answers for material that isn't even on the exam as well as incorrect answers.
Without brain dumps almost impossible to achieve.This can be taken as a 'Use brain dumps if you want to pass the test'. I assume (and hope) that you didn't mean it that way, but it's not really a good thing to imply in any fashion that using them is a good idea.
Philippe Ludwig wrote:I too was horrified by this statement. And I concur fully with Matthew's comments. Difficult yes ... impossible for most good oracle SQL practioners ... certainly not ... that would be a grave insult to them. A guide is almost essential as sometimes it is not obvious from the topics the scope that one should be revising. As it happens I used O'Hearn's book .... and put in some sweat ... ( take me as starting from reaonsably practiced in SQL for many years ... but perhaps a rusty and not too practiced in the more recent ANSI standards ) ... and I wouldn't have had the time to attempt it without a guide to refer back to originating documentation. But for most able SQL people with some interest in the art of SQL it is a challenging journey that can be accomplished. However if one is not really able at SQL then the exam probably shouldn't be attempted. That said; there is almost certainly a proportion of able SQL people who simply woul not cope with the exam format. And I found time pressure ... passed 50% time with less than 50% questions answered. And I had to remember from my distant past to answer one question. And on another I remembered that looking at a question 5 questions before would resolve my doubt on whih of 2 options were correct. And it has been useful .... I now use an SQL statement at times where previously I would have immediately gone PL/SQL. AndI particularly remember udsing one topic on pigs ears to vastly improve performance of a statement ... and that was really important and I might not have realised it if I didn't study the exam (some might argue one could get as much beenfit by following Ask Tom or similar ... and I might not disagree at times).
... Without brain dumps almost impossible to achieve. ...
is der not a way to prepare for this xam... cant u suggest me a way to do so.....Understand that this exam is intended to be passed by individuals who are expert in SQL. Presumably they became expeert in SQL by using it daily for many years. I have been using SQL almost daily for the past fifteen years and I still needed to do some exam preparation for areas that were covered by the test but which I don't tend to use. If you do not have this kind of experience but still want to pass the test, you must study much harder and longer and practice SQL on your own as well.
how will i know having works well before group by... only by solving them ... but wer is d source?Well for one, the Oracle SQL reference specifically indicates this is the case: