Exam 15: Database Administration and Security

The ____ is responsible for ensuring database security and integrity.

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

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

____ management is designed to limit access to the database.

Physical protection of hardware and software must be accomplished by the use of open installations with restricted area access.

____ are written instructions that describe a series of steps to be followed during the performance of a given activity.

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

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

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

The ____ administrator is responsible for strategic planning.

As a manager,the DBA must concentrate on the ____ dimensions of the database administration function.

____________________ decisions are short term and affect only daily operations;for example,deciding to change the price of a product to clear it from inventory.

A ____ is a named collection of settings that control how much of the database resource a given user can use.

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

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

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

____ allows for the translation of the company's strategic goals into the data and applications that will help the company achieve those goals.

Database access can be controlled by placing limits on the use of the DBMS's query and reporting tools.

Describe the DBA's managerial role.

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