You work as a database administrator at Certkiller .com. In your production database there is a job， CALC_STAT， which has been scheduled to run every Friday at 5.00 p.m. CALC_STATupdates the optimizer statistics for the objects owned by the APPSschema. Yo

第1题：

You work as a database administrator for Certkiller .com. In your production  database， the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database， you want to accomplish this task with no impact on the user’s connections.  Which activity must you have completed before accomplishing this task？（）

• A、You must have started the database instance in restricted mode.
• B、You must have started the database instance inNORMALmode.
• C、You must have started the database instance with server parameter file.
• D、You must have started the database instance but must not have mounted.
• E、You must have started the database instance but must not have opened.

第2题：

You work as a database administrator for Certkiller .com. In your database server， the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What would this setting achieve？（）

• A、It degrades the run time and compiler performance.
• B、It provides better run time and compiler performance.
• C、It provides better optimization of the statement during parse time.
• D、It forces the rule based optimizer to be used for statement optimization.
• E、It provides better run time performance but slightly degraded compiler performance. 
• F、It provides better run time performance but slightly degraded run time performance.

第3题：

You work as a database administrator for Certkiller .com. Users complain that their query is taking a long time to complete. You suspect the database buffer cache size to be the reason， and you define an alert to be generated when the buffer cache hit metric goes below 85%. When you observe the dynamic performance views， you find that the buffer cache hit ratio is 81% but no alerts are being generated.  What could be the reason for this problem？（）

• A、The advisory memory has been turned off.
• B、The DB_CACHE_ADVICE parameter has been set to OFF in the parameter file.
• C、The STATISTICS_LEVEL parameter has been set to BASIC in the parameter file.
• D、The TIMED_STATISTICS parameter has been set to FALSE in the parameter file.
• E、The STATISTICS_LEVEL parameter has been set to TYPICAL in the parameter file.

第4题：

You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database.  Which method would you use to recover the data file？（）

• A、Restore all the data files and open the database
• B、Create the data file and performtablespacerecovery
• C、No need to restore any file， just recover the database
• D、Restore only the system data file and recover the database
• E、Restore only lost date file and performtablespacerecovery

第5题：

You work as a database administrator for Certkiller .com. Users in the Certkiller .com PROD database complain about the slow response of transactions. While investigating the reason you find that the transactions are waiting for the undo segments to be available， and undo retention has been set to zero. What would you do to overcome this problem？（）

• A、Increase the undo return
• B、Create more undo segments
• C、Create another undotablespace
• D、Increase the size of the undotablespace

第6题：

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

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第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 want to configure database backups to be run automatically.  Which tool or utility would you use to achieve this？ （）

• A、The DBMS_JOB package
• B、The BACKUP_JOB package
• C、The DBMS_BACKUP_RESTORE package
• D、The calendar tool in the Operating System （OS）
• E、The backup scheduler in Enterprise Manager （EM）
• F、The DBMS_BACKUP_SCHEDULER packager inline mode

第15题：

You work as a database administrator for Certkiller .com. In the Certkiller PRODUCTION database you have granted RESUMABLE system privilege to the CONNECT role.Resumablespace operation has been enabled for all user session. You want users NOT to be aware of any kind of space-related problems while performing transactions. Instead， you want the problem to be resolved by a database trigger automatically. Which combination of triggering time and event would you use to achieve this objective？（）

• A、AFTER CREATE
• B、AFTER SUSPEND
• C、BEFORE CREATE
• D、AFTER TRUNCATE
• E、BEFORE SUSPEND
• F、AFTER INSERT OR DELETE OR DELETE
• G、BEFORE INSERT OR DELETE OR DELETE

第16题：

You work as a database administrator for Certkiller .com. While loading data into the Certkiller STAFF table using Oracle Enterprise Manager 10g Database Control， you find the status of the job as failed. On further investigation， you find the following error message in the output log： ORA-01653 unable to extend table HR. Certkiller STAFF by 8 intablespaceUSERS Which task would you perform to load the data successfully without affecting the users who are accessing the table？（）

• A、Restart the database instance and run the job
• B、Truncate the Certkiller STAFF table and run the job
• C、Delete all rows from the Certkiller STAFF table and run the job
• D、Increase the size of the USERStablespacethe and run the job
• E、Increase the size of the database default permanenttablespaceand run the job

第17题：

You work as a database administrator at Certkiller .com. In your production database， you observe that users’ transactions are consuming a lot of resource and you plan to impose resource restrictions by using Resource Manager. For which three resources can you enable usage restrictions by using Resource Manager？ （）

• A、 CPU usage
• B、 degree of parallelism
• C、 number of open cursors
• D、 number of sorts performed
• E、 idle time for blocking sessions
• F、 number of disk I/O operations performed
• G、 number of memory I/O operations performed

第18题：

You work as a database administrator for Certkiller .com. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）

• A、Database Control
• B、Management Server
• C、Management Repository
• D、Application Server Control
• E、Oracle Management Agent

第19题：

第20题：

第21题：

第22题：

第23题：