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

Home -> Community -> Usenet -> c.d.o.server -> Re: And the correct answer is?

Re: And the correct answer is?

From: DA Morgan <damorgan_at_exxesolutions.com>
Date: Fri, 04 Apr 2003 12:35:06 -0800
Message-ID: <3E8DEC7A.F16BF5B1@exxesolutions.com>


sfk wrote:

> The author states A as the correct answer. I choose D.
>
> "Gerard H. Pille" wrote:
>
> > sfk <nospan_at_noway.org> wrote in message news:<3E8E0B9E.B0B9251F_at_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 Received on Fri Apr 04 2003 - 14:35:06 CST

Original text of this message

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