Exam 12: Database Administration and Security

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

The DBA can use an audit log to automatically record a brief description of the database operations performed by the users.

A full backup, or database dump, produces a complete copy of the entire database.

Training people to use the DBMS and its tools is not included in the DBA's technical activities.

Current data distribution philosophy makes it easy for ____ end users to access the database.

____ deals with ensuring that data is protected against unauthorized access, and if the data are accessed by an authorized user, that the data are used only for an authorized purpose.

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

____________________ deals with the rights of individuals and the organization to determine the "who, what, when, where, and how" of data usage.

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

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

Some common physical security practices found in large database installations include secured entrances, password-protected workstations, ____, closed-circuit video, and voice-recognition technology.

____ activities cover all tasks directly related to the day-to-day operations of the DBMS and its applications.

A(n) ____ is a logical storage space in Oracle.

The advent of the DBMS and its shared view of data produced a new level of data management sophistication and led the DP department to evolve into a(n) _________________________ department.

The ____________________, also known as the information resource manager (IRM), usually reports directly to top management and is given a higher degree of responsibility and authority than the DBA, although the two roles overlap some.

The DBA's ____ role is focused on personnel management and on interactions with the end-user community.

It is common practice to define the DBA function by dividing the DBA operations according to the ____ phases.

The DBA or security officer must secure an insurance policy to provide financial protection in the event of a database failure.

An organization is subject to a(n) _________________________ cycle; that is, the data user applies intelligence to data to produce information that is the basis of knowledge used in decision making by the user.

Instructions to create a password are an example of a ____.