Exam 5: Database Processing

Monitoring the performance of a database after providing solutions for improving its performance is an activity of the DBMS pertaining to ________.

In a database, a table is also called a ________.

Describe the functions of a database management system (DBMS).

In the context of data storage, explain the difference between a spreadsheet and a database.

Traditional database application programs are written in object-oriented languages such as C++.

Traditional database application programs are written in object-oriented languages like ________.

Access and SQL Server are popular ________ DBMS products.

Which of the following best describes the metadata in a database?

Describe the merits of metadata.

What is a database application?

In a database, columns that are keys of a different table than the one in which they reside are known as ________ keys.

Browser-based database applications differ from traditional applications in that they ________.

In a database, a key is a column or group of columns that identifies a unique row in a table.

A database application serves as an intermediary between users and database data.

The database management system (DBMS)can be used to set up a security system involving user accounts, passwords, permissions, and limits for processing the database.

In a database, rows are also called ________.

A(n)________ is a program that is used to create, process, and administer a collection of self-describing integrated records.

SQL stands for ________.

Structured query language statements can be issued directly to the database management system (DBMS)by an application program.

Conducting training to ensure that users and operations personnel know and understand recovery procedures is a task associated with the DBMS ________.