NEW
Font size
WorksheetsADO.NET Quiz
Total questions: 19
Worksheet time: 10mins
What is ADO.NET primarily used for?
Creating web applications
Network communication
Data access technology
Designing user interfaces
Which of the following is a key feature of ADO.NET?
Direct database manipulation
Single user access
Disconnected data access
Continuous database connection
What does the DataSet in ADO.NET represent?
A method for executing SQL commands
A direct connection to the database
An in-memory representation of data
A single table of data
Which class is used to establish a connection to SQL Server in ADO.NET?
SqlConnection
SqlDataAdapter
SqlCommand
SqlDataReader
What is the purpose of the SqlDataSource control in ASP.NET?
To manage application state
To connect to a SQL database
To handle user authentication
To create user interfaces
Which of the following is NOT a data provider in ADO.NET?
OracleClient
SqlClient
OleDb
MySQLClient
What does the DataReader class provide?
A way to bind data to UI controls
A method for executing stored procedures
A way to manipulate data offline
Fast, forward-only access to data
Which method is used to read XML data in ADO.NET?
ReadXml()
WriteXml()
FetchXml()
LoadXml()
What is a primary benefit of using strongly typed datasets?
Faster data retrieval
Easier debugging
Reduced memory usage
Type safety and compile-time checking
What does the AllowPaging property do in a GridView control?
Enables sorting of records
Allows users to navigate through pages of data
Displays data in a vertical format
Automatically generates columns
Which control is best for displaying a single record's details?
FormView
DetailsView
ListView
GridView
What is the purpose of using ObjectDataSource?
To connect directly to a database
To execute SQL commands
To bind UI controls to business objects
To manage user sessions
Which of the following is a limitation of SqlDataSource?
Easy to bind with controls
Not suitable for complex queries
Minimal coding required
Supports CRUD operations
What does the AutoGenerateEditButton property do in a GridView?
Generates a new data source
Automatically creates edit buttons for each row
Allows for data filtering
Enables automatic sorting of data
Which of the following is a feature of ADO.NET's disconnected architecture?
Increases server load
Supports only single-user access
Requires constant database connection
Allows offline data manipulation
What is the main advantage of using parameterized queries?
Automatic data binding
Easier to read code
Prevention of SQL Injection
Improved performance
Which control allows for full customization of layout using templates?
ListView
FormView
DetailsView
GridView
What is the role of the DataProvider in ADO.NET architecture?
To manage user sessions
To handle application logic
To connect to the database and execute commands
To display data in UI controls
Which of the following is a use case for ADO.NET?
Creating a mobile application
Building a web portal for student results
Designing a game
Developing a desktop application
