DBMS Chapter 9

The maintenance and evolution phase of the Database Life Cycle (DBLC) involves ______.

Introducing changes

The implementation and loading phase of the Database Life Cycle (DBLC) involves ______.

Installing the DBMS.

Coding, testing, and debugging are part of the ______ phase of the Systems Development Life Cycle (SDLC).

Implementation

Which of the following is a hardware-induced database failure?

Memory chip errors

Producing the required information flow is part of the ______ phase of the Database Life Cycle (DBLC).

Operation

The first step in developing the conceptual model using ER diagrams is to ______.

Identify, analyze, and refine the business rules.

In the context of the database design process, the conceptual design step that determines end-user views, outputs, and transaction-processing requirements in ______.

Data analysis and requirements

In DBLC, the phase after the database initial study is ______.

Database design

The logical systems design is created during the ______ phase of the Systems Development Life Cycle (SDLC).

Analysis

______ is the process of determining the data storage organization and data characteristics of the database to ensure its integrity, security, and performance.

Physical design

Once the data has been loaded into the database, the ______ tests and fine-tunes the database for performance, integrity, concurrent access, and security constraints.

Database Administrator

During decentralized design, after the _____ has been completed, all modules are integrated into one conceptual model.

Verification process

_____ can render data useless to unauthorized users who might have violated some of the database security layers.

Data encryption

In the context of the database design process, the conceptual design step that defines the fragmentation and allocation strategy is _____.

Distributed database design

The process of creating an information system is known as _____.

Systems development

Selecting database management system (DBMS) software is part of the _____ phase of the Database Life Cycle (DBLC).

Database design

The first step in the ER model verification process is to _____.

Identify the ER model's central entity

_____ is a technique that creates logical representations of computing resources that are independent of the underlying physical computing resources.

Virtualization

In a(n) _____, only the objects that have been updated or modified since the last full backup are backed up.

Differential backup

The implementation of _____ applications tends to prolong the operational life of systems by making them easier to update and maintain.

CASE-produced

Discovery of user requirements, existing system evaluation, and logical system design are part of the _____ phase of the Systems Development Life Cycle (SDLC).

Analysis

"Should the existing system be replaced?" is a question that is asked during the _____ stage of the Systems Development Life Cycle (SDLC).

Planning

The last step in the Database Life Cycle (DBLC) is _____.

Maintenance and evolution

The feasibility study during the planning phase of the Systems Development Life Cycle (SDLC) must address the:

Technical aspects of hardware and software requirements.

The database contents are loaded during the _____ phase of the Systems Development Life Cycle (SDLC).

Implementation