Databases Quiz Practice

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

Data Administration

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

Data type

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

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

Amazon.com allows you to search for thousands and thousands of items using images and information that are organized logically. This much storage and management requires a complex ________.

database

Because he wanted to be able to sort gifts according to continent and time zone, in 1984 Santa switched from using long lists to using ________.

databases

An integral part of a database 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

When you need to link two tables in a database that don't have a field in common, one solution is to create a ________ in one table that links to the primary key in the other table.

foreign key

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

forms

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

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

logical

When you receive a utility bill, you're actually getting a report that was generated by a database management system. The DBMS subsystem that provides for data maintenance, analysis, and the generation of reports is called the data ________ subsystem.

manipulation

A complex database that organizes and stores information in a cube format and has measure attributes and feature attributes is called a(n) ________ database.

multidimensional

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

record

The type of database that uses common fields to create links between tables is called a(n) ________ database.

relational

A link between tables in a relational database that defines how the data is related is called a ________.

relationship

A collection of related records in a database is referred to as a ________.

table

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

field

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

reports