39.Which two statements are true about standard database auditing? (Choose two.)
来源:互联网 发布:svd分解算法步骤 编辑:程序博客网 时间:2024/06/05 18:01
39.Which two statements are true about standard database auditing? (Choose two.)
A.DDL statements can be audited
B.Statements that refer to stand-alone procedure can be audited.
C.Operations by the users logged on as SYSDBA cannot be audited.
D.Only one audit record is ever created for a session per audited statement even though it is executed more than once.
答案:AB
解析:
A:正确,DDL肯定是可以审计的
SQL> audit create table;
Audit succeeded.
SQL> create table test(id integer);
Table created.
SQL>select username,extended_timestamp,audit_option from user_audit_trail where audit_option='CREATE TABLE';
USERNAME EXTENDED_TIMESTAMP AUDIT_OPTION
---------- ----------------------------------- ---------------
SCOTT 16-JUL-16 11.59.48.724025 PM +08:00 CREATE TABLE
B:正确
审计与过程还是触发器还是单条语句没有什么关系
C:错误
这个sysdba登陆其实与开不开审计没啥关系,都会捕获的,只是会写到操作系统文件中
SQL> show parameter audit
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string /u01/oracle/admin/wahaha3/adum
p
audit_sys_operations boolean FALSE
audit_syslog_level string
audit_trail string NONE
--这里审计是关闭的
[oracle@wahaha3 adump]$ rm /u01/oracle/admin/wahaha3/adump/* --先删除对应的文件
[oracle@wahaha3 adump]$ sqlplus / as sysdba --sysdba登陆
SQL> !ls /u01/oracle/admin/wahaha3/adump
wahaha3_ora_3219_1.aud
SQL> ! cat /u01/oracle/admin/wahaha3/adump/wahaha3_ora_3219_1.aud
Sun Jul 17 04:16:35 2016 +08:00
LENGTH : '160'
ACTION :[7] 'CONNECT'
DATABASE USER:[1] '/'
PRIVILEGE :[6] 'SYSDBA'
CLIENT USER:[6] 'oracle'
CLIENT TERMINAL:[5] 'pts/0'
STATUS:[1] '0'
DBID:[10] '1264556381'
D:这个肯定是错误,如果增加 by session的话,那就是在相同的会话中对同类语句只进行一次审计
A.DDL statements can be audited
B.Statements that refer to stand-alone procedure can be audited.
C.Operations by the users logged on as SYSDBA cannot be audited.
D.Only one audit record is ever created for a session per audited statement even though it is executed more than once.
答案:AB
解析:
A:正确,DDL肯定是可以审计的
SQL> audit create table;
Audit succeeded.
SQL> create table test(id integer);
Table created.
SQL>select username,extended_timestamp,audit_option from user_audit_trail where audit_option='CREATE TABLE';
USERNAME EXTENDED_TIMESTAMP AUDIT_OPTION
---------- ----------------------------------- ---------------
SCOTT 16-JUL-16 11.59.48.724025 PM +08:00 CREATE TABLE
B:正确
审计与过程还是触发器还是单条语句没有什么关系
C:错误
这个sysdba登陆其实与开不开审计没啥关系,都会捕获的,只是会写到操作系统文件中
SQL> show parameter audit
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string /u01/oracle/admin/wahaha3/adum
p
audit_sys_operations boolean FALSE
audit_syslog_level string
audit_trail string NONE
--这里审计是关闭的
[oracle@wahaha3 adump]$ rm /u01/oracle/admin/wahaha3/adump/* --先删除对应的文件
[oracle@wahaha3 adump]$ sqlplus / as sysdba --sysdba登陆
SQL> !ls /u01/oracle/admin/wahaha3/adump
wahaha3_ora_3219_1.aud
SQL> ! cat /u01/oracle/admin/wahaha3/adump/wahaha3_ora_3219_1.aud
Sun Jul 17 04:16:35 2016 +08:00
LENGTH : '160'
ACTION :[7] 'CONNECT'
DATABASE USER:[1] '/'
PRIVILEGE :[6] 'SYSDBA'
CLIENT USER:[6] 'oracle'
CLIENT TERMINAL:[5] 'pts/0'
STATUS:[1] '0'
DBID:[10] '1264556381'
D:这个肯定是错误,如果增加 by session的话,那就是在相同的会话中对同类语句只进行一次审计
0 0
- 39.Which two statements are true about standard database auditing? (Choose two.)
- 50.Which two statements are true about alerts? (Choose two.)
- 65.Which two statements are true about checkpointing? (Choose two.)
- 45.Which two statements are true about sequences created in a single instance database? (Choose two.
- 19.Which two statements about the background process of the database writer are true? (Choose two.)
- 46.Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two
- 053-4 Which two statements about the SQL Management Base (SMB) are true? (Choose two.)
- 108 Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.) A.
- 142 Which two statements are true about encrypting RMAN backup? (Choose two.) A. The transparent enc
- 15.Which two statements are true about Shared SQL Area and Private SQL Area? (Choose two.)
- 27.Which two statements are true regarding transactions in an Oracle database? (Choose two.)
- 35.Which two statements are true regarding constraints? (Choose two.)
- 38.Which two statements are true regarding views? (Choose two.)
- 41.Which two statements are true regarding views? (Choose two.)
- 48.Which two statements are true regarding indexes? (Choose two.)
- 133.Which two statements are true regarding subqueries? (Choose two.)
- 175.Which two statements are true regarding savepoints? (Choose two.)
- 130.Which two statements are true regarding listeners? (Choose two.)
- text
- 2016 多校联赛 第一场 HDU 5726 GCD
- When should I use shutdown()?
- Android-transulcent-status-bar
- 制定销售和现金流量计划
- 39.Which two statements are true about standard database auditing? (Choose two.)
- C# ListView用法详解
- Git-Git基础
- Android基础-- 利用handler发送消息报:"This message is already in use"解决办法
- TG(提高篇)第15讲 实践项目 简单银行系统(函数篇)
- Python 处理config.ini文件
- [2016/7/20][usaco 2.1]Hamming Codes
- Codeforces 698C. Fix a Tree (并查集)
- 图片的高斯模糊