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 1

Short Answer

Review LaterAdd Note

Review Later

The DBA's function includes educating the ____________________ in the services provided and how those services enhance data stewardship and data security.

Correct Answer

verified

Show Answer

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

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

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

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

Correct Answer

verified

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

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

The most common backup medium has traditionally been ____________________.

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

The DBA must review the database application design to ensure that transactions are ____________________,meaning that they do not overload the DBMS.

A(n) ____ plan is a set of instructions generated at application compilation time that predetermines how the application will access the database at run time.

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.

One of the important functions provided by the database ____ is to reserve the resources that must be used by the database at run time.

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

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.

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

Most of today's successful organizations depend on the ____________________ database to provide support for all of their operations-from design to implementation,from sales to services,and from daily decision making to strategic planning.

A ____ is a named collection of database access privileges that authorize a user to connect to the database and use the database system resources.

____ are more detailed and specific than policies and describe the minimum requirements of a given DBA activity.

A security ____________________ is a weakness in a system component that could be exploited to allow unauthorized access or cause service disruptions.

In the IBM DB2 system catalog tables,____________________ stores one row for each column of each table or view.

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

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

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