Exam 11: Information and Data Management: Organizing, Verifying, Maintaining, and Accessing

COGNITIVE ASSESSMENT If you are running a check to ensure that a required field contains data, or the correct minimum number of characters, what kind of check are you running?

Data warehouses often use a process called data ____________________ to find patterns and relationships among data.

In a relational database, the only data redundancy (duplication) exists in the common columns (fields) used for relationships.

The developer of a relational database refers to a record as which of the following?

Which of the following refers to the procedures that keep data current?

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

COGNITIVE ASSESSMENT After a power failure, you instruct the DBMS to use the log to reenter any changes made to the database since the last save or backup. What term is used to describe this backup technique?

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 numeric data into a field?

Which of the following stores data in objects?

____________________ helps salespeople manage customer contacts, schedule customer meetings, log customer interactions, manage product information, and place customer orders.

The ____________________ identifies users' access privileges, defines the relationships among data, and decides on the proper placement of fields.

COGNITIVE ASSESSMENT Which of the following statements is not true about relational databases?

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

Which of the following kinds of programs interacts with a DBMS, which in turn interacts with the database?

The developer of a relational database refers to a file as which of the following?

COGNITIVE ASSESSMENT In your school's database, in which of the following is all of the information about a particular student stored?

Which of the following is an advantage of a multidimensional database?

An application that supports a front-end program sometimes is called which of the following?

Which of the following is a collection of related records, as shown in the accompanying figure, stored on storage media such as a hard drive or optical disc?

Most information is important to all people and groups of people.