OCP考题学习.pdf

  1. 1、本文档共6页,可阅读全部内容。
  2. 2、有哪些信誉好的足球投注网站(book118)网站文档一经付费(服务费),不意味着购买了该文档的版权,仅供个人/单位学习、研究之用,不得用于商业用途,未经授权,严禁复制、发行、汇编、翻译或者网络传播等,侵权必究。
  3. 3、本站所有内容均由合作方或网友上传,本站不对文档的完整性、权威性及其观点立场正确性做任何保证或承诺!文档内容仅供研究参考,付费前请自行鉴别。如您付费,意味着您自己接受本站规则且自行承担风险,本站不退款、不进行额外附加服务;查看《如何避免下载的几个坑》。如果您已付费下载过本站文档,您可以点击 这里二次下载
  4. 4、如文档侵犯商业秘密、侵犯著作权、侵犯人身权等,请点击“版权申诉”(推荐),也可以打举报电话:400-050-0827(电话支持时间:9:00-18:30)。
查看更多
OCP考题学习

OCP考题学习 2011年6月24 日 21:09 关于OCP考题学习 前一段时间考了OCP,习了OCP题库,记录部分考题分析及答案理解 2. You execute the following command to enable a session in resumable mode: SQL ALTER SESSION ENABLE RESUMABLE TIMEOUT 60; What is the impact of a timeout on the statements being suspended? A. The statements remain suspended for at least 60 seconds. B. The statements are suspended for 60 seconds and then they are executed. C. C.The suspended statements error out if the problem is not rectified within 60 seconds. D. The statements are automatically suspended 60 seconds after an error is received, and then attempt to execute normally again. Answer: C Note: 从9i开始,Oracle提供了一种避免因为space Error而导致事务异常的操作,那就是resumable在 会话里打开这个功能后(运行alter session enable resumable timeout 秒默认7200).当运行某些 sql导致空间不足(表空间用完了)、或已抵达该表/段的maxextents,或者该用户使用此表空间 的配额已经用完(Out of space condition, Maximum extents reached condition, Space quota exceeded condition. ),此时Oracle将不会报错,而是把语句挂起,让dba 在timeout 所指定 的时间范围内解决问题,之后语句又可以继续运行. 3. Immediately after adding a new disk to or removing an existing disk from an Automatic Storage Management (ASM) instance, you find that the performance of the database decreases initially, until the addition or removal process is completed. Performance then gradually returns to normal levels. Which two activities could you perform to maintain a consistent performance of the database while adding or removing disks? (Choose two.) A. increase the number of checkpoint processes B. define the POWER option while adding or removing the disks C. increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSES D. increase the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVES E. increase the number of ASM Rebalance processes by setting up a higher value for ASM_POWER_LIMIT during the disk addition or removal process Answer: BE Note: ASM ( Automatic Storage Management ) 的一个重要特性是可以进行在

文档评论(0)

xxj1658888 + 关注
实名认证
内容提供者

教师资格证持证人

该用户很懒,什么也没介绍

领域认证该用户于2024年04月12日上传了教师资格证

1亿VIP精品文档

相关文档