c# SEASON TWO FINAL CHAP 14 pt 1
The connection string includes ____.
the data provider and the database name
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
The ____ base class is used to hold the SQL statement or stored procedures.
Command
The SQL statement that retrieves every field from a database table includes ____ following the SELECT keyword.
an asterisk (*)
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';
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"]
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
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.
All of the following are data providers included with .NET for accessing and manipulating data in databases, EXCEPT ____.
Access
Select * from memberTable retrieves all records from the memberTable table that do not have any blank fields.
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
A foreign key is a column (field) or combination of columns that uniquely identifies a row in a table.
FALSE
When accessing a database, it is not necessary to close the connection. This is done automatically for you.
FALSE
The SELECT statement can also be used to retrieve results from multiple tables by joining them using a common field.
TRUE
You identify which records and fields you want to retrieve from the database using the SQL ____________ statement
SELECT
sConnection = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=member.accdb"; is an example of a(n) ____________.
connection string
Which class is automatically instantiated when a table from the Data Sources window is dragged onto the form?
BindingNavigator
To retrieve data from a database programmatically, one of the first things you must do is ____.
connect to the database
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
Classes that can be used to retrieve, manipulate, and update data in databases are part of ____.
ADO.NET
SELECT Address FROM member
WHERE FirstName = 'Bill' AND LastName = 'King';
Given the above SQL statement, which of the following statements is true?
Address is a field.
After connecting to the database, one way to retrieve records programmatically from the database is to ____
issue an SQL query.
When accessing data from a database, select the records (and fields) from the database by executing a SQL Fill statement.
FALSE