Oracle - 11G - 题库337 - 图文(15)

B. Shared server requests (Oracle MTS) C. Bind variable values 绑定变量值

D. Information about transactions 事务信息

E. Remote DESCRIBE and COMMIT operations Answer: A,C,D

QUESTION NO: 117

Which of the following are true concerning block media recovery? (Choose all that apply.) 关于块介质恢复 下列哪个是真的？

A. Any gap in archive logs ends the recovery.

B. If a gap in archive logs is encountered, RMAN will search forward for newer versions of the blocks that are notcorrupt. 如果遇到一个归档记录缺口，RMAN 将向前搜索未损坏的较新版本的块。

C. Uncorrupted blocks from the flashback logs may be used to speed recovery.闪回日志的未损坏块可用于 加快恢复D. The database can be in NOARCHIVELOG mode. E. None of the above.

Option A is incorrect because a gap in archive logs does not automatically end the recovery.

RMAN will search forward for uncorrupted newer blocks; if RMAN finds one, it will continue with the restore and recovery operation. RMAN will check the flashback logs for uncorrupted copies of the block before it checks the backups.

Option D is incorrect because the database must be in ARCHIVELOG mode. Answer: B,C

QUESTION NO: 118

The DBA has chosen to manage SGA and PGA memory separately in an OLTP database because of his unique knowledge of the application. Which of these are good starting points to use when configuring the

maximum values for SGA and PGA, based on the amount of memory available on the system? DBA 已经选 择在 OLTP 数据库中分开管理 SGA 和 PGA 内存，因为他独特的应用知识。基于系统上可用的内存量，当配 置 SGA 和 PGA 的最大值时，这些良好的出发点中哪个可以利用？ A. 20% SGA, 80% PGA

B. 25% SGA, 75% PGA C. 50% SGA, 50% PGA D. 75% SGA, 25% PGA E. 80% SGA, 20% PGA Answer: E

QUESTION NO: 119

You notice that a long-running transaction is suspended due to a space constraint, and there is no AFTER SUSPEND triggered event addressing the issue. You also note that the critical transaction is just about to

reach the RESUMABLE_TIMEOUT value. Which of these actions is appropriate? 您会注意到由于空间限制

一个长期运行的交易被暂停，也没有暂停后解决问题的触发事件。你也注意到关键的事务恰好即将达到可恢 复超时值。这些行动的哪一个是适当的？

A. Abort the session, fix the space problem, then resubmit the transaction.

B. Use the DBMS_RESUMABLE.SET_SESSION_TIMEOUT procedure to extend the time-out for the session while you fix the problem. 当你解决这个问题时，使用DBMS可恢复的.设置会话超时程序以延长会 话的超时时间。

C. Do nothing, let the transaction fail, then fix the problem. D. Use Segment Shrink to clean up the table.

E. Use the DBMS_RESUMABLE.SET_TIMEOUT procedure to extend the time-out for the session while you fix the problem. Answer: B

QUESTION NO: 120

Which of the following are not disabled by default? 下列哪项不是默认情况下禁用？

A. Jobs B. Chains C. Windows

D. Window groups

E. Schedule时间表

A schedule is enabled by default. The others are disabled by default. Answer: E

QUESTION NO: 121

You notice that a job in a chain has not completed on a nonconstrained RAC database. Which of these are valid reasons why that might occur? 您会注意到在一个非约束的RAC数据库中，一个链中的作业还没 有完成。下面这些哪一个是可能发生有效的原因？

A. The job priority is 1 and the resource consumer group CPU emphasis allocation is a low percentage. B. The job affinity is to a service and one node in that service is unavailable.

C. The job affinity is to an instance and that instance is unavailable.作业和一个实例有密切关系，该实例不可用。

D. There is no service affinity.

E. None of the above.

C. Since we‘ve established that the RAC is not performance constrained, option A is not valid—if the resource group were not able to obtain adequate CPU, this might be a valid answer. Option B is not correct because service affinity guarantees that if one instance in the service is available, the Scheduler will attempt to use it to run the job. If there is no service or instance affinity, the Scheduler will attempt to balance the load across surviving nodes. 既然我们已经确定RAC没有性能约束，选项A不是有效--如果资源 组无法获得足够的CPU，这可能是一个有效的答案。选项B是不正确的，因为服务的亲和力保证如果在服 务中的一个实例，调度会尝试用它来运行作业，如果没有服务或实例的亲和力，调度会尝试幸存的节点之 间的负载平衡。Jobs can be defined with a service affinity (they should run on a specific service) as opposed to an instance affinity (they should run on a specific instance). If a job is assigned to a service consisting of two instances, even if one instance is down, the other can execute the job normally. Answer: C

QUESTION NO: 122

The NLS_LANGUAGE parameter specifies the default conventions to be used for which of the following globalization elements? 该本地语言支持语言参数指定默认的约束将用于以下哪些全球化元素？ A. Languages for server messages用于服务器消息的语言

B. Day and month names and abbreviations日期和月份名称和缩写

C. Symbols to represent a.m., p.m., AD, and BC代表上午，下午，公元和公元前的符号 D. Affirmative and negative response strings (YES, NO) 肯定和否定响应字符串（是，否）

E. All of the above

Answer: E

NLS：native language support本地语言支持

QUESTION NO: 123

The NLS_TERRITORY parameter specifies the default conventions to be used for which of the following

globalization elements? (Choose all that apply.)该本地语言支持地域参数指定缺省的协议用于以下哪些全 球化元素？

A. Date format日期格式

B. Decimal character十进制字符

C. Group separator组分隔符，NLS 指定将用作组分隔符和小数位的字符。组分隔符就是用来分隔整数位组 (如千、百万等等) 的字符。小数分隔符用来将一个数字的整数部分与小数部分分隔开。 D. First day of the month E. None of the above F. All of the above Answer: A, …… 此处隐藏：5457字，全部文档内容请下载后查看。喜欢就下载吧 ……