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

第1题：

A user reports that each day some files are deleted from the department share. The administrator needs to find who deleted these files.  Which of the following actions should the administrator perform？（）

• A、 Enable audit object access and specify files and folders to monitor using Task Manager.
• B、 Enable audit policy change and specify files and folders to monitor using Windows Explorer.
• C、 Enable audit object access and specify files and folders to monitor using Windows Explorer.
• D、 Open Performance Monitor and monitor folder activity.

第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题：

Which Oracle Database component is audited by default if the unified Auditing option is enabled?（）

• A、Oracle Data Pump
• B、Oracle Recovery Manager (RMAN)
• C、Oracle Label Security
• D、Oracle Database Vault
• E、Oracle Real Application Security

第4题：

You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? （）

• A、Library cache 
• B、Row cache
• C、Dictionary cache 
• D、Large area 
• E、Buffer cache

第5题：

In your production database， data manipulation language （DML） operations are executed on the SALES table.You have noticed some dubious values in the SALES table during the last few days. You are able to track users， actions taken， and the time of the action for this particular period but the changes in data are not tracked.You decide to keep track of both the old data and new data in the table along with the user information.  Whataction would you take to achieve this task（）

• A、Apply fine-grained auditing.
• B、Implement value-based auditing.
• C、Impose standard database auditing to audit object privileges.
• D、Impose standard database auditing to audit SQL statements.

第6题：

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.

第7题：

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.

第8题：

You are using the Database Configuration Assistant to configure your Oracle database. Which of the following terms pertains to the creation of an object from which creation of the other database can be based? （）

• A、Clone 
• B、Copy 
• C、Template 
• D、Terminal 

第9题：

You work as a database administrator for Certkiller .com. You enabled tracing while creating a listener to your database.  What additional information is available to you when you enable tracing？（）

• A、Information about each Oracle Net connection.
• B、Information about each entry in theLinstener.orafile
• C、Information about the changed done in the database
• D、Information about the different listeners in your system
• E、Information about all thenondatabasefiles required to operate the database

第10题：

You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?（） 

• A、V$DATABASE 
• B、DBA_TABLES 
• C、SYSAUD$ 
• D、EMP