FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 12: Database Administration and Security

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Short Answer

Review LaterAdd Note

Review Later

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.

Correct Answer

verified

DA
data ad...

View Answer

Show Answer

Question 2

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

True

Question 3

True/False

Review LaterAdd Note

Training people to use the DBMS and its tools is not included in the DBA's technical activities.

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

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

A(n) ____ is a logical storage space in Oracle.

The DBA interacts with the end user by providing data and information support services to the organization's departments.

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

____ deals with ensuring that data is protected against unauthorized access, and if the data are accessed by an authorized user, that the data are used only for an authorized purpose.

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

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

The advent of the DBMS and its shared view of data produced a new level of data management sophistication and led the DP department to evolve into a(n) _________________________ department.

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

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.

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

The DBA's ____ role is focused on personnel management and on interactions with the end-user community.

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

An organization is subject to a(n) _________________________ cycle; that is, the data user applies intelligence to data to produce information that is the basis of knowledge used in decision making by the user.

Current data distribution philosophy makes it easy for ____ end users to access the database.