Your database is functional with a peak load for the last one hour. You want to preserve theperformance statistics collected during this period to be used for comparison when you analyze theperformance of the database in the future.  What action would yo

第1题：

You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance， you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data， you want to have minimal impact on the database performance and optimize the dataload operation.  Which method would you use to load data into the Oracle database（）

• A、Use the external table population.
• B、Use the Oracle Data Pump export and import utility.
• C、Use the conventional path data load of the SQL*Loader utility.
• D、Use the INSERT INTO...SELECT command to load the data

第2题：

The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future. What would you do?（）

• A、Create two custom ADDM tasks.
• B、Modify the AWR snapshot time interval to two hours.
• C、Create a new scheduler window for a time period of two hours.
• D、Modify the Automatic Workload Repository (AWR) snapshot retention period to two hours.

第3题：

If you create your database using Oracle Managed Files （OMF）， what is true？（）

• A、You must use Oracle predefined names to identify raw partitions that will hold OMF structures. 
• B、You must define directories for two online redo log groups and three copies of the control file. 
• C、If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically. 
• D、You must use only OMF data files when adding new tablespaces or data files to your database in the future.

第4题：

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.

第5题：

You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）

• A、 The time when the last flashback operation in your database was performed.
• B、 The time when the first flashback operation in your database was performed.
• C、 A list of flashback operations performed in your database using SCN and time.
• D、 The approximate time and the lowest system change number （SCN） to which you can flash back your database.

第6题：

You executed the following query in your database：  FROM V$FLASHBACK_DATABASE_LOG;  What would you determine from the output？（）

• A、the time when the last flashback operation in your database was performed
• B、the time when the first flashback operation in your database was performed
• C、a list of flashback operations performed in your database using SCN and time
• D、the approximate time and the lowest system change number （SCN） to which you can flash back your database

第7题：

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

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

第8题：

In your Oracle 10g database ， you have scheduled a job to update the optimizer statistics at 05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）

• A、average row size
• B、last analyzed date
• C、size of table in bytes
• D、size of table in database blocks
• E、number of free blocks in the free list
• F、number of extents present in the table

第9题：

第10题：

第11题：

第12题：

You find today’s performance of your production database to be the best ever. Therefore， you want to be notified in the future whenever the performance degrades by 10% of today’s performance. What is the first step that you would take to ensure this？（）

• A、create baseline metrics for today’s performance
• B、write the current database metrics to a database table and create a trigger to compare with future database statistics
• C、write the current database metrics to a flat file and create an operating script to compare with future database statistics
• D、write the current database metrics to a database table and create a procedure to compare with future database statistics
• E、write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics

第13题：

You work as a database administrator for Certkiller .com. In your transaction application， you have scheduled a job to update the optimizer statistics at05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）

• A、Average row size
• B、Last analyzed date
• C、Size of table in bytes
• D、Size of table in database blocks
• E、Number of free blocks in the free list
• F、Number of extents present in the table.

第14题：

You work as a database administrator for Certkiller .com. You have set the retention period for Automatic Repository （AWR） statistics to four days and collection interval to 15 minutes. You want to view the statistics collected and stored in AWR snapshot. Which two methods would you use to view the AWR statistics？（）

• A、use enterprise manager
• B、use DBMS_SQL package
• C、use DBMS_AWR package
• D、use PRVT_WORKLOAD package
• E、query the AWR snapshot repository objects
• F、use DBMS_WORKLOAD_REPOSITORY package

第15题：

You are using flat files as the data source for one of your data warehousing applications. To optimizethe application performance， you plan to move the data from the flat files toclustered tablesin an Oracle database.  While migrating the data， you want to have minimal impact on the database performance and optimize thedata load operation. Which method would you use to load data into the Oracle database（）

• A、Use the external table population.
• B、Use the Oracle Data Pump export and import utility.
• C、Use the conventional path data load of the SQL*Loader utility.
• D、Use the INSERT INTO...SELECT command to load the data.

第16题：

You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data， you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database？（）

• A、use the external table population
• B、use the Oracle Data Pump export and import utility
• C、use the conventional path data load of SQL*Loader utility
• D、use the direct path data load of Oracle export and import utility

第17题：

Your database is functional with a peak load for the last one hour. You want to preserve the performancestatistics collected during this period to be used for comparison when you analyze the performance of thedatabase in the future.  What action would you take to achieve this task（）

• A、Insert finding directives for ADDM tasks in the future.
• B、Create a baseline on a pair of snapshots spanning the peak-load period.
• C、Decrease the snapshot interval in the AWR to collect more snapshots during the peak- load period.
• D、Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid automaticpurging of snapshots

第18题：

Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of thedatabase in the future. What action would you take to achieve this task？（）

• A、Set the STATISTICS_LEVEL initialization parameter to ALL.
• B、Create a baseline on a pair of snapshots that have the statistics of the peak-load period in the database.
• C、Decrease the snapshot interval in the AWR to collect more number of snapshots during the peak-load period.
• D、Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid the automatic purging of the snapshots.

第19题：

You want to monitor and control the resource usage by sessions. You want to be warned automatically when more than 100 sessions are opened with your database. What action would you take to achieve this？（）

• A、Use the Database Resource Manager.
• B、Set the limits in the profiles used by users.
• C、Modify the SESSIONS initialization parameter.
• D、Set the warning threshold for the Current Logons Count metric.

第20题：

第21题：