The production database has been functional for the last seven days. Because of application requirements， some of the initialization parameters were changed during run time without any comments. You have asked to find out the value of the parameters when 

第1题：

You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Thursday morning， you find that an important table has been dropped and purged. With reference to this scenario， up to what point in time can the data be recovered？（）

• A、 until Thursday morning
• B、 until that point in time when the database is opened
• C、 until that point in time when the recovery is performed
• D、 until last Sunday’s backup
• E、 until that point in time when the table is dropped and purged
• F、 until Wednesday evening

第2题：

You are the network administrator for The network consists of a single Active Directory domain named All network servers run Windows Server 2003. All 3,500 user accounts are located in the default Users container. All user accounts have their Department attribute values set to the appropriate employee department. The network engineer creates an OU structure for the domain, based on the Testking's departments. You need to place all user accounts that have the Departmetn attribute set to Sales in the Sales OU. Because of time constraints, you need to automate this process. Which two actions should you perform? （）(Each correct answer presents part of the solution. Choose two.)

• A、Run the dsmod command with the appropriate parameters.
• B、Run the dsget command with the appropriate parameters.
• C、Run the dsquery command with the appropriate parameters.
• D、Run the dsmove command with the appropriate parameters.
• E、Run the dsrm command with the appropriate parameters.
• F、Run the find command with the appropriate parameters.

第3题：

WebSphere Commerce has been successfully installed and tested.  WebSphere Commerce Analyzer has been installed and the extraction programs have run with no errors but there is no data in any reports when viewed from the WebSphere Commerce Accelerator.  What could be the cause of this problem？（）

• A、The WebSphere Commerce application server was not started
• B、The web server was not started
• C、SSL has not been configured on the web server
• D、The appropriate listeners were not enabled in Configuration Manager
• E、The database server was not started

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

Initially， for the Automatic Workload Repository （AWR） statistics， the retention period is set to 7 days， the collection interval is set to 30 minutes and the collection level is set to Typical in your production database.  You have been using the Memory Advisor for the last three months to generate recommendations for tuning memory components. However， when you observe the Memory Advisor on a Friday， you find that the statistics are available only for two days， Thursday and Friday， of that week.  What would have caused the statistics to be removed？（）

• A、On Wednesday， the statistics have been purged.
• B、On Wednesday， the retention period has been set to zero.
• C、On Wednesday， the collection interval has been set to zero.
• D、On Wednesday， the collection level has been changed to All.
• E、On Wednesday， the retention period has been set to one day.
• F、On Wednesday， the retention period has been set to two days.
• G、On Wednesday， the collection level has been changed to Typical.
• H、On Wednesday， the collection interval has been set to 1440 minutes.

第6题：

You are part of the DBA team working for a multinational bank. The team is responsible for performing administrative tasks on the database server located at the home office. The database server at the home office has a production database and a test database named TESTDB. The test database is primarily used for testing database commands and configuration settings befor implementing these settings on the production database. The test database is also used for the development of database applications. You have been asked by the senior DBA to grant the SYSDBA privilege to a new team member， John， so that he can perform some administrative tasks， such as shutdown and startup operations， on TESTDB. You use the password file to configure remote authentication on the TESTDB database. You execute the following statement to grant the SYSDBA privilege to John：   SQL>GRANT SYSDBA TO john；   However， you receive the following error：   ORA-01996： GRANT failed： password file   ’c：/oracle/ora9i/dbs/testdb.pwd’ is full   Which action should you take to add the user john to the password file without removing any of the existing users？（）

• A、 Create another password file and then re-execute the GRANT statement.
• B、 Re-create the password file， specifying a larger number of allowed entries， and then re-execute the GRANT statement.
• C、 Change the value of the REMOTE_LOGIN_PASSWORDFILE initialization parameter in theinitialization parameter file to NONE and then re-execute the GRANT statement.
• D、 Change the value of the REMOTE_LOGIN_PASSWORDFILE initialization parameter in the initialization parameter file to SHARED and then re-execute the GRANT statement.

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

You are the network administrator for Testking.com. The TestKing network contains seven application servers. Each application server runs a database application named TestKingApp. Requirements for TestKingApp state that when you add a new user, you must add the user to the server that has the most available disk space. You need to ensure that you meet the requirements when you add new users to TestKingApp. What should you do?（）

• A、Use Event Viewer to review the application logs on each of the seven servers.
• B、Use Performance Logs and Alerts to record the PhysicalDisk object on all seven servers.
• C、Use Task Manager to view the performance data on each of the seven servers.
• D、Use System Monitor to generate a histogram view of the LogicalDisk object on all seven servers.

第9题：

第10题：

第11题：

第12题：

第13题：

A customer reports the optical drive is no longer responding. Which of the following questionsshould be asked FIRST?（）

• A、“Did you log in with an administrator account?”
• B、“Have you been to any inappropriate websites?”
• C、“What have you changed since the optical drive worked properly?”
• D、“What has changed since the optical drive worked properly?”

第14题：

You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem？（）

• A、 Increase the value of the FAST_START_MTTR_TARGET initialization parameter.
• B、 Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.
• C、 Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.
• D、 Increase the value of the SGA_TARGET initialization parameter.

第15题：

You specify a nonzero value for the MEMORY_TARGET initialization parameter，but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.  Which statement about the result is true？（）

• A、 The database instance starts，and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE
• B、 The database instance starts，and Oracle automatically tunes memory and allocates 60 percent to the  SGA and 40 percent to the PGA
• C、 The database instance starts，but Automatic Memory Management is disabled
• D、 The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter

第16题：

A customer stores environmental settings in the deployment descriptors of an application. Whenever they promote the application version from testing to the production environment, they need to open the archive and modify the deployment descriptor. This process is against their security policy.    What approach should you recommend to leverage WebLogic features such that they do not have to modify the application archive for different environments?（）

• A、Keep environmental data in the global settings of domain and the application can read it from the domain where it runs.
• B、Keep environmental data in Deployment Plan XML files. It allows you to change parameters in the deployment descriptor without opening the archive file.
• C、Keep environmental data in the database because it is the most effective way of parametrizing the environment.  
• D、Keep archive in exploded format so the customer does not have to open the archive files.
• E、Eliminate all environmental settings from the application. There should not to be any environmental settings in the application. 

第17题：

To enable resumable space allocation for the instance， which of the following initialization parameters should you set to a nonzero value？（）

• A、 RESUMABLE_SPACE_TIME
• B、 RESUMABLE_SPACE
• C、 RESUMABLE_TIME
• D、 RESUMABLE_TIMEOUT
• E、 TIME_RESUMABLE

第18题：

The production database has been functional for the last seven days. Because of application requirements， some of the initialization parameters were changed during run time without any comments. You have been asked to find out the value of the parameters when the instance was started. Which source would you use to locate this information？（）

• A、fixed views
• B、the alert log file
• C、the parameter file
• D、the server parameter file
• E、dynamic performance views

第19题：

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

第20题：

第21题：

第22题：

第23题：