Exam 14: Working With Databases

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 ____.

Each data provider includes a collection of classes used to access a data source, including connection, command, data reader and data adapter classes.

Applications that connect to a Microsoft Access database use the OLE DB data provider.

In relational databases, data is stored ____.

When finished processing the data, you should close the reader and connection objects. Doing so ____.

Provider classes include classes that allow you to connect to the data source, execute commands against the source, and read the results. The unique provider namespace for Access databases is ____________.

A foreign key is a column (field) or combination of columns that uniquely identifies a  row in a table.

To retrieve data from a database programmatically, one of the first things you must do is ____.

The connection string  includes ____.

Which of the following is a typed accessor method of the OleDbDataReader class?

The default server name for SQL Express is (LocalDB)\v11.0.

When you select the TableAdapter object (from the component tray) and view its properties, you will not see the SelectCommand, InsertCommand, UpdateCommand, and DeleteCommand properties. In order to change the SQL statements associated with those properties, you need to use the DataSet Designer and modify the ____________ for these properties.

The ____________ object stores an entire relational table like structure. More than one table, plus relationships and constraints on the database, can be stored with the ____________ object. The ____________ is considered a memory-resident representation of the data.

The four core classes that make up each data provider are ____________, Command, DataReader, and DataAdapter.

When a database is accessed using a disconnected mode, all or part of a database table(s) is retrieved and stored in a temporary file on a local machine.

You may not want to make a local copy of the database if ____.

When accessing a database, it is not necessary to close the connection. This is done automatically for you.

Which class is automatically instantiated when a table from the Data Sources window is dragged onto the form?

In order to test for a date value with Access tables, surround the date with single apostrophes. Surround the date with pound symbols for SQL Server data.

All of the following are data providers included with .NET for accessing and manipulating data in databases, EXCEPT ____.