c# SEASON TWO FINAL CHAP 15 finale pt 7
A ____ is used to perform a forward-only (sequential) access of the data in the data source while a ____ is used to populate a dataset and updates the database.
Data reader, data adapter
A ____ object is instantiated based on the type of database or type of database provider.
Connection
string sConnection =
"Provider=Microsoft.ACE.OLEDB.12.0;" +
"Data Source=member.accdb";
The above connection string is associated with which type of database?
Access
string sConnection =
"Provider=Microsoft.ACE.OLEDB.12.0;" +
"Data Source=member.accdb";
Using the segment of code above, what is member.accdb?
the name of an Access Database
Which class is used to hold the SQL statement or stored procedures for Access databases?
OleDbCommand
Which of the following SQL statements would retrieve just the first name of all records for Mr. and Mrs. Jones in the memberTable?
Select FirstName from memberTable Where LastName = 'Jones';
To retrieve data from multiple tables use a(n) ____.
INNER JOIN
Typing or inserting an actual SQL query or command as input (as opposed to a requested value, such as a user login name), gaining access to the tables, and then stealing or destroying data is an example of a(n) ____.
SQL injection attack
Read-only forward retrieval of data from an Access database is possible using the ____ class.
OleDbDataReader
In order to use the dataReader object to retrieve the lastName, which is located in the third field of a data record, you could write ____.
dataReader["lastName"]
Which of the following is a typed accessor method of the OleDbDataReader class?
GetBoolean( )
A cache of records retrieved from some data source that may contain one or more tables from the data source describes a(n) ____.
Dataset
One of the visual tools that provides a graphical representation of the dataset object and enables you to set relationships between tables is the ____.
DataSet Designer
A new SQL Server database can be created from the ____ Explorer Window.
Server
You may not want to make a local copy of the database if ____.
updates or changes are being made to the database
When the connection string is saved with the application, it is stored in the ____.
App.config file
Which class is automatically instantiated when a table from the Data Sources window is dragged onto the form?
BindingNavigator
All of the following are core classes that make up the ADO.NET data providers EXCEPT ____.
DataSet
To process the data using a data reader with an Access database, you declare an object of the OleDbDataReader class and then ____.
call the ExecuteReader( ) method.
When finished processing the data, you should close the reader and connection objects. Doing so ____.
unlocks the database so that other applications can access it
ADO.NET does not require that you keep a continuous live connection to the database and process one retrieved record at a time. Additional classes are available that enable you to connect to the database long enough to retrieve records into memory. The primary class for this activity is ____.
DataSet