随笔分类 -  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 阅读全文
posted @ 2017-11-24 10:57 巴啦啦大魔王 阅读(202) 评论(0) 推荐(0)
摘要:Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform? (Choose three. 阅读全文
posted @ 2017-11-16 10:56 巴啦啦大魔王 阅读(129) 评论(0) 推荐(0)
摘要:Which of the following is not a valid linguistic sort element?A. Accent expansionB. Canonical equivalenceC. Reverse secondary sortingD. Ignorable char 阅读全文
posted @ 2017-11-15 10:59 巴啦啦大魔王 阅读(117) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-15 10:56 巴啦啦大魔王 阅读(167) 评论(0) 推荐(0)
摘要:Case-insensitive sorts are always accent insensitive by default.A. TrueB. False Accent-insensitive sorts are always case insensitive,not the other way 阅读全文
posted @ 2017-11-15 10:54 巴啦啦大魔王 阅读(90) 评论(0) 推荐(0)
摘要:Which NLS parameter directly governs linguistic searches?A. NLS_SEARCH_LB. NLS_SORTC. NLS_SEARCHD. NLS_SORT_LE. None of the above Linguistic searches 阅读全文
posted @ 2017-11-15 10:51 巴啦啦大魔王 阅读(68) 评论(0) 推荐(0)
摘要:Which is not a valid locale definition file type?A. LanguageB. Linguistic sortC. CalendarD. TerritoryE. Character set Calendar definitions are not sto 阅读全文
posted @ 2017-11-15 10:46 巴啦啦大魔王 阅读(92) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-15 10:42 巴啦啦大魔王 阅读(103) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-15 10:37 巴啦啦大魔王 阅读(91) 评论(0) 推荐(0)
摘要:Which of the following NLS_SORT parameter values would result in case-insensitive and accent-insensitive binary sorts?A. NLS_SORT = BINARYB. NLS_SORT 阅读全文
posted @ 2017-11-15 10:31 巴啦啦大魔王 阅读(168) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-15 10:25 巴啦啦大魔王 阅读(117) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-15 10:21 巴啦啦大魔王 阅读(90) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-15 10:15 巴啦啦大魔王 阅读(128) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-14 18:31 巴啦啦大魔王 阅读(105) 评论(0) 推荐(0)
摘要:Which of the following are valid settings for the NLS_COMP parameter? (Choose all that apply.)A. ASCIIB. ANSIC. BINARYD. MONOLINGUALE. MULTILINGUAL Th 阅读全文
posted @ 2017-11-14 18:24 巴啦啦大魔王 阅读(133) 评论(0) 推荐(0)
摘要: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. 阅读全文
posted @ 2017-11-14 17:53 巴啦啦大魔王 阅读(101) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-14 17:50 巴啦啦大魔王 阅读(76) 评论(0) 推荐(0)
摘要:What elements of globalization can be explicitly defined using the NLS_LANG environment variable? (Choose all that apply.)A. NLS_LANGUAGEB. NLS_SORTC. 阅读全文
posted @ 2017-11-14 17:45 巴啦啦大魔王 阅读(105) 评论(0) 推荐(0)
摘要:Globalization support is implemented through the text- and character-processing functions provided by which Oracle feature?A. RSTLNEB. NLSRTLC. LISTEN 阅读全文
posted @ 2017-11-14 17:41 巴啦啦大魔王 阅读(117) 评论(0) 推荐(0)
摘要:The following query will provide what information about transportable tablespaces for the currentdatabase? (Choose all that apply.)select d.platform_n 阅读全文
posted @ 2017-11-14 15:09 巴啦啦大魔王 阅读(91) 评论(0) 推荐(0)