Exam 1z0-071 topic 1 question 148 discussion

DEF correct, Null is sorted last in ascending and first in descending by default

The three statements that are true about an ORDER BY clause are: D. By default, an ORDER BY clause sorts rows in ascending order. E. An ORDER BY clause can perform a binary sort. F. An ORDER BY clause can perform a linguistic sort. An ORDER BY clause is used to sort the rows returned by a query in a specified order. By default, if no sort order is specified, the rows are sorted in ascending order. An ORDER BY clause can perform different types of sorts, including binary and linguistic sorts. A binary sort sorts the data based on the binary representation of the values being sorted. A linguistic sort sorts the data based on a specific linguistic definition, taking into account language-specific rules for character and string comparison.

Shouldn't it be DEF? A - FALSE; by default sorting is ASC B - FALSE; In both syntax and execution ORDER BY is always after HAVING C - FALSE; NULLS FIRST can be used to sort NULL values first D - TRUE; E, F - TRUE; parameter NLS_SORT can be changed between BINARY and linguistic_definition. https://docs.oracle.com/database/121/REFRN/GUID-04243CDA-43CA-4AF8-B59D-6FB841B307BE.htm#REFRN10127