Question 1

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

Accepted Answer

A)   planning
B)   analysis
C)   implementation
D)   maintenanceE) C) and D)
F) B) and C)

Question 2

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

Accepted Answer

A)   planning
B)   analysis
C)   implementation
D)   maintenanceE) C) and D)
F) A) and B)

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A)   transaction log backup
B)   conservative backup
C)   differential backup
D)   adaptive backupE) A) and D)
F) C) and D) C

Question 6

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

Accepted Answer

A)   Conceptual design
B)   Networkdesign
C)   Logical design
D)   Physical designE) A) and D)
F) A) and C)

Question 7

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

Accepted Answer

A)   Data encryption
B)   Access rights
C)   Physical security
D)   Password securityE) None of the above
F) All of the above

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

Because real-world database design is generally done by teams, the database design is probably divided into major components known as _____.

Accepted Answer

The answer of Because real-world database design is generally done...

Question 10

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

Accepted Answer

The answer of A(n) _____ is a carefully designed and...

Question 11

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

Accepted Answer

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

Question 12

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).

Accepted Answer

A) True 
 B)False  True

Question 13

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.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

The answer of The traditional Systems Development Life Cycle (SDLC)...

Question 16

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

Accepted Answer

A)   maintenance and evolution
B)   operation
C)   testing and evaluation
D)   implementation and loadingE) All of the above
F) None of the above

Question 17

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

Accepted Answer

A)   Normalization
B)   Virtualization
C)   Specialization
D)   GeneralizationE) A) and D)
F) All of the above

Question 18

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

Accepted Answer

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

Question 19

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

Accepted Answer

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

Question 20

_____ allow end users to access the database without being able to download the information from their workstations.

Accepted Answer

Diskless w...

Exam 9: Database Design

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedC

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Because real-world database design is generally done by teams, the database design is probably divided into major components known as _____.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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).

Correct AnswerverifiedTrue

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedB

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

Correct AnswerverifiedShow Answer

_____ allow end users to access the database without being able to download the information from their workstations.

Correct AnswerverifiedDiskless w...View AnswerShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
C

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
True

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
B

Correct Answer
verified

Correct Answer
verified
Diskless w...
View Answer