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考试题库汇总(57)-CUUG内部解答版
Examine these facts about a databases: 1.USERS is the database default tablespace. 2.USER1,USER2,and USER3 have the CREATE SESSION privilege 3.
736 0
|
数据库 存储
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.
738 0
|
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.
1862 0
OCP-052考试题库汇总(42)-CUUG内部解答版
You successfully executed these commands: connect scott/tiger@prod1; CREATE DATABASE LINK db_prod2 CONNECT TO scott IDENTIFIED BY tiger USING 'PROD2'...
791 0
|
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.
853 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 是客户端工具程序,它们既可以在客户端使用,也可以在服务端使用。
647 0
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。
598 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
|
数据库
OCP-052考试题库汇总(26)-CUUG内部解答版
Which three of these must be accessible to keep a database open? A)Control file. B)All members of a redo log group. C)SYSTEM tablespace. D)SYSAUX tablespace. E)spfile Answer: ABC 赵: 1 nomount:实例已经启动,进程和内存已经分配。
675 0