ANSWER EXERCISE ADO.NET

ANSWER EXERCISE  ADO.NET

1. Which .net Data Provider offers best performance when connected to SQLServer Database ?

OLEDB provider

ODBC provider

SQLServer .NET Data Provider

SQLServer Data provider

2. What is the Best approach that has to be used, if you need continuous connection to the Database ?

ADO.NET

ADO

Both

None of the above

3. Which of the following statements is true about Dataset ?

Dataset can store only one table in its cache

Dataset cannot store any tables in the cache

Dataset stores tables in the cache,only when cache set to true

Dataset can store multiple tables in cache

4. The Databases that make up the data in a dataset

Should be from Single database source

Can be from multiple databases bases which are homogeneous

Can include many heterogeneous databases sources

None of the above

5. In ADO, the data from one component to other is sent in Binary format, where as in ADO.Net it is sent in

Binary format only

Text Stream

XML Format

None of the above

6. Which object of ado.net has the best performance,for retrieving the data

DataSet

DataReader

Data Provider

Dataadapter

7. No of records in memory at any given point of time when the DataReader reads the Data

All reacords pulled by the reader

Only one record at a time

Depends on the data provider

Depends on the data source

8. Which type of Dataset supports schema ?

Typed

UnTyped

Mixed

All types

9. Which Dataset gives easier access to the contents of the table ?

UnTyped

Mixed

Typed

All types

10. How do the SQL classes in .Net Communicate to SQLServer ?

TDS - Tabular Data Stream

OLEDB

ODBC

None of the above

11. Which of the following Namespace is used for better performance when connecting to SQLServer ?

System.Data

System.Data.SQLClient

System.Data.Oledb

System.Data.OracleClient

12. If the DSN (Data Source Name) has to be used with SQL Server, which namespace has to be imported ?

System.Data.SQLClient

Sytem.Data.ODBC

System.Data.OracleClient

System.Data.Oledb

13. When we need to retrieve only a single value from the Database,which Method is efficient

ExecuteReader()

ExecuteScalar()

ExecuteNonQuery()

ExecuteXmlReader()

14. If we are not returning any records from the database which method is used

ExecuteReader ()

ExecuteScalar ()

ExecuteXmlReader()

ExecuteNonQuery()

15. OLEDB Connection Pooling is handled by OLEDB.Net Provider and SQLClient Connection pooling is handled by

OLEDB Provider

SQL Provider

Windows 2000 Component Service

ODBC provider

16. Which object in ADO.Net is similar to the Recordset object of ADO ?

DataSet

DataReader

DataProvider

DataAdaptor

17. State whether the following statement is true or false.ADO.NET does not have the inherent cursor object but has data classes that include functionality of cursors

False

True

Both 1 and 2

None of the above

18. To populate the data set, which methord of DataAdapter is uesd

GetData()

FillData()

FillDataset()

Fill()

19. Which of the following statement is true ?

ADO.net is slower than Ado

Ado.net is faster than ado on all counts of connected and disconnected recordsets

Ado.net is faster than ADO for disconnected recordsets because under ADO, COM marshalling between tiers requires that values in a recordset be converted to values recognized by COM

ADO.net is slower than Ado for disconnected recordsets because under Ado.net, COM marshalling between tiers requires that values in a recordset be converted to values recognized by COM

20. Two users are trying to update the row in a database at the same time.Assuming that optimistic concurrency is not used for concurrency control in this case, what will be the result ?

The Second Update overwrites the first update

Error will be raised when the Second update happens

Second update does not happen at all

None of the above