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
|
