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

You are a database administrator for your company. The company’s financial forecasting application uses a SQL Server 2005 database that enables business users to run both ad hoc and predefined queries. You suspect that some queries consume an excessive amount of server resources. You need to identify which queries consume the most resources. You want to achieve this goal as quickly as possible. What should you do？（）

A、Use the DBCC INPUTBUFFER command.

B、Use the sys.dm_exec_query_stats dynamic management view （DMV）.

C、Use the sqldiag utility.

D、Use the SHOWPLAN session option.

查看正确答案
更多“You are a database administrator for your company. The company’s financial forecasting application uses a SQL Server 2005 database that enables business users to run both ad hoc and predefined queries. You suspect that some queries consume an excessive amount of server resources. You need to identify which queries consume the most resources. You want to achieve this goal as quickly as possible. What should you do？（）”相关的问题
第1题
[单选题] You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There are queries that have an estimated execution cost less than 3. You intend to configure the instance, make it use a single thread for these queries. In the options below, which sp_configure configuration option should you set?（）

A、You should set query governor cost limit  B、You should set cost threshold for parallelism  C、You should set priority boost   D、You should set precompute rank  

点击查看答案
第2题
[简答题] 根据写作要求，写出一篇作文。 Suppose you are Simon. You purchased a Sony digital camera from Amazon.com and found that there were scratches on the screen. You are writing to complain about it.

点击查看答案
第3题
[单选题] 一 Hello! ？- Hello， this is Michael from Tianjin Vanguard Trading Inc.（） 

A、Who are you？  B、What are you？  C、Who is that？  

点击查看答案
第4题
[单选题] You create 200 new user accounts. The users are located in six different sites. New users report that they receive the following error message when they try to log on： "The username or password is incorrect." You confirm that the user accounts exist and are enabled. You also confirm that the user name and password information supplied are correct. You need to identify the cause of the failure. You also need to ensure that the new users are able to log on Which utility should you 

A、Rsdiag  B、Rstools  C、Repadmin  D、Active Directory Domains and Trusts  

点击查看答案
第5题
[单选题] 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.  

点击查看答案
第6题
[] You are enabling the Automatic Shared Memory Management feature in the Oracle Database 10g to ensure that the important memory structures of the System Global Area （SGA） are automatically adjusted depending on the database workload. You are using Enterprise Manager 10g to enable this feature. You are currently on the Administration tab page.  Which two links should you click to go to the Memory Advisor page？（） You are enabling the Automatic Shared Memory Management feature in the Oracle Database 10g toQ

A、A. Advisor Central  B、B. Global Attributes  C、C. Resource Monitors  D、D. Memory Parameters  E、E. Database Usage Statistics  F、F. All Initialization Parameters  H、G. Automatic Workload Repository  

点击查看答案
第7题
[] You work as an application developer at Certkiller .com. You are developing a collection class named ClientCollection， which is to be used for storing the names of Certkiller .com’s clients that are situated in various geographical areas. These client names are represented by the Client class. You are planning to create a method named SortClients in the ClientCollection class to arrange Client objects in ascending order. You need to ensure that the appropriate interface is implemented by the Client class to allow&#

A、A. IDictionary  B、B. IComparable  C、C. IComparer  D、D. IEqualityComparer  

点击查看答案
第8题
[多选题] You are designing a NetBIOS naming strategy for the internal domain. What are two possible NetBIOS domain names you can use to achieve your goal?（）

A、ad  B、dallas  C、internal  D、external  E、Research  

点击查看答案
第9题
[单选题] You are employed as the exchange administrator at Company.com.the Company.com network contains an exchange 2010 organization.Company.com has its headquarters in stockholm where you are located.you are responsible for managing a mailbox server named -ex02.all users within the organization make use of microsoft office outlook 2010 to connect to the exchange organization.you receive an instruction to determine the latency of user connections to-ex02. What should you do？（）

A、You should consider running the Test-OutlookConnectivity cmdlet.  B、You should consider running the Exchange Best Practices Analyzer.  C、You should consider running the Test-OutlookWebServices cmdlet.  D、You should consider running the Message Tracking Performance tool.  

点击查看答案
第10题
[单选题] You are maintaining your database in Oracle10g. You are required to view the list of files that have not been backed up for the last seven days. Which RMAN command will you use？（）

A、 LIST command  B、 CROSSCHECK command  C、 REPORT command  D、 SHOW command  

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

请使用微信扫码支付

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