Re: And the correct answer is?

Would you share.... the correct answer.

DA Morgan wrote:

> 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 - 18:11:01 CST