单选题Which NLS parameter directly governs linguistic searches?()ANLS_SEARCH_LBNLS_SORTCNLS_SEARCHDNLS_SORT_LENone of the above

题目
单选题
Which NLS parameter directly governs linguistic searches?()
A

 NLS_SEARCH_L

B

 NLS_SORT

C

 NLS_SEARCH

D

 NLS_SORT_L

E

 None of the above


相似考题
更多“单选题Which NLS parameter directly governs linguistic searches?()A  NLS_SEARCH_LB  NLS_SORTC  NLS_SEARCHD  NLS_SORT_LE  None of the above”相关问题
  • 第1题:

    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

  • 第2题:

    The President of the United States is elected()

    • A、indirectly by the electors
    • B、by Congress
    • C、directly by the voters
    • D、None of the above

    正确答案:D

  • 第3题:

    What elements of globalization can be explicitly defined using the NLS_LANG environment variable?()

    • A、NLS_LANGUAGE
    • B、NLS_SORT
    • C、NLS_CALENDAR
    • D、NLS_CHARACTERSET
    • E、NLS_TERRITORY

    正确答案:A,D,E

  • 第4题:

    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

  • 第5题:

    Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter?()  

    • A、 Automatic PGA Memory Management
    • B、 Automatic SGA Memory Management
    • C、 Automatic Shared Memory Management
    • D、 Automatic Memory Management
    • E、 Manual SGA Memory Management
    • F、 None of the above

    正确答案:D

  • 第6题:

    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

  • 第7题:

    The NLS_TERRITORY parameter specifies the default conventions to be used for which of the following globalization elements?() 

    • A、 Date format
    • B、 Decimal character
    • C、 Group separator
    • D、 First day of the month
    • E、 None of the above
    • F、 All of the above

    正确答案:A,B,C

  • 第8题:

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


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

  • 第9题:

    多选题
    Which of the following are valid settings for the NLS_COMP parameter?()
    A

    ASCII

    B

    ANSI

    C

    BINARY

    D

    MONOLINGUAL

    E

    MULTILINGUAL


    正确答案: B,C
    解析: 暂无解析

  • 第10题:

    多选题
    The NLS_TERRITORY parameter specifies the default conventions to be used for which of the following globalization elements?()
    A

    Date format

    B

    Decimal character

    C

    Group separator

    D

    First day of the month

    E

    None of the above

    F

    All of the above


    正确答案: F,B
    解析: 暂无解析

  • 第11题:

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

  • 第12题:

    单选题
    Which NLS parameter directly governs linguistic searches?()
    A

    NLS_SEARCH_L

    B

    NLS_SORT

    C

    NLS_SEARCH

    D

    NLS_SORT_L

    E

    None of the above


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

  • 第13题:

    Which of the following is not a valid setting for the PROGRAM_TYPE parameter in a program object or the JOB_TYPE parameter in a job object?()

    A. PLSQL_BLOCK

    B. JAVA_STORED_PROCEDURE

    C. STORED_PROCEDURE

    D. EXECUTABLE

    E. None of the above are invalid settings.


    参考答案:B

  • 第14题:

    You issued the following statement:   SQL> ALTER SESSION SET NLS_LANG=FRENCH_CANADA.WE8ISO8859P1;   Which parameter is NOT overridden by using the above statement?()  

    • A、 the value of the NLS_LANGUAGE variable
    • B、 the value of the NLS_TERRITORY variable
    • C、 the value of the NLS_CURRENCY variable
    • D、the character encoding scheme used by the client application

    正确答案:C

  • 第15题:

    Which of the following is not a valid setting for the PROGRAM_TYPE parameter in a program object or the JOB_TYPE parameter in a job object?()

    • A、PLSQL_BLOCK
    • B、JAVA_STORED_PROCEDURE
    • C、STORED_PROCEDURE
    • D、EXECUTABLE
    • E、None of the above are invalid settings.

    正确答案:B

  • 第16题:

    Which of the following are valid settings for the NLS_COMP parameter?()

    • A、 ASCII
    • B、 ANSI
    • C、 BINARY
    • D、 MONOLINGUAL
    • E、 MULTILINGUAL

    正确答案:B,C

  • 第17题:

    Which NLS parameter directly governs linguistic searches?()

    • A、 NLS_SEARCH_L
    • B、 NLS_SORT
    • C、 NLS_SEARCH
    • D、 NLS_SORT_L
    • E、 None of the above

    正确答案:B

  • 第18题:

    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

  • 第19题:

    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

  • 第20题:

    单选题
    Which of the following is not a valid setting for the PROGRAM_TYPE parameter in a program object or the JOB_TYPE parameter in a job object?()
    A

     PLSQL_BLOCK

    B

     JAVA_STORED_PROCEDURE

    C

     STORED_PROCEDURE

    D

     EXECUTABLE

    E

     None of the above are invalid settings.


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

  • 第21题:

    单选题
    Which NLS parameter directly governs linguistic searches?()
    A

     NLS_SEARCH_L

    B

     NLS_SORT

    C

     NLS_SEARCH

    D

     NLS_SORT_L

    E

     None of the above


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

  • 第22题:

    单选题
    You issued the following statement:   SQL> ALTER SESSION SET NLS_LANG=FRENCH_CANADA.WE8ISO8859P1;   Which parameter is NOT overridden by using the above statement?()
    A

     the value of the NLS_LANGUAGE variable

    B

     the value of the NLS_TERRITORY variable

    C

     the value of the NLS_CURRENCY variable

    D

    the character encoding scheme used by the client application


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

  • 第23题:

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

  • 第24题:

    单选题
    Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter?()
    A

     Automatic PGA Memory Management

    B

     Automatic SGA Memory Management

    C

     Automatic Shared Memory Management

    D

     Automatic Memory Management

    E

     Manual SGA Memory Management

    F

     None of the above


    正确答案: C
    解析: 暂无解析