Exam 10: Incorporating Databases with ADO.NET

Many business databases are password protected.

In a database,a(n)____________________ is referred to as a field.

The Delete button on the BindingNavigator control deletes a record from the program's displayed data,but does not delete the record permanently from the database.

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

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?

To use a database in a Windows application,select the Use Database command on the PROJECT menu._________________________

Data ____ is the term that is used to refer to loading the DataSet string.

The data access technology called ____ allows applications to connect to a variety of database sources from within the Visual Studio environment.

Visual Studio provides tools to connect an application to data from ____.

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 ____ is a collection of related information stored in a structured format.

A(n)____________________ is a collection of related information stored in a structured format.

Database tables store information in ____.

To ensure that the system resources of the computer and network are not overloaded,the program should use a database in ____ form.

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

A Windows form application can be used to view but not update records within a database.

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

A SQL ____ statement is a query statement that requests data from one or more database tables.

In a database,the term ____ is another name for row.

A user can permanently remove a database record by clicking or tapping the ____ button on the navigation toolbar.