Question 1

Performance evaluation is rendered more difficult by the fact that there are standard measurements for database performance.

Accepted Answer

A) True 
 B)False

Question 2

The traditional SDLC is divided into ____ phases.

Accepted Answer

A)   two
B)   three
C)   four
D)   fiveE) All of the above
F) A) and D)

Question 3

The implementation and loading phase of the DBLC involves ____.

Accepted Answer

A)   defining objectives
B)   introducing changes
C)   testing the database
D)   installing the DBMSE) C) and D)
F) B) and C)

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

The SDLC provides the big picture within which the database design and application development can be mapped out and evaluated.

Accepted Answer

A) True 
 B)False

Question 6

Evaluation, maintenance, and enhancement are part of the ____ phase of the SDLC.

Accepted Answer

A)   planning
B)   maintenance
C)   detailed systems design
D)   implementationE) A) and D)
F) C) and D)

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

Explain the differences between a centralized and decentralized approach to database design.

Accepted Answer

Centralized design is productive when th...

Question 9

There are ____ classical approaches to database design.

Accepted Answer

A)   two
B)   three
C)   four
D)   fiveE) B) and C)
F) None of the above

Question 10

The SDLC traces the history of an information system.

Accepted Answer

A) True 
 B)False

Question 11

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) All of the above
F) A) and B)

Question 12

The conceptual design step that identifies ER modules and validates insert, update, and delete rules is ____.

Accepted Answer

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

Question 13

The result of analysis should be a better understanding of the system's functional areas, actual and potential problems, and opportunities.

Accepted Answer

A) True 
 B)False

Question 14

The SDLC is most important to the ____.

Accepted Answer

A)   programmer
B)   manager
C)   system designer
D)   database administratorE) None of the above
F) C) and D)

Question 15

A(n) ____________________ log backup backs up only the transaction log operations that are not reflected in a previous backup copy of the database.

Accepted Answer

The answer of A(n) ____________________ log backup backs up only...

Question 16

The logical systems design is created during the ____ phase of the SDLC.

Accepted Answer

A)   planning
B)   analysis
C)   implementation
D)   maintenanceE) A) and B)
F) All of the above

Question 17

Producing the required information flow is part of the ____ phase of the DBLC.

Accepted Answer

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

Question 18

The first step in ____________________ design is to discover the data element characteristics.

Accepted Answer

The answer of The first step in ____________________ design is...

Question 19

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

Accepted Answer

The answer of The system's ____________________ defines the extent of...

Question 20

The term "module ____________________" describes the extent to which modules are independent of one another.

Accepted Answer

The answer of The term "module ____________________" describes the extent...

Exam 2: Database Development Process

Performance evaluation is rendered more difficult by the fact that there are standard measurements for database performance.

Correct AnswerverifiedShow Answer

Producing the required information flow is part of the ____ phase of the DBLC.

Correct AnswerverifiedShow Answer

The implementation and loading phase of the DBLC involves ____.

Correct AnswerverifiedShow Answer

The first step in ____________________ design is to discover the data element characteristics.

Correct AnswerverifiedShow Answer

The term "module ____________________" describes the extent to which modules are independent of one another.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The SDLC provides the big picture within which the database design and application development can be mapped out and evaluated.

Correct AnswerverifiedShow Answer

The logical systems design is created during the ____ phase of the SDLC.

Correct AnswerverifiedShow Answer

Evaluation, maintenance, and enhancement are part of the ____ phase of the SDLC.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

There are ____ classical approaches to database design.

Correct AnswerverifiedShow Answer

Explain the differences between a centralized and decentralized approach to database design.

Correct AnswerverifiedCentralized design is productive when th...View AnswerShow Answer

The SDLC traces the history of an information system.

Correct AnswerverifiedShow Answer

The traditional SDLC is divided into ____ phases.

Correct AnswerverifiedShow Answer

A(n) ____________________ log backup backs up only the transaction log operations that are not reflected in a previous backup copy of the database.

Correct AnswerverifiedShow Answer

The result of analysis should be a better understanding of the system's functional areas, actual and potential problems, and opportunities.

Correct AnswerverifiedShow Answer

The SDLC is most important to the ____.

Correct AnswerverifiedShow Answer

The conceptual design step that identifies ER modules and validates insert, update, and delete rules is ____.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow 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
Centralized design is productive when th...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified