Exam 14: Working With Databases

The DataGridView is a customizable control that can be bound to a data source.

string sConnection = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=member.accdb"; ​ The above connection string is associated with which type of database? ​

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.

DataAdapter classes are used to exchange data between a database source and a dataset object.

A cache of records retrieved from some data source that may contain one or more tables from the data source describes a(n) ____.

A data reader class allows read-only forward retrieval of data from the database.

The query language used to access, manipulate, and update data in a database is called Data Query Language.

The Dataset Designer tool provides a visual representation of the objects contained in the dataset object.

​SELECT Address FROM member WHERE FirstName = 'Bill' AND LastName = 'King'; Given the above SQL statement, which of the following statements is true? ​

The ADO.NET architecture encapsulates the details of differing database structures such as Oracle, as opposed to Access, in the form of ____.

​ string sConnection = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=member.accdb"; ​ Using the segment of code above, what is member.accdb?

The CommandBuilder object used for accessing data from database tables can be used for datasets that map to one or more database tables.

All of the following are core classes that make up the ADO.NET data providers EXCEPT ____.

To position the OleDbDataReader object onto the row of the first retrieved query result, you use the ____________ method of the OleDbDataReader class. This method is also used to advance to the next record after the previous one is processed.

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.

You use the data adapter object to populate the data reader object.

After values have been retrieved using the OleDbDataReader, you can send the ordinal location of data fields as arguments to methods of the OleDbDataReader class.

The ____________ class can be used to generate SQL statements automatically so that you do not have to do additional SQL programming beyond the initial SELECT statement used to retrieve the records.

____________ provide a communication link between the application and a database. ____________ have a built-in connection object and enable you to configure the InsertCommand, UpdateCommand, and DeleteCommand SQL queries using the Properties window.

You identify which records and fields you want to retrieve from the database using the SQL ____________ statement.