Which NLS parameter can be used to change the default Oracle

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

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第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题:

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

第3题:

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

第4题:

You are required to remove the default EXTPROC entry from the default listener configuration to create a listener that will listen specifically for EXTPROC calls. Which two methods can you use to remove the default EXTPROC entry from the default listener configuration? ()

  • A、 the RMAN utility
  • B、 the import/export utility
  • C、 the Oracle Enterprise Manager
  • D、 the change tracking feature
  • E、 the Net Manager utility

正确答案:C,E

第5题:

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

第6题:

Which two statements are true with regard to policy ordering? ()(Choose two.)

A. The last policy is the default policy, which allows all traffic.

B. The order of policies is not important.

C. New policies are placed at the end of the policy list.

D. The insert command can be used to change the order.


参考答案:C, D

第7题:

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

第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


参考答案:D

第9题:

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

第10题:

You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter in the parameter file to YYYY-MM-DD. The default format of which two data types would be affected by this setting? ()

  • A、 DATE
  • B、 TIMESTAMP
  • C、 INTERVAL YEAR TO MONTH
  • D、 INTERVAL DAY TO SECOND
  • E、 TIMESTAMP WITH LOCAL TIME ZONE

正确答案:B,E

更多相关问题