多选题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 

第1题：

Identify three benefits of Unified Auditing.（）

• A、Decreased use of storage to store audit trail rows in the database.
• B、It improves overall auditing performance.
• C、It guarantees zero-loss auditing.
• D、The audit trail cannot be easily modified because it is read-only.
• E、It automatically audits Recovery Manager (RMAN) events.

第2题：

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.

第3题：

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.

第4题：

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.

第5题：

Which two statements are true about standard database auditing（）

• A、DDL statements can be audited.
• B、Statements that refer to stand-alone procedure can be audited.
• C、Operations by the users logged on as SYSDBA cannot be audited.
• D、Only one audit record is ever created for a session per audited statement even though it is executedmore than once.

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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

第14题：

Which two statements regarding a SQL profile are true？（）

• A、 It is built by Automatic Tuning Optimizer.
• B、 It cannot be stored persistently in the data dictionary.
• C、 It can be used by the query optimizer automatically.
• D、 It can be created manually by using the CREATE PROFILE command.

第15题：

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.

第16题：

Which three statements are true regarding the fine-grained 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.

第17题：

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

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：