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.

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.

C)Audit of the use of system privileges can be enabled for individual database users.

D)DDL statements can be audited when they fail to execute.

E)All Oracle auditing operations occur by default.

F)DML statements can be audited when they execute successfully.

Answer: CDF

赵:

标准数据库审计分为三个级别:

1.语句审计,特点是执行成功或不成功都可审计。

2.权限审计。

3.对象审计。

A 错,审计 sys 用户的打开数据库操作时,数据库还是关闭着的。

B 错,审计参数 audit_trail 为 db 时,将审计结果记录在数据库;参数为 os 时,审计结果放在由audit_file_dest 指定的操作系统的目录中。

C 译:可为个别数据库用户启用对系统特权使用情况的审计。

C 是权限审计,D 和 F 是语句审计。

E 译:默认情况下,所有 Oracle 审计操作都会发生。错。

目录
相关文章
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 ...
2827 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
|
数据库 存储
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.
739 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
|
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考试题库汇总(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 ...
708 0
|
Oracle 关系型数据库
OCP-052考试题库汇总(30)-CUUG内部解答版
Which two are true about the Inventory directory? A)It is shared by all Oracle software installations on a single server.
658 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
|
Oracle 关系型数据库 数据库
OCP-052考试题库汇总(28)-CUUG内部解答版
Archivelog mode is enabled for your database and DB_CREATE_FILE_DEST is set to ‘/u01/oracle/db01’. The parameters, DB_CREATE_ONLINE_LOG_DEST_n and DB_RECOVERY_FILE_DEST, and not specified.
611 0