DBMS Chapter 9

7 September 2022
4.7 (114 reviews)
25 test answers

Unlock all answers in this set

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