Exam 14: Working with Databases

One of the visual tools that provides a graphical representation of the dataset object and enables you to set relationships between tables is the ____.

Selecting Add New Data Source from the Data menu enables you to create a new SQL Server database.

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

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

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

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.

ADO.NET requires that you keep a continuous live connection to the database and process one retrieved record at a time.

A new SQL Server database can be created from the ____ Explorer Window.

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

To retrieve data from multiple tables use a(n)____.

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.

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.

____________ provides a general purpose query facility that can be used with not only relational data sources,but XML data,and any class of data that implemented the IEnumerable<T> interface with IEnumerable supporting simple iteration over a collection.

The SQL statement that retrieves every field from a database table includes ____ following the SELECT keyword.

A ____ object is instantiated based on the type of database or type of database provider.