Exam 7: Database and Content Management

Spreadsheets usually track only one "theme," but databases usually involved more than one "theme."

Users process data in the database using

To prevent the lost-update problem, the DBMS should have some type of ________ mechanism.

________ DBMS like DB2 are designed for large, corporate database applications.

________ is an example of a personal DBMS.

Forms and reports are usually part of a database ________.

________ database products like MS Access are designed for individual users or small workgroups of no more than 15 users.

Many people find it easier to store data using a spreadsheet than a database.

Some employees are frustrated with database applications or are unwilling to share their data, so they prefer to store their data in a(n) ________ instead of a database application.

What is a DBMS? What are the advantages and disadvantages of using a DBMS?

A ________ is a self-describing collection of integrated records.

The purpose of a database is to keep track of things that involve more than one ________.

A(n) ________ DBMS is designed to process large organizational and workgroup databases.

________ is a formal name for a table.

Most large companies develop their own DBMSs.

What is the difference between a personal DBMS and an enterprise DBMS? Give an example of each.

What are the differences between a database and a spreadsheet?

It is often said that much of corporate data resides in various unrelated spreadsheet files or, "spreadsheet silos." What are these concepts and why are they a problem?

If your database produces inaccurate results that don't seem to have a cause, your database may be having ________ problems.

A collection of columns or fields is called rows or ________.