MCQ Flashcards
Which method of the SqlDataReader class is used to read the next record?
Read()
What is the purpose of the ConnectionString property in ADO.NET?
To Configure Connection to a Database
What is the contents of a connections string?
- The database server address
- The dabase name
- The user authentication inforamtion
Which command is used to add a parameter to an SqlCommand object?
Which command is used ot add a parameter to an SQlCommand object?
Add()
What does the Daset class represent in ADO.NET?
An in memory cache of data
What type of ADO.net object is used to execute a stored procedure?
SqlCommand object
What is the purpose of the fill method of a DataAdapter?
to fill a Dataset with data
What does the ExecuteReader method return?
an Sql Datareader object
What object is used to represent a relationship between two tabless in a DataSet?
DataRelation
What is the purpose of the AcceptChanges method in a DataSet?
To commit all changes made sice the lass AcceptCahnges called
Which class class is used to retrive data from the database?
DataReader Class
What is the pupose of the Sql Connection class?
To manage a connection to an Sql Server database
Which method is used to open a connection to a databse?
.Open()
Name a method NOT avalable on a DataAdapeter method?
Read
What is the default isolation level in ADO.NET transactions?
ReadCommitted
What does the ExecuteScalar Method return?
A single value
Which method is used to execute a SQL statement against a connection and return the number of rows affected?
ExecuteNonQuery
What is the purpose of the SqlCommand object?
To execute SQL statements against a database
Which is the job of a DataRelation.
It relates two DataTable objects in a DataSet
