🧪 ADO.Net MCQ Quiz Hub

1. DateSet contains one or more DataTables?
True
False
Can't say
none of the above

2. Can we use DataView to Filter rows in a DataTable?
Yes by setting Filter property
Yes by setting FilterRow property
Yes by setting the SetFilter method
none of the above

3. Which method is used to retrieve the single value?
ExecuteScalar
ExecuteReader
ExecuteSingle
ExecuteNonQuery

4. How to load XML in DataSet?
Using the ReadXml method
Using the GetXml method
Both of the above
none of the above

5. Which method is used to fill DataSet?
Populate
Fill
Open
Close

6. Which object is used to Fill DataSet using the query in SQL Server?
DataSet
DataTable
DataAdapter
none of the above

7. Which object will be used to sort the data of DataSet?
DataView object
DataSet
DataTable
DataAdapter

8. DataSet object is
disconnected
connected
Can't say
none of the above

9. Which is Read-only forward-only recordset?
DataSet
DataReader
DataAdapter
DataCommand

10. Which namespace is used to fetch data from Oracle database?
Sql.Data
Sql.Data.SqlClient
Sql.Data.OracleClient
none of the above

11. Which ADO.net object is very fast to get data from the database?
SqlDataAdapter
DataSet
SqlDataReader
none of the above

12. What is the default specified timeout period for "SQLCommand.CommandTimeout" property?
30 seconds
60 Seconds
90 Seconds
120 Seconds

13. What is the Full form of ADO.Net?
Active Display Object
ActiveX Data Object
Asp Data Object
Active Dot Object

14. Which Adapter is used to get the data from the Access Database?
DataAdapter
OledbDataAdapter
SQLDataAdapter
OracleDataAdapter

15. Which ADO.Net class provides a connected environment?
DataSet
DataReader
Both
None of the mentioned

16. When to use the OleDbConnection object?
When we want to connect to the Oracle database.
When we want to connect to the Sql server database
When we want to connect to Office Access database
none of the above

17. Which is the return type of the ExecuteScalar class?
System.Int32
object
Both
none of the above

18. Which are command object methods?
ExecuteScalar
ExecuteNonQuery
ExecuteReader
All of the above

19. Which of the following is the benefit of the ADO.Net?
Interoperability
Disconnected Data Access
Store Data in multiple tables
All of the above

20. ADO.Net provides the ability to process and create an in-memory database which is called
DataSets
Views
Tables
Relations

21. It is not required to open the connection when I am using DataAdapter.
True
False
all of the above
None of the mentioned

22. Which CommandType is used to define the StoredProcedure?
Command.TableDirect
CommandType.StoredProcedure
CommandType.TableDirect
Command.Stored

23. Which namespace is used to access the connection string from the Web.Config file?
Web.Configuration
Web.Config
System.Configuration
System.Web.Configuration

24. SqlConnection object is used for?
MySql database
Oracle database
Microsoft SQL Server database
Access database

25. Which method is suited best when we have aggregate values in the SELECT statement?
ExecuteScalar()
ExecuteNoQuery().
ExecuteReader()
None of the above

26. On which object we set the properties to create a primary key for DataTable?
DataSet
DataTable
DataRelation
DataColumn

27. Which of the following are the events of the DataTable object?
RowChanged
ColumnChanged
RowChanging
All of the above

28. Which Data Provider gives the maximum performance when connected to SQL Server?
SqlClient Data Provider
OLEDB Data Provider
Oracle Data Provider
All of the above

29. If we want that the command object should return XML data then which Command object will be used?
GetXMLData
GetXml
ExecuteXmlReader
none of the above