OCP-1Z0-053-V12.02-298题
来源:互联网 发布:手机怎样删除淘宝评论 编辑:程序博客网 时间:2024/06/06 15:39
298.While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement
that has stale statistics available.
What would the optimizer do in this situation?
A. It updates the existing SQL profiles with current statistics.
B. It makes the statistics information available to GATHER_STATS_JOB.
C. It initiates the statistics collection process by running GATHER_STATS_JOB.
D. It logs a warning message in the alert log so that the DBA can perform statistics collection manually.
Answer: B
答案解析:
Actions represent the jobs that are performed by a module. For example, the DBMS_SCHEDULER
module can run the GATHER_STATS_JOB
action to gather statistics on all database objects. If a single action is using the majority of the wait time, then you should investigate it.
- OCP-1Z0-053-V12.02-298题
- OCP-1Z0-053-V12.02-679题
- OCP-1Z0-053-V12.02-591题
- OCP-1Z0-053-V12.02-590题
- OCP-1Z0-053-V12.02-552题
- OCP-1Z0-053-V12.02-551题
- OCP-1Z0-053-V12.02-549题
- OCP-1Z0-053-V12.02-548题
- OCP-1Z0-053-V12.02-234题
- OCP-1Z0-053-V12.02-584题
- OCP-1Z0-053-V12.02-595题
- OCP-1Z0-053-V12.02-184题
- OCP-1Z0-053-V12.02-59题
- OCP-1Z0-053-V12.02-676题
- OCP-1Z0-053-V12.02-667题
- OCP-1Z0-053-V12.02-660题
- OCP-1Z0-053-V12.02-580题
- OCP-1Z0-053-V12.02-323题
- python 使用变量构建另类简单定时器(不阻塞)
- 一个有关typedef的找错题以及typedef详解
- 东风汽车股份有限公司MES实施案例
- 【一手笔经】趋势科技2014校招笔试
- 基于OpenCV的PHP图像人脸识别技术
- OCP-1Z0-053-V12.02-298题
- C++类中的静态成员与静态函数
- Java学习第四课 类的继承与多态特性
- Web 设计:实现干净代码的12条定律
- 国内著名互联网企业PHP笔试题
- fork()输出
- 锻炼身体是实现目标的基础
- MAC下邮件客户端操作——解决无法登陆GMail IMAP服务器
- CodeIgniter 入门