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.

Which is true about the Automatic Diagnostic Repository (ADR) ?

A) It is used only if the DIAGNOSTIC_DEST parameter is manually configured.

B) It only contains the alert log and trace files for background processes.

C) Its location is always set by the ORACLE_BASE variable.

D) It includes diagnostic data for critical errors for each server and background process.

Answer: D

赵:

ADR (Automatic Diagnostic Repository) ,ADR 是一个基于文件的资料档案库,用于存放数据库诊断数据(如跟踪、意外事件转储和程序包、预警日志、健康状况监视器报告、核心转储等)。它对存储在任何数据库外的多个实例和多种产品使用一个统一的目录结构。

ADR 根目录又称为 ADR 基目录,其位置由 DIAGNOSTIC_DEST 初始化参数设定。如果省略此参数或将其保留为空,数据库将在启动时按如下方式设置 DIAGNOSTIC_DEST:

如果已设置了环境变量 ORACLE_BASE,则将 DIAGNOSTIC_DEST 设置为$ORACLE_BASE。

如果未设置环境变量 ORACLE_BASE,则将 DIAGNOSTIC_DEST 设置为$ORACLE_HOME/log。

critical 关键的,严重的

目录
相关文章
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考试题库汇总(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考试题库汇总(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
|
SQL
OCP-052考试题库汇总(44)-CUUG内部解答版
Which two are true about external tables? A)They can be stored in an ASM Cluster File System(ACFS). B)They can always be updated using SQL.
8258 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
|
数据库 关系型数据库 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考试题库汇总(35)-CUUG内部解答版
Which two are true about Oracle Data Pump in Oracle Database 11g Release 2? A)If the directory used in the export operation has existing dump files, it overwrites them.
695 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
|
数据库
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:实例已经启动,进程和内存已经分配。
676 0