FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 15: Database Administration and Security

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 22

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 23

True/False

Review LaterAdd Note

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

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?

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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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