Exam 12: Database Administration and Security

The requirement that a password must have a maximum of 12 characters is an example of a(n) ____________________.

By default, Oracle automatically creates ____________________ and SYS user IDs that have administrative privileges with every new database you create.

A(n) ________________________________________ provides a framework that includes the use of computerized, automated, and integrated tools such as a DBMS and CASE tools.

Having a computerized DBMS guarantees that the data will be properly used to provide the best solutions required by managers.

There is a growing trend toward ____ in the data-management function.

Backups must be clearly identified through detailed descriptions and date information, assuring that the correct backup is used to recover the database.

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

User-access management is a subset of ____.

Concurrent backups take place while the user is working on the database.

The DBA's ____ role covers activities involving the use of the DBMS.

The ____ is responsible for ensuring database security and integrity.

The ____ administrator is responsible for strategic planning.

Placing the DBA function in a(n) ____________________ position often creates a consulting environment in which the DBA is able to devise the data administration strategy but does not have the authority to enforce it or to resolve possible conflicts.

Incremental backups produce a backup of all data.

Security breaches can yield a database whose integrity is either preserved or corrupted.

One CASE tool, ____________________ Data Modeler by Computer Associates, produces fully documented ER diagrams that can be displayed at different abstraction levels.

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

The general coordinator of all DBAs is sometimes known as the ____________________ administrator.

In large organizations, the DSO's activities are often classified as ____________________ management.

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