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

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 22

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

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

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

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

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

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

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

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

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

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

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

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.

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 _____.

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

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

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

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?

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