Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!border3.nntp.aus1.giganews.com!nntp.giganews.com!wn12feed!worldnet.att.net!bgtnsc05-news.ops.worldnet.att.net.POSTED!not-for-mail Message-ID: <3E8DCB8E.75AD1103@noway.org> From: sfk X-Mailer: Mozilla 4.79 [en] (WinNT; U) X-Accept-Language: en MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server Subject: Re: And the correct answer is? References: <3E8E0B9E.B0B9251F@noway.org> <41b04c0d.0304040013.7c3dc427@posting.google.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 29 Date: Fri, 04 Apr 2003 18:16:43 GMT NNTP-Posting-Host: 12.84.206.142 X-Complaints-To: abuse@worldnet.att.net X-Trace: bgtnsc05-news.ops.worldnet.att.net 1049480203 12.84.206.142 (Fri, 04 Apr 2003 18:16:43 GMT) NNTP-Posting-Date: Fri, 04 Apr 2003 18:16:43 GMT Organization: AT&T Worldnet Xref: newsfeed1.easynews.com comp.databases.oracle.server:182034 X-Received-Date: Fri, 04 Apr 2003 11:16:24 MST (news.easynews.com) The author states A as the correct answer. I choose D. "Gerard H. Pille" wrote: > sfk 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