单选题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 XM

题目

单选题

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？（）

Add an XML index to the table that contains the product data.

Add the XSINIL argument to the ELEMENTS directive in the query.

Add a HAVING clause to the query.

Add the replace value of clause to the query.

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

相似问题和答案

第1题：

You are in the process of creating a new application.This new application has to be able to read all data from a text file.What should you do?()

参考答案：A

第2题：

You have recently completely creating a new application for Certkiller .com.This new application has to load an instance of the Inventory class from a large file named Inventory.dat.You need to ensure that the application executes the loading process in as little time as possible.What should you do?（）

参考答案：C

第3题：

You are creating an application that consumes a Windows Communication Foundation (WCF) service. The service implements the IService contract. The client application contains the CallbackHandler class, which implements IServiceCallback.You need to ensure that a client proxy is created that can communicate with the service over a duplex channel.Which code segment should you use?（）

参考答案：B

第4题：

If you back up a database without connecting to the recovery catalog， which operations will cause the recovery catalog to be updated？（）

A、 The next time you back up the database when you are also connected to the recovery catalog and the target database
B、 The next time you are connected to the target database and the recovery catalog database and issue the resync command
C、 The next time you connect RMAN to just the recovery catalog
D、 The next time you connect to the recovery catalog and the target database with RMAN
E、 Connecting to the recovery catalog and issuing the resync all databases command

正确答案:A,B

第5题：

You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）

A、 online redo log files
B、 alert log files
C、 control file
D、 datafiles associated with the SYSTEM tablespace

正确答案:C

第6题：

You are currently in the process of creating an application that reads binary information from a file.You need to ensure that the only the first kilobyte of data is retrieved.What should you do?()

参考答案：B

第7题：

You work as a Web Developer at Certkiller.com. You are in the process of creating a Webapplication using Microsoft ASP.NET 3.5. You host the Web application in Microsoft Internet Information Services （IIS） 6.0. You browse theapplication and receive the following error message： Server Application Unavailable The web application you are attempting to access on this web server is currently unavailable.Please hit the "Refresh" button in your web browser to retry your request. You view the Application event log and discover the following message： It is not possible to run two different versions of ASP.NET in the same IIS process. Please use theIIS Administration Tool to reconfigure your server to run the application in a separate process. To ensure productivity you need to solve this problem as quick as possible. What should you do？（）

A、You should change the IIS isolation mode.
B、You should assign the application to another application pool.
C、You should configure all applications that are part of your application's application pool in orderto use the same version of ASP.NET.
D、You should run the Aspnet_regiis.exe Tool.
E、You should restart the application pool that hosts the application.

正确答案:B,C

第8题：

Your company has an Active Directory Domain Services (AD DS) domain. You virtualize applications by using Microsoft Application Virtualization (App-V).You are creating an application virtualization package.Which should you use?（）

A.Microsoft Application Virtualization Sequencer

B.Microsoft Application Virtualization Desktop Client

C.Microsoft System Center Application Virtualization Streaming Server

D.Microsoft System Center Application Virtualization Management Server

参考答案：A

第9题：

It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager （RMAN）. How would you make use of this consistent backup in RMAN？（）

A、cannot be used in RMAN
B、by starting up the database again
C、by using the CATALOG command of RMAN
D、by using the RECOVER CATALOG command in RMAN
E、by re-creating the target control file to rebuild the RMAN repository

正确答案:C

第10题：

You use Microsoft .NET Framework 4 to create a Windows application. You plan to deploy the application by using Trusted Application Deployment. The application can only be installed by users who have elevated permissions. You need to ensure that users are not prompted for additional permissions when they install the application. Which two actions should you perform? （）

A、 Obfuscate the assemblies.
B、 Configure the application as online only.
C、 Enable User Account Control (UAC) on all client computers.
D、 Sign the deployment manifest with the publisher's digital certificate.
E、 Add the publisher of application to the trusted publisher's store on all client computers.

正确答案:D,E

You are creating an online catalog application that will dis

题目

相似问题和答案

更多相关问题

相关内容