违法和不良信息举报 联系客服
免费注册 登录

TestKing.com uses SQL Server 2005. A user reports that an or

题目
多选题
TestKing.com uses SQL Server 2005. A user reports that an order processing application stopped responding in the middle of an order transaction. The users SQL Server session ID is 54. You need to find out if session 54 is blocked by another connection. If it is,you need to identify the blocking session ID. What are two possible ways to achieve this goal？（）
A

In SQL Server Management Studio， open the Activity Monitor. Open the Process Info page. View the blockedBy column for session 54.

B

In SQL Server Management Studio，open the Activity Monitor. Open the Locks by Process page. View the Request Mode column for session 54.

C

In SQL Server Management Studio， open a new query window and execute the following statement.SELECT * FROM sys.dm exec requests WHERE session id = 54View the blocking session id column.

D

In SQL Server Management Studio， open a new query window and execute the following statement.SELECT * FROM sys.dm exec sessionsWHERE session id = 54View the status column.

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

You are planning the migration of an existing application to Windows Azure and SQL Azure. The current application includes reports that are hosted by SQL Server Reporting Services.  You need to recommend an approach for migrating the reports.  What should you recommend？ （）

  • A、 Use SQL Azure to host client report definitions.
  • B、 Use SQL Azure to host server report definitions.
  • C、 Use Windows Azure to host client report definitions in an ASP.NET webpage.
  • D、 Use Windows Azure to host server report definitions in an ASP.NET webpage.

正确答案:C

第2题：

创建SQL Server登录帐户的SQL语句是（）。

  • A、CREATE LOGIN
  • B、CREATE USER
  • C、ADD LOGIN
  • D、ADD USER

正确答案:A

第3题：

You are the administrator of a SQL Server 2000 computer. Your company uses the server to store service contract information for its customers.

You are also the administrator of Oracle relational database management system (RDBMS) server.

This server is used to store your company’s financial information. The financial information is updated frequently throughout the day.

You need to create a series of reports that combine the service contract information and the financial information. These reports will be updated several times a day.

You want to create reports on the SQL Server computer by using the minimum amount of disk space.

What should you do?

A．Set up SQL server replication to replicate the data from the oracle server to the SQL server computer.

B．Set up the oracle server as a linked server. Create a view that joins the service contract information and the financial information.

C．Set up data transformation services (DTS) package that imports and transforms the database from the oracle server to the SQL server computer. Use SQL server agent to execute the DTS package throughout the day as needed.

D．Set up Microsoft ActiveX script. that connects to the oracle server and imports the financial information into SQL server temporary table. Create a view that joins the service contract information and the temporary table.


正确答案：B
解析：Explanation: SQL Server 2000 permits the creation of links to OLE DB data sources called linked servers. After linking to an OLE DB data source, it is possible to reference rowsets from the OLE DB data sources as tables in Transact-SQL statements and to pass commands to the OLE DB data sources and include the resulting rowsets as tables in Transact-SQL statements.

Each distributed query can reference multiple linked servers and can perform. either update or read operations against each individual linked server. A single distributed query can perform. read operations against some linked servers and update operations against other linked servers. The Microsoft OLE DB Provider for Oracle allows distributed queries to query data in Oracle databases.

Incorrect Answers:
A: Replication allows for the coping, distribution, and modification of data across an enterprise. This involves the copying of database data from one server to another. This is not the best solution in this scenario as this will require frequent replication because the reports must be updated several times a day.

C: Data Transformation Services is a set of graphical tools and programmable objects that allows for the extraction, transformation, and consolidation of data from disparate sources into single or multiple destinations. In this scenario, however, the Oracle database needs to be included in a query. Hence, Data Transformation Services are inappropriate.

D: Microsoft ActiveX scripts can be used to add functionality to Data Transformation Services packages, which is a set of graphical tools and programmable objects that allows for the extraction, transformation, and consolidation of data from disparate sources into single or multiple destinations. In this scenario, however, the Oracle database needs to be included in a query. Hence, Data Transformation Services are inappropriate.

第4题：

TestKing.com uses SQL Server 2005. Users report that report execution is slow. You investigate and discover that some queries do not use optimal execution plans. You also notice that some optimizer statistics are missing and others are out of date.  You need to correct the problem so that reports execute more quickly. Which two Transact-SQL statements should you use？（）

  • A、DBCC CHECKTABLE
  • B、ALTER INDEX REORGANIZE
  • C、UPDATE STATISTICS
  • D、CREATE STATISTICS
  • E、DBCC SHOW STATISTICS
  • F、DBCC UPDATEUSAGE

正确答案:C,D

第5题：

You need to provide ad hoc reporting capabilities to fulfill business requirements. What should you do?（）

  • A、Create a SQL Server Reporting Services （SSRS） report. Enable customers to modify the report by using Report Builder.
  • B、Create an ASP.NET application that will enable customers to view and modify reports by calling the SQL Server Reporting Services （SSRS） API.
  • C、Create an ASP.NET application that will enable customers to view and modify reports by using a SQL Server Reporting Services （SSRS） ActiveX control.
  • D、Create a SQL Server Reporting Services （SSRS） Report Model. Enable customers to modify reports based on the model by using Report Builder.

正确答案:D

第6题：

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 database named DB1 in the instance. DB1 is available to a Windows group which is named WIIKIGO/Supervisors. A Windows user named User1 is a member of the WIIKIGO/Supervisors group. WIIKIGO/Supervisors is a member of the db_owner role in the DB1 database. You must make sure that the SQL Server instance is available to User1. In the DB1 database, which Transact-SQL statement(s) should you execute?（）  

  • A、 DROP LOGIN "WIIKIGO/User1"; 
  • B、 EXEC dbo.sp_droprolemember 'db_owner', 'WIIKIGO/User1';
  • C、 EXEC dbo.sp_revokedbaccess 'WIIKIGO/User1';EXEC dbo.sp_revokelogin 'WIIKIGO/User1'; 
  • D、 CREATE LOGIN "WIIKIGO/User1" FROM Windows;DENY CONNECT SQL TO "WIIKIGO/User1";

正确答案:D

第7题：

A user reports that they are unable to reach a particular website. The user had no issues reaching the site earlier in the day. Which of the following is the MOST likely cause of the lack of access？（）

  • A、The VLAN is misconfigured
  • B、The user has an improperly configured NIC
  • C、The DHCP server is down
  • D、The DNS server is down

正确答案:D

第8题：

You design a Business Intelligence （BI） solution by using SQL Server 2008.  The solution includes a SQL Server 2008 Reporting Services （SSRS） infrastructure in a scale-out deployment. All reports use a SQL Server 2008 relational database as the data source. You implement row-level security. You need to ensure that all reports display only the expected data based on the user who is viewing the report. What should you do？（）

  • A、 Store the credential of a user in the data source.
  • B、 Configure the infrastructure to support Kerberos authentication.
  • C、 Configure the infrastructure to support anonymous authentication by using a custom authentication extension.
  • D、 Ensure that all report queries add a filter that uses the User.UserID value as a hidden parameter.

正确答案:B

第9题：

TestKing.com has multiple servers in a distributed environment. You work with two SQL Server 2005 computers named SQL1 and SQL2. Each server uses SQL Server Authentication and they use different logins.You need to write a distributed query that joins the data on SQL1 with the data on SQL2. What should you do？（）

  • A、Ensure that both SQL1 and SQL2 use the same login name as the security context for each server.
  • B、Configure SQL2 as a remote server. Write the query on SQL1.
  • C、Configure SQL2 as a linked server to impersonate the remote login.
  • D、Configure SQL2 as a distributed server. Use pass-through authentication.

正确答案:C

第10题：

You are designing the loan application process for the customer terminals. You need to design a Transact-SQL stored procedure that fulfills the business and technical requirements. Which type of Transact-SQL stored procedure should you use?（）

  • A、one that uses an internal SQL Server Web service endpoint
  • B、one that runs a SQL Server Integration Services （SSIS） package
  • C、one that uses Service Broker
  • D、one that runs a user-defined function

正确答案:C

更多相关问题
相关内容