ADO.NET is known for disconnected data extraction. Which of the following does not use the disconnected mechanism while extracting data from the database?

You have following data table structure: Sales ----------- SalemanId OrderId Price How will you calculate the total amount generated by a salesman (with SalemanID =2201) if the name of DataTable is 'DatTab?'

You have a data table named 'DTable.' You are writing a sub routine to validate the changes made by the user. Which of the following would you use to get the changed table data?

You have created an SqlCommand object as shown below by passing the sql query and the connection object. Dim cmd as New SqlCommand(''Select CategoryID, CategoryName FROM Categories'', con) Which of the following methods would be used by you to get data?

You use a Command object to retrieve employee names from the employee table in the database. Which one will be returned when this command is executed using the ExecuteReader method?

You have to retrieve the details of some members from the 'Member' table. The data reader is executed to get the values. Which one helps go through the results?

You defined a data adapter as follows: Dim adap As New SqlDataAdapter('select * from products;select * from customers', New SqlConnection(ConnectionString)) Dim DataSet As New DataSet adap.Fill(DataSet) How will you pass the customers data to a data grid named as 'dGrid'?

Premium Finance Corp is involved in the savings business with branches all over the country. They provide flexible schemes which can be designed according the client's requirements. A dataset maintains all schemes in separate tables. Whenever a new scheme is created, the dataset creates a new table but it must be checked that the new table name should not already exist. Which method of the Tables collection should be used to check whether the table already exists?

You have got the data view of the customer table named 'ViewCust'. Before displaying the records in the grid, you want to retrieve the CustomerIDs with a value less than 50. How will you do this?

Which one is capable of returning multiple rows and multiple columns from the database?

PreFin101.com has a guest book which uses an XML document. Initially, an XML file is uploaded into the datatable. As records increase, the 'GuestID' column should be incremented. Which properties of the column will be used to implement the auto increment functionality?