c# SEASON TWO FINAL CHAP 14 pt 3
OleDbDataReader class includes a number of typed accessor method members (i.e GetChar( ), GetString( ), GetDecimal( ))..
TRUE
ADO.NET requires that you keep a continuous live connection to the database and process one retrieved record at a time.
FALSE
While the data reader object can hold just one record of the query result at a time, the dataset object stores an entire relational table like structure.
TRUE
The CommandBuilder object used for accessing data from database tables can be used for datasets that map to one or more database tables.
FALSE
Using the local copy of data stored in a datagrid object, you can delete, insert new records or change the values of individual fields in the data grid.
TRUE
Each data provider includes a collection of classes used to access a data source, including connection, command, data reader and data adapter classes.
TRUE
The query language used to access, manipulate, and update data in a database is called Data Query Language.
FALSE
Connection strings are vendor specific.
TRUE
Select * from memberTable retrieves all records from the memberTable table that do not have any blank fields.
FALSE
The SELECT statement can also be used to retrieve results from multiple tables by joining them using a common field.
TRUE
A Data Source Configuration Wizard is available in Visual Studio to automatically generate the connection string, create dataset and table adapter objects, and bring the data into an application.
TRUE
The default server name for SQL Express is (LocalDB)\v11.0.
TRUE
The ADO namespace includes a number of classes that allow you to interact with databases.
FALSE
The WSQL Designer in Visual Studio provides a visual representation of the objects contained in the dataset. It enables you to set relationships between objects and add additional queries to your application.
FALSE
When you place an @ in front of a string, the string becomes a(n) ____.
verbatim string
Classes that can be used to retrieve, manipulate, and update data in databases are part of ____.
ADO.NET
To retrieve data from a database programmatically, one of the first things you must do is ____.
connect to the database
The SQL statement that retrieves every field from a database table includes ____ following the SELECT keyword.
an asterisk (*)
The ADO.NET architecture encapsulates the details of differing database structures such as
Oracle, as opposed to Access, in the form of ____.
data providers
A ____ object is instantiated based on the type of database or type of database provider.
connection
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';
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
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( )
You may not want to make a local copy of the database if ____.
updates or changes are being made to the database
Which class is automatically instantiated when a table from the Data Sources window is dragged onto the form?
BindingNavigator
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.
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
The ____ base class is used to hold the SQL statement or stored procedures.
Command
string sConnection =
"Provider=Microsoft.ACE.OLEDB.12.0;" +
"Data Source=member.accdb";
the name of an Access Database