The NLS_SORT parameter sets the default sort method for which of the following
operations? (Choose all that apply.)
A.
WHERE clause
B.
ORDER BY clause
C.
BETWEEN clause
D.
NLSSORT function
E.
NLS_SORT function
which of the following operations?
The NLS_SORT parameter sets the default sort method for which of the following
operations? (Choose all that apply.)
B and D are correct:
https://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams155.htm#REFRN10127
B: NLS_SORT specifies the collating sequence for character value comparison in various SQL operators and clauses, for example, ORDER BY, GROUP BY, comparison conditions (=, , =), IN, BETWEEN, LIKE, MIN/MAX, GREATEST/LEAST, and INSTR.
D: The value of NLS_SORT affects execution plans of queries. Because a standard index cannot be used as a source of values sorted in a linguistic order, an explicit sort operation must usually be performed instead of an index range scan. A functional index on the NLSSORT function may be defined to provide values sorted in a linguistic order and reintroduce the index range scan to the execution plan.
In the link above it says:
NLS_SORT specifies the collating sequence for character value comparison in various SQL operators and clauses, for example, ORDER BY, GROUP BY, comparison conditions (=, , =), IN, BETWEEN, LIKE, MIN/MAX, GREATEST/LEAST, and INSTR.
So ABCD are correct.