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 selection of the DBMS ____________________ involves asking the question,"Are the company's needs better served by a relational,object-oriented,or object/relational DBMS?"

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

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

A) Dangerous
B) Preserving
C) Corrupting
D) Authorized

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

Correct Answer

verified

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

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.

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

____ are general statements of direction or action that communicate and support DBA goals.

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

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

It is common practice to define the DBA function by dividing the DBA operations according to the ____ phases.

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

An access ____________________ describes the type of authorized access.

Describe the need for convenient and safe backup storage.

Protecting the data in the database is a function of authorization management.

Disaster management includes all the end-user activities designed to secure data availability following a physical disaster or a database integrity 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?

The ____ administrator is responsible for strategic planning.

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.

A ____ is a uniquely identifiable object that allows a given person to log on to the database.

An enterprise database can be defined as the company's data representation that provides support for all present and expected future operations.

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

At the level of middle management,the database must be able to ____.