Filters
Question type

Study Flashcards

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

A) True
B) False

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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


A) cross-training
B) encapsulation
C) specialization
D) centralization

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

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

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


A) analysis
B) graphics
C) program document generator
D) screen painter and report generator

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

Correct Answer

verifed

verified

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.

A) True
B) False

Correct Answer

verifed

verified

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

verifed

verified

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.


A) change tracker
B) digital footprint
C) paper trail
D) audit log

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

Correct Answer

verifed

verified

Incremental backups produce a backup of all data.

A) True
B) False

Correct Answer

verifed

verified

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.

Correct Answer

verifed

verified

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


A) access plan
B) active data dictionary
C) information systems architecture (ISA)
D) security policy

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

Correct Answer

verifed

verified

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


A) control and planning
B) conflict and problem-resolution
C) policies and standards
D) security and privacy

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

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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


A) Backup and recovery
B) System support
C) Performance monitoring and tuning
D) Security auditing and monitoring

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

Correct Answer

verifed

verified

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


A) Guidelines
B) Standards
C) Procedures
D) Documentation

E) All of the above
F) B) and C)

Correct Answer

verifed

verified

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

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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


A) Front-end
B) Back-end
C) Vertical
D) Horizontal

E) All of the above
F) A) and D)

Correct Answer

verifed

verified

Showing 41 - 60 of 100

Related Exams

Show Answer