Exam 10: Database Management

Which of the following kind of checks is a validity check performed on data like that in the accompanying figure, which ensures users enter only alphabetic data into a field?

A person without a programming background usually cannot learn a query language.

Which of the following languages consists of simple, English-like statements that allow users to specify the data to display, print, or store?

COGNITIVE ASSESSMENT Which term is used to describe the practice that users' access privileges are limited to the lowest level necessary to perform required tasks?

Most of these kind of database products for servers and mainframes include SQL, an example of which is shown in the accompanying figure. What kind of database product is this?

COGNITIVE ASSESSMENT Which database vendor created the Access database program?

COGNITIVE ASSESSMENT Which of the following statements best describes a form?

Data redundancy decreases the chance of errors.

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

____________________ is a common data type that includes letters, numbers, or special characters.

It often is easier and faster to develop programs that use the database approach.

COGNITIVE ASSESSMENT What was Megan's Law designed to do?

COGNITIVE ASSESSMENT Which of the following statements about data types is not true?

____________________ is a computer phrase that points out that the accuracy of a computer's output depends on the accuracy of its input.

COGNITIVE ASSESSMENT Which term does a user of a relational database use to refer to a record?

In a rollforward, the DBMS uses the log to undo any changes made to the database during a certain period.

In a relational database, such as that pictured in the accompanying figure, users can set up a relationship between tables at any time, but the tables must have which of the following in common?

The ____________________ manages the security of the database, checks backup and recovery procedures, and monitors the performance of the database.

Which kind of database stores data in dimensions?

For a computer to produce correct information, the data that is input into a database must have integrity.