Path: news.easynews.com!newsfeed1.easynews.com!newsfeed2.easynews.com!easynews.com!easynews!newsfeed.news2me.com!newshosting.com!news-xfer2.atl.newshosting.com!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!sn-xit-03!sn-xit-04!sn-xit-01!sn-post-02!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: DA Morgan Newsgroups: comp.databases.oracle.server Subject: Re: And the correct answer is? Date: Fri, 04 Apr 2003 12:35:06 -0800 Organization: EXE Message-ID: <3E8DEC7A.F16BF5B1@exxesolutions.com> X-Mailer: Mozilla 4.79 [en] (Windows NT 5.0; U) X-Accept-Language: en MIME-Version: 1.0 References: <3E8E0B9E.B0B9251F@noway.org> <41b04c0d.0304040013.7c3dc427@posting.google.com> <3E8DCB8E.75AD1103@noway.org> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Cache-Post-Path: yasure!unknown@splish28.drizzle.com X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 37 Xref: newsfeed1.easynews.com comp.databases.oracle.server:182053 X-Received-Date: Fri, 04 Apr 2003 13:35:50 MST (news.easynews.com) sfk wrote: > 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 I followed my own advice, built the table, tried it, and know the correct answer. You can spend hours debate this endlessly if you wish but you still won't know for sure. Daniel Morgan