Question 1

Data integrity is enforced by the DBMS through the proper use of primary and foreign key rules.

Accepted Answer

A) True 
 B)False

Question 2

What are the factors affecting the purchasing decision for DBMS software?

Accepted Answer

Cost.This includes the original purchase...

Question 3

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

Accepted Answer

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

Question 4

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

Accepted Answer

Centralized design is productive when the data component is composed of a relatively small number of objects and procedures.The design can be carried out and represented in a fairly simple database.Centralized design is typical of relatively simple and/or small databases and can be successfully done by a single person (database administrator)or by a small,informal design team.The company operations and the scope of the problem are sufficiently limited to allow even a single designer to define the problem(s),create the conceptual design,verify the conceptual design with the user views,define system processes and data constraints to ensure the efficacy of the design,and ensure that the design will comply with all the requirements.(Although centralized design is typical for small companies,do not make the mistake of assuming that centralized design is limited to small companies.Even large companies can operate within a relatively simple database environment.)Decentralized design might be used when the data component of the system has a considerable number of entities and complex relations on which very complex operations are performed.Decentralized design is also likely to be employed when the problem itself is spread across several operational sites and each element is a subset of the entire data set.In large and complex projects,the database design typically cannot be done by only one person.Instead,a carefully selected team of database designers is employed to tackle a complex database project.Within the decentralized design framework,the database design task is divided into several modules.Once the design criteria have been established,the lead designer assigns design subsets or modules to design groups within the team.

Question 5

Installing the DBMS,creating the database,and loading or converting the data are part of the ____ phase of the DBLC.

Accepted Answer

A)   database initial study
B)   database design
C)   implementation and loading
D)   testing and evaluationE) A) and B)
F) B) and D) C

Question 6

A system maintenance activity generated in response to changes in the business environment is referred to as corrective maintenance.

Accepted Answer

A) True 
 B)False

Question 7

A(n)____________________ 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(n)____________________ rule is a brief and precise...

Question 8

In addition to system scope,which defines the extent of the design,the proposed system is subject to ____________________,which are external to the system.

Accepted Answer

The answer of In addition to system scope,which defines the...

Question 9

"What are the requirements of the current system's end users?"is a question asked during the ____ phase of the SDLC.

Accepted Answer

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

Question 10

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 11

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 12

Detailed system specification is part of the ____ phase of the SDLC.

Accepted Answer

A)   planning
B)   analysis
C)   detailed systems design
D)   implementationE) B) and C)
F) All of the above

Question 13

The advent of very sophisticated application generators and ____________________ tools has substantially decreased coding and testing time.

Accepted Answer

The answer of The advent of very sophisticated application generators...

Question 14

Database backups can be performed at different levels.List and describe these.

Accepted Answer

A full backup of the database,or dump of the entire database.In this case,all database objects are backed up in their entirety.
A differential backup of the database,in which only the last modifications to the database (when compared with a previous full backup copy)are copied.In this case,only the objects that have been updated since the last full backup are backed up.
A transaction log backup,which backs up only the transaction log operations that are not reflected in a previous backup copy of the database.In this case,only the transaction log is backed up; no other database objects are backed up.

Question 15

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

Question 16

The existing hardware and software systems are studied during the planning phase.

Accepted Answer

A) True 
 B)False

Question 17

The traditional SDLC is divided into ____ phases.

Accepted Answer

A)   two
B)   three
C)   four
D)   fiveE) C) and D)
F) B) and D)

Question 18

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

Accepted Answer

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

Question 19

The ____ design is the process of selecting the data storage and data access characteristics of the database.

Accepted Answer

A)   time
B)   network
C)   logical
D)   physicalE) B) and C)
F) A) and B)

Question 20

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

Exam 9: Database Design

Data integrity is enforced by the DBMS through the proper use of primary and foreign key rules.

Correct Answer
verified

What are the factors affecting the purchasing decision for DBMS software?

Correct Answer
verified
Cost.This includes the original purchase...
View Answer

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

Correct Answer
verified

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

Installing the DBMS,creating the database,and loading or converting the data are part of the ____ phase of the DBLC.

Correct Answer
verified
C

A system maintenance activity generated in response to changes in the business environment is referred to as corrective maintenance.

Correct Answer
verified

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

Correct Answer
verified

In addition to system scope,which defines the extent of the design,the proposed system is subject to ____________________,which are external to the system.

Correct Answer
verified

"What are the requirements of the current system's end users?"is a question asked during the ____ phase of the SDLC.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Detailed system specification is part of the ____ phase of the SDLC.

Correct Answer
verified

The advent of very sophisticated application generators and ____________________ tools has substantially decreased coding and testing time.

Correct Answer
verified

Database backups can be performed at different levels.List and describe these.

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

Correct Answer
verified

The existing hardware and software systems are studied during the planning phase.

Correct Answer
verified

The traditional SDLC is divided into ____ phases.

Correct Answer
verified

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

Correct Answer
verified

The ____ design is the process of selecting the data storage and data access characteristics of the database.

Correct Answer
verified

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 Answer
verified

Exam 9: Database Design

Data integrity is enforced by the DBMS through the proper use of primary and foreign key rules.

Correct AnswerverifiedShow Answer

What are the factors affecting the purchasing decision for DBMS software?

Correct AnswerverifiedCost.This includes the original purchase...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Installing the DBMS,creating the database,and loading or converting the data are part of the ____ phase of the DBLC.

Correct AnswerverifiedC

A system maintenance activity generated in response to changes in the business environment is referred to as corrective maintenance.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

In addition to system scope,which defines the extent of the design,the proposed system is subject to ____________________,which are external to the system.

Correct AnswerverifiedShow Answer

"What are the requirements of the current system's end users?"is a question asked during the ____ phase of the SDLC.

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

Detailed system specification is part of the ____ phase of the SDLC.

Correct AnswerverifiedShow Answer

The advent of very sophisticated application generators and ____________________ tools has substantially decreased coding and testing time.

Correct AnswerverifiedShow Answer

Database backups can be performed at different levels.List and describe these.

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

Correct AnswerverifiedShow Answer

The existing hardware and software systems are studied during the planning phase.

Correct AnswerverifiedShow Answer

The traditional SDLC is divided into ____ phases.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The ____ design is the process of selecting the data storage and data access characteristics of the database.

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

Correct Answer
verified

Correct Answer
verified
Cost.This includes the original purchase...
View Answer

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified