What is ADO.NET primarily used for?
a. Data access and manipulation
b. User interface design
c. Web page layout
d. Session management
Answer: a. Data access and manipulation
Which class in ADO.NET is used to connect to a SQL Server database?
a.
SqlConnection
b.
SqlCommand
c.
SqlDataAdapter
d.
SqlDataReader
Answer: a.
SqlConnection
How do you execute a SQL query and return a single value in ADO.NET?
a. Using
SqlCommand.ExecuteScalar()
b. Using
SqlCommand.ExecuteNonQuery()
c. Using
SqlCommand.ExecuteReader()
d. Using
SqlDataAdapter.Fill()
Answer: a. Using
SqlCommand.ExecuteScalar()
What method of
SqlCommand is used to execute a command that does not return any data?
a.
ExecuteNonQuery()
b.
ExecuteReader()
c.
ExecuteScalar()
d.
ExecuteXmlReader()
Answer: a.
ExecuteNonQuery()
What is the role of the
SqlDataAdapter class in ADO.NET?
a. To fill a
DataSet or
DataTable with data from a database
b. To open and manage database connections
c. To execute SQL commands
d. To read data from a database
Answer: a. To fill a
DataSet or
DataTable with data from a database
Which class provides a forward-only, read-only cursor for reading data?
a.
SqlDataReader
b.
SqlDataAdapter
c.
SqlConnection
d.
SqlCommand
Answer: a.
SqlDataReader
How can you handle transactions in ADO.NET?
a. By using the
SqlTransaction class
b. By setting
TransactionScope in
SqlCommand
c. By configuring transactions in
SqlConnection
d. By using
DataSet transactions
Answer: a. By using the
SqlTransaction class
What is the purpose of the
DataSet class in ADO.NET?
a. To hold data in memory in a tabular format
b. To manage database connections
c. To execute SQL queries
d. To handle transactions
Answer: a. To hold data in memory in a tabular format
Which ADO.NET object is used to fill a
DataSet with data from a database?
a.
SqlDataAdapter
b.
SqlConnection
c.
SqlCommand
d.
SqlDataReader
Answer: a.
SqlDataAdapter
What method of
SqlCommand is used to execute a query and return a
DataReader object?
a.
ExecuteReader()
b.
ExecuteNonQuery()
c.
ExecuteScalar()
d.
ExecuteXmlReader()
Answer: a.
ExecuteReader()
How do you update a database using a
DataSet in ADO.NET?
a. By calling
DataAdapter.Update()
b. By calling
DataSet.Update()
c. By calling
SqlCommand.ExecuteNonQuery()
d. By calling
SqlDataAdapter.Fill()
Answer: a. By calling
DataAdapter.Update()
What class is used to perform batch operations in ADO.NET?
a.
SqlDataAdapter
b.
SqlBulkCopy
c.
SqlCommand
d.
SqlTransaction
Answer: b.
SqlBulkCopy
Which method in
SqlCommand is used to execute a SQL command and return a single object?
a.
ExecuteScalar()
b.
ExecuteNonQuery()
c.
ExecuteReader()
d.
ExecuteXmlReader()
Answer: a.
ExecuteScalar()
What does the
Fill() method of
SqlDataAdapter do?
a. Populates a
DataSet or
DataTable with data from the database
b. Executes a SQL command
c. Opens a database connection
d. Reads data from a database
Answer: a. Populates a
DataSet or
DataTable with data from the database
Which ADO.NET class is used to manage connections to a database?
a.
SqlConnection
b.
SqlCommand
c.
SqlDataAdapter
d.
SqlDataReader
Answer: a.
SqlConnection
How do you handle errors during database operations in ADO.NET?
a. By using try-catch blocks
b. By using the
SqlException class
c. By checking the
HasRows property of
DataReader
d. By validating
DataSet changes
Answer: a. By using try-catch blocks
What is the default command behavior of
SqlCommand when executing a query?
a. It returns a result set
b. It performs an update operation
c. It opens a new database connection
d. It executes a stored procedure
Answer: a. It returns a result set
Which class in ADO.NET provides functionality for reading XML data?
a.
XmlReader
b.
SqlDataReader
c.
SqlDataAdapter
d.
SqlCommand
Answer: a.
XmlReader
What is the purpose of the
DataRow class in ADO.NET?
a. To represent a single row in a
DataTable
b. To execute SQL queries
c. To manage database connections
d. To fill a
DataSet with data
Answer: a. To represent a single row in a
DataTable
Which method of
SqlConnection is used to open a connection to the database?
a.
Open()
b.
Connect()
c.
Begin()
d.
Start()
Answer: a.
Open()
What is the purpose of
DataTable in ADO.NET?
a. To represent a single table of in-memory data
b. To execute a SQL command
c. To manage database connections
d. To handle database transactions
Answer: a. To represent a single table of in-memory data
How can you execute a stored procedure using ADO.NET?
a. By setting the
CommandType property of
SqlCommand to
StoredProcedure
b. By using the
SqlDataAdapter class
c. By using the
DataSet class
d. By using the
SqlConnection class
Answer: a. By setting the
CommandType property of
SqlCommand to
StoredProcedure
Which method of
SqlDataReader is used to read the next row of data?
a.
Read()
b.
Next()
c.
Fetch()
d.
MoveNext()
Answer: a.
Read()
What is the role of
SqlTransaction in ADO.NET?
a. To manage transactions within a database connection
b. To execute SQL commands
c. To open a database connection
d. To read data from a database
Answer: a. To manage transactions within a database connection
Which property of
SqlDataAdapter is used to specify the SQL command to execute?
a.
SelectCommand
b.
CommandText
c.
CommandType
d.
Connection
Answer: a.
SelectCommand
How can you specify a SQL query parameter in ADO.NET?
a. By using
SqlParameter class
b. By including the parameter directly in the SQL query string
c. By setting the
CommandText property
d. By configuring parameters in
SqlConnection
Answer: a. By using
SqlParameter class
What does the
ExecuteNonQuery() method of
SqlCommand return?
a. The number of rows affected by the command
b. The result set from the command
c. A single value from the command
d. A
DataReader object
Answer: a. The number of rows affected by the command
Which class in ADO.NET is used to fill a
DataSet with data from multiple tables?
a.
SqlDataAdapter
b.
SqlConnection
c.
SqlCommand
d.
SqlDataReader
Answer: a.
SqlDataAdapter
What does the
Close() method of
SqlConnection do?
a. Closes the connection to the database
b. Cancels the current transaction
c. Rolls back the current transaction
d. Stops the execution of a command
Answer: a. Closes the connection to the database
Which method of
DataSet is used to merge changes from a
DataTable?
a.
Merge()
b.
Update()
c.
AcceptChanges()
d.
Refresh()
Answer: a.
Merge()
What is
DataReader used for in ADO.NET?
a. To read data in a forward-only, read-only manner
b. To fill a
DataSet with data
c. To execute commands against the database
d. To manage database connections
Answer: a. To read data in a forward-only, read-only manner
Which class in ADO.NET is used to execute SQL commands and retrieve results?
a.
SqlCommand
b.
SqlConnection
c.
SqlDataAdapter
d.
SqlDataReader
Answer: a.
SqlCommand
How can you retrieve schema information from a database using ADO.NET?
a. By using the
GetSchema() method of
SqlConnection
b. By using
SqlDataAdapter
c. By using
SqlCommand
d. By using
DataSet
Answer: a. By using the
GetSchema() method of
SqlConnection
What is the function of
SqlBulkCopy class in ADO.NET?
a. To efficiently bulk copy data from one data source to another
b. To execute SQL commands
c. To read data from a database
d. To fill a
DataSet with data
Answer: a. To efficiently bulk copy data from one data source to another
How do you handle concurrency issues in ADO.NET?
a. By using
RowVersion or
Timestamp columns
b. By disabling transactions
c. By using
DataReader
d. By configuring isolation levels in
SqlConnection
Answer: a. By using
RowVersion or
Timestamp columns
Which property of
SqlCommand is used to specify whether a command is a stored procedure or a SQL query?
a.
CommandType
b.
CommandText
c.
Parameters
d.
Connection
Answer: a.
CommandType
What does the
FillSchema() method of
SqlDataAdapter do?
a. Fills the
DataSet with schema information only
b. Executes a SQL command
c. Fills the
DataSet with data
d. Updates the
DataSet with changes
Answer: a. Fills the
DataSet with schema information only
Which class provides methods for managing the database connection pool in ADO.NET?
a.
SqlConnection
b.
SqlConnectionStringBuilder
c.
SqlCommand
d.
SqlDataAdapter
Answer: a.
SqlConnection
What is the default behavior of
DataSet when changes are made to its rows?
a. Changes are tracked and can be updated to the database
b. Changes are automatically committed to the database
c. Changes are discarded
d. Changes are saved in a new
DataSet
Answer: a. Changes are tracked and can be updated to the database
What does the
GetChanges() method of
DataSet return?
a. A copy of the
DataSet with changes
b. The number of rows changed
c. The schema of the
DataSet
d. The original
DataSet
Answer: a. A copy of the
DataSet with changes
Which class in ADO.NET is used for accessing and updating XML data?
a.
XmlDataAdapter
b.
SqlDataAdapter
c.
DataTable
d.
DataSet
Answer: a.
XmlDataAdapter
What is the purpose of
DataTableReader in ADO.NET?
a. To provide a forward-only, read-only cursor for reading data from a
DataTable
b. To manage database connections
c. To execute SQL commands
d. To update a
DataSet
Answer: a. To provide a forward-only, read-only cursor for reading data from a
DataTable
Which ADO.NET class is designed for asynchronous database operations?
a.
SqlCommand with async methods
b.
SqlDataAdapter
c.
SqlConnection
d.
DataSet
Answer: a.
SqlCommand with async methods
What is the function of the
UpdateCommand property of
SqlDataAdapter?
a. It specifies the SQL command used to update the database with changes from a
DataSet
b. It specifies the SQL command to delete records
c. It specifies the SQL command to insert new records
d. It specifies the SQL command to select records
Answer: a. It specifies the SQL command used to update the database with changes from a
DataSet
How can you perform batch updates to a database using ADO.NET?
a. By using
SqlDataAdapter with multiple commands
b. By using
SqlCommand with
Transaction
c. By using
SqlBulkCopy
d. By using
DataTable with
DataSet
Answer: c. By using
SqlBulkCopy
What is the purpose of
DataColumn in ADO.NET?
a. To represent a single column in a
DataTable
b. To execute a SQL command
c. To manage database connections
d. To handle transactions
Answer: a. To represent a single column in a
DataTable
How does ADO.NET handle data in disconnected mode?
a. By using
DataSet and
DataTable to store data locally
b. By maintaining an open connection throughout the data access
c. By using
SqlDataReader in an open connection
d. By using
DataAdapter to fill data directly
Answer: a. By using
DataSet and
DataTable to store data locally
