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

Which of the following is a huge database that stores and manages the data required to analyze historical and current transactions?

Which of the following is a database that stores data in tables that consist of rows and columns?

Explain a multidimensional database, its applications, and its main advantage.

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

Which of the following kinds of values is the one that a DBMS initially displays in a field?

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

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

COGNITIVE ASSESSMENT Which term does the developer of a relational database use to describe a file?

COGNITIVE ASSESSMENT To what does the term GIGO refer?

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

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

To access data in a(n) ____________________ database, users fill in an e-form or enter search text on a webpage.

In a 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?

Critical Thinking Questions Case 11-1 In your new role as a DBA, you have inherited a database that has a lot of problems. Your first task, you decide, is to identify whether or not the information in your database contains the qualities of valuable information, and which quality may be missing. The manager for the eastern division sales force is upset because she wants to determine which members of her sales force need awards for high monthly sales, and which employees need remediation because they have not sold enough product during the past month. However, all of the sales information has not yet been entered into the database. What kind of information is at issue in this instance?

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

One application that uses multidimensional databases is a data warehouse.

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

COGNITIVE ASSESSMENT What is another term for data dictionary?

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

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