单选题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 with OLTP.C Schedule OS maintenance such that it includes frequent application of PTFs.D Perform incremental backups of transaction processing and full backups of batch processing.
单选题
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 with OLTP.
C
Schedule OS maintenance such that it includes frequent application of PTFs.
D
Perform incremental backups of transaction processing and full backups of batch processing.
参考解析
解析：
暂无解析
相关考题：
Which of the following requirements is NOT mentioned in successfully dealing with large volume and variety of transactions?A．A large number of skillful staff and expertise.B．Effective internal control system.C．Complex accounting system.D．Widespread use of electronic data processing.
You are the administrator of a SQL Server 2000 computer. You create a Data Transformation Services (DTS) package. The package is stored as a local package on the server. The package exports data from an online transaction processing (OLTP) database system to an online analytical processing (OLAP) database system that is located on a second SQL Server 2000 computer.You want the package to execute automatically each evening at 8:00 P.M. What should you do?A．Use SQL Server Enterprise Manager to create a new job Create a CmdExec job step that runs the dtsrun utility Schedule the job to run each night at 8:00 P.M.B．Use SQL Server Enterprise Manager to create a new job Create a Transact-SQL job step to query data from the OLTP database Create a second Transact-SQL job step to launch the DTS package Schedule the job to run each night at 8:00 P.M.C．Create a batch file that runs the dtsrun utility Use the Microsoft Windows Task Scheduler to run the job each night at 8:00 P.M. Configure the Windows Task Scheduler to use the local system accountD．Move the DTS package to the repository Configure the SQLServerAgent service on the OLAP database server to update the package each night at 8:00 P.M.
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
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 ManagerB、NTBACKUPC、FDISKD、Disk Defragmenter
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 ModeB、Automated System RecoveryC、Last Known Good ConfigurationD、System Restore
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 with OLTP.C、 Schedule OS maintenance such that it includes frequent application of PTFs.D、 Perform incremental backups of transaction processing and full backups of batch processing.
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、iostatB、netstatC、psD、vmstat
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.
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、 WindowB、 ProgramC、 Job_ClassD、 Window group
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.
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.
In which situation would you use the Oracle Shared Server configuration？（）A、when performing export and import using Oracle Data PumpB、when performing backup and recovery operations using Oracle Recovery ManagerC、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
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_TRANSACTIONSB、 DBA_AUDIT_STATEMENTC、 V$FLASHBACK_DATABASE_STATSD、 FLASHBACK_TRANSACTION_QUERY
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.
单选题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_TRANSACTIONSB DBA_AUDIT_STATEMENTC V$FLASHBACK_DATABASE_STATSD FLASHBACK_TRANSACTION_QUERY
单选题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?（）AAdding VMControl will automate processor resource allocation during peak workloads BEnable Dynamic Symmetric Multithreading in the HMC to balance workloads across processors.CAdd processing resources during the times they are required using Utility Capacity on Demand.DChanging the partitions to Uncapped can make use of additional processor cycles during peak workloads.
单选题In which situation would you use the Oracle Shared Server configuration？（）Awhen performing export and import using Oracle Data PumpBwhen performing backup and recovery operations using Oracle Recovery ManagerCwhen performing batch processing and bulk loading operation in a data warehouse environment Din an online transaction processing （OLTP） system where large number of client sessions are idle most of the time
单选题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?（）AWORM and encryption capability Boffers sequential stream of batch data Coffers ability to read and write multiple generation cartridges Dlower cost per GB when compared to LTO-4
单选题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？（）ADefine user profiles and set the CPU_PER_CALL limit. BDefine a SWITCH_TIME for a plan in the Resource Manager. CCreate a batch job that checks V$SESSION_LONGOPS；the batch job alters the session priority of the long running operations. DCreate a user defined event in the Oracle Enterprise Manager， which monitors V$SESSION_LONGOPS.
单选题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？（）ApingBiostatCnetstatDifconfig
单选题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 with OLTP.C Schedule OS maintenance such that it includes frequent application of PTFs.D Perform incremental backups of transaction processing and full backups of batch processing.
单选题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?（）ASafe ModeBAutomated System RecoveryCLast Known Good ConfigurationDSystem Restore
单选题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?（）AWrite a batch file that uses aspnet_compiler.exe.BWrite a batch file that uses InstallUtil.exe.CWrite a batch file that uses Csc.exe.DWrite a batch file that uses aspnet_wp.exe.
单选题When configuring a Commerce Payments cassette for a merchant， what should be created for EACH account？（）AA batch for each supported credit card typeBA batch for each currency and credit card typeCA batch for each cassette and currencyDA brand for each supported credit card typeEA brand for each currency and credit card type
单选题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 WindowB ProgramC Job_ClassD Window group
单选题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？（）AiostatBnetstatCpsDvmstat
多选题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？（）AThe batch operation started by the user， SCOTT， terminates with an error.BThe batch operation started by the user， SCOTT， hangs and you are required to increase the undo pool resource plan directive.CThe batch operation started by the user， SCOTT， runs uninterrupted because the database uses the SYSTEM tablespace for the undo operation.DThe user， BLAKE， cannot start a transaction that uses any DML operations until you increase the value of the undo pool resource plan directive.EThe user BLAKE can start a transaction that uses any DML operations after the batch operation started by the user， SCOTT， terminates with an error.
单选题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? （）ATask ManagerBNTBACKUPCFDISKDDisk Defragmenter