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 

题目

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 two are true regarding MySQL binary and text backups?()A.Binary backups are usually faster than text backupsB.Binary backups are usually slower than text backupsC.Text backups are human-readable while binary backups are notD.Binary backups are not portable across different operating systems

2.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 insensitive by default.

3.What can you determine about the following linguistic sorts based only on their names?()1. GERMAN2. FRENCH_M multilingualA. 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.

4.Case－insensitive sorts are always accent insensitive by default.()A. TrueB. False

更多“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 ”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    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

  • 第5题：

    What can you determine about the following linguistic sorts based only on their names？（）   1. GERMAN  2. FRENCH_M  

    • 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

  • 第6题：

    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

  • 第7题：

    单选题
    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.


    正确答案： E
    解析： 暂无解析

  • 第8题：

    多选题
    The NLS_SORT parameter sets the default sort method for which of the following operations？（）
    A

    WHERE clause

    B

    ORDER BY clause

    C

    BETWEEN clause

    D

    NLSSORT function

    E

    NLS_SORT function


    正确答案： B,E
    解析： 暂无解析

  • 第9题：

    多选题
    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,E
    解析： 暂无解析

  • 第10题：

    单选题
    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
    解析： 暂无解析

  • 第11题：

    单选题
    What can you determine about the following linguistic sorts based only on their names？（）   1. GERMAN  2. FRENCH_M
    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.


    正确答案： D
    解析： 暂无解析

  • 第12题：

    单选题
    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
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    Case-insensitive sorts are always accent insensitive by default.（）

    • A、True
    • B、False

    正确答案:B

  • 第16题：

    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

  • 第17题：

    The NLS_SORT parameter sets the default sort method for which of the following operations？（）

    • A、 WHERE clause
    • B、 ORDER BY clause
    • C、 BETWEEN clause
    • D、 NLSSORT function
    • E、 NLS_SORT function

    正确答案:A,D

  • 第18题：

    Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic for the SQL SELECT statement？（）

    • A、 NLS_LANG
    • B、 NLS_COMP
    • C、 NLS_SORT
    • D、 None of the above

    正确答案:D

  • 第19题：

    单选题
    Case-insensitive sorts are always accent insensitive by default.（）
    A

     True

    B

     False


    正确答案： A
    解析： 暂无解析

  • 第20题：

    单选题
    You are specifying French case-insensitive sorts by using the NSL_SORT parameter for the user session of the user， Scott. Which value will you set for the NLS_SORT parameter？（）
    A

     FRENCH_AI

    B

     FRENCH_CI

    C

     AI_FRENCH

    D

     CI_FRENCH


    正确答案： B
    解析： 暂无解析

  • 第21题：

    单选题
    What can you determine about the following linguistic sorts based only on their names?（） 1. GERMAN 2. 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
    解析： 暂无解析

  • 第22题：

    单选题
    Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic for the SQL SELECT statement?（）
    A

    NLS_LANG

    B

    NLS_COMP

    C

    NLS_SORT

    D

    None of the above


    正确答案： B
    解析： 暂无解析

  • 第23题：

    单选题
    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


    正确答案： A
    解析： 暂无解析

相关内容