Exam 11: Databases

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

In SQL, if you need to include a single quote as part of a string, simply write two consecutive single quotes in its place.

A ____________ can display an entire database table in a scrollable grid on an application's form.

The Desc operator can be used to sort the results of an SQL Select query in descending order.

SQL does not support relational operators.

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

A ____________ is a set of individual controls that are bound to the columns in a single row. For example, it might display multiple data items for a single student.

Data stored in a database table is organized into rows and columns.

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