Exam 11: Databases

Each _________ in a table holds an individual piece of information about all items in the table.

When you place a data-bound control on a form, keep in mind that Visual Studio does not automatically generate the code needed for the control to display any data from the database table.

In an SQL statement, a query parameter variable begins with the ____________.

Most database tables have a(n) ____________, which is a column that can be used to identify a specific row.

Data stored in databases is organized into one or more tables.

When working with data-bound controls on multiple forms, you can make sure that a dataset contains a current copy of the data by calling the table adapter's ____________.

When you click on the ____________ in a data-bound control, a tasks panel will appear, giving you a number of options you can perform.

When specifying a data type for the columns in a database table, the data types you can choose from are provided by the ____________.

When developing applications that work with an intensive amount of data, most developers prefer to use a database management system.

In SQL, the ____________ is used as a wildcard character, and can be used to represent any sequence of zero or more characters.

If you wish to sort the results of an SQL Select query, you can use the ____________.

It is possible to change the type of control that a column is bound to in a Details view.

SQL is a general purpose programming language, which can be used to write applications.

A(n) ____________ is software specifically designed to store, retrieve, and manipulate large amounts of data in an organized and efficient manner.

A ____________ is a file, ending with the .xsd extension, which describes the contents of a dataset.

Each subsequent time an application runs, it connects to the copy of the database in the output folder, rather than the project folder.

Each column in a table must have a name.

Data stored in a database table's column is divided into tables.

A ____________ is a user interface control that is connected to a data source.

When an application runs for the first time, Visual Studio copies the database file from the project folder to the project's ____________, which is the bin/Debug folder.