Which of the following NLS_SORT parameter values would result in case-insensitive and accent-insensitive binary sorts?()A、NLS_SORT = BINARYB、NLS_SORT = BINARY_AIC、NLS_SORT = BINARY_CID、NLS_SORT = BINARY_AI_CIE、Binary sorts are case insensitive and accent

题目

Which of the following NLS_SORT parameter values would result in case-insensitive and accent-insensitive binary sorts?()

  • 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.
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

Which of the following NLS_SORT parameter values would result in case-insensitive and accent-insensitive binary sorts?()

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.


参考答案:B

第2题:

Which view shows all valid values for the NLS_LANGUAGE, NLS_SORT, NLS_TERRITORY,and NLS_CHARACTERSET parameters?()

A. V$VALID_NLS_VALUES

B. NLS_VALID_VALUES

C. NLS_VALUE_OPTIONS

D. V$NLS_VALUE_OPTIONS

E. V$NLS_VALID_VALUES


参考答案:E

第3题:

Which two are true regarding MySQL binary and text backups?()

A.Binary backups are usually faster than text backups

B.Binary backups are usually slower than text backups

C.Text backups are human-readable while binary backups are not

D.Binary backups are not portable across different operating systems


参考答案:A, C

第4题:

Case-insensitive sorts are always accent insensitive by default.()

  • A、True
  • B、False

正确答案:B

第5题:

A user executes the statement;PURGE BINARY LOGS TO ‘mysql-bin.010‘;What is the result?()

A.It deletes all binary log files, except ‘mysql-in.010‘

B.It deletes all binary log files up to and including ‘mysql-bin.010‘

C.It deletes all binary log files before ‘mysql-bin.010‘

D.It deletes all binary log files after ‘mysql-bin.010‘


参考答案:C

第6题:

What can you determine about the following linguistic sorts based only on their names?()1. GERMAN2. FRENCH_M multilingual

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.


参考答案:A

第7题:

The NLS_SORT parameter sets the default sort method for which of the following operations?()

A. WHERE clause WHERE

B. ORDER BY clause

C. BETWEEN clause

D. NLSSORT function

E. NLS_SORT function


参考答案:A, D

第8题:

Case-insensitive sorts are always accent insensitive by default.()

A. True

B. False


参考答案:B

第9题:

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?()

  • A、V$SESSION 
  • B、V$SYSSTAT 
  • C、DBA_SEGMENTS 
  • D、V$SORT_USAGE

正确答案:D

第10题:

A user executes the statement; PURGE BINARY LOGS TO 'mysql-bin.010'; What is the result?()

  • A、It deletes all binary log files, except 'mysql-in.010'
  • B、It deletes all binary log files up to and including 'mysql-bin.010'
  • C、It deletes all binary log files before 'mysql-bin.010'
  • D、It deletes all binary log files after 'mysql-bin.010'

正确答案:C

更多相关问题