C. Microsoft SQL Server Data Transformation Services (DTS)
If you are creating the logical design for the new reservation application. Which entity or entities should you include? (Choose all options that apply)A. AirportB. FlightC. CustomerD. GateE. City
Explain Which data item or items should you add to the existing applications? (Choose all that apply)A. Waybill informationB. Broker identification informationC. Depot informationD. Parcel dimensionsE. Parcel routing informationF. Information about use of space on vehicles
Explain Which performance standard should you use for your solution?A. Vehicle usage of at least 80 percent of total capacityB. Database size of less than one terabyteC. CPU utilization of less than 50 percent in the database serverD. Screen response time of two seconds or less
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
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.
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.
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
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.
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
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.
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
