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

第1题：

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 off
• D、At least one process is running in the background using nohup and it will terminate when the operator logs off

第2题：

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.

第3题：

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.

第4题：

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

第5题：

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.

第6题：

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.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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 Advisor
• B、 Segment Advisor
• C、 Undo Advisor
• D、 SQL Tuning Advisor

第14题：

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.

第15题：

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 profile
• B、set the CPU time per session in the users profiles
• C、set the CPU levels for the users’ group using Resource Manager
• D、set the TIMED_STATISTICS parameter to TRUE in the parameter file

第16题：

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.

第17题：

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 server
• B、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 domain
• D、Configure forest functional level server for Windows server 2008 to configure filteredattribute set.
• E、None of the above

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：