单选题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.
单选题
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 are having problems with connections from a specific host (192.168.1.15) not closing down correctly.You want to find the state of the threads from that host check for long-running queries. Which statement will accomplish this?（）A.AB.BC.CD.D
The airline industry also relies on many management, professional, and administrative support workers to keep operations running _______.A.smooth B.smoothly C.smoothness D.smoothish
Twenty database users are connected to your database. Five of the users are running long queries involving sort operations. The TEMP tablespace is the default temporary tablespace for your database. You are performing offline tablespace backups of individual tablespaces and erroneously execute the following statement： SQLALTER TABLSPACE temp OFFLINE NORMAL； What is the result of this statement？（）A、 The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are disconnected after their queries complete.B、 The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are disconnected and must re-execute their queries.C、 The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are not disconnected， but these users must re-execute their queries.D、 The TEMP tablespace is not taken offline. The users using the TEMP tablespace for sorting are not disconnected， and their queries execute successfully.
TS3 is a server running Windows Server 2008 and Terminal Services. You have the responsibility ofsupporting users who connect to TS3 to run various applications. Users complain that the application is responding slowly. You use the quser command on TS3 and discover that many users havemultiple disconnected sessions on the server with idle times of two days or more. You want to reduce thestrain on the TS3 by eliminating disconnected sessions that have been idle for more than two days. What should you do？（）A、Use the Rwinsta command.B、Use the Tsdicon command.C、Use the Tskill command.D、Use the Tscon command.
When an operator is trying to log off the system displays this message: you have running jobs?? What does this mean?（）A、One or more processes are running in the background, preventing log off.B、One or more processes are paused, requiring operator input prior to logging off.C、At least one process is running in the background and it will keep running after the operator logs offD、At least one process is running in the background using nohup and it will terminate when the operator logs off
While running long running queries， you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error？（）A、 Memory AdvisorB、 Segment AdvisorC、 Undo AdvisorD、 SQL Tuning Advisor
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.
For the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database， who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time， but you still do not want to terminate them with an error message. Which method would you follow to achieve this？（）A、 Set the CPU time per call in the users profile.B、 Set the CPU time per session in the users profile.C、 Set the CPU levels for the user’s group using Resource Manager.D、 Set the TIMED_STATISTICS parameter to TRUE in the parameter file.
You work as a database administrator for Supportcenter.cn. You received the following error while working on your database： ORA-01555： snapshot too old ，In which situation would you receive such an error？（）A、You performed rollback after commit.B、If a log switch occurs in your database.C、Thearchiverfails to generate an archived log file.D、Instance recovery fails to find one of the redo log files.E、A long-running query is unable to get read-consistent image.F、If you perform manual undo management operations in auto mode.
From the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database， who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time， but you still do not want to terminate them with an error message. Which method would you follow to achieve this？（）A、set the CPU time per call in the users profileB、set the CPU time per session in the users profilesC、set the CPU levels for the users’ group using Resource ManagerD、set the TIMED_STATISTICS parameter to TRUE in the parameter file
You have a long-running process you want to assign to a specific UNDO segment brought online for that express purpose. You are not using automatic UNDO management. What statement can be used for this task? （）A、ALTER DATABASE B、SET TRANSACTION C、ALTER ROLLBACK SEGMENT D、ALTER TABLE
You need to design the consolidation strategy for the Promotions and Partners databases. You want to choose a strategy that results in the best database performance while maintaining the permissions of end users in each database.What consolidation strategy should you choose？（）A、Place each database in a separate instance running on SQL2.B、Place each database in a separate instance running on SQL3.C、Place both databases in a single instance running on SQL2.D、Place both databases in a single instance running on SQL3.
You need to design the Service Broker queues that will be used to submit requests for long-running reports. Your solution must minimize complexity of using the queues by applications. What should you do?（）A、Specify one queue for each client application that can submit report requests.B、Specify one queue for each of the two report-generation services.C、Specify one queue for all long-running report requests.D、Specify eight queues：One for each service， and one for each client application.
One of the remote branch offices of Certkiller branch is running a Windows Server 2008 having ready only domain controller （RODC） installed.For security reasons you don’t want some critical credentials like （passwords， encryption keys） to be stored on RODC. What should you do so that these credentials are not replicated to any RODC’s in the forest（）A、Configure RODC filtered attribute set on the serverB、Configure RODC filtered set on the server that holds Schema Operations Master role.C、Delegate local administrative permissions for an RODC to any domain user without granting that user any user rights for the domainD、Configure forest functional level server for Windows server 2008 to configure filteredattribute set.E、None of the above
You are employed as the enterprise exchange administrator at Company.com..com makes use of Microsoft exchange server 2010 messaging solution.you are responsible for managing the exchange network for Company.com.you are experiencing various problems in the exchange environment.you decide to determine whether one of the other administrators executed any configuration changes in the organization.What should you do？（）A、You should consider running Exchange Best Practices Analyzer.B、You should consider running Microsoft Baseline Security Analyzer （MBSA）.C、You should consider running the Get-ExchangeServer cmdlet.D、You should consider running the Get-EventLogLevel cmdlet.
单选题When an operator is trying to log off the system displays this message: you have running jobs?? What does this mean?（）AOne or more processes are running in the background, preventing log off.BOne or more processes are paused, requiring operator input prior to logging off.CAt least one process is running in the background and it will keep running after the operator logs offDAt least one process is running in the background using nohup and it will terminate when the operator logs off
单选题What advantage would you get if you increase the length of time during which the undo information would be stored in the database？（）Aroll back of large transactionsBroll forward to redo a transactionCdata concurrency for large updatesDread consistency for long-running transactions
单选题While running long running queries， you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error？（）A Memory AdvisorB Segment AdvisorC Undo AdvisorD SQL Tuning Advisor
单选题You work as a database administrator for Certkiller .com. You received the following error while working on your database： ORA-01555： snapshot too old In which situation would you receive such an error？（）AYou performed rollback after commit.BIf a log switch occurs in your database.CThearchiverfails to generate an archived log file.DInstance recovery fails to find one of the redo log files.EA long-running query is unable to get read-consistent image.FIf you perform manual undo management operations in auto mode.
单选题You are employed as the enterprise exchange administrator at Company.com..com makes use of Microsoft exchange server 2010 messaging solution.you are responsible for managing the exchange network for Company.com.you are experiencing various problems in the exchange environment.you decide to determine whether one of the other administrators executed any configuration changes in the organization.What should you do？（）AYou should consider running Exchange Best Practices Analyzer.BYou should consider running Microsoft Baseline Security Analyzer （MBSA）.CYou should consider running the Get-ExchangeServer cmdlet.DYou should consider running the Get-EventLogLevel cmdlet.
单选题You need to design the Service Broker queues that will be used to submit requests for long-running reports. Your solution must minimize complexity of using the queues by applications. What should you do?（）ASpecify one queue for each client application that can submit report requests.BSpecify one queue for each of the two report-generation services.CSpecify one queue for all long-running report requests.DSpecify eight queues：One for each service， and one for each client application.
单选题TS3 is a server running Windows Server 2008 and Terminal Services. You have the responsibility ofsupporting users who connect to TS3 to run various applications. Users complain that the application is responding slowly. You use the quser command on TS3 and discover that many users havemultiple disconnected sessions on the server with idle times of two days or more. You want to reduce thestrain on the TS3 by eliminating disconnected sessions that have been idle for more than two days. What should you do？（）AUse the Rwinsta command.BUse the Tsdicon command.CUse the Tskill command.DUse the Tscon command.
单选题For the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database， who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time， but you still do not want to terminate them with an error message. Which method would you follow to achieve this？（）A Set the CPU time per call in the users profile.B Set the CPU time per session in the users profile.C Set the CPU levels for the user’s group using Resource Manager.D Set the TIMED_STATISTICS parameter to TRUE in the parameter file.
单选题You have a long-running process you want to assign to a specific UNDO segment brought online for that express purpose. You are not using automatic UNDO management. What statement can be used for this task? （）AALTER DATABASE BSET TRANSACTION CALTER ROLLBACK SEGMENT DALTER TABLE
单选题From the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database， who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time， but you still do not want to terminate them with an error message. Which method would you follow to achieve this？（）A set the CPU time per call in the users profileB set the CPU time per session in the users profilesC set the TIMED_STATISTICS parameter to TRUE in the parameter fileD set the CPU levels for the users’ group using Resource Manager
单选题You need to design the consolidation strategy for the Promotions and Partners databases. You want to choose a strategy that results in the best database performance while maintaining the permissions of end users in each database.What consolidation strategy should you choose？（）APlace each database in a separate instance running on SQL2.BPlace each database in a separate instance running on SQL3.CPlace both databases in a single instance running on SQL2.DPlace both databases in a single instance running on SQL3.
单选题Running your own business usually（）working long hours.AincludesBinvolvesCcontainsDcomprises