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 have two parent and child data tables named 'DTOrder' and 'DTOrderDetail' respectively. Both are stored in a data set named 'DS.' How will you make a relation 'DTOrder2DTOrderDetail' between the two, using 'OrderId' as primary key?

Which one was not among the main design goals behind ADO NET?

Which options should you use to copy the edited rows from a dataset called ProductInfo into another dataset called Product Changes?

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?

You want to return '1' as new ID, if there exists no record in the database. Otherwise, the return value should be the maximum bill number plus one. What should follow in line 4, if you want to check for Null values as well?

You are using Visual Basic to retrieve class information from a Microsoft SQL Server database named ClassList. The database resides on a server named Neptune. Which code fragment will create a connection to this data source?

Which one is not true about CommandType.TableDirect?