Re: And the correct answer is?

Would you check your typing.

The second query ought to return error

    ORA-00936 - Missing expression
as there is legal expression between the ORDER BY and the ASC.

As it stands, B seems to be the correct answer.

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html

____UK_______April 8th
____UK_______April 22nd
____Denmark__May 21-23rd
____USA_(FL)_May 2nd

Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
____UK_(Manchester)_May
____Estonia___June (provisional)
____USA_(CA, TX)_August

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


"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.

>

>

>