Exam 16: Database Administration and Security

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

Within the data security framework, _____ is concerned with keeping data consistent and free of errors or anomalies.

In the context of database administration, _____ is the extent to which individuals and organizations have the right to determine the "who, what, when, where, and how" of data usage.

Which of the following is a reason why a DBMS's daily operations must be clearly documented?

A(n) _____ plan is a set of instructions generated at application compilation time that predetermines how the application will connect to and communicate with the database at run time.

In the context of Oracle Enterprise Manager, a(n) _____ is a named collection of database access privileges that authorize a user to connect to the database and use its system resources.

In the context of Oracle Enterprise Manager, a(n) _____ isa uniquely identifiable object that allows a given person to log on to the database.

The DBA is responsible for ensuring that the data are distributed to the right persons, at the right time, and in the right format.

One of the important functions provided by the database _____ is to reserve the resources that must be used by the database at run time.

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

A(n) _____ is a logical storage area in Oracle.

_____ are more detailed and specific than policies and describe the minimum requirements of a given DBA 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.

In the context of ensuring integrity of a database, a(n) _____ transaction is one that does not overload the DBMS.

_____ CASE tools provide support for the coding and implementation phases.

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

The _____ administrator is responsible for strategic planning.

A(n) _____ data dictionary is not updated automatically and usually requires a batch process to be run.

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

A data administrator is also known as a(n) _____.