FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 16: Database Administration and Security

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Multiple Choice

Review LaterAdd Note

Review Later

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

A) Access Management
B) Business Intelligence
C) Information engineering (IE)
D) MOLAP

E) C) and D)
F) All of the above

Correct Answer

verified

Show Answer

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

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

A) dynamic
B) active
C) passive
D) static

E) C) and D)
F) A) and C)

Correct Answer

verified

Show Answer

Question 3

Short Answer

Review LaterAdd Note

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.

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

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

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

Describe the need for convenient and safe backup storage.

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

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

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 full backup, or database dump, produces a complete copy of the entire database.

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

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

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

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.

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.

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

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

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.