Database Quiz

To search a database for information, create a ___ .

query

The type of database that uses common fields to create links between tables is called a ___ database.

relational

When you make an online purchase and enter your shipping or billing information, you're actually filling out a form that was generated by a database management system. The DBMS subsystem that allows for form creation is the ___ generation subsystem.

Application

What element of a database field specifies the data in a field such as text, numeric, or date/time?

Data Type

Adam was in the fifth grade when he was adopted by the Smith's. Because his school used a centralized database, all of his teachers had his correct name on their grade reports. This is an example of how a centralized database can help improve data ___ .

Integrity

Because Microsoft Access includes not only the software needed to create a database, but also the software needed to create forms, reports, data dictionaries and other capabilities, it is often referred to as a Database ___ System.

Management

A complex database that organizes and stores information in a cube format and has measure attributes and feature attributes is called a ___ database.

Object-oriented

In the datasheet view of a relational database (such as Microsoft Access) a row of information is called a ___ .

Record

In a database a _____ is a group of related characters in a database table that represents a characteristic of someone or something.

Relationship

The DBMS subsystem that allows for data recovery, support, and maintaining and securing the database is called the ___ subsystem.

data management

To control how information is entered into a database, programmers and database administrators create ___ to help ensure data integrity.

forms

Databases are built by starting with single characters of data, organizing the data into fields, organizing the related fields into records, the records then make up a table. This organization is referred to as a data ___ .

Hierarchy

An integral part of a databases management system (DBMS) is the Data Definition subsection. This subsection uses a data schema, also called a data ___ .

dictionary

A database that stores data in different physical locations and that users access though client/server networks is called a ___ database.

distributed

The DBMS engine provides an interface for the end user of the database. This interface is called the ___ view.

physical

To display or distribute information from a database, programmers or database administrators create ___ .

reports