OCP-052考试题库汇总(47)-CUUG内部解答版

简介: Which three are true about the Automatic Database Diagnostic Monitor (ADDM)?A)It improves database performance by automatically implementing Oracle ‘s best practices.

Which three are true about the Automatic Database Diagnostic Monitor (ADDM)?

A)It improves database performance by automatically implementing Oracle ‘s best practices.

B)It can assist the DBA in diagnosing database instance startup failures.

C)It can be used by executing the PL/SQL procedures in the DBMS_ADDM package.

D)It runs automatically after each Automatic Workload Repository snapshot is created.

E)It provides recommendations to improve database performance.

F)Its findings are accessible only by using Oracle Enterprise Manager.

Answer: CDE

赵:

ADDM(Automatic Database Diagnostic Monitor)自动诊断监视工具,ADDM 通过检查和分析 AWR 获取的数据来判断 Oracle 数据库中可能的问题。

目录
相关文章
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 ...
768 0
OCP-052考试题库汇总(55)-CUUG内部解答版
Examine these facts about a database: 1.USER is the database default tablespace. 2.USER1, USER2, and USER3 have the CREATE SESSION privilege.
3048 0
|
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.
963 0
|
数据库管理
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...
770 0
|
SQL 数据库 关系型数据库
OCP-052考试题库汇总(43)-CUUG内部解答版
Which is true about external tables? A)Segments are allocated for external tables. B)They may have indexes.
2131 0
|
数据库 关系型数据库 Oracle
OCP-052考试题库汇总(39)-CUUG内部解答版
Which three are true about auditing? A)Auditing is active only when the database is OPEN. B)Audit records are always stored in the database.
732 0
|
Oracle 关系型数据库 数据库
OCP-052考试题库汇总(33)-CUUG内部解答版
Which two can be exported by a non-administrative account by using Data Pump? A)directory objects B)tables C)tablespaces D)schemas E)database Answer: BD 赵: EXP 和 IMP 是客户端工具程序,它们既可以在客户端使用,也可以在服务端使用。
648 0
|
Oracle 关系型数据库 数据库
OCP-052考试题库汇总(31)-CUUG内部解答版
which four are true about the tools used to administer Oracle database? A)the Data Pump utility can be used to load data from text files.
792 0
|
Oracle 关系型数据库
OCP-052考试题库汇总(29)-CUUG内部解答版
When does an incremental checkpoint occur ? A)when an online redo log switch occurs. B)when DBWn writes dirty buffers as part of its normal processing.
1033 0
OCP-052考试题库汇总(27)-CUUG内部解答版
Which two of these must be available READ/WRITE to keep a database open? A)all copies of the control file.
512 0