Exam 14: Databases and Database Management Systems

____ is a growing concern because of the vast amounts of personal data stored in databases today and the many breaches that have occurred in the recent past.

In a typical client-server database application, the client is called the ____.

-The accompanying figure shows an n-tier database model.

Most DBMSs come bundled with a set of tools to perform a variety of necessary tasks, such as building user interfaces, creating forms and reports, and interfacing with query languages and ____ for complex applications.

The ____ contains all data definitions for a database, including table structures, security information, relationships between the tables in the database, and so on.

In ____________________ organization, the order of the records is physically based on the content of the key field.

Virtually all DBMSs include a ____ for easy data input, modification, and retrieval.

A field is also called a ____.

To create a query, users can either type a query using SQL or, more commonly, use the query tools built into the DBMS (such as a query design screen or query ____) to create a query object.

____ create the actual database, based on the design generated by the database designer, and get it ready for data entry.

In ASPs, the code to tie the database to the Web site is typically written in JavaScript or ____.

A ____ is a collection of related fields.

One of the properties that can be assigned to a field is a(n) ____ to specify the format (such as letters, numbers, or symbols) that must be entered into a field.

____________________ databases are located on a PC and are designed to be accessed by one user.

Views need to be designed to extract the needed information in as efficient a manner as possible.

In ____, the table field involved in the changes is locked until the changes to that field have been completed.

With a(n) ____________________, the data is separated into several databases, each of which is stored on a different computer that may be in different physical locations from one another but that are connected via a network.

The characteristics of an entity are called ____.

Middleware for Web database applications is commonly written as ____-short sections of code written in a programming or scripting language that are executed by another program.

To protect against data loss caused by a database failure, accidental deletion, or other problem that renders the main copy of a database unusable, stringent backup procedures should be implemented.