题目内容

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";

查看答案

搜索结果不匹配？点我反馈

更多问题

Which of the following is the correct syntax to specify the path to a file that generates the strong type？（）

A. <%@ PreviousPageType VirtualPath ="~/MyPage.aspx"% >
B. <%@ PreviousPageType VirtualPath ="/MyPage.aspx/ ~"% >
C. <%@ PreviousPageType VirtualPath ="~/MyPage.master"% >
D. <%@ PreviousPageType VirtualPath ="~/MyPage"% >

查看答案

You are working as a network technician， study the exhibit carefully. Your boss has informed youthat there have been problems with the WAN that is using EIGRP routing protocol. You arerequired to troubleshoot these problems. Before going to the questions of this sim， we should have a quick review about GRE tunneling：GRE Quick Summary. The picture below shows how to configure a GRE Tunnel between two routers， notice that the"tunnel destination" must be the IP address of the interface， not of the opposite tunnel. Notice： The tunnel source on one router must be specified as the tunnel destination on the otherrouter. Below are the questions of this lab-sim. What is preventing the HQ router and the Branch1 router from building up an EIGRP neighborrelationship？（）

A. When running EIGRP over GRE tunnels， you must manually configure the neighbor addressusing the eigrp neighbor ipaddress command
B. The tunnel destination address is incorrect on the HQ router. It should be 10.2.1.1 to match theinterface address of the Branch1 router
C. The tunnel source is incorrect on the Branch1 router. It should be serial 2/0
D. The default route is missing from the Branch1 router
E. The tunnel interface numbers for the tunnel between the HQ router and Branch1 router do notmatch

查看答案

ou 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. According to the company requirement, you intend to perform an installation of an instance of SQL Server Reporting Services (SSRS) to the same machine. Now your company CIO wants version histories of all deployed reports can be kept. As a technical support, what should you do to ensure this?（）

A. You should use the http.sys listener to install the SSRS instance.
B. You should configure the SSRS database, make it use Native mode
C. You should configure the SSRS database, make it use SharePoint integrated mode
D. You should use the Internet Information Services default Web site to install the SSRS instance

查看答案

You work as an ASP.NET Web Application Developer for SomeCompany. The company uses Visual Studio .NET 2010 as its application development platform. You create an ASP.NET MVC 2 Web application using .NET Framework 4.0. You implement a single project area in the MVC 2 Web application. In the Areas folder， you add a subfolder named MyTest. You add the following ﬁles to the appropriate sub-folders： MyController. csMyHome.aspx You register a route of the area， setting the route name to MyTest_default and the area name to test. You create a view named MyViews.aspx that is outside the test area. You need to add a link to MyViews.aspx that points to MyHome.aspx. Which of the following code segments will you use？（）

A. <%= Html.ActionLink("MyTest", "MyHome", new {area = "test"}, null)%>
B. <%= Html.RouteLink("MyHome", "MyTest", new {area = "test"}, null)%>
C. <%= Html.RouteLink("MyTest", "MyHome", "MyTest", new {area = "test"}, null)%>
D. <%= Html.ActionLink("MyTest", "MyHome", "MyTest", new {area = "test"}, null)%>

查看答案

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";

Which of the following is the correct syntax to specify the path to a file that generates the strong type？（）

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";