Question 1

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Each one of these in a relational database must contain a unique value

Accepted Answer

A table is a collection of related data stored in rows and columns. Each row in a table must contain a unique value for the primary key column.

Question 2

The process of data ____________________ is used to display each field as an object on the form.

Accepted Answer

The answer of The process of data ____________________ is used...

Question 3

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-When using this control to add a new record to a database table,the Save Data button must be used to save the new record

Accepted Answer

The Binding Navigator control is used to navigate through the records of a database table and add new records. When a new record is added, the Save Data button on the Binding Navigator must be used to save the changes to the table.

Question 4

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-When you drag database field objects from the Data Sources window,the Visual Studio automatically creates this to populate the form

Accepted Answer

Visual Studio automatically creates data binding to populate the form when you drag database field objects from the Data Sources window.

Question 5

You create a connection to a database by specifying a(n)____________________ from the Windows application to the database source.

Accepted Answer

The answer of You create a connection to a database...

Question 6

A table's ____________________ represents the identifying field used to uniquely identify each record in the table.

Accepted Answer

The answer of A table's ____________________ represents the identifying field...

Question 7

A database should be used in ____________________ form,with the procedure shown in the accompanying figure,in order to minimize the use of computer and network resources.

Accepted Answer

The answer of A database should be used in ____________________...

Question 8

Before data from a database can be displayed on a Windows form,a(n)____________________ object must be filled with the table information.

Accepted Answer

The answer of Before data from a database can be...

Question 9

The prefix ____________________ is used when naming an OleDbDataAdapter in code.

Accepted Answer

The answer of The prefix ____________________ is used when naming...

Question 10

The Fill command is used to fill a(n)____________________ object with data from a database.

Accepted Answer

The answer of The Fill command is used to fill...

Question 11

The ____________________,which has two parts,includes a path statement that connects to a database in order to fill a DataSet object with data.

Accepted Answer

The answer of The ____________________,which has two parts,includes a path...

Question 12

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Used to generate the connection information required for a program to access a database

Accepted Answer

The Data Source Configuration Wizard is used to generate the connection information required for a program to access a database.

Question 13

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Each bindable field item in this window can be placed on a Windows Form object

Accepted Answer

The answer of MATCHING
Identify the letter of the choice that...

Question 14

The SQL statement:
____________________ * FROM ApprovedTravelRequests
is a query statement that requests that the entire table named ApprovedTravelRequests is opened for use by the application.

Accepted Answer

The answer of The SQL statement:
____________________ * FROM ApprovedTravelRequests
is a...

Question 15

The DataSet used in the Database Wizard is a collection of ____________________ objects.

Accepted Answer

The answer of The DataSet used in the Database Wizard...

Question 16

The ____________________ command is used to fill a DataTable with data from the selected table.

Accepted Answer

The answer of The ____________________ command is used to fill...

Question 17

A DataSet object is a temporary ____________________ storage for data retrieved from a data source.

Accepted Answer

The answer of A DataSet object is a temporary ____________________...

Question 18

The process of defining a(n)____________________ to a database is the same for all types of databases.

Accepted Answer

The answer of The process of defining a(n)____________________ to a...

Question 19

The DataTable object can be used to access individual fields within a database by using the ____________________ procedure.

Accepted Answer

The answer of The DataTable object can be used to...

Question 20

Data from a database is available for dragging onto a Windows form from the Data ____________________ window.

Accepted Answer

The answer of Data from a database is available for...

Quiz 10: Incorporating Databases with ADO.NET

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Each one of these in a relational database must contain a unique value