FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 14: Working with Databases

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 2

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

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

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.

Typically when you are programming for database access,you use a(n)____________.

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

string sConnection = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=member.accdb"; -Which class is used to hold the SQL statement or stored procedures for Access databases?

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

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

The Dataset Designer tool provides a visual representation of the objects contained in the dataset 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.

To process the data using a data reader with an Access database,you declare an object of the OleDbDataReader class and then ____.

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

Classes that can be used to retrieve,manipulate,and update data in databases are part of ____.

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

OleDbDataReader class includes a number of typed accessor method members (i.e GetChar( ),GetString( ),GetDecimal( ))..

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

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

Read-only forward retrieval of data from an Access database is possible using the ____ class.