When a system has both online transaction processing as well as large batch processing， which of the following common procedures will best help to improve system performance？（）A、 Boost the priority of batch jobs.B、 Schedule batch runs to reduce contention

第1题：

A corporation wants help in reducing backup costs. By proposing a library with LTO-5 drives,which one of the following would be the BEST reason to choose LTO-5 over LTO-4?（）

• A、WORM and encryption capability 
• B、offers sequential stream of batch data 
• C、offers ability to read and write multiple generation cartridges 
• D、lower cost per GB when compared to LTO-4

第2题：

A user can no longer launch their word processing program. The program worked fine yesterday.Which of the following options could BEST be used to fix the word processing program?（）

• A、Safe Mode
• B、Automated System Recovery
• C、Last Known Good Configuration
• D、System Restore

第3题：

When configuring a Commerce Payments cassette for a merchant， what should be created for EACH account？（）

• A、A batch for each supported credit card type
• B、A batch for each currency and credit card type
• C、A batch for each cassette and currency
• D、A brand for each supported credit card type
• E、A brand for each currency and credit card type

第4题：

A system administrator is monitoring a system that has recently shown a decrease in performance.The administrator suspects that the system may be low on memory and may be paging excessively.Which of the following commands is best to identify a possible paging problem？（）

• A、iostat
• B、netstat
• C、ps
• D、vmstat

第5题：

An AIX system， which is running a database， is having performance issues with I/O writing.  The DBA has provided numbers for the HIGH and LOW watermarks for pending file writes， which will optimize the system for best performance.  To set these numbers， which of the following commands would be used？（）

• A、 perfmon -h 30 -l 25
• B、 chdev
• C、 no -o
• D、 smit chgsys

第6题：

Your system performs heavy transaction processing between 8：00 A.M. and 5：00 P.M. but runs batch processing and reports after that. You decide to create a separate resource plan to govern resource allocation for each time period. Which scheduler object will you use to switch automatically between the two resource plans？（）  

• A、 Window
• B、 Program
• C、 Job_Class
• D、 Window group

第7题：

You set the undo pool resource plan directive for the consumer group named DSS_USERS that is assigned to the DAY_SHIFT plan. The database users， SCOTT and BLAKE， belong to the DSS_USERS resource group. The user， SCOTT， initiates a database session and executes a batch operation that inserts millions of rows into the HISTORY table. Which two options are true if the total undo space allocated to the DSS_USERS group exceeds the value specified in the undo pool resource plan directive？（）

• A、 The batch operation started by the user， SCOTT， terminates with an error.
• B、 The batch operation started by the user， SCOTT， hangs and you are required to increase the undo pool resource plan directive.
• C、 The batch operation started by the user， SCOTT， runs uninterrupted because the database uses the SYSTEM tablespace for the undo operation.
• D、 The user， BLAKE， cannot start a transaction that uses any DML operations until you increase the value of the undo pool resource plan directive.
• E、 The user BLAKE can start a transaction that uses any DML operations after the batch operation started by the user， SCOTT， terminates with an error.

第8题：

At 10：30 A.M.， you ran a batch job by mistake， which executed a transaction in the database. The transaction identifier of the transaction that made to the changes in the database is 0500A00627B000. At 11：10 A.M.， you stopped the batch job. Now， you want to identify the changes made to the database tables by the batch job. Which view will you query？（）

• A、 DBA_PENDING_TRANSACTIONS
• B、 DBA_AUDIT_STATEMENT
• C、 V$FLASHBACK_DATABASE_STATS
• D、 FLASHBACK_TRANSACTION_QUERY

第9题：

第10题：

第11题：

第12题：

第13题：

A user reports that their system is starting to run slower, especially when opening large local files. The system has sufficient RAM for the users applications, but the hard drive seems to have higher than normal activity when opening large files. Which of the following would be the BEST tool to diagnose and troubleshoot this problem? （）

• A、Task Manager
• B、NTBACKUP
• C、FDISK
• D、Disk Defragmenter

第14题：

Which of the following options best justifies why a DNS server should be run in a large network system？（）

• A、To use ftp and telnet
• B、To perform NFS mounts
• C、To make /etc/hosts files unnecessary
• D、To reduce network traffic and save bandwidth

第15题：

A system administrator is monitoring a system that has recently shown a decrease in performance. The administrator suspects there is an overload of traffic on a single Ethernet adapter. Which of the following commands is best to identify a possible overload of the Ethernet adapter？（）

• A、ping
• B、iostat
• C、netstat
• D、ifconfig

第16题：

A retail customer has an 8-core Power 740 server with 2 partitions. Production has 4 dedicated cores and the test partition has 2 dedicated cores. Both partitions run during the day without problems. At night, batch processing is exceeding the run window. Which solution addresses this problem without requiring additional hardware?（）

• A、AddingVMControl will automate processor resource allocation during peak workloads.
• B、Enable Dynamic Symmetric Multithreading in the HMC to balance workloads across processors.
• C、Add processing resources during the times they are required using Utility Capacity on Demand.
• D、Changing the partitions to Uncapped can make use of additional processor cycles during peak workloads.

第17题：

At the end of the financial year， an accounts accumulation batch is run. This batch updates the company’s accounting records. During the batch run process， some incorrect entries were inserted into the ACCOUNT table. You identified the bug and immediately stopped the batch run process， but 3000 incorrect records were inserted into the ACCOUNT table before the batch process was stopped. You want to recover the table to the state it was at 11：50 P.M. Which flashback feature will you use？（）

• A、 Flashback Drop
• B、 Flashback Database
• C、 Flashback Table
• D、 Flashback Version Query

第18题：

There is more than one way to set the server to detect and affect long running operations automatically. What is the best choice of you want to reduce the impact of long running operations on other users without aborting the long running operations？（）

• A、Define user profiles and set the CPU_PER_CALL limit. 
• B、Define a SWITCH_TIME for a plan in the Resource Manager. 
• C、Create a batch job that checks V$SESSION_LONGOPS；the batch job alters the session priority of the long running operations. 
• D、Create a user defined event in the Oracle Enterprise Manager， which monitors V$SESSION_LONGOPS.

第19题：

In which situation would you use the Oracle Shared Server configuration？（）

• A、when performing export and import using Oracle Data Pump
• B、when performing backup and recovery operations using Oracle Recovery Manager
• C、when performing batch processing and bulk loading operation in a data warehouse environment 
• D、in an online transaction processing （OLTP） system where large number of client sessions are idle most of the time

第20题：

Your team creates a Web site. The Web site needs to be deployed to a staging server for performance testing. You plan to make a number of performance enhancements and then retest. You need to compile and copy the Web site to the staging server. What should you do? （）

• A、Write a batch file that uses aspnet_compiler.exe.
• B、Write a batch file that uses InstallUtil.exe.
• C、Write a batch file that uses Csc.exe.
• D、Write a batch file that uses aspnet_wp.exe.

第21题：

第22题：

第23题：