2016年Oracle DBA审计数据库试题
Q. 1 : What feature in oracle allows you to monitor Suspicious Activity on the Datbase
1. Replication
2. Auditing
3. Monitoring
4. Tuning
Q. 2 : Auditing can be turned on by setting this parameter
1. DB_AUDIT_TRAIL
2. AUDIT_TRAIL
3. AUDIT_DB
4. None of the above
Q. 3 : What are the valid values for AUDIT_TRAIL Parameter
1. DB
2. OS
3. NONE
4. All of the above
Q. 4 : Where are the records stored if the following value is set in the PARAMETER file. "AUDIT_TRAIL=DB"
1. Database
2. Operating System File
3. Tape
4. None of the above
Q. 5 : Where is the audit information written to when the AUDIT_TRAIL parameter is set to NONE
1. Parameter File
2. Redo Log
3. OS File
4. Audit Trail is not turned on
Q. 6 : Which data dictionary object holds the information about audit codes and their associated names
1. AUDIT_INFO
2. DBA_AUDIT_INFO
3. AUDIT_ACTIONS
4. None of the above
Q. 7 : Audit Data is Stored in
1. SYS.X$AUDIT
2. SYS.V$AUD
3. $
4. None of the above
Q. 8 : Instance Startup Audit Records are Placed in
1.
2.
3. AUDIT_FILE_DEST
4. AUDIT_REC_DEST
Q. 9 : The db is running with Session audit and the audit table is full. What happens to new sessions
1. Nothing, They are not audited
2. New Connections are Not Allowed
3. Session allowed, with audit record to
4. None of the abvoe
Q. 10 : After Audit_Trail is set to NONE, the audit trail is disabled by
1. Restarting the Database
2. Disabling Restricted Mode
3. Grant Audit_trail to public
4. None of the above
Answer:
1=>2,
2=>2,
3=>4,
4=>1,
5=>4,
6=>3,
7=>3,
8=>3,
9=>2,
10=>1,
-
Oracle认证及其标准
Oracle认证是由Oracle公司,为能够满足对Oracle核心人士需求,Oracle公司颁布并实施的一项权威品的服务与支持。并具有娴熟的专业技术标准,它是专为认证那些有操作能力与广泛理论知识的专业人。Oracle认证证书只是让雇主了解到来应聘的人通过了Oracle数据库方面的技...
-
Oracle正则表达式汇集
Oracle10g数据库内建了符合IEEEPOSIX(PortableOperatingSystemforUnix)标准的正则表达式。熟练使用正则表达式,可以写出简洁,强大的SQL语句。正则表达式有几个优点优于常见的LIKE操作符和INSTR、SUBSTR及REPLACE函数的。这些传统的SQL函数不便于进行模式匹配。只...
-
oracle的sql语句
OracleWDP全称为OracleWorkforceDevelopmentProgram,是Oracle(甲骨文)公司专门面向学生、个人、在职人员等群体开设的职业发展力课程。下面是小编整理的关于oracle的sql语句,欢迎大家参考!首先,以超级管理员的身份登录oraclesqlplussys/bjsxtassysdba--然后,解除对...
-
Oracle数据库无响应故障处理方式
Oracle数据库无响应故障,简单地讲就是数据库实例不能响应客户端发起的请求,客户端提交一个SQL后,就一直处于等待数据库实例返回结果的状态。更严重的现象是客户端根本不能连接到数据库,发起一个连接请求后,一直处于等待状态。Oracle数据库无响应故障怎么处理呢?下面...