ITPub博客

（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函数...

（460）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 apply.)A. A must contain all of the characters defined in B.B. A must be Unicode.C. The encoded values in A must match the encoded values i...

（459）What elements of globalization can be explicitly defined using the NLS_LANG environment variable?(Choose all that apply.)A. NLS_LANGUAGEB. NLS_SORTC. NLS_CALENDARD. NLS_CHARACTERSETE. NLS_TERRITORY答案：（A、D、E）解析：NLS_LANG环境变量可以定义语言、字符集、te...

（458）Globalization support is implemented through the text-and character-processing functions provided by which Oracle feature?A. RSTLNEB. NLSRTLC. LISTENERD. NLSSORTE. Linguistic sorts答案：（B）解析：《Globalization Support Guide》 glossaryNLSRTL（National...

（457）If two windows overlap,which window attribute will determine whether one should be chosen over the other?A. WINDOW_PRIORITYB. PRIORITYC. PRIORITY_LEVELD. WINDOW_PRIORITY_LEVELE. OVERLAP_RULE答案：（A）解析：DBMS_SCHEDULER.CREATE_WINDOWwindow_priority = ...

（456）Which of the following is true about job chains?A. They consist of one or more Scheduler programs.B. They are used to implement dependency scheduling.C. They are used to implement time-based scheduling.D. They are used to implement event-based scheduling.E. None of the abov...

（455）When a job exceeds the date specified in its END_DATE attribute,which of the following will happen?(Choose all that apply.)A. The job will be dropped automatically if the value of the AUTO_DROP attribute is TRUE.B. The job will only be disabled if the value of the AUTO_DROP attribute i...

（454）If a job references a schedule that has been disabled,what will be the result?A. The job will be automatically disabled.B. The job will never execute.C. The job will attempt to execute but will fail.D. The job will inherit the DEFAULT_SCHEDULE schedule.E. A schedule object ...

（453）What is the danger associated with stopping a running job by using the STOP_JOB procedure?A. The job will need to be reenabled before it will execute again.B. The job may hold locks on objects referenced within it.C. All jobs within the job group will also be stopped.D. The job...

（452）Which of the following Scheduler elements encourage object reuse?(Choose all that apply.)A. Schedule objectsB. Program argumentsC. Job classesD. Job argumentsE. All of the above答案：（A、B、D）解析：《Administrator’s Guide》 29...