Exam 15: Database Administration and Security

The selection of the DBMS ____________________ involves asking the question,"Are the company's needs better served by a relational,object-oriented,or object/relational DBMS?"

"All users must have passwords" is an example of a ____.

Some common physical security practices found in large database installations include secured entrances,password-protected workstations,____,closed-circuit video,and voice-recognition technology.

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

A(n)____ plan is a set of instructions generated at application compilation time that predetermines how the application will access the database at run time.

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

An access ____________________ describes the type of authorized access.

At the level of middle management,the database must be able to ____.

The testing and evaluation of a database application cover all aspects of the system-from the simple collection and creation of data to its use and retirement.What is covered by the evaluation process?

Describe the need for convenient and safe backup storage.

Protecting the data in the database is a function of authorization management.

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

In the IBM DB2 system catalog tables,____________________ stores one row for each column of each table or view.

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

Disaster management includes all the end-user activities designed to secure data availability following a physical disaster or a database integrity failure.

A ____ is a uniquely identifiable object that allows a given person to log on to the database.

____ security breaches include database access by computer viruses and by hackers whose actions are designed to destroy or alter data.

____ are general statements of direction or action that communicate and support DBA goals.

The ____ administrator is responsible for strategic planning.

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