Exam 15: Database Administration and Security

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

Instructions to create a password are an example of a .

In the context of database administration, standards are written instructions that describe a series of steps to be followed during the performance of a given activity.

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

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 can overlap.

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

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

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.

Describe the DBA's managerial role.

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

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

are more detailed and specific than policies and describe the minimum requirements of a given DBA activity.

_____ 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.

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

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

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

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

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

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

The maintenance activities of the DBA are an extension of the operational activities.