单选题To make audit information more productive， the DBA executes the following command before starting an auditoperation： SQL> ALTER SYSTEM SET AUDIT_TRAIL=DB，EXTENDED SCOPE=SPFILE； Which statement is true regarding the audit record generated when auditing 

第1题：

Which two statements are true regarding the SQL Repair Advisor？（） 

• A、 The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.
• B、 The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.
• C、 The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement.
• D、 The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.

第2题：

The SAVE_AMT column in the ACCOUNTS table contains the balance details of customers in a bank. As part of the year/x7fend tax and interest calculation process， all the rows in the table need to be accessed. The bank authorities want to track access to the rows containing balance amounts exceeding $200，000， and then send an alert message to the administrator.  Which method would you suggest to the bank for achieving this task？（）

• A、implementing value­based auditing by using triggers
• B、implementing fine­grained auditing with audit condition and event handler
• C、performing standard database auditing to audit object privileges by setting the AUDIT_TRAIL parameter to EXTENDED
• D、performing standard database auditing to audit SQL statements with granularity level set to ACCESS

第3题：

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？（）

• A、One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.
• B、One audit record is created for every session when any user successfully drops a table owned by SCOTT.
• C、One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.
• D、One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.
• E、One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.

第4题：

You are working as a DBA in an organization. The flash recovery area files are created in ’+disk1’. You want to create new flash recovery area files in the ’+disk2’ location. The new location of the flash recovery area files should be written in the control file and the spfile.Which command will you issue to change the location of the flash recovery area files？（）  

• A、 ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = ’+disk2’ ；
• B、 ALTER SYSTEM SET DB_RECOVER_FILE_DEST = ’+disk2’ SCOPE = BOTH；
• C、 ALTER SYSTEM SET DB_CREATE_FILE_DEST = ’+disk2’；
• D、 ALTER SYSTEM SET DB_CREATE_ONLINE_LOG_DEST_n = ’+disk2’；

第5题：

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.

第6题：

You decided to increase the value for the SHARED_SERVERS parameter by using the following command：  SQL> ALTER SYSTEM SET SHARED_|SERVERS=3 SCOPE=？；  Which three values can be specified for the SCOPE clause？（）

• A、ALL
• B、PFILE
• C、BOTH
• D、NONE
• E、SPFILE
• F、MEMORY
• G、INSTANCE
• H、DATABASE

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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

第14题：

You installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database？（） 

• A、 The audit trail is stored in an operating system file.
• B、 Auditing is disabled for all privileges.
• C、 The audit trail is stored in the database.
• D、 Auditing is enabled for all privileges.
• E、 Auditing is enabled for certain privileges related to database security.

第15题：

Which three statements are true regarding the fine/x7fgrained auditing （FGA）？（）

• A、FGA is possible on SELECT statements only.
• B、The audit trail for FGA is stored in the FGA_LOG$ table.
• C、The audit trail for FGA is stored in the AUD_LOG$ table.
• D、FGA enables a SQL predicate to define when to audit an event.
• E、FGA audits DELETE statements only when audit columns are specified.
• F、FGA includes the SQL statement used by the user as part of the audit event entry.

第16题：

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.

第17题：

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.

第18题：

he DBA is about to enable auditing on the Oracle database in an attempt to discover some suspicious activity. Audit trail information is stored in which of the following database object names?（）

• A、SYS.SOURCE$ 
• B、SYS.AUD$ 
• C、DBA_SOURCE 
• D、DBA_AUDIT_TRAIL

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：