Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> OCP EXAM AND SQL PLUS

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?
  1. order by is not allowed in a subquery.
  2. 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&nbsp;&nbsp;&nbsp; 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>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>DO THEY ASK DEFINITIONS ? </FONT></DIV>
<DIV><FONT face=3DArial size=3D2>LIKE WHAT DOES THE&nbsp;'ACCEPT' =
COMMAND=20
DO&nbsp;?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp; A ) =

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

<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;B ) =
...........</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp; C ) .... </FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp; D )........</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>DO&nbsp;THEY ASK WHICH OF THOSE ARE =
TRUE=20
QUESTIONS?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp; A)&nbsp;</FONT>&nbsp;<FONT =
face=3DArial=20
size=3D2>order by is not allowed in a subquery.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US