Practice Quiz 10 (4)

Training people to use the DBMS and its tools is not included in the responsibilities of a DBA.

False

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

administrator

In the context of database usage monitoring, a(n) _____ is a file that automatically records a brief description of the database operations performed by all users.

audit log

A(n) _____ physically stores the database's data.

data file

The DSO's activities are often classified as _____ management, which includes all DBA activities designed to ensure data availability following a physical calamity or a database integrity failure.

disaster

_____ CASE tools provide support for the planning, analysis, and design phases.

front-end

"All users must have passwords" is an example of a _____.

policy

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

provide the data necessary for tactical decisions and planning

An enterprise database can be defined as the company's data representation that provides support for all present and expected future operations.

true

The DBA must supervise the installation of all software and hardware designated to support the data administration strategy.

true

The DBMS must provide tools that give each level of management a useful view of the data and support the required level of decision-making.

true

The storage locations for multiple backups must include sites inside and outside the organization.

true

When performing user access management, a DBA assigns passwords to each user at both the operating system and DBMS levels.

true

Performance monitoring and _____ activities are designed to ensure that the DBMS, utilities, and applications maintain satisfactory performance levels.

tuning

Protecting the security and integrity of a database is a function of authorization management.

True