Exam 16: Database Administration and Security

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

Each database has an associated_____ file that is read at instance startup, stores run-time configuration parameters, and is used to set the working environment for the database.

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

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.

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

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

The person responsible for the control of the centralized and shared database is the database _____.

In case a company installs several incompatible databases and assigns a DBA for each of them, the general coordinator of all such DBAs is known as the _____ administrator.

A security vulnerability is a collection of standards and policies created to guarantee the security of a system and ensure auditing and compliance.

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

Explain user requirements gathering as part of the DBA's end-user support services.

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

Describe the need for convenient and safe backup storage.

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

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

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.

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

In the context of an organization's managerial structure, _____ 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(n) _____ data dictionary is automatically updated by the DBMS with every database access.

Instructions to create a password are an example of a _____.