Chapter 15 Database Administration

question

role
answer

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

data
answer

The ____ administrator is responsible for strategic planning
question

full
answer

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

Authorization
answer

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

profile
answer

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

managerial
answer

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

deliver the data necessary for tactical decisions and planning
answer

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

to support managerial decision making
answer

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

data
answer

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

security officer
answer

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

Standards
answer

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

establish DBMS performance goals
answer

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

actions
answer

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

cultural
answer

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

systems administrator
answer

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

control and planning
answer

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

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

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

administrator
answer

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

access plan
answer

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

Disaster
answer

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

OracleOraDb10g_home1TNSListener
answer

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

procedure
answer

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

administrator
answer

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

policy
answer

“All users must have passwords” is an example of a ____.
question

ISA
answer

What is the output of the IE process?
question

Procedures
answer

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

IE
answer

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

wizard
answer

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.
question

Back
answer

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

DBLC
answer

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

technical
answer

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

managerial
answer

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

User access
answer

____ management is designed to limit access to the database.
question

DP
answer

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.
question

Corrupting
answer

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

Front
answer

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

user
answer

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

top
answer

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

Policies
answer

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

specialization
answer

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

Concurrent
answer

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

database
answer

The ____ administrator controls and supervises the DBMS.
question

audit log
answer

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.
question

electronic personnel badges
answer

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

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

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

authorization management
answer

User access management is a subset of ____.
question

active
answer

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

annually
answer

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

Get instant access to
all materials

Become a Member