Exam 14: Database Design

Most modern database management systems (DBMS) include powerful, menu-driven database generators that automatically create a DDL and generate a prototype database from that DDL.

A file is a collection of similar records.

The primary key for a record must never be allowed to have a NULL value.

A(n) _______________________ factor is the number of logical records included in a single read or write operation (from the computer's perspective).

A historical ___________________________ (advantage or disadvantage) of using conventional files has been processing speed. They can be optimized for the access of the application.

SQL provides a JOIN command to join two or more tables across a common field.

Data are a resource that must be controlled and managed!

Stored procedures are programs embedded within a table that are automatically invoked by updates to another table.

It is important for the database administrator to estimate how much disk capacity is required for a new database to ensure that sufficient disk space is available.

Horizontal distribution of data results in efficient access and security because each location has only those tables and rows required for that location.

The cost of developing databases is higher than the cost of developing files.

Referential integrity is the assurance that a foreign-key value in one table has a matching primary-key value in a related table.

The person responsible for data planning, definition, architecture, and management is known as a(n):

Stored procedures are programs embedded within a table that can be called from an application program.

When a computer program "reads" a record from a database, it actually retrieves a group or block (or page.) of records at a time. This approach minimizes the number of actual disk accesses.

The advantages and disadvantages of horizontal versus vertical distribution of data are similar.

_______________________ files are special records of updates to other files, especially master and transaction files. They are used in conjunction with archival files to recover "lost" data.

A blocking factor is the number of physical records included in a single read or write operation.

A Gender field can hold only the values M or

With horizontal distribution of data, the data cannot always be easily recombined for management analysis across sites.