搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【单选题】

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

查看正确答案
更多“While running long running queries， you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error？（）”相关的问题
第1题
[单选题] You have two processes， P1 and P2 on you computer. You notice that when you execute both the process at a time， process P2 always times out， while if you pause process P1， process P2 starts running fine. Process P1 runs in "Real Time" priority and uses twelve threads while process P1 runs in "Normal" priority and uses one thread. What should you do to solve this problem？ （）

A、Increase the number of threads for process P2.  B、Increase the priority for process P2.  C、Decrease the number of threads for process P1.  D、Decrease the priority for process P1 to ’Normal’.  

点击查看答案
第2题
[] Safe Mode is an essential Startup tool for troubleshooting Windows 98. Which two methods cause the system to start up in Safe Mode？（）

A、A.start the system in DOS Mode and run the WIN /S command  B、B.press the  key while restarting system - select Safe Mode  C、C.start the system in DOS Mode and run the safe.EXE file  D、D.hold  key while restarting the system； select Safe Mode  

点击查看答案
第3题
[] 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、A.Place each database in a separate instance running on SQL2.  B、B.Place each database in a separate instance running on SQL3.  C、C.Place both databases in a single instance running on SQL2.  D、D.Place both databases in a single instance running on SQL3.  

点击查看答案
第4题
[单选题] A customer wants to purchase a Windows 2003 DataCenter Edition system to run an application.  The application benefits the most by caching a vast amount of data in RAM so the user does not have to wait for disk I/O while editing.  Processing is second in importance.  If cost is not an issue， what machine will have the best performance？（）

A、Use an x360 running 4 MP processors with 16GB of RAM  B、Use an x360 running 4 DP processors with 16GB of RAM  C、Use an x445 running 2 DP processors with 64GB of RAM  D、Use an x445 running 4 DP processors with 64GB of RAM  

点击查看答案
第5题
[] While discussing the customer’s environment the storage specialist discovers that the customerhas both Windows and UNIX servers running various applications. The customer is looking for acost effective 10 TB solution that includes a mirrored site to meet their Disaster Recovery plan.Which of the following solutions should be recommended？（）

A、A.DS5020 system running Metro Mirror and Volume Copy  B、B.Storwize V7000 running FlashCopy and Volume Copy  C、C.DS5020 system runningFlashCopy and Enhanced Remote Mirror  D、D.DS5300 system runningFlashCopy and Enhanced Remote Mirror  

点击查看答案
第6题
[单选题] An administrator logs into a server and notices slow performance.While troubleshooting the problem the administrator notices that an unfamiliar process in the Task Manager is running at 100% CPU usage.The administrator tries to end the task and receives ‘Access is denied’.  Which of the following steps would allow the administrator to terminate that process？（）

A、Adding the ‘Run as a service’ permission to their account.  B、Running the kill utility.  C、Adding their account to the remote users group.  D、Ending the services.exe process then ending the runaway process.  

点击查看答案
第7题
[单选题] A system has users doing interactive work while background jobs are running.  Interactive users are requesting that system response time be improved for foreground processes.  Which tuning parameters should be changed to accomplish this？（）

A、 schedtune -h  B、 schedtune -r  C、 vmtune -f  D、 schedtune -w  

点击查看答案
第8题
[单选题] You have an SQL query that takes one minute to execute. You use the following code segment to execute the SQL query asynchronously.IAsyncResult ar = cmd.BeginExecuteReader（　）;You need to execute a method named Do Work（　） that takes one second to run while the SQL query is executing. DoWork（　） must run as many times as possible while the SQL query is executing. Which code segment should you use? （）

A、while（ar.AsyncWaitHandle==null）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；  B、while（!ar.IsCompleted）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；  C、while（Thread.CurrentThread.ThreadState==ThreadState.Running）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；  D、while（!ar.AsyncWaitHandle.WaitOne（））{DoWork（）；}dr=cmd.EndExecuteReader（ar）；  

点击查看答案
第9题
[单选题] You work as a database administrator for Certkiller .com. While loading data into the Certkiller STAFF table using Oracle Enterprise Manager 10g Database Control， you find the status of the job as failed. On further investigation， you find the following error message in the output log： ORA-01653 unable to extend table HR. Certkiller STAFF by 8 intablespaceUSERS Which task would you perform to load the data successfully without affecting the users who are accessing the table？（）

A、Restart the database instance and run the job  B、Truncate the Certkiller STAFF table and run the job  C、Delete all rows from the Certkiller STAFF table and run the job  D、Increase the size of the USERStablespacethe and run the job  E、Increase the size of the database default permanenttablespaceand run the job  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服