Exam 10: Database Management

Discuss at least four strengths of the database approach.

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

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

Explain what data validation is and the various types of validity checks.

COGNITIVE ASSESSMENT What does the S in SQL stand for?

With a distributed database, the data is accessible through a variety of servers.

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

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

DBMSs will process flagged records unless an instruction is issued to ignore them.

One application that uses multidimensional databases is a data warehouse.

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

Accurate information is error free.

Many database programs today have a Web page as their back end.

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

With a(n) ____________________, users create a computerized database; add, change, and delete data in the database; sort and retrieve data from the database; and create forms and reports from the data in the database.

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

Like a form, a report generator is used to maintain and retrieve data.

Critical Thinking Questions Case 10-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?

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

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