MCTSMCTS(70-431)单项选择题每日一练(2019.01.17)

单项选择题
你工作在一个地方销售办公室，负责导入导出SQL SERVER 2005数据库中的数据。现在，你的上级要求你以文本文件的形式发送给他你所在区域最新的客户信息。而且，上级的数据库管理员要求数据必须按照StateProvince，Surname，和FirstName三个字段进行排序。为了满足这些要求，最简单的方法应该是？（）
A.在bcp out 命令中为ORDER 提示指定StateProvince，Surname，和FirstName参数值
B.为导出操作创建一个格式文件。
C.在bcp queryout 命令的ORDER BY子句中指定StateProvince，Surname，和FirstName参数值。
D.首先拷贝数据到一个以StateProvince，Surname，和FirstName列作为聚集索引的新表中，然后再导出数据。
单项选择题
You work with a database named DB1， which is located on a SQL Server 2005 computer. You discover that a table scan on Table1 in DB1 causes a slow query. Table1 is a very large table that is used frequently. You ascertain that the query contains the following statement. SELECT col1， col2 FROM table1 WHERE col3 = You need to provide maximum query performance. Table1 must remain available to users.What should you do？（）
A.Update all statistics on Table1 in DB1.
B.Use the CREATE STATISTICS statement in DB1 to create missing statistics on col3of Table1.
C.Set the priority boost server option to 1.
D.Execute the following statement.USE DB1GOCREATE INDEX index1 ON table1（col3）INCLUDE（col1， col2） WITH （ONLINE = ON）GO
单项选择题
You work with a SQL Server 2005 database that provides banking information for customers. You want customers to see banking reports that combine data that is retrieved from the database with real-time investment information that comes from a Web service provided by a third party. The investment information must be current when the reports are executed. You need to create the appropriate objects that support the reports.What should you do？（）
A.Publish the data in the database as an XML Web service by using the FOR XML AUTO clause.
B.Create a table to store the banking information for each customer. Create a trigger that fires when data is inserted into the table that joins with the data coming from the Web service.
C.Create a Transact-SQL stored procedure that uses a temporary table to store the banking information for each customer. Update the table with the values from the Web service.
D.Have a developer in TestKing.com create an assembly that calls the remote Web service.Create a CLR function by using the assembly. Call the CLR function and combine the results with banking information in the database.
单项选择题
Application developers in TestKing.com create an assembly that contains a CLR function.This CLR function reads data from a spreadsheet， performs some calculations， and returns the data to a SQL Server 2005 computer. You need to register the assembly with SQL Server 2005 by using the CREATE ASSEMBLY statement and the least privileged security permission set.Which permission set should you use？（）
A.Default
B.SAFE
C.EXTERNAL ACCESS
D.UNSAFE
单项选择题
你正在负责管理公司一个SQL SERVER 2005数据库。公司使用一个连接客户和销售表的视图v_CustomerSales进行例行的业务分析。他们用这个视图按月按客户进行销售数据汇总。为了，提高视图的性能，你应该怎么做？（）
A.修改视图，在表Customers 和 Sales之间采用外连接（outer join）
B.为视图v_CustomerSales新建一个聚集索引
C.为Customers表和Sales表分别创建v_Customers和v_Sales视图，在每个视图中不包含任何的连接关系
D.用v_CustomerSales 视图创建一个存储过程来进行业务分析