ITPub博客

481.Which statement is true about a running session that belongs to the online transaction processing (OLTP) group?A. It permanently switches to the low_group consumer group if the session exceeds 10,000 I/O requests or 2,500 MB of data transfer.B. It performs the first 10000 I/O requests or 2,500...

479.Which two statements about workload capture and replay TM 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 wor...

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) snapshotsAnswer: AC确定两个直接来源，从那里SQL计划可以加载到SQL计划基线。A、游标缓存C、SQL...

477.Which of the following is not a valid linguistic sort element?A. Accent expansionB. Canonical equivalenceC. Reverse secondary sortingD. Ignorable charactersE. Character rearrangementAnswer: A参考：http://docs.oracle.com/cd/E11882_01/server.112/e10729/ch5lingsort.htm#NLSPG276下列哪项不...

474.Which NLS parameter directly governs linguistic searches?A. NLS_SEARCH_LB. NLS_SORTC. NLS_SEARCHD. NLS_SORT_LE. None of the aboveAnswer: B参考：http://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams155.htm#REFRN10127哪种国家语言支持参数直接支配语言搜索？Linguistic searches ...

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.Answer: B...

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.Answer: A参考：http://docs.oracle...

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 functionAnswer: AD国家语言支持排序参数设置默认的排序方式为以下哪些操作？The NLS_SORT parame...

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 in B for ...

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_TERRITORYAnswer: ADE参考：http://docs.oracle.com/cd/E11882_01/server.112/e10729/ch3globenv.htm#NLSPG...

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 is FALS...

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 aboveAnswer: ABD以下哪些调度器元素鼓励对象的重用？Schedule objects do not specify any action to be performed; the...

450.Which of the following are valid program types for a lightweight job? (Choose all that apply.)A. PLSQL_BLOCKB. EXECUTABLEC. JAVA_STORED_PROCEDURED. STORED_PROCEDUREE. EXTERNALAnswer: AD参考：http://docs.oracle.com/cd/E11882_01/server.112/e25494/schedover.htm#ADMIN12357下列哪一个是轻量...

445.To set the history retention period for either window logging or job logging individually, which parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used? (Choose all that apply.)A. LOG_HISTORYB. JOB_LOG_RETENTIONC. WINDOW_LOG_RETENTIOND. WHICH_LOGE. LOG_NAMEAnswer: AD要为窗口...

443.Which DBMS_SCHEDULER procedure(s) can be used to alter an existing job? (Choose all that apply.)A. SET_ATTRIBUTE_NULLB. ALTER_JOBC. ALTER_JOB_PARAMETERSD. ALTERE. SET_ATTRIBUTEAnswer: AE参考：http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_sched.htm#ARPLS72402哪些DBMS_SCHEDULER...

439.Which DBMS_SCHEDULER procedures can be used to enable a program? (Choose all that apply.)A. ENABLEB. ENABLE_PROGRAMC. VALIDATE_PROGRAMD. SET_ATTRIBUTEE. SET_ENABLEDAnswer: AD哪些DDBMS_SCHEDULER过程可以用来启用程序？Programs (as well as jobs) can be enabled in two ways: by using the ENA...

436.Which DBMS_RESOURCE_MANAGER procedure prioritizes consumer-group mappings?A. CREATE_MAPPING_PRIORITYB. SET_MAPPING_PRIORITYC. SET_MAPPING_ORDERD. PRIORITIZE_MAPPING_ORDERE. This functionality is not available through the DBMS_RESOURCE_MANAGER package.Answer: B哪一个DBMS_RESOURCE_MANAGER...

434.Which of these represent the main components of Database Resource Manager? (Choose all that apply.)A. Resource consumer groupsB. Resource plansC. Resource-plan groupsD. Resource-plan directivesE. All of the aboveAnswer: ABD哪些代表数据库资源管理器的主要组成部分？A、资源消费者组B、资源...

433.When shrinking a table segment, you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use?A. INCLUDING DEPENDENCIESB. INCLUDING DEPENDENCIES CASCADEC. COMPACTD. CASCADEE. None of the aboveAnswer: D当收缩一个表段，你选择使用收缩空间命...

432.For which of the following can you use Segment Shrink? (Choose all that apply.)A. Heap tablesB. Tables with function-based indexesC. IndexesD. Partitions and subpartitionsE. None of the aboveAnswer: ACD你可以使用段收缩用于以下哪些？The Segment Shrink feature can be used on tables, inde...