Top 20 MCQ Questions On ADO.Net Architecture

Here are the collections of MCQ questions on ADO.Net architecture includes multiple-choice questions on the fundamentals of ADO.Net architecture. It includes objective-type questions on the benefits of ADO.Net, parts of ADO.Net architecture, core objects of the data provider, properties and methods of the connection and command object, and the major objects of the dataset.

1. … is the data access and manipulation protocol used by C#.Net.
A) ASP.Net
B) ADO.Net
C) VB.Net
D) C#.Net

2. Which of the following are the benefits of ADO.Net.
i) Interoperability
ii) Maintainability
iii) Performance
iv) Visibility
A) i, ii and iii only
B) ii, iii and iv only
C) i, iii and iv only
D) All i, ii, iii and iv

3. State whether the following statements about ADO.Net are True or False.
i) ADO.Net allows you to access data through typed programming.
ii) It is the CLR-based library.
iii) It works in the connected mode to access data.
A) i-True, ii-True, iii-True
B) i-False, ii-True, iii-True
C) i-True, ii-True, iii-False
D) i-False, ii-True, iii-False

4. Which of the following are the advantages of ADO.Net compared to classic ADO.
i) Locking feature is available.
ii) XML integration is possible.
iii) It uses Dataset to store the data from the data source.
A) i and ii only
B) ii and iii only
C) i and iii only
D) All i, ii and iii

5. Which of the following are the core objects of data provider of .Net architecture.
i) Connection
ii) Command
iii) Data Adapter
A) i and ii only
B) ii and iii only
C) i and iii only
D) All i, ii and iii

6. Which of the following are the properties of the connection object.
i) Connection
ii) Integrated Security
iii) Data Source
A) i and ii only
B) ii and iii only
C) i and iii only
D) All i, ii and iii

7. State whether the following statements about connection objects are True or False.
i) Connection object helps in accessing and manipulating a database.
ii) It executes a command against a data source.
A) i-True, ii-True
B) i-False, ii-True
C) i-True, ii-False
D) i-False, ii-False

8. Which of the following are the types of commands available on the CommandType property of the command object.
i) Text
ii) StoredProcedure
iii) TableDirect
iv) Number
A) i, ii and iii only
B) ii, iii and iv only
C) i, iii and iv only
D) All i, ii, iii and iv

9. … method of command object executes the command specifies and returns the number of rows affected.
A) ExecuteNonQuery()
B) ExecuteScalar()
C) ExecuteReader()
D) ExecuteCommand()

10. … method executes the command specified and returns the first column of first row of the result set.
A) ExecuteNonQuery()
B) ExecuteScalar()
C) ExecuteReader()
D) ExecuteCommand()

11. The … provides the bridge between the data set object and the data source.
A) Data bridge
B) Data reader
C) Data object
D) Data Adapter

12. The … provides a high-performance stream of data from the data source.
A) Data bridge
B) Data reader
C) Data object
D) Data Adapter

13. State whether the following statements about the data reader are True or False.
i) It reads a forward-only, read-only stream of data from a data source.
ii) It works in a connected model.
iii) Fill() is the method of data reader object.
A) i and ii only
B) ii and iii only
C) i and iii only
D) All i, ii and iii

14. The … is a memory-resident representation of data that provides a consistent relational programming model regardless of the data source.
A) Data bridge
B) Data reader
C) Data set
D) Data Adapter

15. Which of the following are the methods of data adapter object.
i) Fill()
ii) Read()
iii) Update()
A) i and ii only
B) ii and iii only
C) i and iii only
D) All i, ii and iii

16. The … method executes the command specified and returns an instance of SqlDataReader.
A) ExecuteScalar()
B) ExecuteReader()
C) ExecuteXmlReader()
D) ExecuteCommand()

17. A … is defined in the system.Data namespace and represents a single table of memory-resident data.
A) Data Table
B) System Table
C) Root Table
D) Data Relation

18. A … identifies matching columns in two tables of the dataset.
A) Data Table
B) System Table
C) Root Table
D) Data Relation

19. State whether the following statements about the typed dataset are True or False.
i) It is the class that derives from a Dataset.
ii) It provides strongly typed methods, events, and properties.
A) i-True, ii-True
B) i-False, ii-True
C) i-True, ii-False
D) i-False, ii-False

20. State whether the following statements about the command object are True or False.
i) The command object exposes parameters and can execute in the scope of a transaction from a connection.
ii) Command object performs the standard select, Insert, Delete and Update T-SQL operations.
iii) ConnectionType and CommandText are the properties of the command object.
A) i-True, ii-True, iii-True
B) i-False, ii-True, iii-True
C) i-True, ii-True, iii-False
D) i-False, ii-True, iii-False

Answers: