Question 1

is the process that establishes the need for,and the extent of,an information system.

Accepted Answer

The answer of is the process that establishes the need...

Question 2

The Systems Development Life Cycle's (SDLC's)planning phase yields a general overview of the company and its objectives.

Accepted Answer

A) True 
 B)False

Question 3

After the initial declarations in Database Life Cycle (DBLC),the database designer must carefully probe in order to generate additional information that will help define the problem within the larger framework of company operations.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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 6

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

Question 7

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

Question 8

A rule is a brief and precise narrative of a policy,procedure,or principle within a specific organization's environment.

Accepted Answer

The answer of A rule is a brief and precise...

Question 9

In most modern relational DBMSs,a new database implementation requires the creation of special storage-related constructs to house the end-user tables.

Accepted Answer

A) True 
 B)False

Question 10

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

Question 11

The database administrator must be prepared to perform routine maintenance activities within the database.

Accepted Answer

A) True 
 B)False

Question 12

The implementation phase of database design includes creating the database storage structure and loading the database,but does not provide for data management.

Accepted Answer

A) True 
 B)False

Question 13

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 14

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

Question 15

Selecting database management system (DBMS) software is part of the phase of the Database Life Cycle (DBLC) .

Accepted Answer

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

Question 16

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

Question 17

When selecting DBMS ,items to consider include processors,RAM,and disk space.

Accepted Answer

The answer of When selecting DBMS ,items to consider include...

Question 18

The database contents are loaded during the phase of the Systems Development Life Cycle (SDLC) .

Accepted Answer

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

Question 19

"What are the requirements of the current system's end users?" is a question asked during the phase of the Systems Development Life Cycle (SDLC) .

Accepted Answer

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

Question 20

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

Accepted Answer

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

Exam 9: Database Design

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

Correct AnswerverifiedA full backup,or dump,of the entire data...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

is the process that establishes the need for,and the extent of,an information system.

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

In most modern relational DBMSs,a new database implementation requires the creation of special storage-related constructs to house the end-user tables.

Correct AnswerverifiedShow Answer

Selecting database management system (DBMS) software is part of the phase of the Database Life Cycle (DBLC) .

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The database administrator must be prepared to perform routine maintenance activities within the database.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The Systems Development Life Cycle's (SDLC's)planning phase yields a general overview of the company and its objectives.

Correct AnswerverifiedShow Answer

When selecting DBMS ,items to consider include processors,RAM,and disk space.

Correct AnswerverifiedShow Answer

"What are the requirements of the current system's end users?" is a question asked during the phase of the Systems Development Life Cycle (SDLC) .

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The database contents are loaded during the phase of the Systems Development Life Cycle (SDLC) .

Correct AnswerverifiedShow Answer

The implementation phase of database design includes creating the database storage structure and loading the database,but does not provide for data management.

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

A rule is a brief and precise narrative of a policy,procedure,or principle within a specific organization's environment.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

After the initial declarations in Database Life Cycle (DBLC),the database designer must carefully probe in order to generate additional information that will help define the problem within the larger framework of company operations.

Correct AnswerverifiedShow Answer

Correct Answer
verified
A full backup,or dump,of the entire data...
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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified