AI 助理
备案控制台
开发者社区 数据库 文章 正文

OCP-052考试题库汇总（13）-CUUG内部解答版

2019-07-31 1029
版权
版权声明：
本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《 阿里云开发者社区用户服务协议》和 《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写 侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
简介： Which three are true about the Automatic Workload Repository (AWR)?A)AWR data is stored in the SYSTEM tablespace.

Which three are true about the Automatic Workload Repository (AWR)?

A)AWR data is stored in the SYSTEM tablespace.

B)By default, AWR snapshots are taken every 60 minutes.

C)It is the foundation for the self-managing infrastructure.

D)The taking of AWR snapshots cannot be disabled.

E)Its collection level is determined by the value of the STATISTICS_LEVEL database parameter.

Answer: BCE

赵：

A 选项，AWR 是存放在 SYSAUX 中的表，属于 SYSMAN 模式

B 选项，MMON 进程将 AWR 统计信息作为快照保存到 AWR，默认 60 分钟保存一次，保存 8 天。

D 选项，The taking of AWR snapshots cannot be disabled. AWR 不能禁止，是错的，basic 就禁用了

E 选项，AWR 的收集级别取决于 STATISTICS_LEVEL，BASIC 几乎禁用全部信息，即禁用 AWR 的信息收集;TYPICAL 收集正常调整需要的信息，不收集对性能有不良影响的信息;ALL 收集全部与 SQL 执行有关的信息

文章标签：
SQL
bjcuug
目录
相关文章
bjcuug
OCP-052考试题库汇总（59）-CUUG内部解答版
In one of your databases: 1.USER1 and USER2 have no system privileges. 2.ROLE1 only has these privileges: ?CREATE SESSION ?CREATE TABLE ?CREATE VIEW ...
bjcuug
2839 0
bjcuug
OCP-052考试题库汇总（58）-CUUG内部解答版
In one of your databases: 1.USER1 and USER2 have no system privileges. 2.ROLE1 only has these privileges: ?CREATE SESSION ?CREATE TABLE ?CREATE VIEW ...
bjcuug
783 0
bjcuug
|
数据库 存储
OCP-052考试题库汇总（48）-CUUG内部解答版
Which is true about the Automatic Diagnostic Repository (ADR) ? A) It is used only if the DIAGNOSTIC_DEST parameter is manually configured.
bjcuug
760 0
bjcuug
|
Oracle 关系型数据库 数据库
OCP-052考试题库汇总（49）-CUUG内部解答版
Which two statements are true about the Automatic Diagnostic Repository (ADR) ? A)It only exists if DIAGNOSTIC_DEST is configured in the SPFILE.
bjcuug
984 0
bjcuug
|
数据库管理
OCP-052考试题库汇总（46）-CUUG内部解答版
Examine this command: SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area (startdate DATE, enddate DATE, class CHAR(20)) ON COMMIT PRESERVE ROWS; Whi...
bjcuug
781 0
bjcuug
|
Oracle 关系型数据库 数据库
OCP-052考试题库汇总（45）-CUUG内部解答版
You want to access employee details contained in flat files created by an application. Which two methods will achieve this? A)Use a BFILE column in a table to access the flat file.
bjcuug
1872 0
bjcuug
|
XML SQL 数据库
OCP-052考试题库汇总（41）-CUUG内部解答版
Examine this session output: SQL> connect scott/tiger Connected. SQL>select name,value 2 from v$parameter 3 where name='audit_trail'; NAME VALUE ----...
bjcuug
905 0
bjcuug
|
SQL 存储 Oracle
OCP-052考试题库汇总（37）-CUUG内部解答版
Examine these facts about objects in the SYSTEM schema: 1.EMP is a table. 2.EMP_PK is a primary key constraint on EMP.
bjcuug
860 0
bjcuug
OCP-052考试题库汇总（34）-CUUG内部解答版
Where is an expdp operation tracked? A)dump files B)control file C)log files D)Automatic Diagnostic Repository(ADR) E)master table (MT) Answer: E 赵： 题译：哪里有一个 Exdp 操作跟踪? Master table 是一个临时 table，专门为 import pump 和 export pump 创建的，一旦完成就会自动被 drop。
bjcuug
614 0
bjcuug
|
数据库 关系型数据库 Oracle
OCP-052考试题库汇总（32）-CUUG内部解答版
Which state must a database be to enable ARCHIVELOG ? A)NOMOUNT B)OPEN IN READ WRITE mode C)OPEN IN READ ONLY mode D)OPEN IN RESTRICTED mode E)MOUNT ...
bjcuug
727 0