[单选]
You are creating an online catalog application that will display product information on the company Web site. The product data is stored in a SQL Server 2005 database. The data is stored as relational data but must be passed to the application as an XML document by using FOR XML. You test your application and notice that not all of the items matching your query appear in the XML document. Only those products that have values for all elements in the schema appear.
You need to modify your Transact-SQL statement so that all products matching your query appear in the XML document.
What should you do？（）

A . Add an XML index to the table that contains the product data.
B . Add the XSINIL argument to the ELEMENTS directive in the query.
C . Add a HAVING clause to the query.
D . Add the replace value of clause to the query.

You are the network administrator for your company. Your network consists of a single Active Directory domain. The functional level of the domain is Windows Server 2003. You add eight servers for a new application. You create an organizational unit （OU） named Application to hold the servers and other resources for the application. Users and groups in the domain will need varied permissions on the application servers. The members of a global group named Server Access Team need to be able to grant access to the servers. The Server Access Team group does not need to be able to perform any other tasks on the servers. You need to allow the Server Access Team group to grant permissions for the application servers without granting the Server Access Team group unnecessary permissions. What should you do？（） Create a Group Policy object （GPO） for restricted groups. Configure the GPO to make the Server Access Team group a member of the Power Users group on each application server. Link the GPO to the Application OU.。 Grant the Server Access Team group permissions to modify computer objects in the Application OU.。 Move the Server Access Team group object into the Application OU.。 Create domain local groups that grant access to the application servers. Grant the Server Access Team group permissions to modify the membership of the domain local groups.。核酶作为一种金属依赖酶，金属离子在I型内含子中发挥的作用是什么？你有一台运行Windows 7的计算机。你需要复制文件到一个虚拟硬盘（VHD）文件中。首先你应该怎么做？（）运行Run Dism.exe 并指定 /image 和 /online 参数。打开Windows资源管理器，右击VHD文件并选择“打开”。运行Diskpart.exe ，并运行选择和挂载命令。运行Imagex.exe 并指定 /mountrw 和 /append 参数。编制项目工作计划首先要确定哪些工作？（）各开发阶段、子项目与工作步骤的工作量。论证系统开发必要性。子项目之间的依赖关系与系统的开发顺序。开发阶段、子项目与工作步骤的划分。主观幸福感产生于活动本身而非活动目标的实现是（）判断理论。目标理论。活动理论。

You are creating an online catalog application that will display product information on the company Web site. The product data is stored in a SQL Server 2005 database. The data is stored as relational data but must be passed to the application as an XML document by using FOR XML. You test your application and notice that not all of the items matching your query appear in the XML document. Only those products that have values for all elements in the schema appear.
You need to modify your Transact-SQL statement so that all products matching your query appear in the XML document.
What should you do？（）

参考答案：

● 参考解析

本题暂无解析

当前位置：MCTS(70-431)题库

相关题目: