Question 1

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

Accepted Answer

A)   initial
B)   verification
C)   conceptual
D)   logicalE) C) and D)
F) B) and C)

Question 2

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 3

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

Question 4

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

Question 5

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

Accepted Answer

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

Question 6

User requirements, existing system evaluation, and logical system design are part of the ____ phase of the SDLC.

Accepted Answer

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

Question 7

The database initial study phase of the DBLC involves ____.

Accepted Answer

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

Question 8

The database contents may be loaded interactively or in ____________________ mode.

Accepted Answer

The answer of The database contents may be loaded interactively...

Question 9

The last step in the DBLC is ____.

Accepted Answer

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

Question 10

The company ____________________ describes the general conditions in which a company operates, its organizational structure, and its mission.

Accepted Answer

The answer of The company ____________________ describes the general conditions...

Question 11

Coding, testing, and debugging are part of the ____ phase of the SDLC.

Accepted Answer

A)   planning
B)   analysis
C)   detailed systems design
D)   implementationE) A) and B)
F) B) and D)

Question 12

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

The traditional SDLC phases are ____________________, analysis, detailed systems design, implementation, and maintenance.

Accepted Answer

The answer of The traditional SDLC phases are ____________________, analysis,...

Question 14

Once the data has been loaded into the database, the ____ tests and fine-tunes the database for performance, integrity, concurrent access, and security constraints.

Accepted Answer

A)   programmer
B)   manager
C)   database administrator
D)   systems administratorE) A) and D)
F) None of the above

Question 15

Problems defined during the planning phase are examined in greater detail during the analysis phase.

Accepted Answer

A) True 
 B)False

Question 16

What are the classical approaches to database design?

Accepted Answer

There are two classical approaches to da...

Question 17

The conceptual design step that determines end-user views, outputs, and transaction-processing requirements is ____.

Accepted Answer

A)   data analysis and requirements
B)   entity relationship modeling and normalization
C)   data model verification
D)   distributed database designE) C) and D)
F) B) and D)

Question 18

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 19

When selecting DBMS ____________________, consider processor(s), RAM, disk space, and so on.

Accepted Answer

The answer of When selecting DBMS ____________________, consider processor(s), RAM,...

Question 20

After testing is concluded, the final ____________________ is reviewed and printed and end users are trained.

Accepted Answer

The answer of After testing is concluded, the final ____________________...

Exam 2: Database Development Process

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

Correct AnswerverifiedA full backup, or dump, of the entire da...View AnswerShow 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 conceptual design step that determines end-user views, outputs, and transaction-processing requirements is ____.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The last step in the DBLC is ____.

Correct AnswerverifiedShow Answer

When selecting DBMS ____________________, consider processor(s), RAM, disk space, and so on.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Problems defined during the planning phase are examined in greater detail during the analysis phase.

Correct AnswerverifiedShow Answer

Coding, testing, and debugging are part of the ____ phase of the SDLC.

Correct AnswerverifiedShow Answer

The database contents may be loaded interactively or in ____________________ mode.

Correct AnswerverifiedShow Answer

The database initial study phase of the DBLC involves ____.

Correct AnswerverifiedShow Answer

After testing is concluded, the final ____________________ is reviewed and printed and end users are trained.

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

User requirements, existing system evaluation, and logical system design are part of the ____ phase of the SDLC.

Correct AnswerverifiedShow Answer

Once the data has been loaded into the database, the ____ tests and fine-tunes the database for performance, integrity, concurrent access, and security constraints.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What are the classical approaches to database design?

Correct AnswerverifiedThere are two classical approaches to da...View AnswerShow Answer

The traditional SDLC phases are ____________________, analysis, detailed systems design, implementation, and maintenance.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The company ____________________ describes the general conditions in which a company operates, its organizational structure, and its mission.

Correct AnswerverifiedShow Answer

Correct Answer
verified
A full backup, or dump, of the entire da...
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
There are two classical approaches to da...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified