question

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

answer

role

question

The ____ administrator is responsible for strategic planning

answer

data

question

A(n) ____ backup produces a complete copy of the entire database.

answer

full

question

____ management defines procedures to protect and guarantee database security and integrity.

answer

Authorization

question

A ____ is a named collection of settings that control how much of the database resource a given user can use.

answer

profile

question

The DA's job typically has a strong ____ orientation with company-wide scope.

answer

managerial

question

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

answer

deliver the data necessary for tactical decisions and planning

question

Whatever the type of organization, the database's predominant role is ____.

answer

to support managerial decision making

question

The ____ administrator is responsible for providing a global and comprehensive administrative strategy for all of the organization's data.

answer

data

question

The database ____ is responsible for ensuring database security and integrity.

answer

security officer

question

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

answer

Standards

question

To carry out the performance-monitoring and tuning tasks, the DBA must first ____.

answer

establish DBMS performance goals

question

In the data-information decision making cycle, decision making triggers ____.

answer

actions

question

When introducing a database into an organization, a(n) ____ impact is likely because the database approach creates a more controlled and structured information flow.

answer

cultural

question

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

answer

systems administrator

question

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

answer

control and planning

question

What is a disadvantage of using a graphical tool such as the Oracle Configuration Assistant to create a database?

answer

There are no records in the form of SQL scripts to document the creation of the database.

question

The database ____ must provide testing and evaluation services for all the database and end user applications.

answer

administrator

question

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

answer

access plan

question

____ management includes all DBA activities designed to secure data availability following a physical disaster or a database integrity failure.

answer

Disaster

question

____ is the process that "listens to" and processes the end-user connection requests over the network.

answer

OracleOraDb10g_home1TNSListener

question

Instructions to create a password are an example of a ____.

answer

procedure

question

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

answer

administrator

question

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

answer

policy

question

What is the output of the IE process?

answer

ISA

question

____ are written instructions that describe a series of steps to be followed during the performance of a given activity

answer

Procedures

question

The ____ rationale is simple: business data types tend to remain fairly stable and do not change much during their existence.

answer

IE

question

Using the Oracle Database Configuration Assistant, it is simple to create a database. The DBA uses a ____ interface to answer a series of questions to establish the parameters for the database to be created.

answer

wizard

question

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

answer

Back

question

Although no current standard exists, it is common practice to define the DBA function by dividing the DBA operations according to the ____ phases.

answer

DBLC

question

The DBA's ____ role covers activities involving the use of the DBMS

answer

technical

question

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

answer

managerial

question

____ management is designed to limit access to the database.

answer

User access

question

In the old, decentralized world of the file system, the ____ department's task was to pool all computer resources to support all departments at the operational level.

answer

DP

question

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

answer

Corrupting

question

____-end CASE tools provide support for the planning, analysis, and design phases.

answer

Front

question

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

answer

user

question

The data administrator (DA) usually reports directly to ____ management.

answer

top

question

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

answer

Policies

question

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

answer

specialization

question

____ backups take place while the user is working on the database

answer

Concurrent

question

The ____ administrator controls and supervises the DBMS.

answer

database

question

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.

answer

audit log

question

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

answer

electronic personnel badges

question

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

answer

provide access to external and internal data to identify growth opportunities and to chart the direction of such growth

question

User access management is a subset of ____.

answer

authorization management

question

A(n) ____ data dictionary is automatically updated by the DBMS with every database access.

answer

active

question

Procedures and standards must be revised at least ____ to keep them up to date.

answer

annually

Chapter 15 Database Administration – Flashcards

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards