70-320 XML Web Services and Server Components with C#.NET
Note 1: 70-320 Exhibit and all related diagrams are not shown in demo questions.
Note 2: 70-320 Answers are not shown in demo questions.
Exhibits and Answers are only provided in the Full Version.
Note 2: 70-320 Answers are not shown in demo questions.
Exhibits and Answers are only provided in the Full Version.
Demo Question 2.
You have coded the following line: Dim cmdMain As New OleDbCommand() cmdMain.CommandText = "UPDATE StaffTable SET LastName = " & strLName cmdMain.ExecuteNonQuery What actions could you take to improve the performance of this code? (Select 2 choices.)
A. Index the database completely.
B. Use a Cache object to execute the command.
C. Use a SQLDataReader object to execute the command.
D. Use an OLEDBDataReader object to execute the command.
E. Use a DataReader object to execute the command.
F. Call the Prepare method on cmdMain before executing the query.
G. Use a stored procedure instead of dynamic text in the CommandText property.
H. Use a SqlCommand object rather than an OleDbCommand object.
Display Answer
Purchase Full Version:
70-320 Printable PDF Prep Guide $49.95 BUY NOW!
70-320 Test Simulation Engine $69.95 BUY NOW!
70-320 PDF & Test Simulation Engine $99.95 BUY NOW!
Answer: G, H
To improve the performance of the code, you should use a SqlCommand object rather than an
OleDbCommand object and use a stored procedure instead of dynamic text in the CommandText property.
When data is accessed from SQL Server, the SqlCommand object is faster than the generic OleDbCommand
object. Stored procedures process faster than dynamic text because the execution path has already been
determined when the stored procedure was compiled. None of the other options would improve the
processing speed.
Explanation:
- Based on the latest 70-320 exam objectives!
- Designed like actual 70-320 exam questions!
- 100% Verified Realistic 70-320 Exam Questions and Answers!
- Exhibits, Drag&Drop and Simulation 70-320 Questions Included!
- Constantly Updated Guide to Reflect the Current 70-320 Exams!
- Detailed Explanations for Most Guide Practice Exams!
Sponsored Links
Australia
Great thanks to EliteCertify for such excellent products! It really helped me a lot for passing 3Com 3M0-212. The practice ...
Demark
Took my last CCNP test last Friday. EliteCertify tests really made the difference, I passed every one on the first ...
England
Many thanks to your complete solution in 3Com Test Simulation Engine, Study Guides and PDF practice exams which are very ...
Keyword
