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 -> And the correct answer is?

And the correct answer is?

From: sfk <nospan_at_noway.org>
Date: Thu, 03 Apr 2003 22:50:51 GMT
Message-ID: <3E8E0B9E.B0B9251F@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.
Received on Thu Apr 03 2003 - 16:50:51 CST

Original text of this message

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