MCTS章节练习(2019.02.08)

单项选择题
你工作在一个售书公司.你正在基于SQL SERVER 2005数据库创建一个报表。此报表显示本月超过销售配额的销售代表及他们的销售额。已知，销售配额为$2，000。查询的起始日期和截至日期以变量@FromDate 和 @ToDate 传递进来。为了实现满足上述条件的报表，你应该使用下面哪一个SQL查询语句？（）
A.SELECT s.AgentName，SUM（ISNULL（o.OrderTotal，0.00））AS SumOrderTotal FROM SalesAgent s JOIN OrderHeader o ON s.AgentID = o.AgentIDWHERE o.OrderDate BETWEEN @FromDate AND @ToDate GROUP BY s.AgentName
B.SELECT s.AgentName，SUM（ISNULL （o.OrderTotal，0.00））AS SumOrderTotal FROM SalesAgent s JOIN OrderHeader o ON s.AgentID = o.AgentIDWHERE o.OrderDate BETWEEN @FromDate AND @ToDate AND o.OrderTotal >= 2000 GROUP BY s.AgentName
C.SELECT s.AgentName， SUM（ISNULL （o.OrderTotal，0.00））AS SumOrderTotal FROM SalesAgent s JOIN OrderHeader o ON s.AgentID = o.AgentID WHERE o.OrderDate BETWEEN @FromDate AND @ToDateGROUP BY s.AgentNameHAVING SUM（o.OrderTotal） >= 2000
D.SELECT s.AgentName,SUM（ISNULL（o.OrderTotal，0.00））AS SumOrderTotal FROM SalesAgent s JOIN OrderHeader o ON s.AgentID=o.AgentIDWHERE o.ordertotal =2000 AND o.OrderDate BETWEEN @FromDate AND @ToDate GROUP BY s.AgentName HAVING SUM（o.OrderTotal）>= 2000
多项选择题
You are creating a custom user control. The custom user control will be used on 10 Web Forms for an ASP.NET Web site that allows users to register and log on to a personalized experience.The custom user control uses two TextBox controls and two Button controls.You need to ensure that the controls are visible only when users are not logged on to the Web site. You also need to minimize the amount of effort in development and maintenance for the Web site.Which two actions should you perform?（）
A. Add the OnClick event handler for the Login button to the code used in the custom user control.
B. Add the OnClick event handler for the Login button to the code used in the Web Form where the control is added.
C. In the Page_Load method of the Web Form, add a code segment to set the visibility of the TextBox and Button controls where the control is added.
D. In the Page_Load method of the custom user control, add a code segment to set the visibility of the TextBox and Button controls.
单项选择题
你连接了一个运行Windows Mobile专业版6.1的移动设备到一台计算机。你发现Windows无法为这个移动设备安装所必需的设备驱动程序。你要确保你可以与这个移动设备同步文件，你该怎么做？（）
A.在Windows 移动中心，单击同步设置
B.在同步中心，单击设置新的同步伙伴
C.在设备管理器，单击扫描检测硬件改动
D.在设备和打印机，右击设备并单击疑难解答
单项选择题
You are implementing an ASP.NET MVC 2 Web application that contains the following class.You create a strongly typed view that displays details for a Department instance. You want the view to also include a listing of department employees. You need to write a code segment that will call the ListEmployees action method and output the results in place. Which code segment should you use？（）
A.<%= Html.Action("ListEmployees", Model) %>
B.<%= Html.ActionLink("ListEmployees", "Department", "DepartmentController") %>
C.<% Html.RenderPartial("ListEmployees", Model); %>
D.<%= Html.DisplayForModel("ListEmployees") %>
单项选择题
You develop a Windows Communication Foundation (WCF) service. You enable all performance counters and run multiple calls to the service.The service must isolate session data to each user. You need to monitor the instancing behaviour used in the service.Which performance counter should you monitor?（）
A. ServiceModeService 4.0.0.0\Calls
B. ServiceModeService 4.0.0.0\Instances
C. ASP.Net StateService \ Server Sessions Active
D. ASP.Net StateService \ Server Sessions Total
单项选择题
你有一台运行Windows 7的计算机。你的公司有三个自定义的应用程序分别名为App1.exe，App2.exe和App3.exe。这些应用程序具有公司的数字签名。你需要创建一个策略，只允许有公司数字签名的程序可以运行，你应该创建什么？（）
A.一个应用程序控制策略可执行规则
B.一个应用程序控制策略Windows 安装程序规则
C.一个软件限制策略证书规则
D.一个软件限制策略哈希规则
单项选择题
你需要让 Web 应用的用户能够修改 Web 应用的 UI 和行为。而且，这些在不同用户之间的更改相互独立。并且，当用户返回到 Web 应用的时候，这些改变任然有效。为了用最小的代码量达到此目标，你应用如何做？（）
A.用view state持久化控件的数据。
B.用Web Part控件.
C.为每个用户维护一个profile。
D.设置Web应用可以使用Session。
单项选择题
You have an existing Windows Communication Foundation (WCF) Web service. The Web service is not responding to messages larger than 64 KB. You need to ensure that the Web service can accept messages larger than 64 KB without generating errors. What should you do?（）
A. Increase the value of maxReceivedMessageSize on the endpoint binding.
B. Increase the value of maxRequestLength on the httpRuntime element.
C. Increase the value of maxBufferSize on the endpoint binding.
D. Increase the value of maxBufferPoolSize on the endpoint binding.
单项选择题
You have to store user data of 200 KB in an object. Which state management technique to use：（）
A.Server session
B.Cookie
C.ViewState
D.Hidden Field
单项选择题
You create a Windows Communication Foundation (WCF) service and deploy it with wsHttpBinding and message security enabled.You create an intermediate WCF service for logging messages sent to the primary service.The intermediate service is called via endpoint behaviour. The primary service is receiving malformed data from a client application.You need to enable inspection of the malformed data and prevent message tampering.What do you do?（）
A. Specify a protection level of None in the contract for the intermediate service. Disable message and transport security from the client application configuration file.
B. Specify a protection level of Sign in the contract for the intermediate service. Disable transport security from the client application configuration file.
C. Modify the binding on the intermediate service to use netNamedPipeBinding.
D. Modify the binding on the intermediate service to use webHttpBinding.