Exam 12: Data and Database Administration

A DBMS may perform checkpoints automatically or in response to commands in user application programs.

A(n) ________ stores metadata about an organization's data and data processing resources.

A business transaction is a sequence of steps that constitute some well-defined business activity.

An open-source DBMS is:

Three-factor authentication is most often implemented with a credit card.

An audit trail of database changes is kept by a:

A repository of information about data is called a catalog.

A database management system needs to provide only three basic facilities for backup and recovery of a database: backup facilities, journalizing facilities, and a recovery manager.

Open-source DBMS are free software that provide the core functionality of an SQL compliant DBMS.

With a one-key encryption standard, both the sender and the receiver need to know the key that is used to scramble the transmitted or stored data.

Specifying database access policies is done during the database implementation phase.

A discrete unit of work that must be processed completely or not at all within a computer system is called a:

The restoration manager allows the DBMS to restore the database to a correct condition and restart processing transactions.

Loss of data integrity does not impact the quality of data in a database.

What new trends and technologies have driven the need for changes in the data administration and database administration roles?

What factors should one consider when choosing an open source DBMS?

A DBMS must provide journalizing facilities to provide an audit trail of transactions and database changes.

A view can be built to present only the data to which a user requires access.

Which of the following threats involves outside parties using information to embarrass a company?

A transaction that terminates abnormally is called a(n) ________ transaction.