Question 1

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

Accepted Answer

A)   maintenance
B)   implementation
C)   analysis
D)   detailed systems designE) B) and C)
F) A) and D)

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

List and briefly describe the three types of system maintenance activities.

Accepted Answer

The three types of maintenance activitie...

Question 4

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

Accepted Answer

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 requirementsE) A) and B)
F) B) and C)

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A)   database initial study
B)   database design
C)   operation
D)   testing and evaluationE) B) and D)
F) None of the above

Question 7

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

Accepted Answer

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

Question 8

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

Accepted Answer

A)   database analysis and requirements
B)   ER modeling and normalization
C)   data model verification
D)   distributed database designE) B) and C)
F) None of the above

Question 9

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

Accepted Answer

A)   systems development
B)   database development
C)   network development
D)   enterprise developmentE) C) and D)
F) None of the above

Question 10

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

Accepted Answer

The answer of An initial assessment of the information flow-and-extent...

Question 11

List and describe the different levels at which database backups can be performed.

Accepted Answer

A full backup, or dump, of the entire da...

Question 12

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

Accepted Answer

The answer of _____ are usually provided by the database...

Question 13

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

Accepted Answer

The answer of The proposed system is subject to limits...

Question 14

The result of the _____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.

Accepted Answer

A)   analysis
B)   implementation
C)   detailed systems design
D)   maintenanceE) None of the above
F) A) and B)

Question 15

The _____ stage uses data modeling to create an abstract database structure that represents real-world objects in the most realistic way possible.

Accepted Answer

The answer of The _____ stage uses data modeling to...

Question 16

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

Accepted Answer

A)   declaration process
B)   verificationprocess
C)   conceptual process
D)   logical processE) A) and D)
F) A) and C)

Question 17

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

Accepted Answer

A)   Memory chip errors
B)   Viruses
C)   Malware
D)   Abortion due to deadlockE) None of the above
F) All of the above

Question 18

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

Accepted Answer

A)   programmer
B)   manager
C)   database administrator
D)   systems administratorE) None of the above
F) A) and B)

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 9: Database Design

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

List and briefly describe the three types of system maintenance activities.

Correct AnswerverifiedThe three types of maintenance activitie...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The result of the _____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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The _____ stage uses data modeling to create an abstract database structure that represents real-world objects in the most realistic way possible.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

List and describe the different levels at which database backups can be performed.

Correct AnswerverifiedA full backup, or dump, of the entire da...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
The three types of maintenance activitie...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A full backup, or dump, of the entire da...
View Answer

Correct Answer
verified

Correct Answer
verified