Exam 11: Databases

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

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

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

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 function properly.

Rather than showing multiple rows at once, a Details view lets the user see one row at a time.

SQL does not support relational operators.

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

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

When you make changes to the dataset in one form, the changes automatically appear in other forms that have their own dataset.

When you use the ____________ with a Select statement, only the rows that meet the search criteria are returned.

Rather than retrieving or manipulating the data directly, applications can send instructions to the DBMS, and the DBMS carries out those instructions and sends the results back to the application.

In SQL, the asterisk symbol is used as a wildcard to represent a single character.

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

____________ is automatically installed on your system when you install Visual Studio or Visual Studio Express.

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

A ____________ connects to a data source and can retrieve data from a table in a data source.

If an application needs to store only a small amount of data, traditional files work well.

The data that is stored in a database is organized into one or more tables.

The data that stored in a table is organized into rows and columns.

Each ____________ in a table holds an individual piece of information about an item.