You have a strongly types DataSet object. This object contains three DataTable objects named Customers, Orders and OrderDetails.Customers and Orders have a data column named CustomerlD. Orders and OrderDetails have a data column named OrderlD.Orders have a foreign key constraint between Customers and Orders on CustomerlD. OrderDetails has a foreign key constraint between Orders and OrderDetails on OrderlD.You want to populate Customers, Orders and OrderDetails with data from Microsoft SQL Server database.In which order should you fill the Data table objects?

试卷相关题目

• 1You have a .NET Remoting object named ProductLoader. The Product- Loader class is a server-activated Singleton object.The ProductLoader class loads product data into a Microsoft SQL Server database. The Load method of the ProductLoader class is a time-consuming method to call.You are developing a client application that uses the ProductLoader class. You want to ensure that the client application can continue to respond to user input while the Load method of the ProductLoader class is called.What should you do?

  A.Use an AsyncDelegate instance to call the Load method

  B.Modify the ProductLoader class to be derived from IAsyncResult

  C.Configure the ProductLoader class to be a client-activated .NET Remoting object

  D.Configure the client application to have its own remoting channel that matches the server's channel and formatter

  开始考试点击查看答案
• 2You are developing a order-processing application that retrieves data from a Microsoft SQL Server database named Datal that contains a table named Customers and a table named Orders.Customer has a primary key of customerID. Each row in orders has a CustomerlD that indicates which customer placed the order.Your application uses a DataSet object named ordersDataSet to capture customer and order information before it applied to the database. The ordersDataSet object has two Data Table objects named Customers and Orders.You want to ensure that a row cannot exist in the Orders Data Table object without a matching row existing in the Customers Data Table object.Which two actions should you take? (Each correct answer presents part of the solution. Choose two)

  A.Create a foreign key constraint named constraintOrders that has Orders.CustomersID as the parent column and Customers. CustomerlD as the child column

  B.Create a foreign key constraint named ConstraintCustomers that has Customers.CustomerlD as the parent column and Orders.CustomerlD as the child column

  C.Create a unique constraint named uniqueCustomers by using theCustomers.CustomerlD

  D.Add ConstraintOrders tothe Orders Data Table

  E.Add ConstraintOrders tothe Customer Data Table

  G.Add ConstraintCustomers to the Customers Data Table

  H.Add UniqueCustomers to the Customers Data Table

  开始考试点击查看答案
• 3You are developing an application to monitor store inventory. When inventory falls below a specified level, the application auto-matically generates a purchase request. Suppliers have requested that you transmit purchase requests to them in an XML document. Suppliers will accept the XML document in any valid form, except they do not want the data set definition to be included in the XML f ile.You create a method named GeneraLePurchaseRequest. You write the code to populate a DataSet object named myDataSet with the purchase request dat

  A.You define a variable named fileName that contains the name and path of the output file.You need to create an XML file from the data in myDataSet by adding code to GeneratePurchaseRequest. You want to accomplish this task by writing the minimum amount of code.Which code segment should you use?A.myDataSet.WriteXML(fileName, XmlWriteMode•IgnoreSchema)

  B.myDataSet.WriteXML(fileName, XmlWriteMode.WriteSchema)

  C.myDataSet.WriteXMLSchema(filename)

  D.Dim myWriter As TextWriter = New StreamWriter(fileName) myDataSet.WriteXMLSchema(myWriter)

  开始考试点击查看答案
• 4You have a SqlDataReader object named ordersDataReader. This object contains a column named OrderQuantity that has an integer value. This object also contains one row for each order received during the previous week.You need to write code that will process each row in orders Data Reader and pass OrderQuantity to a function named myFunction.Which code segment should you use?

  A.Dim weeklyOrderQuantity As Long = 0 While ordersDataReader.Read()Call myFunction(ordersDataReader("OrderQuantity")) End While

  B.Dim weeklyOrderQuantity As Long = 0 While ordersDataReader.NextResuit()Call myFunction(ordersDataReader("OrderQuantity")) End While

  C.Dim weeklyOrderQuantity As Long = 0 Dim orderCount As Integer = 0While orderCount < ordersDataReader.FieldCount Call myFunction(ordersDataReader("OrderQuantity")) orderCount += 1 ordersDataReader.Read()End While

  D.Dim weeklyOraerQuantity As Long = 0 Dim orderCount As Integer = 0While orderCount < ordersDataReader.FieldCount Call myFunction(ordersDataReader("OrderQuantity")> orderCount += 1 ordersDataReader.NextResult()End While

  开始考试点击查看答案
• 5Your company buys and sells used refrigerators. External vendors frequently send you XML documents that list one type of used appliances for sale. The documents that you receive contain either only washers or only refrigerators as in the following example.<!——A document with refrigerators --><saleList><refrigerators>〈refrigerator type="freezer on bottom", price="210"/> </refrigerators〉</saleList><!-- A document with washers --><saleList><washers><washer type="front load" , price="145"/> <washer type="top load" , price="130"/> </washers></saleList>All incoming XML documents are loaded into a MemorySystem object named used List.You need to automate a process that will discover XML documents contain refrigerator elements. As soon as you ascertain that a document contains refrigerators, you can stop processing the document.You decide to use Visual studio .NET to develop an application that will contain a Boolean variable named hasRefrigerator. A value of True for this variable means that a document contains refrigerator elements. A value of false means that it does not. You want to ensure that the discovery process occurs as quickly as possible.What should you do?

  A.Create an XtalDocument object and load it from used List. Use the SelectSingleNode method to search the XmlDocument object for the saleLisUrefrigerators node. If this node is found, aet hasRefrigerator to True. Otherwise, set hasRefrigerator to False

  B.Create an XmlXPathDocument object and load it from usedList. Use an XPatbNavigator object to search the XmlXPathDocument for the saleLisUrefrigerators node. If this node is found, set hasRefrigerator to True. Otherwise, set hasRefrigerator to False

  C.Create an XmlTextReader object on used List. Loop through usedlist by using the MoveToContent method of the XmlTextReader object and comparing for the sale list/refrigerators node. If this node is found, set hasRefrigerator to True. Otherwise, set hasRefrigerator to False

  D.Create a DataSet object and use its ReadXml method to load used list into the object. If the Count property of the Rows collection of the "refrigerators'* entry in the object is not equal to zero, set hasRefrigerator to Tru

  E.Otherwise, set hasRefrigerator to False

  开始考试点击查看答案
• 6Your Microsoft SQL Server database contains a table named Customers . Customers contains three columns named FamilyName, PersonalName, and Address.You instantiate a SqlCommand object named CRCommand that you will use to populate a DataReader object named customers Data Reader. You need to initialize CRCommand to load customersDataReader to include FamilyName and PersonalName for all rows in Customers.Which code segment should you use?

  A.CRCommand.CommandText = "SELECT FamilyName, "PersonalName FROM Customers"

  B.CRCommand.CommandType = "SELECT FamilyName,"Personal Name FROM Customers")C . CRCommand.Parameters.Add("SELECT FamilyName, "Personal Name FROM Customers")D. CRCommand.ExecuteNonOuery()

  开始考试点击查看答案
• 7You are creating an XML Web service that processes highly confidential messages. The service exposed a Web method named Retri- eveMessage that takes as input a code name and returns an encrypted message.You create a SOAP extension and override the extension's Process Message method so that you can encrypt the message before it is sent back to the caller.You need to encrypt only the data within the RetrieveMessageResult node of the SOAP response. You create a function named EncryptMessage that encrypts the RetrieveMessageResult node. You need to ensure that this method gets called before sending the message back to the caller.During which SoapMessageStage should you call EncryptMessage?

  A.BeforeSerialize

  B.AfterSerializeC . BeforeDeserializeD. AfterDeserialize

  开始考试点击查看答案
• 8You have a DataSet object that contains a single DataTable object named Employees. Employees has a column named EmployeelD. EmployeelD contains no duplicate dat

  A.You are creating a function that accepts a parameter of EmployeelD and searches Employees to return the DataRow object for the spec] fied EmployeelD.You want to use the Find method of the rows collection in Employees Co return the requested DataRow object from the function. You needto ensure that you can use the Find method to accomplish this goal. What should you do?A.Ensure that EmployeelD is the first column in Employees

  B.Ensure that EmployeelD is unique for each row in Employees

  C.Ensure that Employees has a primary key on EmployeelD

  D.Ensure that Employees is sorted in ascending order on EmployeelD

  开始考试点击查看答案
• 9You develop an ASP.NET application that consumes a third-party XML Web service named CreditService . CreditService contains a Web method named ChargeCard. ChargeCard takes as input a credit card number, a billing address, and a monetary amount and returns a Boolean variable that indicates whether or not the card was changed.Calls to ChargeCard take one minute to complete. You do not want users to have to wait while ChargeCard executes. You want users to be taken automatically to the next Web page of the application.Which code segment should you use to call CreditService?

  A.CreditService.ChargeCard(ccNumb, billAddress, amount)Server.Transfer ("process.aspx")

  B.CreditService.ChargeCard(ccNumb,_ billAddress, amount)Response.Redirect("process.aspx")

  C.CreditService.BeginChargeCard(ccNumb, billAddress, amount, New AsyncCallback(AddressOf_CCResponse), Nothing)Server.Transfer("process.aspx")Private Sub CCResponse(aRes As IAsyncResult) CreditService.EndChargeCard(aRes)End Sub

  D.Dim AsyncResult As IAsyncResultAsyncResult = CreditServic

  E.BeginChargeCard(ccNumb,_ billAddress, amount, Nothing, Nothing)AsyncResult.AsyncWaitHandle.WaitOne()CreditService.EndChargeCard(AsyncResult)Server.Transfer ("process.aspx")

  开始考试点击查看答案
• 10You have a DataSet object named customersDataSet that contains a DataTable object named Customers. Customers retrieves information from a Microsoft SOL Server database. Customers contains a column named Region.You want to create a DataView object named customersDataView that contains only customers in which the value in the Region column is France.Which code segment should you use?

  A.Dim customersDataView As _New DataView(customersDataSet.Tables("Customers")) customersDataView.FindRows("Region = France")

  B.Dim customersDataView As _New DataView(customersDataSet.Tables("Customers")) customersDataView.FindRows("Region = ’France1”）

  C.Dim customersDataView As _New DataView(customersDataSet.Tables("Customers")) customersDataView.RowFilter = ("Region = Franc")

  D.Dim customersDataView As _New DataView(customersDataSet.Tables("Customers")) customersDataView .RowFilter = ("Region = 'France1，'）

  开始考试点击查看答案