QUESTION: 06

On 20 de July de 2007, in 1Z0-001, OCA (PL/SQL Developer), ORACLE, by Fabiano Anjos

Which statement about SQL is true?

A: Null values are displayed last in the ascending sequences.
B: Data values are displayed in descending order by default.
C: You cannot specify a column alias in an ORDER BY clause.
D: You cannot sort query results by a column that is not included in the SELECT list.
E: The results are sorted by the first column in the SELECT list, if the ORDER BY clause is not provided.

ANSWER: A

EXPLANATION: Answer A is correct because of null values are displayed last in the ascending sequences.

INCORRECT ANSWERS:

B: Data values are displayed in ASCENDING order by default.
C: It is possible to specify a column alias in an ORDER BY clause (but not in a GROUP BY clause).
D: You can sort query results by a column that is not included in the SELECT list.
E: The results will not be sorted at all, if the ORDER BY clause was not used in query.

 

Comments are closed.