随笔分类 - OCP字符相关
摘要:Which SQL statements would display the value 1890.55 as $1,890.55? (Choose three)A. SELECT TO_CHAR(1890.55,'$0G000D00') FROM DUAL;B. SELECT TO_CHAR(18
阅读全文
摘要:Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform? (Choose three.
阅读全文
摘要:Which of the following is not a valid linguistic sort element?A. Accent expansionB. Canonical equivalenceC. Reverse secondary sortingD. Ignorable char
阅读全文
摘要:What is the name of the file that identifies the set of available locale definitions?A. locale.defB. lxdef.oraC. lx1boot.nlbD. lx1boot.oraE. lang.def
阅读全文
摘要:Case-insensitive sorts are always accent insensitive by default.A. TrueB. False Accent-insensitive sorts are always case insensitive,not the other way
阅读全文
摘要:Which NLS parameter directly governs linguistic searches?A. NLS_SEARCH_LB. NLS_SORTC. NLS_SEARCHD. NLS_SORT_LE. None of the above Linguistic searches
阅读全文
摘要:Which is not a valid locale definition file type?A. LanguageB. Linguistic sortC. CalendarD. TerritoryE. Character set Calendar definitions are not sto
阅读全文
摘要:Which of the following would be affected by setting NLS_LENGTH_SEMANTICS=CHAR?A. All objects in the databaseB. Tables owned by SYS and SYSTEMC. Data d
阅读全文
摘要:Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic for the SQL SELECT statement?A. NLS_LANGB. NLS_COMP
阅读全文
摘要:Which of the following NLS_SORT parameter values would result in case-insensitive and accent-insensitive binary sorts?A. NLS_SORT = BINARYB. NLS_SORT
阅读全文
摘要:Automatic data conversion will occur if which of the following happens?A. The client and server have different NLS_LANGUAGE settings.B. The client and
阅读全文
摘要:In a database with the database character set of US7ASCII and a national character set of UTF-8, which datatypes would be capable of storing Unicode d
阅读全文
摘要:What can you determine about the following linguistic sorts based only on their names?1. GERMAN2. FRENCH_MA. 1 is a monolingual sort.B. 2 is a monolin
阅读全文
摘要:NLS parameters can be set using the five methods listed. Put the methods in order from highest tolowest according to Oracles order of precedence:A. De
阅读全文
摘要:Which of the following are valid settings for the NLS_COMP parameter? (Choose all that apply.)A. ASCIIB. ANSIC. BINARYD. MONOLINGUALE. MULTILINGUAL Th
阅读全文
摘要:The NLS_SORT parameter sets the default sort method for which of the following operations?(Choose all that apply.)A. WHERE clauseB. ORDER BY clauseC.
阅读全文
摘要:Given two different character sets (A and B), which of the following must be true for A to be considered a strict superset of B? (Choose all that appl
阅读全文
摘要:What elements of globalization can be explicitly defined using the NLS_LANG environment variable? (Choose all that apply.)A. NLS_LANGUAGEB. NLS_SORTC.
阅读全文
摘要:Globalization support is implemented through the text- and character-processing functions provided by which Oracle feature?A. RSTLNEB. NLSRTLC. LISTEN
阅读全文
摘要:The following query will provide what information about transportable tablespaces for the currentdatabase? (Choose all that apply.)select d.platform_n
阅读全文
浙公网安备 33010602011771号