Question 1

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-As soon as the program connects to the database and fills this object,the program should disconnect from the database
A)Binding Navigator
B)Data Source Configuration Wizard
C)Data Table
D)Data Sources
E)Fill
F)initialize
G)connection
H)data binding
I)Count
J)table

Accepted Answer

A Data Table is an object that can be filled with data from a database, and once filled, the program can disconnect from the database.

Question 2

CASE
Critical Thinking Questions
Case 10-1
As you prepare to teach a class on the fundamentals of databases, you want to create a real-world example that will help define some of the key terms for this concept.
-Your AutoRepairDetails table contains the following line:
Smith,Robert; Honda; Civic; 2008; X4T6Y3; $150.00
Which of the following terms best describes this entry in the table?
A) record
B) column
C) id
D) field

Accepted Answer

This entry in the table is best described as a "record" because it represents a complete set of related data items (fields) for one entity (in this case, a specific auto repair detail).

Question 3

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-The dat prefix is used to do this to a DataTable
A)Binding Navigator
B)Data Source Configuration Wizard
C)Data Table
D)Data Sources
E)Fill
F)initialize
G)connection
H)data binding
I)Count
J)table

Accepted Answer

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

Question 4

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A DataTable object contains this command that is used to fill the data table with data from the selected database table
A)Binding Navigator
B)Data Source Configuration Wizard
C)Data Table
D)Data Sources
E)Fill
F)initialize
G)connection
H)data binding
I)Count
J)table

Accepted Answer

The "Fill" command is used to populate a DataTable object with data from a selected database table.

Question 5

Explain OleDbDataAdapter and what it consists of,and provide its general form.

Accepted Answer

The answer of Explain OleDbDataAdapter and what it consists of,and...

Question 6

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-To keep the maximum number of these available for use,the program should keep one open only as long as necessary
A)Binding Navigator
B)Data Source Configuration Wizard
C)Data Table
D)Data Sources
E)Fill
F)initialize
G)connection
H)data binding
I)Count
J)table

Accepted Answer

Keeping a connection open only as long as necessary can help conserve resources and ensure that the maximum number of connections are available for use.

Answer: E 
 The Fill method is used to populate a data table with data from a database or other data source. In order to conserve resources and improve performance, it's important to only keep the data table open for as long as necessary.

Question 7

Once you have configured a DataSet with the Data Source Configuration Wizard,what is the next step? Be sure to include the term data binding in your response.

Accepted Answer

The answer of Once you have configured a DataSet with...

Question 8

Critical Thinking Questions
Case 10-2
Melissa helps you figure out how to use the OleDbDataAdapter to make a connection to a database for you. But in order to help you learn as much as you can, she wants you to begin to figure out things on your own.
-Which of the following is NOT a true statement Melissa can make to you about filling the DataTable object you have created?
A) As soon as you connect to the database and fill the DataTable object, the next statement should disconnect the application from the database.
B) To keep the maximum number of connections available, you should keep connections open only as long as necessary.
C) After the DataTable is initialized, it must be filled using the Populate command with the data from the selected table.
D) By using the database in disconnected form, the system resources of the computer and network are not overloaded.

Accepted Answer

The DataTable is filled using the Fill method of the OleDbDataAdapter, not a "Populate" command.

Question 9

Critical Thinking Questions
Case 10-2
Melissa helps you figure out how to use the OleDbDataAdapter to make a connection to a database for you. But in order to help you learn as much as you can, she wants you to begin to figure out things on your own.
-Assuming a database named Travel.accdb,which of the following lines of code will Melissa tell you is correct as you construct the statement to disconnect from the database?
A) odaTravel.Unlink()
B) odaTravel.Break()
C) odaTravel.Dispose()
D) odaTravel.Disconnect()

Accepted Answer

The correct method to disconnect from a database when using OleDbDataAdapter is odaTravel.Dispose(). Unlink(), Break(), and Disconnect() are not valid methods for disconnecting from a database using OleDbDataAdapter. Dispose() releases all resources used by the OleDbDataAdapter, including the database connection.

Question 10

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Property that can be used to determine the number of columns in a DataTable
A)Binding Navigator
B)Data Source Configuration Wizard
C)Data Table
D)Data Sources
E)Fill
F)initialize
G)connection
H)data binding
I)Count
J)table

Accepted Answer

The Count property returns the number of columns in a DataTable.

Question 11

CASE
Critical Thinking Questions
Case 10-1
As you prepare to teach a class on the fundamentals of databases, you want to create a real-world example that will help define some of the key terms for this concept.
-You have a table called AutoRepairDetails,which includes elements labeled Make,Model,LicensePlate,RepairCost,and OwnerName.In this table,which term best describes the role that RepairCost plays in the table?
A) row
B) field
C) record
D) id

Accepted Answer

A field is a single piece of data in a database table, such as RepairCost. The other choices, such as row (A), record (C), and id (D), do not specifically describe the role of RepairCost in the table.

Question 12

Explain in general terms how to establish a database connection.Be sure to include the Data Sources window and the DataSet object in your response.

Accepted Answer

The answer of Explain in general terms how to establish...

Quiz 10: Incorporating Databases with ADO.NET

MATCHING Identify the letter of the choice that best matches the phrase or definition. -As soon as the program connects to the database and fills this object,the program should disconnect from the database

MATCHING Identify the letter of the choice that best matches the phrase or definition. -The dat prefix is used to do this to a DataTable

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A DataTable object contains this command that is used to fill the data table with data from the selected database table

Explain OleDbDataAdapter and what it consists of,and provide its general form.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -To keep the maximum number of these available for use,the program should keep one open only as long as necessary

Once you have configured a DataSet with the Data Source Configuration Wizard,what is the next step? Be sure to include the term data binding in your response.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Property that can be used to determine the number of columns in a DataTable

Explain in general terms how to establish a database connection.Be sure to include the Data Sources window and the DataSet object in your response.