ado.net questions and answers paper 660 - skillgunNote: Paper virtual numbers may be different from actual paper numbers . In the page numbers section website displaying virtual numbers .
what is true about Dataset? A) Can interact with multiple database. B) Can interact with multiple database. C) transcation of data is fast when compared with DataReader. D) Transcation data is slow when compared with DataReader.
A and D
A and B
A and C
B and D
Which Command is used to excute stored Procedure
CommandType is an enum
Which technique is used to transfer dataset result from to another
What object is used to check the state of the connection?
Which one of these was not part of classic ADO?
XML is one of the most important leap between classic ADO and ADO.NET.
How can we commit changes in DataSet
Dataset has AcceptChanges method which commits all the changes since last time Acceptchanges has been executed.
How can we cancel all changes done in dataset?
What is basic use of DataView ?
Sorting the Dataset
Managing the Dateset
Editing the DataSet
DataView represents a complete table or can be small section of rows depending on some criteria. It is best used for sorting and finding data with in datatable.
What does DataSet.Clone do?
Copies only the Data
Copies only the Structure
Copies both Data and Structure
Copies nither Data nor Structure
Which one of these are true about RecordSet? A)Can merge two Database tables into one dataset. B) Cannot merge two database tables into one dataset. C) RecordSet cannot be sent over HTTP. D)RecordSet can be sent over HTTP
D and C
With dataset you an retrieve data from two databases like oracle and sql server and merge them in one dataset , with recordset this is not possible
What does ConnectionPooling refers to?
Use Single object for single Request
Use of Single object for multiple Requests
Use of multiple object for single request
Use of multiple object for mutiple request
What is SQL Injection?
it is a technique used by the db administrators for copying data from one data source to another data source.
The process of tampering or commenting a portion of sql query
process of copying dataset data into database tables.
None of the options are correct.
we can tamper the query by commenting some part by add special charcters, this can be avoid by using parameters
How to avoid SQL Injection attacks in ado.net ?
using inline queries.
Where to write ado.net code in a 3-layered architecture applications ?
All the Above
Which of the following given Constraints valid in DataSet tables?
Default, Primary key Constriants
Primary, Unique and Check Constriants
Primary key and Foregien key Constriants
Only Primary Key Constriant
What is MARS?
if we want to use multiple dataset without closing previous connection we have to set MultipleActiveResultSet="True"
What is the use of multiple active resultsets in ado.net ?
using MARS we can create and use multiple
datasets at a time.
using MARS we can create and use multiple data readers in ado.net at a time without closing any data reader.
using MARS we can create and use multiple data adapaters at a time for filling the content to the data sets.
Which of the following .NET frame work data providers are not supported in ado.net ?
.NET framework data provider for Oledb
.NET framework data provider for Odbc
.NET framework data provider for Sqlserver
.NET framework data provider for nhybernate.
Which of the following data provider is not present in .NET frame work 2.0
Entity client provider
Added to .net framework version 3.0 for interacting with entity data models.
Back To Top