Question 1

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 2

_____ 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) C) and D)
F) All of the above

Question 3

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

Question 4

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) All of the above
F) None of the above

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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) None of the above
F) B) and C)

Question 7

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 8

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

Question 9

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 10

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 11

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 12

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

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

_____ 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) B) and C)
F) C) and D)

Question 15

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) B) and C)
F) None of the above C

Question 16

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

Accepted Answer

A) True 
 B)False

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

Question 18

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

Accepted Answer

Diskless w...

Question 19

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

Question 20

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

Exam 9: Database Design

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The logical systems design is created during the _____ phase 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

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

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 last step in the Database Life Cycle (DBLC) is _____.

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

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedB

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

Correct AnswerverifiedShow Answer

_____ 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

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

Correct AnswerverifiedC

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

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

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

Correct AnswerverifiedDiskless w...View AnswerShow 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

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

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
True

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
B

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
C

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Diskless w...
View Answer

Correct Answer
verified

Correct Answer
verified