70-305 Developing and Implementing Web Applications with Microsoft Visual Basic.NET Brain Dump

Microsoft ™

70-305 Developing and Implementing Web Applications with Microsoft Visual Basic.NET

Note 1: 70-305 Exhibit and all related diagrams are not shown in demo questions.
Note 2: 70-305 Answers are not shown in demo questions.
Exhibits and Answers are only provided in the Full Version.

Demo Question 5.

You work as the Web developer at EliteCertify.com. You are developing a function that must return the number of clients booked on a flight. You decide to use the ExecuteNonQuery method of the SqlCommand class to execute a Transact-SQL statement. Choose the value which will be returned by the ExecuteNonQuery method.

A. An integer specifying the number of rows affected will be returned.
B. A Boolean value specifying that the command processed correctly will be returned.
C. A string with the name of the stored procedure or query string that executed will be returned.
D. A string with the description of any errors that could have occurred will be returned.

Display Answer

Purchase Full Version:

70-305 Printable PDF Prep Guide $49.95 BUY NOW!

70-305 Test Simulation Engine $69.95 BUY NOW!

70-305 PDF & Test Simulation Engine $99.95 BUY NOW!

Answer: A The ExecuteNonQuery method is used to process Transact-SQL statements that perform DELETE, INSERT and UPDATE functions. The method returns an integer indicating the number of rows that were deleted, inserted or updated. The ExecuteNonQuery method does not return any rows, but will populate any output parameters that are present in the Command object.

Explanation: