OraFAQ Forum: Training & Certification » Cheat Sheet Oracle Commands for OCA 11g exam

Home » Other » Training & Certification » Cheat Sheet Oracle Commands for OCA 11g exam

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Cheat Sheet Oracle Commands for OCA 11g exam [message #578698]

Mon, 04 March 2013 05:08

oranooob
Messages: 84
Registered: May 2009

Member

Hi

is there a Cheat Sheet for Oracle Commands? I need that for my OCA exams.
I found only http://ss64.com/ora/ - but there a lot commands missing (for example MERGE).

Report message to a moderator

Re: Cheat Sheet Oracle Commands for OCA 11g exam [message #578702 is a reply to message #578698]

Mon, 04 March 2013 05:25

Littlefoot
Messages: 16993
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

You must be kidding. In this joke, both subject and object is the same person - you. Who do you mean to fool? Oracle? Nope, yourself.

Report message to a moderator

Re: Cheat Sheet Oracle Commands for OCA 11g exam [message #578712 is a reply to message #578702]

Mon, 04 March 2013 06:15

oranooob
Messages: 84
Registered: May 2009

Member

Littlefoot wrote on Mon, 04 March 2013 05:25

You must be kidding. In this joke, both subject and object is the same person - you. Who do you mean to fool? Oracle? Nope, yourself.

English not my native language. Sorry. I won't use the cheat sheet during exam. I will use it during preparation. I need all commands for OCA in a summary.

Report message to a moderator

Re: Cheat Sheet Oracle Commands for OCA 11g exam [message #578713 is a reply to message #578712]

Mon, 04 March 2013 06:35

Littlefoot
Messages: 16993
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Here you go, SQL Language Reference. All commands are in there.

Report message to a moderator

Re: Cheat Sheet Oracle Commands for OCA 11g exam [message #578855 is a reply to message #578713]

Tue, 05 March 2013 21:05

matthewmorris68
Messages: 129
Registered: May 2012
Location: Orlando, FL

Senior Member

Since he's apparently looking for a small reference, the SQL Language Quick Reference might be a better option:

http://docs.oracle.com/cd/E11882_01/server.112/e17119.pdf

Report message to a moderator

Re: Cheat Sheet Oracle Commands for OCA 11g exam [message #578899 is a reply to message #578698]

Wed, 06 March 2013 03:30

oranooob
Messages: 84
Registered: May 2009

Member

Thank you dudes for SQL Language Quick Reference and SQL Language Reference.

But need only OCA 11g scope, because most commands I don't know so far.

Report message to a moderator

Re: Cheat Sheet Oracle Commands for OCA 11g exam [message #578944 is a reply to message #578899]

Wed, 06 March 2013 09:17

matthewmorris68
Messages: 129
Registered: May 2012
Location: Orlando, FL

Senior Member

>But need only OCA 11g scope, because most commands I don't know so far.

I don't understand the restriction. All of the commands in either of the SQL References provided are 'in the 11G scope' in terms of being valid 11G commands. Possibly you mean only the ones that will be on the SQL Fundamentals exam 1Z0-051. If so -- there's not a definitive list saying these commands will be on the test but those commands will not be. You mentioned MERGE, but IIRC, that is a topic on 1Z0-047, which is a dead giveaway that it won't be on 1Z0-051. That said, you may be talking about 1Z0-047, but if so I don't know why you referenced 11G because that exam was developed under 10G (although it has since been validated against 11.2).

In short, I can't really be more specific without knowing what you are really looking for.

Report message to a moderator

Previous Topic:	realtime projects
Next Topic:	PeopleSoft HCM Certified Consultant Study guide

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 23 22:00:41 CDT 2013

Total time taken to generate the page: 0.11495 seconds