70-503(VB) 70-561(C++) Fragen und Antworten Zertifizierung-portal.de verkauft die Originaldokumente Microsoft Zertifizierungsexamen 70-503(VB) 70-561(C++) . Zertifizierung-portal.de hilft den Kandidaten offenbar dabei, die 70-503(VB) 70-561(C++) Examen problemlos zu bestehen. Auf der Internet-Seite der zertifizierung-portal.de heisst, es, dass man durch die Nutzung der 70-503(VB) 70-561(C++) Trainingsmaterialien keinerlei Schwierigkeiten haben würde, die 70-503(VB) 70-561(C++) Prüfungen zu durchlaufen. Auch für die Prüfungen anderer Technologieunternehmen werden Dokumente angeboten. Zum Teil der 70-561-Cplusplus Demo: 6. You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET. The application connects to a Microsoft SQL Server 2005 database. You write the following code segment. string query = “Select EmpNo, EmpName from dbo.Table_1; select Name,Age from dbo.Table_2″; SqlCommand command = new SqlCommand(query, connection); SqlDataReader reader = command.ExecuteReader(); You need to ensure that the application reads all the rows returned by the code segment. Which code segment should you use? A. while (reader.NextResult()) { Console.WriteLine(String.Format(“{0}, {1}”,reader[0], reader[1])); reader.Read(); } B. while (reader.Read()) { Console.WriteLine(String.Format(“{0}, {1}”,reader[0], reader[1])); reader.NextResult(); } C. while (reader.Read()) { Console.WriteLine(String.Format(“{0}, {1}”,reader[0], reader[1])); } reader.NextResult(); while (reader.Read()) { Console.WriteLine(String.Format(“{0}, {1}”,reader[0], reader[1])); } D. while (reader.NextResult()) { Console.WriteLine(String.Format(“{0}, {1}”,reader[0], reader[1])); } reader.Read(); while (reader.NextResult()) { Console.WriteLine(String.Format(“{0}, {1}”,reader[0], reader[1])); } Answer: C 7. You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET. The application has a DataTable object named OrderDetailTable. The object has the following columns: ` ID ` OrderID ` ProductID ` Quantity ` LineTotal The OrderDetailTable object is populated with data provided by a business partner. Some of the records contain a null value in the LineTotal field and 0 in the Quantity field. You write the following code segment. (Line numbers are included for reference only.) 01 DataColumn col = new DataColumn(“UnitPrice”, typeof(decimal)); 02 03 OrderDetailTable.Columns.Add(col); You need to add a DataColumn named UnitPrice to the OrderDetailTable object. Which line of code should you insert at line 02? A. col.Expression = “LineTotal/Quantity”; B. col.Expression = “LineTotal/ISNULL(Quantity, 1)”; C. col.Expression = “LineTotal.Value/ISNULL(Quantity.Value,1)”; D. col.Expression = “iif(Quantity > 0, LineTotal/Quantity, 0)”; Answer: D 8. You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET. The application contains a DataSet object named orderDS. The object contains a table named Order as shown in the following exhibit. The application uses a SqlDataAdapter object named daOrder to populate the Order table. You write the following code segment. (Line numbers are included for reference only.) 01 private void FillOrderTable(int pageIndex) { The safer , easier way to help you pass any IT exams. 02 int pageSize = 5; 03 04 } You need to fill the Order table with the next set of 5 records for each increase in the pageIndex value. Which code segment should you insert at line 03? A. string sql = “SELECT SalesOrderID, CustomerID, OrderDate FROM Sales.SalesOrderHeader”; daOrder.SelectCommand.CommandText = sql; daOrder.Fill(orderDS, pageIndex, pageSize, “Order”); B. int startRecord = (pageIndex – 1) * pageSize; string sql = “SELECT SalesOrderID, CustomerID, OrderDate FROM Sales.SalesOrderHeader”; daOrder.SelectCommand.CommandText = sql; daOrder.Fill(orderDS, startRecord, pageSize, “Order”); C. string sql = string.Format(“SELECT TOP {0} SalesOrderID, customerID, orderDate FROM Sales.SalesOrderHeader WHERE SalesOrderID > {1}”, pageSize, pageIndex); daOrder.SelectCommand.CommandText = sql; daOrder.Fill(orderDS, “Order”); D. int startRecord = (pageIndex – 1) * pageSize; string sql = string.Format(“SELECT TOP {0} SalesOrderID, CustomerID, orderDate FROM Sales.SalesOrderHeader WHERE SalesOrderID > {1}”, pageSize, startRecord); daOrder.SelectCommand.CommandText = sql; daOrder.Fill(orderDS, “Order”); Answer: B
