MCSD.NET - 70-306 Exam Interview Preparation Guide
Elevate your MCSD.NET - 70-306 Exam interview readiness with our detailed compilation of 14 questions. These questions will test your expertise and readiness for any MCSD.NET - 70-306 Exam interview scenario. Ideal for candidates of all levels, this collection is a must-have for your study plan. Access the free PDF to get all 14 questions and give yourself the best chance of acing your MCSD.NET - 70-306 Exam interview. This resource is perfect for thorough preparation and confidence building.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.
2 :: Suppose You create a Visual Studio .NET setup project to distribute an application. You add a SQL script
named XYZDB.SQL. You must ensure that the SQL script is executed during the installation
process. What should you do?
A. Add a custom action to your setup project.
Select XYZDB.SQL as the source path.
B. Add a batch file to your setup project to execute XYZDB.SQL.
Add a launch condition to the setup project.
Set the Condition property to the batch file.
C. Create a new Visual Studio .NET project that executes XYZDB.SQL.
Include the new project with your setup project.
Add a custom action that launches the new project during installation.
D. Add a launch condition to your setup project.
Set the Condition property to XYZDB.SQL.
A. Add a custom action to your setup project.
Select XYZDB.SQL as the source path.
Select XYZDB.SQL as the source path.
3 :: Suppose You use Visual Studio .NET to develop a Windows-based application. Your application will
display customer order information from a Microsoft SQL Server database. The orders will be
displayed on a Windows Form that includes a DataGrid control named XYZGrid1. XYZGrid1 is
bound to a DataView object. Users will be able to edit order information directly in XYZGrid1.
You must give users the option of displaying only edited customer orders and updated values in
XYZGrid1.
What should you do?
A. Set the RowStateFilter property of the DataView object to
DataViewRowState.ModifiedOriginal.
B. Set the RowStateFilter property of the DataView object to DataViewRowState.ModifiedCurrent.
C. Set the RowFilter property of the DataView object to DataViewRowState.ModifiedOriginal.
D. Set the RowFilter property of the DataView object to DataViewRowState.ModifiedCurrent.
C. Set the RowFilter property of the DataView object to DataViewRowState.ModifiedOriginal.
4 :: Suppose You develop a Windows-based application XYZ App by using Visual Studio .NET. XYZApp
implements ADO.NET objects to call Microsoft SQL Server stored procedures. Your database
administrator is responsible for coding and maintaining all stored procedures. Periodically, the
administrator modifies the stored procedures.
At run time, your application code must discover any changes in the way that values are passed
to and returned from the stored procedures.
Which ADO.NET object and method should you use?
A. CommandBuilder.RefreshSchema
B. CommandBuilder.DeriveParameters
C. SqlCommand.CreateParameter
D. SqlDataAdapter.GetFillParameters
B. CommandBuilder.DeriveParameters
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.
6 :: Suppose You execute a query on your external Oracle database named XYZSalesDate by using an
OleDbCommand object. The query uses the Average function to return a single value that
represents the average price of products in the inventory table. You want to optimize performance
when you execute this query.
To execute this query from your ADO.NET code, you need to use a method of the
OleDbCommand object. Which method should you use?
A. ExecuteNonQuery
B. ExecuteScalar
C. ToString
D. ExecuteReader
B. ExecuteScalar
7 :: Suppose You develop a Windows-based application XYZApp that includes several menus. Every top-level
menu contains several menu items, and certain menus contain items that are mutually exclusive.
You decide to distinguish the single most important item in each menu by changing its caption
text to bold type.
What should you do?
A. Set the DefaultItem property to True.
B. Set the Text property to ?<b>True</b>?.
C. Set the Checked property to True.
D. Set the OwnerDraw property to True.
A. Set the DefaultItem property to True.
8 :: Suppose You use Visual Studio .NET to create a Windows-based application for XYZ Inc. The application
includes a form that contains several controls, including a button named exitButton. After you
finish designing the form, you select all controls and then select Lock Controls from the Format
menu.
Later, you discover that exitButton is too small. You need to enlarge its vertical dimension with
the least possible effort, and without disrupting the other controls.
First you select exitButton in the Windows Forms Designer. What should you do next?
A. Set the Locked property to False.
Set the Size property to the required size.
Set the Locked property to True.
B. Set the Locked property to False.
Use the mouse to resize the control.
Set the Locked property to True.
C. Set the Size property to the required size.
D. Use the mouse to resize the control.
C. Set the Size property to the required size.
9 :: Suppose You develop a Windows-based application that includes the following code segment. (Line
numbers are included for reference only.)
01 Public Sub password_Validating (ByVal sender As _
02 Object, ByVal e As _.
03 System.ComponentModel.CancelEventArgs)
04 Handles password.Validating
05 If ValidPassword() = False Then
06 Insert new code.
07 End If
08 End Sub
You must ensure that users cannot move control focus away from textPassword if
ValidPassword returns a value of False. You will add the required code on line 6.
Which code segment should you use?
A. e.Cancel = True
B. sender = textName
C. password.AcceptsTab = False
D. password.CausesValidation =False
A. e.Cancel = True
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