数据岸审记试题选 宽源介绍：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_ALDIT_TRAIL 2 AUDIT_TRAIL 3.AUDIT_DB 4.None of the above Q.3 What are the valid values for AUDIT TRAIL Paraneter 1.DB 205 3.NONE 4.All of the above Q.4 Where are the records stored if the following value is set in the PARAMETER fiIe."AUDIT_TRAIL-阳 1.Database 2 Operating Systen File 3.Tape 4.None of the abowe Q.5:Where is the audit information written to whes the AUDIT_TRAIL paraneter is set to NONE 1.Parameter File 2.Redo Log 3.0S File 4.Audit Trail is not turned on
数据库审记试题选 资源介绍：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
Q6:Which data dictionary objeet 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.XSAUDIT 2.SYS.VSAUD 3.SYS.ADS 4.None of the above Q.8 Instance Startup Audit Records are Placed in 1.ALERT.LOG 2.USER TRC 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 alert.log 4.None of the abvoe Q.10 After Audit_Trail is set to NOME,the audit trail is disabled hy 1.Restarting the Dutabase 2.Disabling Restricted Mode 3.Grant Audit_trail to public 4.None of the above Answer: 1-22. 2=>2
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. SYS.AUD$ 4. None of the above Q. 8 : Instance Startup Audit Records are Placed in 1. ALERT.LOG 2. USER.TRC 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 alert.log 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-94, 41, 5->0. 6->3, 7=>3 8->8, 9=>2
3=>4, 4=>1, 5=>4, 6=>3, 7=>3, 8=>3, 9=>2