NLS_SORT = BINARY
NLS_SORT = BINARY_AI
NLS_SORT = BINARY_CI
NLS_SORT = BINARY_AI_CI
Binary sorts are case insensitive and accent insensitive by default.
第1题:
A. 1 is a monolingual sort.
B. 2 is a monolingual sort.
C. 1 is case insensitive.
D. Both 1 and 2 are case insensitive.
E.Case sensitivity is unknown.
第2题:
A. WHERE clause WHERE
B. ORDER BY clause
C. BETWEEN clause
D. NLSSORT function
E. NLS_SORT function
第3题:
A. True
B. False
第4题:
A user executes the statement; PURGE BINARY LOGS TO 'mysql-bin.010'; What is the result?()
第5题:
You are trying to determine how many disk sorts are happening on the database right now. Which of the following dictionary tables would you use to find that information?()
第6题:
A. V$VALID_NLS_VALUES
B. NLS_VALID_VALUES
C. NLS_VALUE_OPTIONS
D. V$NLS_VALUE_OPTIONS
E. V$NLS_VALID_VALUES
第7题:
Which of the following NLS_SORT parameter values would result in case-insensitive and accent-insensitive binary sorts?()
第8题:
A. NLS_SORT = BINARY
B. NLS_SORT = BINARY_AI
C. NLS_SORT = BINARY_CI
D. NLS_SORT = BINARY_AI_CI
E. Binary sorts are case insensitive and accent insensitive by default.
第9题:
Case-insensitive sorts are always accent insensitive by default.()
第10题:
Which of the following NLS_SORT parameter values would result in case-insensitive and accent-insensitive binary sorts?()