Deck 9: Database Design

Question 1

During the implementation phase of the Systems Development Life Cycle (SDLC), the hardware, database management system (DBMS) software, and application programs are installed, and the database design is implemented.

Answer 1

True

Question 2

The implementation phase of database design includes creating the database storage structure and loading the database, but does not provide for data management.

Answer 2

False

Question 3

Training principles and methodologies are planned during the implementation phase of the Systems Development Life Cycle (SDLC).

Answer 3

False

Question 4

A system is always at some stage of SDLC because every request for structural changes requires retracing the steps of the Systems Development Life Cycle (SDLC).

Question 5

Systems analysis establishes the need for an information system and its extent.

Question 6

The term "database development" is used to describe the process of database design and implementation.

Question 7

The result of analysis phase of the Systems Development Life Cycle (SDLC) should be a better understanding of the system's functional areas, actual and potential problems, and opportunities.

Question 8

The Systems Development Life Cycle (SDLC) provides the big picture within which the database design and application development can be mapped out and evaluated.

Question 9

In the Systems Development Life Cycle (SDLC), after testing is concluded, end-user training is not necessary.

Question 10

The Systems Development Life Cycle (SDLC) traces the history of an information system.

Question 11

A system maintenance activity generated in response to changes in the business environment is referred to as corrective maintenance.

Question 12

In the Systems Development Life Cycle (SDLC), problems defined during the planning phase are examined in greater detail during the analysis phase.

Question 13

The Systems Development Life Cycle's (SDLC's) planning phase yields a general overview of the company and its objectives.

Question 14

In the Systems Development Life Cycle(SDLC), the design of the system's processes begins in the detailed systems design phase.

Question 15

The system is subjected to exhaustive testing during the testing phase of the Systems Development Life Cycle (SDLC).

Question 16

The primary objective in database design is to create complete, normalized, nonredundant, and fully integrated conceptual, logical, and physical database models.

Question 17

The database contents might be loaded interactively or in batch mode using a variety of methods and devices including customized user programs.

Question 18

The analysis phase of the Systems Development Life Cycle (SDLC) involves a cycle of coding, testing, and debugging.

Question 19

In the detailed systems design phase of the Systems Development Life Cycle (SDLC), steps are laid out for the conversion of a database from an old system to a new system.

Question 20

The detailed systems design phase of the Systems Development Life Cycle (SDLC) includes all the necessary technical specifications for the screens, menus, reports, and other devices used to make the system more efficient.

Question 21

Database performance is one of the least important factors in all database implementations.

Question 22

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

A) planning
B) analysis
C) detailed systems design
D) implementation

Question 23

The assignment of access rights may restrict operations on predetermined objects such as databases, tables, views, queries, and reports.

Question 24

Data integrity is enforced by the database management system (DBMS) through the proper use of primary and foreign key rules.

Question 25

Physical design becomes simpler when data is distributed at different locations.

Question 26

Decentralized design is typical of relatively simple, small databases and can be successfully done by a single person.

Question 27

The traditional Systems Development Life Cycle (SDLC) is divided into phases.

A) two
B) three
C) four
D) five

Question 28

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

A) planning
B) analysis
C) detailed systems design
D) implementation

Question 29

The overall purpose of the database initial study is to create the conceptual design.

Question 30

The testing and evaluation phase of the Database Life Cycle (DBLC) occurs after applications programming.

Question 31

In most modern relational DBMSs, a new database implementation requires the creation of special storage-related constructs to house the end-user tables.

Question 32

The main purpose of a backup is to guarantee database restoration following a hardware or software failure.

Question 33

The process of creating an information system is known as .

A) systems development
B) database development
C) network development
D) enterprise development

Question 34

The initial assessment and the feasibility study are part of the Systems Development Life Cycle's (SDLC's) ? phase.

A) planning
B) analysis
C) detailed systems design
D) implementation

Question 35

After the initial declarations in Database Life Cycle (DBLC), the database designer must carefully probe in order to generate additional information that will help define the problem within the larger framework of company operations.

Question 36

Evaluation of database performance is rendered easier by the fact there are no standards to measure it.

Question 37

The Systems Development Life Cycle (SDLC) is a sequential process rather than an iterative process.

Question 38

The database administrator must be prepared to perform routine maintenance activities within the database.

Question 39

To analyze the company situation, the database designer must discover what the company's operational components are, how they function, and how they interact.

Question 40

Installation and fine tuning are part of the phase of the Systems Development Life Cycle (SDLC).

A) planning
B) analysis
C) detailed systems design
D) implementation

Question 41

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

A) database initial study
B) database design
C) operation
D) testing and evaluation

Question 42

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

A) analysis
B) detailed systems design
C) implementation
D) maintenance

Question 43

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

A) planning
B) analysis
C) implementation
D) maintenance

Question 44

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

A) Data encryption
B) Access rights
C) Physical security
D) Password security

Question 45

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

A) database-produced
B) network-produced
C) CASE-produced
D) design-produced

Question 46

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

A) data analysis and requirements
B) entity relationship modeling and normalization
C) data model verification
D) distributed database design

Question 47

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

A) operation
B) database design
C) database initial study
D) implementation and loading

Question 48

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

A) planning
B) analysis
C) implementation
D) maintenance

Question 49

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

A) requirements of the current system's end users.
B) problems and constraints related to the company situation.
C) questions about modification and replacement of existing system.
D) technical aspects of hardware and software requirements.

Question 50

The database initial study phase of the Database Life Cycle (DBLC) involves .

A) defining objectives
B) introducing changes
C) testing the database
D) installing the DBMS

Question 51

There are stages in the Database Life Cycle (DBLC).

A) four
B) five
C) six
D) seven

Question 52

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

A) database initial study
B) database design
C) implementation and loading
D) testing and evaluation

Question 53

Analyzing the company situation is part of the phase of the Database Life Cycle (DBLC).

A) database initial study
B) database design
C) testing, and evaluation
D) operation

Question 54

Installing the DBMS, creating the database, and loading or converting the data are part of the phase of the Database Life Cycle (DBLC).

A) database initial study
B) database design
C) implementation and loading
D) testing and evaluation

Question 55

The design of the system's processes is completed during the phase of the Systems Development Life Cycle (SDLC).

A) planning
B) analysis
C) detailed systems design
D) implementation

Question 56

"What are the requirements of the current system's end users?" is a question asked during the phase of the Systems Development Life Cycle (SDLC).

A) planning
B) analysis
C) implementation
D) maintenance

Question 57

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

A) defining objectives
B) introducing changes
C) testing the database
D) installing the DBMS

Question 58

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

A) Normalization
B) Virtualization
C) Specialization
D) Generalization

Question 59

In the context of the database design process, the conceptual design step that identifies ER modules and validates insert, update, and delete rules is .

A) database analysis and requirements
B) ER modeling and normalization
C) data model verification
D) distributed database design

Question 60

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

A) maintenance and evolution
B) operation
C) testing and evaluation
D) implementation and loading

Question 61

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

A) identify each module and its components
B) identify the ER model's central entity
C) verify all processes against the ER model
D) identify each module's internal transaction requirements

Question 62

The system's defines the extent of the design according to operational requirements.

Question 63

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

A) normalize the entities
B) complete the initial ER diagram
C) identify, analyze, and refine the business rules
D) define the attributes, primary keys, and foreign keys for each of the entities

Question 64

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

A) Memory chip errors
B) Viruses
C) Malware
D) Abortion due to deadlock

Question 65

After testing is concluded, the final is reviewed and printed and end users are trained.

Question 66

are usually provided by the database management system (DBMS) to check for access violations.

Question 67

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

A) programmer
B) manager
C) database administrator
D) systems administrator

Question 68

The traditional Systems Development Life Cycle (SDLC) phases are , analysis, detailed systems design, implementation, and maintenance.

Question 69

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

A) declaration process
B) verification process
C) conceptual process
D) logical process

Question 70

The describes the general conditions in which a company operates, its organizational structure, and its mission.

Question 71

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

A) transaction log backup
B) conservative backup
C) differential backup
D) adaptive backup

Question 72

The proposed system is subject to limits known as , which are external to the system.

Question 73

A(n) is a carefully designed and constructed repository of facts that is a part of a larger whole known as an information system.

Question 74

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

A) database analysis and requirements
B) ER modeling and normalization
C) data model verification
D) distributed database design

Question 75

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

A) Conceptual design
B) Network design
C) Logical design
D) Physical design

Question 76

An initial assessment of the information flow-and-extent requirements must be made during the portion of the Systems Development Life Cycle (SDLC).

Question 77

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

A) defining objectives
B) introducing changes
C) testing the database
D) installing the DBMS

Question 78

is the process that establishes the need for, and the extent of, an information system.

Question 79

The advent of very sophisticated application generators and has substantially decreased coding and testing time.

Question 80

The system and operational costs are addressed by the during the planning phase of the Systems Development Life Cycle (SDLC).