Home » Other » Training & Certification » OCA 1Z0-007 Exam has ANSI Std SQL's?
OCA 1Z0-007 Exam has ANSI Std SQL's? [message #143276] Wed, 19 October 2005 13:57 Go to next message
srokkam
Messages: 2
Registered: October 2005
Junior Member
Hi,

I'm preparing OCA Certification - 1Z0-007 exam.
In most of the sample questions, I see that the SQL used is in ANSI standard for query joins. Is it going to be the same way in real exam? or we will get the ORACLE join syntax?.

As I'm totally used to ORACLE join syntax, ANSI standard will be little bit confusing to me and may lead to incorrect answers.

Could you please advice.

Thanks,
Suresh

Report message to a moderator

Re: OCA 1Z0-007 Exam has ANSI Std SQL's? [message #143750 is a reply to message #143276] Fri, 21 October 2005 18:16 Go to previous messageGo to next message
DRasa
Messages: 3
Registered: February 2005
Junior Member
Hi,

Oracle recommends to use the ANSI syntax for joins, as outer join queries with Oracle join operator (+) are subject to the number of rules and restrictions. During the exam you will get some questions, which will check your ability to use ANSI syntax for joins. So my advice would be to learn this syntax. Cool

Regards,
Rasa

Report message to a moderator

icon9.gif  Re: OCA 1Z0-007 Exam has ANSI Std SQL's? [message #144056 is a reply to message #143750] Mon, 24 October 2005 18:00 Go to previous message
srokkam
Messages: 2
Registered: October 2005
Junior Member
Thanks for the advice. I have to start learning ANSI stds now.

Rgds,
Suresh

Report message to a moderator

Previous Topic: OCP study groups (merged)
Next Topic: oracle certification
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 05:25:08 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.