如果要对成功登录和退出数据库的操作进行审计，审计设置语句应如何写（）。A、AUDIT CONNECT WHENEVER NOT SUCCESSFULB、AUDIT CONNECT WHENEVER SUCCESSFULC、AUDIT LOGIN WHENEVER NOT SUCCESSFULD、AUDIT LOGIN WHENEVER SUCCESSFUL
如果要对成功登录和退出数据库的操作进行审计，审计设置语句应如何写（）。
- A、AUDIT CONNECT WHENEVER NOT SUCCESSFUL
- B、AUDIT CONNECT WHENEVER SUCCESSFUL
- C、AUDIT LOGIN WHENEVER NOT SUCCESSFUL
- D、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
Consider the Mysql Enterprise Audit plugin. The following event detail is found in the audit log:Which two points can be concluded from the given event?() A.A connection as the user kate was successfulB.A connection failed due to authentication being unsuccessfulC.A connection was attempted via socket rather than TCPD.A connection was blocked by a firewall or a similar security mechanismE.A connection failed because the proxy user privileges did not match the login user
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
YouworkasadatabaseadministratorforCertkiller.com.Inyourdevelopmentenvironmentenvironment，thedevelopersareresponsibleformodifyingthetablestructureaccordingtotheapplicationrequirements.However，youwanttokeeptrackoftheALTERTABLEcommandsbeingexecutedbydevelopers，soyouenableauditingtoachievethisobjective.Whichtwoviewswouldyourefertofindouttheauditinformation？（）A.DBA_AUDIT_TRAILB.DBA_AUDIT_SESSIONC.DBA_FGA_AUDIT_TRAILD.DBA_COMMON_AUDIT_TRAIL
在oracle数据库里面检查审计配置命令的是() A.Show parameter REMOTE_LOGIN_PASSWORDFILEB.select * from v$versionC.show parameter 07_dictionary_accessibilityD.show parameter audit_trail
Oracle中如何设置audittrail审计，正确的说法是：（）A、在init.ora文件中设置“audit_trail=true”或者“audit_trail=db”B、以SYSDBA身份使用AUDITALLONSYS.AUD$BYACCESS，语句对audittrail审计C、Oracle不支持对audittrail的审计D、在设置audittrail审计前，要保证已经打开Oracle的审计机制
查看审计策略是否生效的视图是?() A. DBA_AUDIT_EXISTSB. DBA_AUDIT_OBJECTC. DBA_AUDIT_POLICY_COLUMNSD. DBA_AUDIT_POLICIESE. DBA_AUDIT_SESSION
Oracle中启用审计后,查看审计信息的语句是下面哪一个?() A.select*fromSYS.AUDIT$B.select*fromsysloginsC.select*fromSYS.AUD$D.AUDIT SESSION
使用SYSDBA权限进行连接的用户需要执行（）审计动作。A、将AUDIT—SYS-OPERATIONS实例参数设置为TRUEB、使用数据库来审计SYSDBA权限的使用C、首先将REMOTE—LOGIN—PASSWORDFILE实例参数设置为NONE，从而只能通过操作系统身份验证来生成SYSDBA连接。然后将AUDIT—TRAIL参数设置为OS，并且确保DBA无权进行审计追踪D、没有必要，具体SYSDBA权限的任何用户始终会跳过审计机制
When do you need to configure the P1 interface？（）A、 whenever you have an upstream proxyB、 whenever you intend to deploy the L4TM in blocking modeC、 whenever you want to enable the WSA proxyD、 whenever you have a separate management VLAN orsubnetwork
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
You execute the following command to audit database activities： SQL AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command（）A、One audit record is created for every successful DROP TABLE command executed in the session of SCOTT.B、One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to otherusers.C、One audit record is created for the whole session if user SCOTT successfully drops one or more tables inhis session.D、One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.E、One audit record is created for every successful DROP TABLE command executed by any user to drop Tables owned by SCOTT
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 execute the following PL/SQL:Which two statements are true?（）A、Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE 10000 is accessed.B、FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE 10000 is accessed.C、FGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column.D、FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.
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?（）A、One 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.B、One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.C、One 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.D、One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.E、One 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 execute the following command toauditdatabase activities： SQLAUDITDROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command（）A、Oneauditrecord is created for every successful DROP TABLE command executed in the session ofSCOTT.B、Oneauditrecord is generated for the session when SCOTT grants the DROP ANY TABLE privilege toother users.C、One audit record is created for the whole session if user SCOTT successfully drops one or more tablesin his session.D、One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.E、One audit record is created for every successful DROP TABLE command executed by any user to droptables owned by SCOTT.
Oracle中启用审计后，查看审计信息的语句是下面哪一个？（）A、select*fromSYS.AUDIT$B、select*fromsysloginsC、select*fromSYS.AUD$D、AUDIT SESSION
You need to design an audit strategy for Southbridge Video. Your solution must meet business requirements.What should you do？（）A、Create a new security template that enables the Audit account logon events policy for successful and failed attempts. Create a new GPO， and link it to the domain. Import the new security template into the new GPOB、Create a new security template that enables the Audit account logon events policy for successful and failed attempts. Create a new GPO， and link it to the Domain Controllers OU. Import the new security template into the new GPOC、Create a new security template that enables the Audit logon events policy for successful and failed attempts. Create a new GPO， and link it to the Domain Controllers OU. Import the new security template into the new GPOD、Create a new security template that enables the Audit logon events policy for successful and failed attempts. Create a new GPO， and link it to the domain. Import the new security template into the new GPO
单选题When do you need to configure the P1 interface？（）A whenever you have an upstream proxyB whenever you intend to deploy the L4TM in blocking modeC whenever you want to enable the WSA proxyD whenever you have a separate management VLAN orsubnetwork
单选题Oracle中启用审计后，查看审计信息的语句是下面哪一个？（）Aselect*fromSYS.AUDIT$Bselect*fromsysloginsCselect*fromSYS.AUD$DAUDIT SESSION
多选题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
多选题Oracle中如何设置audittrail审计，正确的说法是：（）A在init.ora文件中设置“audit_trail=true”或者“audit_trail=db”B以SYSDBA身份使用AUDITALLONSYS.AUD$BYACCESS，语句对audittrail审计COracle不支持对audittrail的审计D在设置audittrail审计前，要保证已经打开Oracle的审计机制