Select chapter



Basics (2.papers)

Sponsored Links


  

ado.net questions and answers

Show Answer
Share Facebook gmail Twitter
2
Which one of these acts as a bridge between Datastore and Dataset ?
  1. Connection
  2. Command Object
  3.  Data Adapter 
  4. Data Set
Show Answer
Share Facebook gmail Twitter
Show Answer
Share Facebook gmail Twitter
4
What is a DataSet?
  1. BackEnd DataBase
  2. DataCommand
  3. FrontEnd Database
  4. Virtual Database
Show Answer
Share Facebook gmail Twitter
Show Answer
Share Facebook gmail Twitter
6
What does ADO stand for?
  1. Access Data Objects
  2. ActiveX Data Objects
  3. Access Data Only
  4. Associated Data Objects
Show Answer
Share Facebook gmail Twitter
7
What is a Data Provider? 
  1. A set of libraries that is used to communicate with data source
  2. A set of Data Commands
  3. A set of libraries to used to communicate with server
  4. A Set of objects to work with DataSets
Show Answer
Share Facebook gmail Twitter
8
Which name space is used for connecting to the oracle database 11i or later versions efficiently ?
  1. system.data.oledb
  2. system.data.odbc
  3. system.data.OrcleClient
  4. system.data.sqlclient
Show Answer
Share Facebook gmail Twitter
9
Which namespace do we use to connect to SqlSever 2005 or later versions efficiently ?
  1. System.Data.Oracle
  2. System.Data.SqlClient
  3. System.Data.Net
  4. System.Data.IO
Show Answer
Share Facebook gmail Twitter
Show Answer
Share Facebook gmail Twitter
11
Which of the following statements are wrong about data sets in ado.net ?
  1. data set follows disconnected architecture.
  2. data sets are capable taking data 
    from multiple data sources.
  3. data sets are usefull for bulk updations.
  4. None of the options are correct.
Show Answer
Share Facebook gmail Twitter
Show Answer
Share Facebook gmail Twitter
13
Which of the following statements are wrong about datareaders in ado.net ?
  1. data reader follows connected architecture.
  2. data reader follows read only forward only mechanism.
  3. data reader cannot be used for updating data in data source.
  4. data reader is used for bulk updations.
Show Answer
Share Facebook gmail Twitter
Show Answer
Share Facebook gmail Twitter
15
What is the use of ExecuteScalar() associated with command object.
  1. used for retrieving multiple records from a data source.
  2. use for retrieving a single scalar 
    value from a datasource.
  3. Used for performing dml operations against a data source and retrieves the number of records affected count.
  4. None of the options are correct.
Show Answer
Share Facebook gmail Twitter
16
Which of the below options are used for getting all the data returned by the following query ?
Query: select * from students .
  1. use ExecuteNonQuery() method.
  2. Use ExecuteScalar() method.
  3. Use ExecuteReader() method.
  4. None of the options are correct.
Show Answer
Share Facebook gmail Twitter
17
Which of the below given method is used for inserting the data into the sql data source table from ado.net ?
  1. use ExecuteNonQuery() method of SqlCommand class .
  2. Use ExecuteScalar() method of 
    SQLCommand class.
  3. Use ExecuteReader() method of SqlCommand class.
  4. Use fill method of data adapter.
Show Answer
Share Facebook gmail Twitter
Show Answer
Share Facebook gmail Twitter
19
Which is the best place for storing the Connection String ?
  1. Gobal.asax
  2. in a static application variable .
  3. Default.aspx
  4. Configuration file.
Show Answer
Share Facebook gmail Twitter
Show Answer
Share Facebook gmail Twitter
Read more papers :