Exam 15: Database Administration and Security

The DBA function provides data modeling and design services to the end-user community,often through coordination with an application development group within the data-processing department.

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

A(n)____ serves as the basis for planning,development,and control of future information systems

The security,privacy,and integrity of the data in the database are of minimal concern to DBAs who manage current DBMS installations.

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

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

Incremental backups produce a backup of all data.

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

Testing procedures and standards must already be in place before any application program can be approved for use in the company.

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

The DBA must periodically generate a(n)____________________ report to determine whether there have been actual or attempted security violations-and,if so,from what locations,and if possible,by whom.

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

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

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

The DBA must define data views to protect and control the scope of the data that are accessible to an authorized user.

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

Several DBMS packages contain features that allow the creation of a(n)____,which automatically records a brief description of the database operations performed by all users.

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

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.