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

Which of the following privileges for data involve establishing who can enter new data, change existing data, delete unwanted data, and view data?

Data redundancy decreases the chance of errors.

____________________ information is available when a decision maker needs it.

In the database pictured in the accompanying figure, which of the following is a combination of one or more related characters or bytes and is the smallest unit of data a user accesses?

CAE aids in the development and testing of product designs, and often includes CAD.

COGNITIVE ASSESSMENT A data dictionary contains details about data. What term is used to describe this characteristic?

COGNITIVE ASSESSMENT What database term is used to describe a request for specific data from the database?

COGNITIVE ASSESSMENT Which statement is not a recognized guideline for designing a database?

Metadata describes the widespread growth of data, the variety of formats in which this data is available, and the processing required to make this data accessible in a timely manner.

Discuss the seven qualities of valuable information.

Which of the following is a number(s) or character(s) that is appended to or inserted into a primary key field?

____________________ information is arranged to suit the needs and requirements of a decision maker.

____________________ is a common data type that consists of an email address or a web address that links to a webpage on the Internet, for example.

Which of the following consists of rules and standards that define how a database organizes data?

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. Once you have worked with the data entry team to make sure that they are getting the monthly sales data into the database in a timely fashion, your next challenge is to change the method of disseminating this information from a printed report that is snail-mailed to all sales managers across the country, to an online dissemination strategy that emails the reports to the managers. What kind of information is at issue in this instance?

Which of the following, with regard to the entire database, should be made on a regular basis?

Which of the following is a window on the screen that provides areas for entering or changing data in a database?

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

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

COGNITIVE ASSESSMENT Which of the following is true about the database approach?