MCSD.NET - 70-306 Exam Interview Preparation Guide
MCSD.NET - 70-306 Exam guideline for job interview preparation. Explore list of MCSD.NET - 70-306 Exam frequently asked questions(FAQs) asked in number of MCSD.NET - 70-306 Exam interviews. Post your comments as your suggestions, questions and answers on any MCSD.NET - 70-306 Exam Interview Question or answer. Ask MCSD.NET - 70-306 Exam Question, your question will be answered by our fellow friends.14 MCSD.NET - 70-306 Exam Questions and Answers:
1 :: Suppose You develop a Windows-based inventory management application that interacts with a Microsoft
SQL Server database. Your application enables users to update information about items in
inventory. Each time a user changes an inventory item, your application executes a SQL Server
stored procedure XYZSP to update rows in the database. XYZSP will run many times during each
user session.
Your application will use a SqlCommand object to execute XYZSP. You must revise your code so
that the use of this object optimizes query performance.
What should you do?
A. Call the SqlCommand.DeriveParameters method before each call to
SqlCommand.ExecuteNonQuery.
B. Call the SqlCommand.Prepare method before each call to SqlCommand.ExecuteNonQuery.
C. Call the SqlCommand.DeriveParameters method before the first call to
SqlCommand.ExecuteNonQuery.
D. Call the SqlCommand.Prepare method before the first call to SqlCommand.ExecuteNonQuery.
D. Call the SqlCommand.Prepare method before the first call to SqlCommand.ExecuteNonQuery.
5 :: Suppose You develop a Windows-based application XYZiApp by using Visual Studio .NET. XYZiApp uses
a SqlConnection object for database access.
You typically run XYZiApp on a computer that has limited RAM and hard disk space. After the
code finishes using the SqlConnection object, you must ensure that the connection is closed and
that any resources consumed by the object are released immediately.
What should you do?
A. Call the Finalize method of the SqlConnection object.
B. Call the Dispose method of the SqlConnection object.
C. Set the SqlConnection object equal to Nothing.
D. Set the SqlConnection object equal to
B. Call the Dispose method of the SqlConnection object.
10 :: Suppose You develop a Windows Form that provides online help for users. You want the help functionality
to be available when users press the F1 key. Help text will be displayed in a pop-up window for
the text box that has focus.
To implement this functionality, you need to call a method of the HelpProvider control and pass
the text box and the help text.
Which method should you call?
A. SetShowHelp
B. SetHelpString
C. SetHelpKeyword
D. ToString
B. SetHelpString