Re: And the correct answer is?

Connor McDonald wrote:

> sfk wrote:
> >
> > 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.
>
> Hmmmmmmmmmmmm...lets see
>
> what's an 'enumber' ? what's an 'asc' ?
> With the two above questions, does not seem you are capable of bright
> ideas.

>
> Hey, here's a bright idea - you could
>
> a) run @?/rdbms/admin/utlsampl.sql to create the SCOTT schema
> b) run the two statements
> c) see what happens

d) know what happens!
If you don't want to participate, why don't you just move along and leave you witty and 'bright ideas' somewhere else!

>
>
> cheers
> connor
> --
> =========================
> Connor McDonald
> http://www.oracledba.co.uk
>
> "Some days you're the pigeon, some days you're the statue"
Received on Fri Apr 04 2003 - 12:13:52 CST