Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: And the correct answer is?
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