单选题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？（）ABoost the priority of batch jobs.BSchedule batch runs to reduce contention

题目

单选题

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？（）

Boost the priority of batch jobs.

Schedule batch runs to reduce contention with OLTP.

Schedule OS maintenance such that it includes frequent application of PTFs.

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 content”相关问题

第1题

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.

点击查看答案
第2题

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

点击查看答案
第3题

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.

点击查看答案
第4题

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.

点击查看答案
第5题

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

点击查看答案
第6题

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

点击查看答案
第7题

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.

点击查看答案

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

题目

更多“单选题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 content”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容