Your Microsoft SQL Server database contains a table named Orders. Due to a recent increase in product sales, Orders now contains more than 500,000 rows.You need to develop an application to produce a report of all orders in the table. You need to ensure that the application processes the data as quickly as possible.Which code segment should you use?

试卷相关题目

• 1You are developing an application that retrieves a list of geographical regions from a table in a Microsoft SQL Server database. The list of regions is displayed in a dropdown list box on a Windows Form. .You want to populate the list box with data from a DataSet object. You want to fill the DataSet object by using a SqlDataAdapter object.You create a SqlConnection object named YourConnection and a SQL query string named regionSQL. You need to write the code to create the SqlDataAdapter object.Which code segment should you use?

  A.Dim myDataAdapter As New SqlDataAdapter()myDataAdapter.SelectCommand.Connection = MyConnection myDataAdapter.SelectCommand.CommandTexc = regionSQL

  B.Dim myDataAdapter As New SqlDataAdapter(regionSQL, MyConnection)C . Dim SqlCmd As New SqlCommand(regionSQL)Dim myDataAdapter As New SqlDataAdapter() myDataAdapter.SelectCommand.Connection = MyConnection myDataAdapter.SelectCommand = SqlCmdD. Dim SqlCmd As New SqlComrnand ()Dim myDataAdapter As New SqlDataAdapter()SqlCmd.CommandText = regionSQLmyDataAdapter.SelectCommand.Connection = MyConnection myDataAdapter.SelectCommand = SqlCmd

  开始考试点击查看答案
• 2You are planning to create a DataSet object named YourDataSet to be used in a bond-trading application. Several developers will need to write code to manipulate YourDataSet, and you want to ensure that YourDataSet is easy for them to use . You decide to create YourDataSet as a strongly typed data set.Which two actions should you take? (Each correct answer presents part of the solution. Choose two)

  A.Create an XSD schema that defines YourDataSet

  B.Create an XDR schema that defines YourDataSet

  C.Create a class for YourDataSet that is based on the schema and that inherits from the DataSet class

  D.Create a class for YourDataSet that is based on the schema and that inherits from the XmlSchema class

  E.Create a key pair for YourDataSet by using the Strong Name tool(Sn.exe)

  开始考试点击查看答案
• 3You create an XML web service that retrieves data from Microsoft SQL Server database. You instantiate a SqlConnection object named YourConnection and set the Max Pool Size property of the conne- ctionString to 50.All 50 connections are now in use. However, a request for connection number 51 is received.What is the most likely result?

  A.An exception is immediately thrown

  B.The current connection pool is expanded by 50 additional connections

  C.A new connection pool is created that has the same maximum number of connections

  D.The request is queued until a connection becomes available or until the timeout limit is reached

  开始考试点击查看答案
• 4You create two serviced components named OrderPipeline and Or- derAdmin. Each component is registered in a separate COM+ server application. Both components use pricing dat

  A.OrderPipeline reads the pricing data for placing user orders. OrderAdmin modifies the pricing data.You want to ensure that OrderPipeline accesses the pricing data as quickly as possible, while still being able to immediately retrieve any pricing changes made by OrderAdmin.What should you do?A.Store the pricing data in the Shared Property Manager

  B.Store the pricing data in Microsoft SQL Server database

  C.Store the pricing data in a Hashtable object within OrderAdmin. Expose the Hashtable object through a property on OrderAdmin

  D.Store the pricing data in an XmlDocument object within OrderAdmin. Expose the XmlDocument object through a property on OrderAdmin

  开始考试点击查看答案
• 5You are creating a .NET Remoting object named BankOps. BankOps exposes methods for creating, finding, and modifying objects in a class named BankCustomer. BankCustomer has a large number of read/write properties.You expect a large number of remote client applications to frequently connect to BankOps. You expect these remote client applications to use many of the BankCustomer properties. You want to ensure that network traffic is minimized.What should you do?

  A.Add the Serializable attribute to the BankCustomer class

  B.Implement the IDisposable interface in the BankCustomer class

  C.Derive the BankCustomer class from ContextBoundObject

  D.Derive the BankCustomer class from MarshalByRefObject. Override the inherited InitializeLifetimeService method to return null

  开始考试点击查看答案
• 6You have a DataSet object named ordersDataSet. This object contains two DataTable objects named Orders and OrderDetails. Both Orders and OrderDetails contain a column named OrderlD.You create a DataRelation object named orderRelation between Orders and OrderDetails on OrderlD. Order is the parent table. OrderDetails is the child table.You add orderRelation to the ordersDataSet relation collection by using the following of code:ordersDataSet.Relations.Add(orderRelation)You verify that prior to adding orderRelation, there were no constraints on either table You then run the line of code.How many constraints does each table have now?

  A.One on Orders; none on OrderDetails

  B.None on Orders; one on OrderDetails

  C.None on Orders; none on OrderDetails

  D.One on Orders; one on OrderDetails

  开始考试点击查看答案
• 7Your Microsoft SQL Server database has a stored procedure that sums the total number of orders received each day. The stored procedure returns a result that is a single data value of type integer.You need to write code that will execute the stored procedure and return the result as an integer value.You instantiate a SglCommand object named myCommand and initialize all appropriate parameters.Which myCommand method should you use?

  A.ExecuteReader

  B.ExecuteNonOuery

  C.ExecuteScalar

  D.ExecuteXMLReader

  开始考试点击查看答案
• 8You need to write the c<ide that will parse the document and build the customerOutput string that will be used to write each row in the file.Which code segment should you use?

  A.Dim myNodeList As XmlNodeListmyRootNode.SelectNodes[/CustomerData/Customers)For Each curNode In myNodeList If curNode.HasChildNodes Then customerOutput -""For i « 0 To curNode.ChildNodes.Count - 1 customerOutput = curNode.ChildNodes(D.Name &一 »*=•，+curNode.ChildNodes(D.InnerText 'Code to write the output files goes here.Next i End If Next

  B.Dim myNodeList As XmlNodeList = _ myRootNode.SelectNodes(/CustomerData/Customers)For Each curNode In myNodeListIf curNode.HasChildNodes Then customerOutput * ”"For i = 0 To curNode.ChildNodes.Count - 1 customerOutput * curNode.ChildNodes(D.Name &_ +curNode.ChildNodes(D.Value •Code to write the output file goes here.Next i End If Next

  C.Dim myNodeList As XmlNodeList * myRootNode.SelectNodes (/Customers)For Each curNode In myNodeList If curNode.HasChildNodes Then customerOutput = ,M,For i = 0 To curNode.ChildNodes.Count - 1 customerOutput = curNode.ChildNodes (i) .Name &_"="+ curNode.ChildNodes(

  D.Name &一 »*=•，+curNod

  E.ChildNodes(D.InnerText 'Code to write the output files goes here.Next i End If NextB.Dim myNodeList As XmlNodeList = _ myRootNode.SelectNodes(/CustomerData/Customers)For Each curNode In myNodeListIf curNode.HasChildNodes Then customerOutput * ”"For i = 0 To curNode.ChildNodes.Count - 1 customerOutput * curNode.ChildNodes(D.Name &_ +curNode.ChildNodes(D.Value •Code to write the output file goes here.Next i End If NextC.Dim myNodeList As XmlNodeList * myRootNode.SelectNodes (/Customers)For Each curNode In myNodeList If curNode.HasChildNodes Then customerOutput = ,M,For i = 0 To curNode.ChildNodes.Count - 1 customerOutput = curNode.ChildNodes (i) .Name &_"="+ curNode.ChildNodes(D.InnerText 'Code to Write the output file goes here. .Next i End If NextD.Dim myNodeList As XmlNodeList = myRootNode.SelectNodes ("/Customers")For Each curNode In myNodeList If curNode.HasChildNodes Then customerOutput =""For i = 0 To curNode.ChildNodes.Count - 1customerOutput =_ curNode.ChildNodes(D.Attributes(0).value + ='&_ curNode.ChildNodes(i) .Attributes (1) .Value 'Code to write the output file goes here.Next i End If Next

  开始考试点击查看答案
• 9You are troubleshooting a Visual Studio .NET application that was developed by a former colleague. The application contains a NextToken function. This function reads product names from a file. You find the following code segment with a large assembly(Line numbers are included for reference only):1 Dim xwriter As New XmlTextWriter("productNames.xml",2System.Text.Encoding.UTF8)3xwriter.WriteStartDocument(True)4xwriter.WriteStartElement("data", nwww.contozo.com")5Dim val As String * NextToken()6While val <> ""7xwriter.WriteElementString("item",_8"www.contozo.com", val)9val = NextToken()10xwriter.WriteEndElement()11xwriter.WriteEndDocument()12xwriter.Close()You find that productsNames.xml contains only two entries: prodO and prodl.Which XML output is produced by this code segment?

  A.

  B. prod0prodl

  C. prod0prodl

  D. prod0prodl

  开始考试点击查看答案
• 10You create a Windows service named myService that queries a table named Orders in a Microsoft SQL Server database. You want myService to check every 30 seconds for now rows in Orders.You create the following method in myService:Private Sub ProcessOrders(ByVal source As Object, ByVal event- arguments As Timers.ElapsedEventArgs)'Logic to process Orders table goes here.End SubYou need to add additional code to myService to invoke the ProcessOrders method.What should you do?

  A.To the OnStart method, add the following code segment:Dim myTimer As New Timers.Timer()AddHandler myTimer.Elapsed, AddressOfProcessOrders myTimer.Interval = 30000 myTimer.Enabled = True

  B.To the OnCustomCommand method, add the following code segment: Dim myTimer As New Timers.Timer ()AddHandler myTimer.Elapsed, AddressOf ProcessOrders myTimer.Interval = 30000 myTimer.Enabled = True

  C.To the OnStart method, add the following code segment: Dim myTimer As New Timers.Timer ()AddHandler myTimer.Elapsed, AddressOf ProcessOrders myTimer.Interval = 30000 myTimer.AutoReset = True

  D.To the OnCustomCommand method, add the following code segment: Dim myTimer As New Timers.Timer ()AddHandler myTimer.Elapsed, AddressOf ProcessOrders myTimer.Interval = 30000 myTimer.AutoReset = True

  开始考试点击查看答案