MCSD.NET - 70-306 Exam

  Home  Certifications  MCSD.NET - 70-306 Exam


“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 execute a query on your external Oracle database named XYZSalesDate by using anOleDbCommand object. The query uses the Average function to return a single value thatrepresents the average price of products in the inventory table. You want to optimize performancewhen you execute this query.To execute this query from your ADO.NET code, you need to use a method of theOleDbCommand object. Which method should you use?A. ExecuteNonQueryB. ExecuteScalarC. ToStringD. ExecuteReader

B. ExecuteScalar

 199 views

2⟩ Suppose You use Visual Studio .NET to create a Windows-based application for XYZ Inc. The applicationincludes a form that contains several controls, including a button named exitButton. After youfinish designing the form, you select all controls and then select Lock Controls from the Formatmenu.Later, you discover that exitButton is too small. You need to enlarge its vertical dimension withthe 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.

 177 views

3⟩ Suppose You develop a Windows-based application XYZApp that includes several menus. Every top-levelmenu 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 captiontext 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.

 188 views

4⟩ Suppose You develop a Windows-based application XYZiApp by using Visual Studio .NET. XYZiApp usesa SqlConnection object for database access.You typically run XYZiApp on a computer that has limited RAM and hard disk space. After thecode finishes using the SqlConnection object, you must ensure that the connection is closed andthat 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.

 185 views

5⟩ Suppose You create a Visual Studio .NET setup project to distribute an application. You add a SQL scriptnamed XYZDB.SQL. You must ensure that the SQL script is executed during the installationprocess. 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.

 195 views

6⟩ Suppose You develop a Windows-based application XYZ App by using Visual Studio .NET. XYZAppimplements ADO.NET objects to call Microsoft SQL Server stored procedures. Your databaseadministrator is responsible for coding and maintaining all stored procedures. Periodically, theadministrator modifies the stored procedures.At run time, your application code must discover any changes in the way that values are passedto and returned from the stored procedures.Which ADO.NET object and method should you use?A. CommandBuilder.RefreshSchemaB. CommandBuilder.DeriveParametersC. SqlCommand.CreateParameterD. SqlDataAdapter.GetFillParameters

B. CommandBuilder.DeriveParameters

 195 views

7⟩ Suppose You use Visual Studio .NET to develop a Windows-based application. Your application willdisplay customer order information from a Microsoft SQL Server database. The orders will bedisplayed on a Windows Form that includes a DataGrid control named XYZGrid1. XYZGrid1 isbound 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 inXYZGrid1.What should you do?A. Set the RowStateFilter property of the DataView object toDataViewRowState.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.

 203 views

8⟩ Suppose You develop a Windows-based inventory management application that interacts with a MicrosoftSQL Server database. Your application enables users to update information about items ininventory. Each time a user changes an inventory item, your application executes a SQL Serverstored procedure XYZSP to update rows in the database. XYZSP will run many times during eachuser session.Your application will use a SqlCommand object to execute XYZSP. You must revise your code sothat the use of this object optimizes query performance.What should you do?A. Call the SqlCommand.DeriveParameters method before each call toSqlCommand.ExecuteNonQuery.B. Call the SqlCommand.Prepare method before each call to SqlCommand.ExecuteNonQuery.C. Call the SqlCommand.DeriveParameters method before the first call toSqlCommand.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.

 182 views

10⟩ As a developer at XYZ you develop a new sales analysis application that reuses existing dataaccess components. One of these components returns a DataSet object that contains the data forall customer orders for the previous year.You want your application to display orders for individual product numbers. Users will specify theappropriate product numbers at run time.What should you do?A. Use the DataSet.Reset method.B. Set the RowFilter property of the DataSet object by using a filter expression.C. Create a DataView object and set the RowFilter property by using a filter expression.D. Create a DataView object and set the RowStateFilter property by using a filter expression..

C. Create a DataView object and set the RowFilter property by using a filter expression.

 186 views

11⟩ You are preparing a localized version of a Windows Form named XYZLocal. Users of XYZLocalspeak a language that prints text from right to left. User interface elements on the form need toconform to this alignment.You must ensure that all user interface elements are properly formatted when the localizedWindows Form runs. You must also ensure that XYZLocal is easy to update and maintain.What should you do?A. Set the RightToLeft property of each control on the form to Yes.B. Set the RightToLeft property of the form to Yes.C. Set the Language property of the form to the appropriate language.D. Set the Localizable property of the form to True.

B. Set the RightToLeft property of the form to Yes.

 174 views

12⟩ Suppose You develop a Windows Form that provides online help for users. You want the help functionalityto be available when users press the F1 key. Help text will be displayed in a pop-up window forthe text box that has focus.To implement this functionality, you need to call a method of the HelpProvider control and passthe text box and the help text.Which method should you call?A. SetShowHelpB. SetHelpStringC. SetHelpKeywordD. ToString

B. SetHelpString

 180 views

13⟩ Suppose You develop a Windows-based application. The application uses a DataSet object that containstwo DataTable objects. The application will display data from the two data tables. One tablecontains customer information, which must be displayed in a data-bound ListBox control. Theother table contains order information, which must be displayed in a DataGrid control.You need to modify your application to enable the list box functionality. What should you do?A. Use the DataSet.Merge method.B. Define primary keys for the DataTable objects.C. Create a foreign key constraint on the DataSet object.D. Add a DataRelation object to the Relation collection of the DataSet object.

D. Add a DataRelation object to the Relation collection of the DataSet object.

 199 views

14⟩ Suppose You develop a Windows-based application that includes the following code segment. (Linenumbers 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.Validating05 If ValidPassword() = False Then06 Insert new code.07 End If08 End SubYou must ensure that users cannot move control focus away from textPassword ifValidPassword returns a value of False. You will add the required code on line 6.Which code segment should you use?A. e.Cancel = TrueB. sender = textNameC. password.AcceptsTab = FalseD. password.CausesValidation =False

A. e.Cancel = True

 193 views