Exam 10: Database Management

A data model defines how users view the organization of data.

COGNITIVE ASSESSMENT You store all of your photographs on a Web site that uses a database to store the photos users post. What is this type of database called?

In a relational database, users can set up a relationship between tables at any time, but the tables must have a common row or field

In a forward recovery, the DBMS uses the log to undo any changes made to a database during a certain period, such as an hour.

Whereas a relational database can store more than two dimensions, a multidimensional database is a two-dimensional table.

When a DBMS flags a deleted record, the record is deleted ____________________ because the DBMS will not process it.

Which of the following is true in a relational database?

All DBMSs have built-in backup utilities.

COGNITIVE ASSESSMENT What is the term for the process of comparing data with a set of rules or values to find out if the data is correct?

Critical Thinking Questions Case 10-2 In your database course, your instructor has given you a small database that has a lot of invalid data, issuing the challenge to you that you work to apply validation rules to the data and determine what checks need to be applied in order to restore integrity to the data. A quick scan of the data in the First Name field in the database yields the numbers 3 and 7 and an asterisk. What kind of check should you run on this field?

COGNITIVE ASSESSMENT In a database, what is the smallest unit of data a user accesses?

COGNITIVE ASSESSMENT Which term describes a huge database that stores and manages data required to analyze historical and current transactions?

Which of the following kind of checks is a validity check on data like that in the accompanying figure, which determines whether a number is within a specified group of numbers?

In a database, the data ____________________ specifies the kind of data a field can contain and how the field is used.

Many e-commerce sites use ____________________ to determine customer preferences.

COGNITIVE ASSESSMENT Which recovery technique is more expensive, but provides recovery of damaged data in a matter of seconds?

Object-oriented and object-relational databases often use a query language to manipulate and retrieve data. What is the name of this query language?

____________________ is a common data type that consists of lengthy text entries.

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?

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