Which statement is true regarding the default behavior of the ORDER BY clause?

Which statement is true regarding the default behavior of the ORDER BY clause?

Which statement is true regarding the default behavior of the ORDER BY clause?

A.
In a character sort, the values are case-sensitive

B.
NULL values are not considered at all by the sort operation

C.
Only those columns that are specified in the SELECT list can be used in the ORDER BY clause

D.
Numeric values are displayed from the maximum to the minimum value if they have decimal
positions

Explanation:
Character Strings and Dates
Character strings and date values are enclosed with single quotation marks.
Character values are case-sensitive and date values are format-sensitive.
The default date display format is DD-MON-RR.



Leave a Reply 4

Your email address will not be published. Required fields are marked *


morgan

morgan

I think “C” is also correct.

JTS

JTS

I agree

Amit

Amit

C is not correct as you can use other colums as well in order by clause which are not part of select clause.

Jenny

Jenny

You’re right.