ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
发布时间：2019-07-31 09:45:13
A)AWR data is stored in the SYSTEM tablespace.C)It is the foundation for the self-managing infrastructure.E)Its collection level is determined by the value of the STATISTICS_LEVEL database parameter.赵：B 选项，MMON 进程将 AWR 统计信息作为快照保存到 AWR，默认 60 分钟保存一次，保存 .........【阅读全文】
发布时间：2019-07-30 13:05:30
A)They are gathered by the Manageability Monitor(MMON) background process.C)They do not persist across instance restarts.E)They provide information to the Optimizer so that it can determine optimal execution plans for SQL statements.Answer: BE......【阅读全文】
发布时间：2019-07-30 11:20:51
A)AWR data is stored in the SYSAUX tablespace.C)It includes statistics that contain the number of distinct values per table column.E)it is maintained by executing the pl/sql procedures in the dbms_stats package.Answer: ABD......【阅读全文】
发布时间：2019-07-29 11:14:52
A)They are automatically updated when ddl statements execute.C)They can be gathered on external tables.E)They can be estimated.赵：......【阅读全文】
发布时间：2019-07-29 10:36:29
A)They can be gathered manuallyC)They contain the execution plan for each executed SQL statement.E)They can be gathered automatically by an automatic maintenance job.赵：C 错，优化器统计信息和执行计划是两个事，统计信息的最终用途是告诉优化器 optimizer 可以对每个 SQL 去选择最好的执行计划.........【阅读全文】
