ITPub博客

（480）View the Exhibit exhibit1 to examine the series of SQL commands.View the Exhibit exhibit2 to examine the plans available in the SQL plan baseline.The baseline in the first row of the Exhibit is created when OPTIMIZER_MODE was set to FIRST_ROWS.Which statement is true if the SQL query i...

（479）Which two statements about workload capture and replay operations are true?(Choose two.)A. The clients must be created manually on the test machines to perform more realistic testing.B. Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state for...

（478）Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.(Choose two.)A. Cursor cacheB. Stored outlineC. SQL Tuning SetD. Automatic Workload Repository(AWR) snapshots答案：（A、C）解析：《performance tuning guide》 15D...

（477）Which of the following is not a valid linguistic sort element?A. Accent expansionB. Canonical equivalenceC. Reverse secondary sortingD. Ignorable charactersE. Character rearrangement答案：（A）解析：再议

（476）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答案：（C）解析：《globalization support guide》 13.8After you have defined a new language,territory,cha...

（475）Case-insensitive sorts are always accent insensitive by default.A. TrueB. False答案：（B）解析：反了，应该是accent不敏感的（AI），默认为大小写不敏感的（CI）。

（474）Which NLS parameter directly governs linguistic searches?A. NLS_SEARCH_LB. NLS_SORTC. NLS_SEARCHD. NLS_SORT_LE. None of the above答案：（B）解析：其它参数都没有

（473）How many different calendars does Oracle 11g support?A. 22B. 7C. 6D. 15E. 2答案：（B）解析：《Globalization Support Guide》 1.2.5

（472）Which is not a valid locale definition file type?A. LanguageB. Linguistic sortC. CalendarD. TerritoryE. Character set答案：（C）

（471）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 dictionary tablesD. NCHAR columnsE. CHAR columns答案：（E）解析：指定长度的语义是字符语义，还是字节语义...

（470）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_COMPC. NLS_SORTD. None of the above答案：（D）解析：感觉应该为B

（469）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....

（468）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 server character sets are not the same,and the database character set is not a strict superset of the client character set.C.The clie...

（467）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 data by default?A. VARCHAR2B. CHARC. NVARCHAR2D. CLOBE. LONG答案：（C）解析：因为国家字符集为UTF-8...

（466）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 monolingual sort.C. 1 is case insensitive.D. Both 1 and 2 are case insensitive.E. Case sensitivity is unknown.答案：（A）...

（465）NLS parameters can be set using the five methods listed.Put the methods in order from highest to lowest according to Oracles order of precedence:a. Default setting      b. Client environment variablec. Explicit ALTER SESSION statementd. Inside SQL f...

（464）Which of the following are valid settings for the NLS_COMP parameter?(Choose all that apply.)A. ASCIIB. ANSIC. BINARYD. MONOLINGUALE. MULTILINGUAL答案：（B、C）解析：NLS_COMP共有3种取值：1. BINARY2. LINGUISTIC3. ANSI...

（463）Which of the following datatypes store time-zone information in the database?A.TIMESTAMPB.DATEC.TIMESTAMP WITH TIME ZONED.TIMESTAMP WITH LOCAL TIME ZONEE.DATETIME答案：（C）

（462）Which view shows all valid values for the NLS_LANGUAGE,NLS_SORT,NLS_TERRITORY,and NLS_CHARACTERSET parameters?A. V$VALID_NLS_VALUESB. NLS_VALID_VALUESC. NLS_VALUE_OPTIONSD. V$NLS_VALUE_OPTIONSE. V$NLS_VALID_VALUES答案：（E）

（461）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. BETWEEN clauseD. NLSSORT functionE. NLS_SORT function答案：（A、D）->（B，C，D）解析：E（X），没有NLS_SORT函数...