简述Audit的功能.
简述Audit的功能.
相关考题:
6 Discuss how developments in each of the following areas has affected the scope of the audit and the audit workundertaken:(a) fair value accounting; (6 marks)
(c) Explain the possible impact of RBG outsourcing its internal audit services on the audit of the financialstatements by Grey Co. (4 marks)
You enabled an audit policy by issuing the following statements:SQL AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT;SQL AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;For which database users and for which executions is the audit policy now active? ()A. SYS, SYSTEMB. SCOTTC. Only for successful executionsD. Only for failed executionsE. Both successful and failed executions
You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.You issue the following statements:SQL AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;SQL AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;SQL AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;For which database users is the audit policy now active?()A. All users except SYSB. All users except SCOTTC. All users except sys and SCOTTD. All users except sys, system, and SCOTT
YouworkasadatabaseadministratorforCertkiller.com.Inyourdevelopmentenvironmentenvironment,thedevelopersareresponsibleformodifyingthetablestructureaccordingtotheapplicationrequirements.However,youwanttokeeptrackoftheALTERTABLEcommandsbeingexecutedbydevelopers,soyouenableauditingtoachievethisobjective.Whichtwoviewswouldyourefertofindouttheauditinformation?()A.DBA_AUDIT_TRAILB.DBA_AUDIT_SESSIONC.DBA_FGA_AUDIT_TRAILD.DBA_COMMON_AUDIT_TRAIL
查看审计策略是否生效的视图是?() A. DBA_AUDIT_EXISTSB. DBA_AUDIT_OBJECTC. DBA_AUDIT_POLICY_COLUMNSD. DBA_AUDIT_POLICIESE. DBA_AUDIT_SESSION
如果要对成功登录和退出数据库的操作进行审计,审计设置语句应如何写()。A、AUDIT CONNECT WHENEVER NOT SUCCESSFULB、AUDIT CONNECT WHENEVER SUCCESSFULC、AUDIT LOGIN WHENEVER NOT SUCCESSFULD、AUDIT LOGIN WHENEVER SUCCESSFUL
Consider the MySQL Enterprise Audit plugin, You add the following lines to the my.cnf configuration tile: [mysqld] Plugin-load=audit_log.so Audit-log=FORCE_PLUS_PERMANENT You attempt to start up the MySQL service and notice that it fails to start. Which two statements would explain why the service did not start?()A、FORCE_PLUS_PERMANENT is not valid for the audit-log optionB、The audit_log.so library does not existC、The audit_log.so library is in a location that is different from that defined by the plugin_dir optionD、The audit plugin must be loaded dynamically by using the INSTALL PLUGIN commandE、The audit log file does not exist in which to write audit eventsF、The audit_log.so library is not an executable file
For which two of these purposes are Cisco Spectrum Expert used?()A、audit VoWLAN cell edge coverageB、verify RFID tag coverage by four access points at -75 dBmC、audit microwave oven interferenceD、audit 802.11a channel 36 utilizationE、create test scripts for 802.11n bonded channel throughput tests
You enabled an audit policy by issuing the following statements: SQL AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT; SQL AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM; For which database users and for which executions is the audit policy now active? ()A、SYS, SYSTEMB、SCOTTC、Only for successful executionsD、Only for failed executionsE、Both successful and failed executions
You need to identify each help desk user who bypasses the new corporate security policy. What should you do?()A、Configure Audit Special Logon and define Special Groups.B、Configure Audit Other Privilege Use Events and define Special Groups.C、Configure Audit Sensitive Privilege Use and configure auditing for the HelpDesk group.D、Configure Audit Object Access and modify the auditing settings for the HelpDesk group.
多选题You work as a database administrator for Certkiller .com. In your development environmentenvironment, the developers are responsible for modifying the table structure according to the application requirements. However, you want to keep track of the ALTER TABLE commands being executed by developers, so you enable auditing to achieve this objective. Which two views would you refer to find out the audit information?()ADBA_AUDIT_TRAILBDBA_AUDIT_SESSIONCDBA_FGA_AUDIT_TRAILDDBA_COMMON_AUDIT_TRAIL
单选题You execute the following commands to audit database activities: SQL ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE; SQL AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL; Which statement is true about the audit record that generated when auditing after instance restarts?()AOne audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.BOne audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.COne audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.DOne audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.EOne audit record is created for the whole session if john successfully executes a SELECT, INSERT,or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.
多选题You enabled an audit policy by issuing the following statements: SQL AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT; SQL AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM; For which database users and for which executions is the audit policy now active? ()ASYS, SYSTEMBSCOTTCOnly for successful executionsDOnly for failed executionsEBoth successful and failed executions
单选题You execute the following command to audit the database activities: SQL AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL; What is the effect of this command?()AOne audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.BOne audit record is created for every session when any user successfully drops a table owned by SCOTT.COne audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.DOne audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.EOne audit record is created for each successful DROP TABLE command executed in the session of SCOTT.
多选题Which three statements are true regarding the fine-grained auditing (FGA)?()AFGA is possible on SELECT statements only.BThe audit trail for FGA is stored in the FGA_LOG$ table.CThe audit trail for FGA is stored in the AUD_LOG$ table.DFGA enables a SQL predicate to define when to audit an event.EFGA audits DELETE statements only when audit columns are specified.FFGA includes the SQL statement used by the user as part of the audit event entry.
单选题Your network contains an Active Directory domain. All servers run Windows Server 2008 R2. You need to audit the deletion of registry keys on each server. What should you do()AFrom Audit Policy, modify the Object Access settings and the Process Tracking settings.BFrom Audit Policy, modify the System Events settings and the Privilege Use settings.CFrom Advanced Audit Policy Configuration, modify the System settings and the Detailed Tracking settings.DFrom Advanced Audit Policy Configuration, modify the Object Access settings and the Global Object Access Auditin
多选题Consider the MySQL Enterprise Audit plugin, You add the following lines to the my.cnf configuration tile: [mysqld] Plugin-load=audit_log.so Audit-log=FORCE_PLUS_PERMANENT You attempt to start up the MySQL service and notice that it fails to start. Which two statements would explain why the service did not start?()AFORCE_PLUS_PERMANENT is not valid for the audit-log optionBThe audit_log.so library does not existCThe audit_log.so library is in a location that is different from that defined by the plugin_dir optionDThe audit plugin must be loaded dynamically by using the INSTALL PLUGIN commandEThe audit log file does not exist in which to write audit eventsFThe audit_log.so library is not an executable file
单选题Consider the MySQL Enterprise Audit plugin. On attempting to start the MySQL service after a crash, notice the following error: [ERROR] Plugin ‘audit_log’ init function returned error. In the audit log file, you notice the final entry: … What action should you take to fix the error and allow the service to start?()A Re-install the audit pluginB Execute the command FLUSH LOGSC Execute the command SET GLOBAL audit_log_fiush= OND Move or rename the existing audit.log file
问答题AuditTests此项任务主要完成何种功能?对BSC,BTS,TSC分别可以做哪几种Audit?什么情况下,OMC_R会自动做Audit?