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.)
Why not ‘ORDER BY’…?
http://docs.oracle.com/cd/B28359_01/server.111/b28298/ch5lingsort.htm#CIHJBFAD
I found some explanation:
The NLS_SORT parameter defines the default sort method (binary or linguistic)
for both SQL WHERE clause operations and NLSSORT function operations. The default
sort method for ORDER_BY and BETWEEN (and all other SQL operations that support
linguistic sorts) is defined by the NLS_COMP parameter. NLS_SORT is an invalid
function name.
http://oracle-study-notes.blogspot.nl/2007/09/ocp-oracle-10g-admin-ii-ch10.html
Yes this is the explanation given in the book where this question is published. It suggests that answers A and D are correct.
May I add that my last entry in this blog is the opinion of the book, it is not mine. My opinion can be found below.
B, D:
By using the NLS_SORT parameter, you can make the following changes to Oracle’s
default functionality:
– Set the default sort method for all ORDER BY operations.
– Set the default sort value for the NLSSORT function.