Exam 11: Building Solutions

When a(n) ____________________ no longer is needed, a user deletes it from a file.

____________________ unneeded records reduces the size of files, thereby freeing up storage space.

DBMSs that maintain inactive data for an extended period of time seldom flag records.

A(n) ____________________ verifies that each individual program or object works by itself.

If the lowest annual fee at a discount warehouse is $20.25 and the highest is $55.50, a(n) ____________________ on the Annual Fee field ensures it is a value between $20.25 and $55.50.

More than 30 years ago, the first macro viruses wreaked havoc with personal computers.

In a file processing system, each department or area in an organization shares files collectively.

Applications best suited for relational databases are those whose data can be organized in a two-dimensional table.

A user of a database such as that pictured in the accompanying figure refers to a field as what?

What is a data type? List the data types commonly found in a database.

What type of database exists in many separate locations throughout a network or the Internet?

The purpose of the ____________________ phase is to provide ongoing assistance for an information system and its users after the system is implemented.

Which of the following is a program with which users interact that generally has a more user-friendly interface than a DBMS?

Many database programs perform which of the following in order to analyze entered data to help ensure that it is correct?

Which of the following is a query language that allows users to manage, update, and retrieve data?

Big Data refers to large-scale data sets that require advanced technologies.

An application generator is a program that creates source code or machine code from a specification of the required functionality.

Which of the following is NOT a way that a DBMS deals with deleting records from a database?

What is a database that stores data in tables that consist of rows and columns?

With the database approach, most data items are stored in multiple files, which greatly reduces duplicate data.