如果要对成功登录和退出数据库的操作进行审计，审计设置语句应如何写（）。A、AUDIT CONNECT WHENEVER NOT SUCCESSFULB、AUDIT CONNECT WHENEVER SUCCESSFULC、AUDIT LOGIN WHENEVER NOT SUCCESSFULD、AUDIT LOGIN WHENEVER SUCCESSFUL

第1题：

第2题：

第3题：

打开审计开关的操作是什么（）。

• A、ENABLE_AUDIT=0
• B、ENABLE_ENCRYPT=0
• C、ENABLE_AUDIT=1
• D、ENABLE_ENCRYPT=1

第4题：

When do you need to configure the P1 interface？（）

• A、 whenever you have an upstream proxy
• B、 whenever you intend to deploy the L4TM in blocking mode
• C、 whenever you want to enable the WSA proxy
• D、 whenever you have a separate management VLAN orsubnetwork

第5题：

AAA包括（）

• A、授权（Authorization）
• B、计费（Accounting）
• C、审计（Audit）
• D、认证（Authentication）

第6题：

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, SYSTEM
• B、SCOTT
• C、Only for successful executions
• D、Only for failed executions
• E、Both successful and failed executions

第7题：

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.

第8题：

Oracle中启用审计后，查看审计信息的语句是下面哪一个？（）

• A、select*fromSYS.AUDIT$
• B、select*fromsyslogins
• C、select*fromSYS.AUD$
• D、AUDIT SESSION

第9题：

桌面终端管理系统的审计账号为audit，利用audit账号不可以创建子审计账号。

第10题：

第11题：

第12题：

第13题：

第14题：

第15题：

使用SYSDBA权限进行连接的用户需要执行（）审计动作。

• A、将AUDIT—SYS-OPERATIONS实例参数设置为TRUE
• B、使用数据库来审计SYSDBA权限的使用
• C、首先将REMOTE—LOGIN—PASSWORDFILE实例参数设置为NONE，从而只能通过操作系统身份验证来生成SYSDBA连接。然后将AUDIT—TRAIL参数设置为OS，并且确保DBA无权进行审计追踪
• D、没有必要，具体SYSDBA权限的任何用户始终会跳过审计机制

第16题：

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 option
• B、The audit_log.so library does not exist
• C、The audit_log.so library is in a location that is different from that defined by the plugin_dir option
• D、The audit plugin must be loaded dynamically by using the INSTALL PLUGIN command
• E、The audit log file does not exist in which to write audit events
• F、The audit_log.so library is not an executable file

第17题：

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

第18题：

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.

第19题：

You execute the following command toauditdatabase activities：  SQL>AUDITDROP 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.

第20题：

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 GPO
• B、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 GPO
• C、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 GPO
• D、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

第21题：

第22题：

第23题：