必威体育精装版Oracle OCP 11G题库中文版第二部分.pdf

日期版本 内容 文档完善者 邮箱 2013/09/22V2.1 美河学习在线 toogso@G QUESTION NO: 338 Within a resource-plan definition, what differentiates a top-level plan from a subplan?资 源计划定义中，顶层规划和子计划有什么区别？ A. A subplan has the PLAN_SUB parameter value set to SUB. B. A top-level plan has the GROUP_OR_PLAN parameter set to the name of the subplan in the resource-plan definition. C. There is no difference in the resource-plan definition. 在资源计划定义没有任何区别。 D. A subplan always has the CPU_MTH parameter value set to RATIO. E. The string TOP_LEVEL is appended to the name of top-level resource plans. Answer: C There is no concept of a subplan in the resource-plan definition. Only in a resource-plan directive can a subplan be identified.资源计划定义中子计划的概念不存在，只有在一个资源计划指令中能确定一个子计划。 QUESTION NO: 339 When setting arguments for a job, which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype? 当为一个作业设置参数时，你使用哪一个存储过程不能隐式转换一个 VARCHAR2数据类型？ A. SET_JOB_ARGUMENT_VALUE B. SET_JOB_VALUE_ANYDATA C. SET_JOB_ANYDATA_VALUE设置作业任何数据值 D. SET_SPECIAL_JOB_VALUE E. SET_JOB_ANYTYPE_VALUE Answer: C The SET_JOB_ANYDATA_VALUE procedure allows you to set job arguments that don‟t easily convert to and from a string (VARCHAR2) datatype. 设置作业任何数据值的存储过程允许你设置作业参数，该参数不会 轻易转换一个字符串（VARCHAR2 ）数据类型。 QUESTION NO: 340 Which DBMS_SCHEDULER procedures can be used to enable a program? (Choose all that apply.) 哪 些DBMS的调度器过程可以用来启用程序？ A. ENABLE启用 B. ENABLE_PROGRAM C. VALIDATE_PROGRAM D. SET_ATTRIBUTE设置属性 E. SET_ENABLED Answer: A,D Programs (as well as jobs) can be enabled in two ways: by using the ENABLE procedure or by using the SET_ATTRIBUTE procedure to set the ENABLED attribute to TRUE. 程序 （以及作业）可以启用在两个方面： 通过使用ENABLE过程或使用的SET_ATTRIBUTE过程来设置enabled属性为TRUE 。 QUESTION NO: 341 Which of the following is not a valid calendaring syntax element? 下列哪项不是一个有效的日程表语法元素？ A. FREQ