Databases Quiz

The DBMS subsystem that provides programming language interfaces, allowing programmers to create visually appealing data entry screens, is called the application ___ subsystem.

generation

Select the advantages of using a database instead of a traditional filing system.

A database can hold larger amounts of data A database can provide better data integrity

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

Large databases, often called data banks, that cover particular subjects are referred to as ___ databases.

Commercial

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

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

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

Logical

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

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

Relational

Your college has a database with a Students table. Which of the following could be a primary key in the table?

Student number Social Security Number

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

Table

You need to purchase concert tickets for your friends. You go to StubHub.com to find them. In StubHub.com you can search between hundreds of seats in thousands of venues and thousands of events. To organize this information in a searchable manner, StubHub uses a complex ___ .

database

Forms structure data input to help ensure data ___, meaning the information entered is accurate, timely, and useful.

integrity

The reliability and the accuracy of the information in a database is referred to as data ___ .

integrity.

In a relational database, such as Microsoft Access, a collection of related fields in a data file is called a ___ .

record

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

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 subsystem that allows for data recovery, support, and maintaining and securing the database is called the ___ subsystem.

Data Administration

In a relational database, an important field that contains a unique value that identifies each record as individual is the ___ key.

primary