Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!news-feed01.roc.ny.frontiernet.net!logbridge.uoregon.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: geert.pille@vandemoortele.com (Gerard H. Pille)
Newsgroups: comp.databases.oracle.server
Subject: Re: And the correct answer is?
Date: 4 Apr 2003 00:13:46 -0800
Organization: http://groups.google.com/
Lines: 23
Message-ID: <41b04c0d.0304040013.7c3dc427@posting.google.com>
References: <3E8E0B9E.B0B9251F@noway.org>
NNTP-Posting-Host: 212.190.80.221
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1049444026 24641 127.0.0.1 (4 Apr 2003 08:13:46 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 4 Apr 2003 08:13:46 GMT
Xref: newsfeed1.easynews.com comp.databases.oracle.server:181953
X-Received-Date: Fri, 04 Apr 2003 01:13:28 MST (news.easynews.com)

sfk <nospan@noway.org> wrote in message news:<3E8E0B9E.B0B9251F@noway.org>...
> The following is from a text..... I would like some opinions .... what
> is the correct answer.
> 
> EMP Table is defined as follows:
> EMPNO            NUMBER            4
> ENAME            VARCHAR2        30
> SALARY           NUMBER            14,2
> COMM             NUMBER            10,2
> DEPTNO            NUMBER            2
> 
> You perform the following tow queries:
> 
> 1. SELECT empno enumber, ename FROM emp ORDER BY 1;
> 2. SELECT empno, ename FROM emp ORDER BY ASC;
> 
> Which of the following is true?
> A. Statements 1 and 2 will produce the same result.
> B. Statement 1 will execute; statement 2 will return an error.
> C. Statement 2 will execute; statement 1 will return an error.
> D. Statement 1 and 2 will execute but produce different results.

I vote for B