DBMS Chapter 9
Discovery of user requirements, existing system evaluation, and logical system design are part of the _____ phase of the Systems Development Life Cycle (SDLC).
Analysis
The logical systems design is created during the ______ phase of the Systems Development Life Cycle (SDLC).
Analysis
The last step in the Database Life Cycle (DBLC) is _____.
Maintenance and evolution
"Should the existing system be replaced?" is a question that is asked during the _____ stage of the Systems Development Life Cycle (SDLC).
Planning
The feasibility study during the planning phase of the Systems Development Life Cycle (SDLC) must address the:
Technical aspects of hardware and software requirements.
During decentralized design, after the _____ has been completed, all modules are integrated into one conceptual model.
Verification process
_____ is a technique that creates logical representations of computing resources that are independent of the underlying physical computing resources.
Virtualization
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
_____ can render data useless to unauthorized users who might have violated some of the database security layers.
Data encryption
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
In DBLC, the phase after the database initial study is ______.
Database design
Selecting database management system (DBMS) software is part of the _____ phase of the Database Life Cycle (DBLC).
Database design
The implementation of _____ applications tends to prolong the operational life of systems by making them easier to update and maintain.
CASE-produced
In a(n) _____, only the objects that have been updated or modified since the last full backup are backed up.
Differential backup
In the context of the database design process, the conceptual design step that defines the fragmentation and allocation strategy is _____.
Distributed database design
The first step in the ER model verification process is to _____.
Identify the ER model's central entity
The first step in developing the conceptual model using ER diagrams is to ______.
Identify, analyze, and refine the business rules.
Coding, testing, and debugging are part of the ______ phase of the Systems Development Life Cycle (SDLC).
Implementation
The database contents are loaded during the _____ phase of the Systems Development Life Cycle (SDLC).
Implementation
The implementation and loading phase of the Database Life Cycle (DBLC) involves ______.
Installing the DBMS.
The maintenance and evolution phase of the Database Life Cycle (DBLC) involves ______.
Introducing changes
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
______ is the process of determining the data storage organization and data characteristics of the database to ensure its integrity, security, and performance.
Physical design
The process of creating an information system is known as _____.
Systems development