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 31

True/False

Review LaterAdd Note

Review Later

The DBA must define data views to protect and control the scope of the data that are accessible to an authorized user.

A) True
B) False

Correct Answer

verified

Show Answer

Question 32

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 33

Multiple Choice

Review LaterAdd Note

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

The DBA function provides data modeling and design services to the end-user community,often through coordination with an application development group within the data-processing department.

The DBA can use an audit log to automatically record a brief description of the database operations performed by the users.

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

A(n) ____ serves as the basis for planning,development,and control of future information systems

Several DBMS packages contain features that allow the creation of a(n) ____,which automatically records a brief description of the database operations performed by all users.

The DBA must periodically generate a(n)____________________ report to determine whether there have been actual or attempted security violations-and,if so,from what locations,and if possible,by whom.

Database access can be controlled by placing limits on the use of the DBMS's query and reporting tools.

Testing procedures and standards must already be in place before any application program can be approved for use in the company.

The security,privacy,and integrity of the data in the database are of minimal concern to DBAs who manage current DBMS installations.

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

As a manager,the DBA must concentrate on the ____ dimensions of the database administration function.

Incremental backups produce a backup of all data.

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

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

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

____ CASE tools provide support for the coding and implementation phases.

____________________ deals with the rights of individuals and the organization to determine the "who,what,when,where,and how" of data usage.