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

The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA’s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework？（）

A、 statistics recommendations

B、 SQL profile recommendations

C、 index-related recommendations

D、 restructuring of SQL recommendations

查看正确答案
更多“The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA’s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework？（）”相关的问题
第1题
[单选题] You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. According to the company requirement, you migrate an application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008. You have to monitor the SQL Server instance, and record the use of features which will be discontinued. What should you do? （） 

A、The SQL Server 2008 Upgrade Advisor should be used   B、You should use a SQL server-side trace. The trace captures the Deprecation Announcement and Deprecation Final Support event classes   C、You should use the SQL Server Profiler. The profiler captures the SQL:BatchCompleted and Exception event classes   D、You should use a SQL server-side trace. The trace captures the SQL:BatchCompleted and Exception event classes.   

点击查看答案
第2题
[单选题] You are a database administrator for your company. The company has two SQL Server 2005 computers named SQL1 and SQL2. SQL1 is located on the local network. SQL2 is located at a vendors site and is connected by using a VPN over the Internet. You need to write heterogeneous queries on SQL1 that access data from both SQL1 and SQL2. To ensure that your queries are functional， you must configure access to the vendors site. What should you do？（）

A、Configure an HTTP endpoint for SQL2 on SQL1.  B、Configure SQL2 as a linked server on SQL1.  C、Configure an HTTP endpoint for SQL1 on SQL2.  D、Configure SQL1 as a linked server on SQL2.  

点击查看答案
第3题
[单选题] You are a database administrator of two SQL Server 2005 computers named SQL1 and SQL2. You have a Microsoft .NET application that has been modified so that it now accesses a database on SQL2 in addition to SQL1. You do not want the user application to connect directly to SQL2. You need to enable the data retrieval from SQL2 while maintaining the ability to assign different permissions to different users who use the .NET application. What should you do？（）

A、Change the .NET application to define a new server connection to SQL2.  B、Configure a linked server on SQL1 to point to SQL2.  C、Configure a linked server on SQL2 to point to SQL1.  D、Change the stored procedures called by the .NET application to include the OPENXML command.  

点击查看答案
第4题
[单选题] Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement？（）  

A、 The SGA Tuning Advisor  B、 The SQL Access Advisor  C、 The SQL Tuning Advisor  D、 The Memory Advisor  

点击查看答案
第5题
[单选题] Your company has two SQL Server 2005 computers named SQL1 and SQL2. A user in your company named Eric writes many ad hoc queries against the company databases. Eric has access to the Customer database on SQL1. He does not have access to the Sales database on SQL2. You need to ensure that Eric can write queries that join information from both servers. What should you do first?（）

A、Create a linked server on SQL1 to SQL2. Configure the linked server to use impersonation.   B、Create a linked server on SQL1 to SQL2. Configure the linked server to use mapped logins.   C、Instruct Eric to write the queries on SQL2 by using the OPENQUERY statement and specifying SQL1 as the server name.   D、Instruct Eric to specify SQL Server object names by using four-part notation.   

点击查看答案
第6题
[单选题] Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement？（）

A、 SQL Repair Advisor  B、 SQL Optimizer  C、 SQL Access Advisor  D、 SQL Tuning Advisor  

点击查看答案
第7题
[单选题] You have forgotten the name of binary PL/SQL library saved to the operating system. This file contains the PL/SQL constricts you created for the inventory report. For which file extension should you reach?（）

A、 .SQL   B、 .PLL   C、 .PLD  D、 .PRT  

点击查看答案
第8题
[] You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a text file which is named SQL01.log on the E: drive. A SQL Server Agent job executes every 2 minutes and logs information to the text file. You get a report from users saying that the sever doesn't make response. As the technical support, you check and find that the SQLQ

A、A.You should check SQL1.log  B、B.You should check SQLAGENT.OUT  C、C.You should check log_xx.trc  D、D.You should check ERRORLOG  

点击查看答案
第9题
[多选题] You are configuring SQL1 so that the distributed query in the Sales database can access data in the CRM database on SQL2. You create a linked server for SQL2， and you create a linked server login that uses impersonation.Now， you need to ask the network administrator to configure SQL1. Which two tasks should you ask the administrator to perform？（）

A、Add the user account that is used by the SQL Server service to the local Administrators group.  B、Enable the Do not trust this user for delegation Active Domain property for the user account that is used by the SQL Server service.  C、Create a Service Principal Name （SPN） for the user account that is used by the SQL Server service.  D、Enable the Trusted for delegation Active Domain property for the user account that is used by the SQL Server service.  

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

请使用微信扫码支付

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