ado.net interview questions and answers - skillgun
Which of the folloing namespace classes are the base classes for all the .net framework data providers supported in ado.net ?
All DataBase classes inherit from System.Data.Common namespace, Hence they all have common class and same functionality.
Which one of these acts as a bridge between Datastore and Dataset ?
Data Adapter are objects that connect one or more Command objects to a Dataset object
Which of the following data adapter method used for loading data into data set ?
Since data apdater acts like a bridge, its has the ability to fill the dataset
What is a DataSet?
Its acts like fornt end database since changes made on it wont effect the original database
Which of the following class is independent of .net framework data providers ?
We need not create a object of Dataset, since its pure .Net Component
What does ADO stand for?
Access Data Objects
ActiveX Data Objects
Access Data Only
Associated Data Objects
What is a Data Provider?
A set of libraries that is used to communicate with data source
A set of Data Commands
A set of libraries to used to communicate with server
A Set of objects to work with DataSets
A set of library used for external sources
Which name space is used for connecting to the oracle database 11i or later versions efficiently ?
Which namespace do we use to connect to SqlSever 2005 or later versions efficiently ?
In .Net Framework, System.Data.SqlClient is specificly design to connect to the Microsoft SqlServer
How many tables can we load into a
DataSet has the capability to store many datatables, it is like a database but disconnected.
Which of the following statements are wrong about data sets in ado.net ?
data set follows disconnected architecture.
data sets are capable taking data
from multiple data sources.
data sets are usefull for bulk updations.
None of the options are correct.
DataSet doesn't need a connected Architechture. Once data is filled into data set data set will not be aware of any modifications being performed on the data sources.
Which of the following is required for filling content into a dataset from sql server data source ?
data adpater is required for filling dataset.
Which of the following statements are wrong about datareaders in ado.net ?
data reader follows connected architecture.
data reader follows read only forward only mechanism.
data reader cannot be used for updating data in data source.
data reader is used for bulk updations.
data reader is used only for reading
data present in data sources.
Which of the following data adapter method is used for copying table schema from a sql server data source ?
pass data table object to the Fillschema method of data adapter.
What is the use of ExecuteScalar() associated with command object.
used for retrieving multiple records from a data source.
use for retrieving a single scalar
value from a datasource.
Used for performing dml operations against a data source and retrieves the number of records affected count.
ExcuteScalar is used when we want to get a sinlge output from the data sources.
Which of the below options are used for getting all the data returned by the following query ?
Query: select * from students .
use ExecuteNonQuery() method.
Use ExecuteScalar() method.
Use ExecuteReader() method.
ExecuteReader is used when the query is returning multiple values.
Which of the below given method is used for inserting the data into the sql data source table from ado.net ?
use ExecuteNonQuery() method of SqlCommand class .
Use ExecuteScalar() method of
Use ExecuteReader() method of SqlCommand class.
Use fill method of data adapter.
ExecuteNonQuery is suitable for inserting data into the Sql datasource.
Which of the following class is useful for reading the connection string present in a configuration file.
Which is the best place for storing the Connection String ?
in a static application variable .
All the secured connection are stored in web.config in encyrpted format in case of asp.net applications.
Which one of these are true about Dataser? A)Changes made in Dataset will Effect the original database. B) DataSet follows Disconnected Architechture. C)Changes made in DataSet wil not effect the original database. D) DataSet follow Connected Architechture.
A and B are true
B and C are true
C and D are true
A and D are true
The connection is closed after the data is extracted from the database, hence the changes made in dataset wont effect the original database
Back To Top