Question 1

In the context of the database design process, 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 C)
F) A) and C)

Question 2

From a database point of view, the collection of data becomes meaningful only when the are defined.

Accepted Answer

The answer of From a database point of view, the...

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Question 5

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

Question 6

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 7

The goal is to design an enterprise-wide database based on a specific data model but independent of physical-level details.

Accepted Answer

The answer of The goal is to design an enterprise-wide...

Question 8

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

Accepted Answer

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 entitiesE) None of the above
F) A) and D)

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

The answer of The first step in is to discover...

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

Question 12

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 13

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

Accepted Answer

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

Question 14

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 15

The term describes the strength of the relationships found among a module's entities.

Accepted Answer

The answer of The term describes the strength of the...

Question 16

Programmers use database tools to the applications during coding of the programs.

Accepted Answer

The answer of Programmers use database tools to the applications...

Question 17

What are the classical approaches to database design?

Accepted Answer

There are two classical approaches to da...

Question 18

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

Question 19

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

Question 20

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.

Accepted Answer

A) True 
 B)False

Exam 9: Database Design

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The term describes the strength of the relationships found among a module's entities.

Correct AnswerverifiedShow Answer

Programmers use database tools to the applications during coding of the programs.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

From a database point of view, the collection of data becomes meaningful only when the are defined.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The goal is to design an enterprise-wide database based on a specific data model but independent of physical-level details.

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What are the classical approaches to database design?

Correct AnswerverifiedThere are two classical approaches to da...View AnswerShow 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

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

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

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

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
There are two classical approaches to da...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified