Exam 11: Databases

The DBMS works directly with the data and sends the results of operations back to the ____________.

The application handles the mechanical details reading of, writing of, and searching for data in a database.

A(n) ____________ is a column that contains unique values generated by the DBMS, usually using a counter.

Once data items are stored using a database management system, applications may be written in ____________ to communicate with the DBMS.

A ____________ is a component that can connect user interface controls directly to a dataset.

A ____________ is a source of data with which the application can work. Examples are databases, and Excel spreadsheets.

In SQL, the ____________ requires that both search criteria be true in order for a row to be qualified as a match.

The Not operator can be used in SQL to disqualify a character pattern in a search criteria.

SQL uses database mnemonics to construct statements, which are also known as table adapter queries.

The ____________ identifies a column from the table to display in a ListBox control.

SQL provides the ____________ for determining the number of matching rows in a table.

SQL, which stands for ____________, is a standard language for working with database management systems.

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

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

SQL provides several functions for performing calculations.

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

The equal to and not equal to operators in SQL are different from those in C#.

In SQL, you use keywords to construct statements, which are also known as ____________.

A ____________ gets a copy of a table from the table adapter and keeps the copy of the table in memory.

In SQL, the ____________ calculates the average value in a particular column.