Exam 15: Database Administration and Security

Based on the type of decision-making support required, database users may be classified into: operational, tactical, or _____.

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?

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

The DBA must review the database application design to ensure that transactions are , meaning that they mirror real-world events.

A full backup, or database dump, produces a complete copy of the entire database.

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

A(n) _____ physically stores the database's data.

Explain conflict and problem resolution as part of the DBA's end-user support services.

Protecting the security and integrity of a database is a function of authorization management.

Database administration operations are commonly defined and divided according to the phases of the .

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

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

The DBA must supervise the installation of all software and hardware designated to support the data administration strategy.

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

The storage locations for multiple backups must include sites inside and outside the organization.

The aspect of introducing a DBMS in an organization deals with hardware and software changes in the organization.

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

Describe the need for convenient and safe backup storage.

When an organization employs both a DA and a DBA, the DA's job has a technical orientation, whereas the DBA's job has a managerial orientation.

In the context of the data-information-decision cycle, decisions made by high-level managers trigger actions in an organization's: