OCP EXAM AND SQL PLUS

From: bunyamin karadeniz <bunyamink_at_havelsan.com.tr>
Date: Mon, 18 Sep 2000 16:04:43 +0300
Message-Id: <10683.122371@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_0109_01C0218A.283B1CE0 Content-Type: text/plain;

charset="iso-8859-9"
Content-Transfer-Encoding: quoted-printable

DO THEY ASK THE COMMANDS IN SQL PLUS IN THE INTRO TO ORACLE = SQL,PL/SQL EXAM.....????
dO I NEED TO KNOW ALL OF THEM ..???
AND THE FORMATS OF TO_DATE AND TO_CHAR FUNCTIONS ARE VERY CONFUSING ... = DO THEY ASK THEM IN THE EXAM . DO I NEED TO KNOW ALL THE FORMATS??? DO THEY ASK DEFINITIONS ?=20
LIKE WHAT DOES THE 'ACCEPT' COMMAND DO ?

  A ) ................
  B ) ...........

C ) ....=20
D )........
DO THEY ASK WHICH OF THOSE ARE TRUE QUESTIONS?

order by is not allowed in a subquery.
order by must be last in a query. etc..
Bunyamin K. Karadeniz Enformasyon Teknolojileri Dir. Veri Taban=FD Grubu tel : 2873565/1681 HAVELSAN=20

------=_NextPart_000_0109_01C0218A.283B1CE0 Content-Type: text/html;

charset="iso-8859-9"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-9" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2014.210" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#a6caf0>
<DIV><FONT face=3DArial size=3D2>DO THEY ASK THE COMMANDS IN SQL=20
PLUS    IN THE INTRO TO ORACLE SQL,PL/SQL=20 EXAM.....????</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>dO I NEED TO KNOW ALL OF THEM =
..???<BR>AND THE=20
FORMATS OF TO_DATE AND TO_CHAR FUNCTIONS ARE VERY CONFUSING ... DO THEY = ASK THEM=20
IN THE EXAM . DO I NEED TO KNOW ALL THE FORMATS???</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>DO THEY ASK DEFINITIONS ? </FONT></DIV>
<DIV><FONT face=3DArial size=3D2>LIKE WHAT DOES THE 'ACCEPT' =
COMMAND=20
DO ?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>  A ) =

................</FONT></DIV>

<DIV><FONT face=3DArial size=3D2>  B ) =
...........</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>  C ) .... </FONT></DIV>
<DIV><FONT face=3DArial size=3D2>  D )........</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>DO THEY ASK WHICH OF THOSE ARE =
TRUE=20
QUESTIONS?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>  A) </FONT> <FONT =
face=3DArial=20
size=3D2>order by is not allowed in a subquery.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2> B) order by must be last in a=20
query.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>etc..</FONT></DIV>
<DIV><FONT face=3DArial=20

size=3D2>**********************************************<BR>Bunyamin K.=20

Karadeniz<BR>Enformasyon Teknolojileri Dir.<BR>Veri Taban=FD Grubu tel : =

2873565/1681<BR>HAVELSAN=20
<BR>**********************************************</FONT></DIV></BODY></H=
Received on Mon Sep 18 2000 - 08:04:43 CDT