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

第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. 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

第3题：

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

第4题：

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. You want the task to be generic， thereby allowing users to modify the attributes of the task at run time without affecting the original task.Which component of Oracle Scheduler must you define to achieve this？（）

• A、 Window
• B、 Program
• C、 Job class
• D、 Window group

第5题：

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

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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

第14题：

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

第15题：

Manually， you set the consumer group of all of the newly created users to MYDB_GRP. You want the users to be able to change their consumer groups as per the application requirement. What was the first step that was needed in the process to achieve this objective？（）

• A、 The user must have been granted the DBA role.
• B、 The user must have been granted the switch privilege as a part of a role.
• C、 The user must have been granted the Resource Manager administrator privilege.
• D、 The user must have been granted the switch privilege by using the DBMS_RESOURCE_MANAGER_PRIVS package.

第16题：

You work as a database administrator for Certkiller .com. In a production environment， users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response？（）

• A、The trace file
• B、The fixed views
• C、The data dictionary views
• D、The operating system log fields
• E、The dynamic performance views.

第17题：

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：