c# SEASON TWO FINAL CHAP 14 pt 2
The CommandBuilder object used for accessing data from database tables can be used for datasets that map to one or more database tables.
FALSE
You use the data adapter object to populate the data reader object.
FALSE
____________ 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.
TableAdapters
In relational databases, data is stored ____.
in a tabular format
Each data provider includes a collection of classes used to access a data source, including connection, command, data reader and data adapter classes.
TRUE
Connection strings are vendor specific.
TRUE
For simple read-only access to the database, ADO.NET includes a(n) ____________ class that can be used to read rows of data from a database.
data reader
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.
CommandText
A ____ object is instantiated based on the type of database or type of database provider.
connection
The Data Source Configuration Wizard simplifies connecting your application to a data source by guiding you through the process, automatically generating the connection string, creating dataset and table adapter objects, and bringing the data into your application.
TRUE
ADO.NET requires that you keep a continuous live connection to the database and process one retrieved record at a time.
FALSE
The Dataset Designer tool provides a visual representation of the objects contained in the dataset object.
TRUE
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
string sConnection ="Provider=Microsoft.ACE.OLEDB.12.0;" +"Data Source=member.accdb";
The above connection string is associated with which type of database?
Access
OleDbDataReader class includes a number of typed accessor method members (i.e GetChar( ), GetString( ), GetDecimal( ))..
TRUE
DataAdapter classes are used to exchange data between a database source and a dataset object.
TRUE
A data reader class allows read-only forward retrieval of data from the database.
TRUE
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.
CommandBuilder
All of the following are core classes that make up the ADO.NET data providers EXCEPT ____.
DataSet
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
The query language used to access, manipulate, and update data in a database is called Data Query Language.
FALSE
Applications that connect to a Microsoft Access database use the OLE DB data provider.
TRUE
The DataGridView is a customizable control that can be bound to a data source.
TRUE