ADO Test

ADO.Net

1. What is ADO Full form?

Active Dependency Object
Active Data Option
ActiveX Data Object


2. Which Namespace is needed to work with SqlServer?

Using System.Data;
Using System.Data.Sql;
Using System.Data.SqlClient;


3. What is DataSet?

DataSet is collection of Database
DataSet is colection of tables
DataSet is will get data from database


4. Which statement is TRUE?

Dataset work with Disconnected Architecture
DatReader work with Disconnected Architecture
DataAdapter work with connected Architecture


5. What is the purpose of Ado.Net?

Ado.net is used to create classes in c#
Ado.net is used to communicate with Database
Ado.Net is used to create create object of classes


6. which statemetn is false?

data adapter is meadiator between dataset and database
data set is not a collection of tables
None


7. what is connection object?

It is used to perform DML operations
It is used make a connection
It is used to manipulate data in DB


8. which method is used to fill that data in dataset

Fall()
Full()
Fill()


9. How will you access data from dataset

By using index
bu using name of table
All the above


10. whihc method of command object do you use to perform Insert operation

ExecuteReader()
ExceCuteScalar()
ExcecuteNonQuery()