You use a Command object to retrieve employee names from the employee table in the database. Which of the following 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 command types are provided by an oledb and sql provider?

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?

We are iterating through the results received in a data reader named 'DReaderOrder,' which is created by using the connection 'SqlCon.' In between we need to retrieve some more values from the database, so we executed another command in the same connection to get the results in a new data reader named 'DReaderProduct.' What will be the result if we are using ADO.NET 2.0? (Note:Multiple Active Result Sets (MARS) is enabled in SQL Server 2005).