Exam 15: Database Administration and Security

allows for the translation of the company's strategic goals into the data and applications that will help the company achieve those goals.

In the context of data quality management tools, software is one that gathers statistics, analyzes existing data sources and metadata to determine patterns, and compares the patterns against standards that the organization has defined.

When performing user access management, a DBA defines each user to the database at the levels.

Disaster management includes all the end-user activities designed to secure data availability before a physical disaster or a database integrity failure.

At the level of middle management, the database must be able to .

The introduction of a DBMS represents a big change and challenge, and is likely to have a profound impact throughout the organization.

In the context of database security measures, enforcing complex password policies will address the security vulnerabilities of the operating system component.

In the context of an organization's managerial structure, decisions are short term and affect only daily operations; for example, deciding to change the price of a product to clear it from inventory.

CASE tools provide support for the coding and implementation phases.

User-access management is a subset of .

are written instructions that describe a series of steps to be followed during the performance of a given activity.

In the context of developing a data administration strategy, a(n) provides a framework that includes computerized, automated, and integrated tools such as a DBMS and CASE tools.

Incremental backups produce a backup of all data.

A security breach is a weakness in a system component that could be exploited to allow unauthorized access or cause service disruptions.

The component of a CASE tool produces the information system's input/output formats.

The administrator is responsible for strategic planning.

A(n) data dictionary is automatically updated by the DBMS with every database access.

The DBA interacts with the end user by providing data and information support services to the organization's departments.

In case a company installs several incompatible databases and assigns a DBA for each of them, the general coordinator of all such DBAs is known as the administrator.

The person responsible for the control of the centralized and shared database is the database .