Enter your search terms
Submit search form
Web
examineonline.googlepages.com
Online Exam
>>
Programming
>>
Microsoft.Net
>>
ADO.NET
Menu
Programming
COMPTIA
GMAT
English
IQ
DataBase
OS
MCSE
CISCO
Finance
Management
Health
Soft Skills
Web Building
Multimedia
ADO.NET
1 . Which .net Data Provider offers best performance when connected to SQLServer Database ?
A.
OLEDB provider
B.
ODBC provider
C.
SQLServer .NET Data Provider
D.
SQLServer Data provider
2 . What is the Best approach that has to be used, if you need continuous connection to the Database ?
A.
ADO.NET
B.
ADO
C.
Both
D.
None of the above
3 . Which of the following statements is true about Dataset ?
A.
Dataset can store only one table in its cache
B.
Dataset cannot store any tables in the cache
C.
Dataset stores tables in the cache,only when cache set to true
D.
Dataset can store multiple tables in cache
4 . The Databases that make up the data in a dataset
A.
Should be from Single database source
B.
Can be from multiple databases bases which are homogeneous
C.
Can include many heterogeneous databases sources
D.
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
A.
Binary format only
B.
Text Stream
C.
XML Format
D.
None of the above
6 . Which object of ado.net has the best performance,for retrieving the data
A.
DataSet
B.
DataReader
C.
Data Provider
D.
Data Adapter
7 . No of records in memory at any given point of time when the DataReader reads the Data
A.
All reacords pulled by the reader
B.
Only one record at a time
C.
Depends on the data provider
D.
Depends on the data source
8 . Which type of Dataset supports schema ?
A.
Typed
B.
UnTyped
C.
Mixed
D.
All types
9 . Which Dataset gives easier access to the contents of the table ?
A.
UnTyped
B.
Mixed
C.
Typed
D.
All types
10 . How do the SQL classes in .Net Communicate to SQLServer ?
A.
TDS - Tabular Data Stream
B.
OLEDB
C.
ODBC
D.
None of the above
11 . Which of the following Namespace is used for better performance when connecting to SQLServer ?
A.
System.Data
B.
System.Data.SQLClient
C.
System.Data.Oledb
D.
System.Data.OracleClient
12 . If the DSN (Data Source Name) has to be used with SQL Server, which namespace has to be imported ?
A.
System.Data.SQLClient
B.
Sytem.Data.ODBC
C.
System.Data.OracleClient
D.
System.Data.Oledb
13 . When we need to retrieve only a single value from the Database,which Method is efficient
A.
ExecuteReader()
B.
ExecuteScalar()
C.
ExecuteNonQuery()
D.
ExecuteXmlReader()
14 . If we are not returning any records from the database which method is used
A.
ExecuteReader ()
B.
ExecuteScalar ()
C.
ExecuteXmlReader()
D.
ExecuteNonQuery()
15 . OLEDB Connection Pooling is handled by OLEDB.Net Provider and SQLClient Connection pooling is handled by
A.
OLEDB Provider
B.
SQL Provider
C.
Windows 2000 Component Service
D.
ODBC provider
16 . Which object in ADO.Net is similar to the Recordset object of ADO ?
A.
DataSet
B.
DataReader
C.
DataProvider
D.
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
A.
False
B.
True
C.
Both 1 and 2
D.
None of the above
18 . To populate the data set, which methord of DataAdapter is uesd
A.
GetData()
B.
FillData()
C.
FillDataset()
D.
Fill()
19 . Which of the following statement is true ?
A.
ADO.net is slower than Ado
B.
Ado.net is faster than ado on all counts of connected and disconnected recordsets
C.
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
D.
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 ?
A.
The Second Update overwrites the first update
B.
Error will be raised when the Second update happens
C.
Second update does not happen at all
D.
None of the above
Test Name :
ADO.NET
Category :
Microsoft.Net
Number of Question :
20
Pass Score :
80
Test Result
Your Score :
Passing Score :
80
Result :
Copyright by
VanTuMinh
© 2007
