Exam 14: Database Design

______________________________ distribution of the data means that each table or entire rows in a table would be assigned to different database servers and locations. This option results in efficient access and security because each location has only those tables and rows required for that location.

A field is a collection of records arranged in a predefined format.

Once a database design and its corresponding schema have been completed, a _________________________ database can usually be generated very quickly.

A principal advantage of the database approach is that you can build a single super-database that contains all data items of interest to an organization.

The main reason why data is retrieved in "blocks" is to:

Few high-end, enterprise database management systems include replication technology that coordinates updates to the duplicated tables and records to maintain data integrity.

A database management system (DBMS) is somewhat _____________ (slower or faster) than file technology.

A database is not necessarily dependent on the applications that use it.

Which of the following is not a command in SQL?

An index is frequently created for keys.

A significant advantage of conventional files is their flexibility and scalability.

Domain integrity means that appropriate controls must be designed to ensure that no field takes on a value that is outside the range of legal values.

In general, the data manipulation language (DML) is very flexible in that it may be used by itself to create, read, update, and delete records; or its commands may be "called" from a separate host __________________.

A good data model should be _________________________ and adaptable to future needs.

A good data model is complex. As a general rule, the data attributes that describe an entity should describe all possible characteristics of that entity.

The field whose values identify one and only one record in a file is known as the:

A(n) ____________________________ key is an alternate identifier for a database. Its value may identify either a single record or a subset of all records.

A good data model is essentially___________________________. This means that each data attribute, other than foreign keys, describes at most one entity.

Which of the following is NOT a high-performance relational DBMS?

Which of the following languages is used to create, read, update, and delete records in the database and to navigate between different records and types of records?