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 51

Short Answer

Review LaterAdd Note

Review Later

In large organizations, the DSO's activities are often classified as ____________________ management.

Correct Answer

verified

Show Answer

Question 52

Multiple Choice

Review LaterAdd Note

Review Later

The DBA's ____ role covers activities involving the use of the DBMS.

A) administrative
B) arbitration
C) technical
D) managerial

E) A) and C)
F) None of the above

Correct Answer

verified

Show Answer

Question 53

True/False

Review LaterAdd Note

Having a computerized DBMS guarantees that the data will be properly used to provide the best solutions required by managers.

Security breaches can yield a database whose integrity is either preserved or corrupted.

Placing the DBA function in a(n) ____________________ position often creates a consulting environment in which the DBA is able to devise the data administration strategy but does not have the authority to enforce it or to resolve possible conflicts.

A(n) ________________________________________ provides a framework that includes the use of computerized, automated, and integrated tools such as a DBMS and CASE tools.

The ____ administrator is responsible for strategic planning.

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

The ____ is responsible for ensuring database security and integrity.

The requirement that a password must have a maximum of 12 characters is an example of a(n) ____________________.

There is a growing trend toward ____ in the data-management function.

The ____ component of a CASE tool produces the information system's input/output formats.

One CASE tool, ____________________ Data Modeler by Computer Associates, produces fully documented ER diagrams that can be displayed at different abstraction levels.

User-access management is a subset of ____.

Concurrent backups take place while the user is working on the database.

Incremental backups produce a backup of all data.

The DBMS must provide tools that give each level of management a different view of the data and support the required level of decision-making.

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

By default, Oracle automatically creates ____________________ and SYS user IDs that have administrative privileges with every new database you create.

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