Exam 3: The Relational Model: SQL

What type of database update occurs when multiple users make updates to the same database at the same time?

Many database management systems maintain catalogs of information as special, hidden tables.

_____ is the process of returning a database that has encountered a problem to a state known to be correct.

For which of the following tasks is data independence not a consideration?

Which of the following demonstrates the concept of a distributed database?

Compare traditional database replication with distributed databases.

Microsoft Access allows concurrent updates to different records of the same table.

When you run a recovery program that applies the after images of committed transactions from the log to bring a database up to date, what method of recovery are you using?

What type of constraints help to ensure the accuracy and consistency of field values?

Which authentication tool identifies users by physical characteristics such as fingerprints, voiceprints, handwritten signatures, and facial characteristics?

To support data independence, you should _____ in an SQL SELECT command.

One of the key services of a DBMS is to analyze overall hard drive usage.

_____ occurs when multiple users make updates to the same database at the same time.

Which Microsoft Access tool helps you identify all objects dependent on a particular table, query, form, or report?

_____ are actions that are performed on resources or files at the server.

Which of the following Access tools shows the database schema?

Identify the type of change that generally requires the most rework to existing programs and queries in a database and explain whether making the change is worthwhile.

_____ is a popular website for hosting projects that use the Git language for version control.

Which of the following features does an enterprise-level DBMS use to avoid the costly and time-consuming task of having users redo their work?

What do you call applying and reconciling updates from various copies of a database with the master copy?