Exam 11: Databases

If a particular column is not allowed to be null, anytime you add a row of data to the table, the DBMS will require a value for the column.

The row that is designated as the primary key must hold a unique value for each column.

A .NET application requires a set of special components that let it connect to, and work with, a database.

A ____________ is a complete set of information about a single item in a table.

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

In SQL, the ____________ can be used to search for a substring.

The data that is stored in column is divided into tables.

The ____________ requires that both search criteria be true in order for a row to be qualified as a match.

When you create a database table, you must specify a data type for the columns.

In a database, each ____________ holds a collection of related data.

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

In SQL, you use the ____________ to retrieve the rows in a table.

The application handles the actual reading of, writing of, and searching for data.

Data-bound controls automatically display data from the data source and can be used to change the data that they are bound to.

The ____________ identifies a column from the table to display in the data-bound control.

A ____________ is a set of individual controls that are bound to the columns in a single row.

In SQL, strings are enclosed in ____________, not double quotes.

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

A(n) ____________ is an SQL statement that is stored in a table adapter and can be executed simply by calling a method.

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.