Select chapter



Basics (2.papers)

Sponsored Links


  

ado.net questions and answers

Show Answer
Share Facebook gmail Twitter
2
Which Command is used to excute stored Procedure
  1. ExcuteStoreProcedure
  2. CommandType.TableDirect
  3. CommandType.Text
  4. CommandType.StoredProcedure
Show Answer
Share Facebook gmail Twitter
Show Answer
Share Facebook gmail Twitter
4
What object is used to check the state of the connection?
  1. ConnectionState.Open
  2. ConnectionState.Fetching
  3. ConnectionState.Excuting
  4. ConnectionState.Connected
Show Answer
Share Facebook gmail Twitter
5
Which one of these was not part of classic ADO?
  1. DataSet
  2. XML
  3. DataAdapter 
  4. DataReader
Show Answer
Share Facebook gmail Twitter
6
How can we commit changes in DataSet
  1. GetChanges
  2. AcceptChanges
  3. CommitChanges
  4. HasChanges
Show Answer
Share Facebook gmail Twitter
7
 How can we cancel all changes done in dataset?
  1. AbandonChanges() 
  2. RejectChanges()
  3. RemoveChanges()
  4. UndoChanges()
Show Answer
Share Facebook gmail Twitter
8
 What is basic use of DataView ?
  1. Sorting the Dataset
  2. Managing the Dateset
  3. Editing the DataSet
  4. Display Dataset
Show Answer
Share Facebook gmail Twitter
9
What does DataSet.Clone do? 
  1. Copies only the Data 
  2. Copies only the Structure
  3. Copies both Data and Structure
  4. Copies nither Data nor Structure
Show Answer
Share Facebook gmail Twitter
Show Answer
Share Facebook gmail Twitter
11
What does ConnectionPooling refers to? 
  1. Use Single object for single Request
  2. Use of Single object for multiple Requests
  3. Use of multiple object for single request
  4. Use of multiple object for mutiple request
Show Answer
Share Facebook gmail Twitter
12
What is SQL Injection?
  1. it is a technique used by the db administrators for copying data from one data source to another data source.
  2. The process of tampering or commenting a portion of sql query
  3. process of copying dataset data into database tables.
  4. None of the options are correct.
Show Answer
Share Facebook gmail Twitter
13
How to avoid SQL Injection attacks in ado.net ?
  1. using sqlparameters.
  2. using inline queries.
  3. using MARS.
  4. None of the options are correct.
Show Answer
Share Facebook gmail Twitter
14
Where to write ado.net code in a 3-layered architecture applications ?
  1. Data Layer
  2. Bussniess Layer
  3. UI layer
  4. All the Above
Show Answer
Share Facebook gmail Twitter
15
Which of the following given Constraints valid in DataSet tables?
  1. Default, Primary key Constriants
  2. Primary, Unique and Check Constriants
  3. Primary key and Foregien key Constriants
  4. Only Primary Key Constriant
Show Answer
Share Facebook gmail Twitter
16
What is MARS?
  1. MultipleActiveRowSet
  2. MultipleActiveResultSet
  3. MultipleActiveRemovedSet
  4. MultipleAddedResultSet
Show Answer
Share Facebook gmail Twitter
17
What is the use of multiple active resultsets in ado.net ?
  1. using MARS we can create and use multiple 
    datasets at a time.
  2. using MARS we can create and use multiple data readers in ado.net at a time without closing any data reader.
  3. using MARS we can create and use multiple data adapaters at a time for filling the content to the data sets.
  4. None of the options are correct.
Show Answer
Share Facebook gmail Twitter
18
Which of the following .NET frame work data providers are not supported in ado.net ?
  1. .NET framework data provider for Oledb
  2. .NET framework data provider for Odbc
  3. .NET framework data provider for Sqlserver
  4. .NET framework data provider for nhybernate.
Show Answer
Share Facebook gmail Twitter
19
Which of the following  data provider is not present in .NET frame work 2.0 
  1. .NET framework data provider for Oledb
  2. .NET framework data provider for Odbc
  3. .NET framework data provider for Sqlserver
  4. Entity client provider
Show Answer
Share Facebook gmail Twitter
Read more papers :