You have DataSet object named LoanCustomersDataSet that contains customers serviced by the loan department of your company. You receive a second DataSet that contains customers serviced by the asset management department of your company. Both objects have the same structure.You want to merge assetCustomersDataSet into LoancustomersDataSet and preserve the original values in loanCustomerDataSet.Which code segment should you use?

试卷相关题目

• 1You have a DataSet object named YourDataSet. This object contains two DataTable objects named Customers and Orders. Customers has a column named CustomerlD, which is unique to each customer. Orders also has a column named CustomerlD.You want to use the GetChildRows method of the DataRow object to get all orders for the current customers.What should you do?

  A.Add a foreign key constraint on CustomerlD of Orders between Customers and Orders

  B.Add a data relation to YourDataSet on OrderlD between Customers and Orders

  C.Create a unique constraint on CustomerlD of Customers

  D.Create a primary key on CustomerlD of Customers

  开始考试点击查看答案
• 2You are developing an application that queries a Microsoft SQL Server database. The application will package the results of the query as XML dat

  A.The XML data will be retrieved directly from the database and transmitted electronically to a business partner.The query must retrieve all rows and all columns from a database table named Customers.Which query should you use?A.SELECT * FROM Customers FOR XML AUTO

  B.SELECT * FROM XML FROM Customers

  C.SELECT * FROM Customers as XMLDATA

  D.SELECT * FROM OPENXML('开始考试点击查看答案

• 3You have a SqlDataReader object named ProductsDataReader. The ProductsDataReader object contains three columns in the following order:ProductID as Integer ProductName as nvarchar (40)UnitsInStock as IntegerYou want to use ProductsDataReader to create an inventory management report. You define the following three variables:MyProductID as Integer MyProductName as String MyUnits as IntegerYou need to ensure that the report runs as quickly as possible.Which code segment should you use?

  A.MyProductID - ProductsDataReader.Item(1)MyProductName ** ProductsDataReader.Item(2}MyUnits * ProductsDataReader.Item(3)

  B.MyProductID - ProductsDataReader.Item(0).MyProductName * ProductsDataReader.Item(1)MyUnits - ProductsDataReader.Item(2)

  C.MyProductID = ProductsDataReader.Item("ProductID") MyProductName « ProductsDataReader. Item (" ProductName1*) MyUnits - ProductsDataReader.Item("UnitsInStock")

  D.MyProductID * ProductsDataReader.GetOrdinal("ProductlD") MyProductName - ProductsDataReader. GetOrdinal ("ProductName") MyUnits « ProductsDataReader.GetOrdinal《"UnitsInStock*1)

  开始考试点击查看答案
• 4You create an XML Web service named AutoPartsService that processes automobile part orders. This service exposes a Web method named PlaceOrder, which is shown in the following code segment:<WebMethod(TransactionOption.RequiresNew)>Public Function PlaceOrder(orderData As DataSet) As DataSet Dim brakes As New Serverl.BrakesService ()Dim parts As New Server2.PartsService()'Call OrderBrakes to order only brakes. brakes.OrderBrakes(orderDat

  A.Tables(Brakes))'Call OrderParts to order all other auto parts. parts.OrderParts(orderData.Tables(Parts))End FunctionBrakesService and PartsService are XML services. The Transac- tionOption property of OrderBrakes and OrderParts is set to TransactionOption.Required.You develop a Windows Forms application named PartOrderApp that consumes AutoPartsService. You run PartOrderApp and place and order for three sets of brakes and four wheels. While PlaceOrder is placing the order for the wheels, you close PartOrderApp.What is the most likely result?A.OrderParts stops processing the order, and all orders are cancelled

  B.OrderParts continues processing the order, and all orders are placed

  C.OrderParts stops processing the order, the brakes are ordered, but the wheels are not ordered

  D.You develop a Windows Forms application named PartOrderApp that consumes AutoPartsServic

  E.You run PartOrderApp and place and order for three sets of brakes and four wheels. While PlaceOrder is placing the order for the wheels, you close PartOrderApp.What is the most likely result?A.OrderParts stops processing the order, and all orders are cancelledB.OrderParts continues processing the order, and all orders are placedC.OrderParts stops processing the order, the brakes are ordered, but the wheels are not orderedD.OrderParts stops processing the order, the brakes are not ordered, but the wheels are ordered

  开始考试点击查看答案
• 5Your company frequently receives product information from external vendors in the form of XML dat

  A.You receive XML document files, an .xdr schema file, and an xsd schema file.You need to write code that will create a typed DataSet object on the basis of product information. Your code will be used in several Visual studio .NET applications to speed up data processing.You need to create this code as quickly as possible.What should you do?A.Create the code manually

  B.Use XmlSerializer.Serialize to generate the code

  C.Use XmlSerializer.Deserialize to generate the code

  D.Use the Xml Schema Definition tool (Xsd.exe) to generate the code

  开始考试点击查看答案
• 6As a software developer at your company, you are creating an XML Web service named DistributionService. This service must be able to access and manipulate data in a table named Inventory in a Microsoft SQL Server database.Some functions within Distribution Service need the inventory data to be exposed as XML data . Other functions within DistributionService need the inventory data to be exposed as a DataSet object.You need to create the object that will provide this data access.Which object should you use?

  A.XmlDocument

  B.XmlDocumentFragment

  C.XPathDocument

  D.XmlDataDocument

  开始考试点击查看答案
• 7You develop an ADO.NET application that uses a Microsoft SQL Server database and a SqlClient data provider. Your application includes the following four code segments, which are each called once:Dim MyConnection 1 As New SqlConnection () MyConnectionl.Connectionstring = "Data Source=" & "ProdServer;Initial Catalog=Billing/& "Integrated Security=true"MyConnectionl.Open ()Dim MyConnection2 As New SqlConnection() MyConnection2.Connectionstring = "DataSource=" & "ProdServer;Initial Catalog=Billing;& "Integrated Security=true"MyConnection2.Open ()Dim MyConnection3 As New SqlConnection() MyConnection3.Connectionstring = "Data Source=" & "SearchServer;Initial Catalog=Search;& "Integrated Security=true"MyConnection3.Open()Dim MyConnectionl As New SqlConnection() MyConnectionl.Connectionstring ="Data Source=" & "ProdServer;Initial Catalog=OrderEntry;"& "Integrated Security=true"MyConnection4.Open()You verify that your application is the only application that is using SQL Server. Your application runs all code segments by using the same identity.You run the application. Connection pooling is enabled, and the entire application run within the connection timeout parameter.How many connection pools are created?

  A.One

  B.Two

  C.Three

  D.Four

  开始考试点击查看答案
• 8You are using Visual Studio .NET to develop an application to replace a COM-based application. You are assigned to write a . NET class that will be used by client applications as a COM object. Your class code is being moved and modified while development continues on the new application.You want to minimize any possible disruption to the COM interface as a result of code changes.Which code segment should you use?

  A.Public Class MyClassToExpose Public Function Calc () As Integer 'Implementation code goes here.End Function End Class

  B.Public Interface IMyClassToExposePublic Function Calc () As Integer End InterfacePublic Class MyClassToExpose Implements IMyClassToExpose Public Function Calc () As Integer 'Implementation code goes here.End Function End Class

  C. Public Class MyClassToExposePublic Function Calc() As Integer 'Implementation code goes here. End Function End Class

  D.

  E.AutoDispatch) >Public Class MyClassToExpose Public Function Calc () As Integer 'Implementation code goes here.End Function End Class

  开始考试点击查看答案
• 9You are using Visual Studio .NET to develop an application. You have a common business logic component that was created in COM that you want to use until you can replace it with Visual Studio .NET code.You create the Visual Studio .NET solution for the new application. You want to use the COM component in your Visual Studio .NET solution. What should you do?

  A.Register the COM component by using Regsvr32.exe

  B.Run the Type Library Exporter (Tlbexp.exe) and pass the COM component as the filename parameter

  C.Use Visual Studio .NET to add a reference to the COM component

  D.Run the Assembly Registration tool(Regasm.exe) and pass theCOM component as the filename parameter

  开始考试点击查看答案
• 10You are using Visual Studio .NET to develop a new application to replace an older COM-based application. The new application will use some of the old COM components until they can be replaced by Visual Studio .NET code.Your application uses a COM DLL named OurCOM.dll. The Visual Studio.NET assembly for 0urC0M.dll must be named OurDotNetCOM. You must use the name "ProjectX" for the namespace of the COM components . You must ensure that your application uses these naming guidelines. What should you do?

  A.Reference OurCOM.dll from Visual Studio .NET.Change the assembly name in Solution Explorer.Change the namespace name by editing the assembly

  B.Reference OurCOM.dll from Visual.NET.Change the assembly name in Solution Explorer. Change the namespace name by using the Namespace property of a Code- Name space Import object

  C.Run the Type Library Importer (Tlbimp.exe) with the /namespace and/out options to create the assembly

  D.Run the Type Library Importer (Tlbimp. exe) with the /out option to create the assembly. Change the namespace by using the Namespace property of a CodeNamespaceImport object

  开始考试点击查看答案