EXERCISE 2
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 |
quiz
ReplyDelete