Question 1

Testing, fine-tuning, and evaluating the database and its applications are part of the ____ phase of the DBLC.

Accepted Answer

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

Question 2

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

Accepted Answer

A) True 
 B)False  True

Question 3

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

database

Question 4

The process of creating an information system is known as ____ development.

Accepted Answer

A)  systems 
B)  database 
C)  network 
D)  transformation 
A)  systems 
B)  database 
C)  network 
D)  transformation

Question 5

The design of the system's processes is completed during the ____ phase of the SDLC.

Accepted Answer

A)  planning 
B)  analysis 
C)  detailed systems design 
D)  implementation 
A)  planning 
B)  analysis 
C)  detailed systems design 
D)  implementation

Question 6

Systems analysis is used to determine the need for an information system and to establish its limits.

Accepted Answer

A) True 
 B)False

Question 7

A detailed system specification is part of the ____ phase of the SDLC.

Accepted Answer

A)  planning 
B)  analysis 
C)  detailed systems design 
D)  implementation 
A)  planning 
B)  analysis 
C)  detailed systems design 
D)  implementation

Question 8

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

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Question 11

The database is loaded during the ____ phase of the SDLC.

Accepted Answer

A)  analysis 
B)  detailed systems design 
C)  implementation 
D)  maintenance 
A)  analysis 
B)  detailed systems design 
C)  implementation 
D)  maintenance

Question 12

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 13

In order to develop an accurate data ____________________, the designer must have a thorough understanding of the company's data types, extent, and uses.

Accepted Answer

The answer of In order to develop an accurate data...

Question 14

In the detailed systems design phase, the designer starts the design of the system's processes.

Accepted Answer

A) True 
 B)False

Question 15

____ allow(s) physical access to areas by authorized personnel only.

Accepted Answer

A)  Physical security 
B)  Password security 
C)  Access rights 
D)  Data encryption 
A)  Physical security 
B)  Password security 
C)  Access rights 
D)  Data encryption

Question 16

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 17

The maintenance and evolution phase of the DBLC involves ____.

Accepted Answer

A)  defining objectives 
B)  introducing changes 
C)  testing the database 
D)  installing the DBMS 
A)  defining objectives 
B)  introducing changes 
C)  testing the database 
D)  installing the DBMS

Question 18

An initial assessment of the information flow-and-extent requirements must be made during the ____________________ portion of the SDLC.

Accepted Answer

The answer of An initial assessment of the information flow-and-extent...

Question 19

Making sure that the final product meets user and system requirements is the most critical ______________________________ phase.

Accepted Answer

DBLC
Database Life C

Question 20

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

Accepted Answer

A) True 
 B)False

Testing, fine-tuning, and evaluating the database and its applications are part of the ____ phase of the DBLC.

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

A(n) ____________________ is a carefully designed and constructed repository of facts that is a part of a larger whole known as an information system.

The process of creating an information system is known as ____ development.

The design of the system's processes is completed during the ____ phase of the SDLC.

Systems analysis is used to determine the need for an information system and to establish its limits.

A detailed system specification is part of the ____ phase of the SDLC.

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

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

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

The database is loaded during the ____ phase of the SDLC.

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

In order to develop an accurate data ____________________, the designer must have a thorough understanding of the company's data types, extent, and uses.

In the detailed systems design phase, the designer starts the design of the system's processes.

____ allow(s) physical access to areas by authorized personnel only.

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

The maintenance and evolution phase of the DBLC involves ____.

An initial assessment of the information flow-and-extent requirements must be made during the ____________________ portion of the SDLC.

Making sure that the final product meets user and system requirements is the most critical ______________________________ phase.

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

The Database Approach

Data Models

Relational Model Characteristics

Beginning Structured Query Language Sql

Procedural Language Sql and Advanced Sql

Data Modeling With Entity Relationship Diagrams

Data Modeling Advanced Concepts

Normalizing Database Designs

Distributed Databases

Interacting With Databases Through the Web

Database Administration and Security

Managing Transactions and Concurrency

Managing Database and Sql Performance

Databases for Decision Support

Filters

Exam 2: Database Development Process

Testing, fine-tuning, and evaluating the database and its applications are part of the ____ phase of the DBLC.

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

A(n) ____________________ is a carefully designed and constructed repository of facts that is a part of a larger whole known as an information system.

The process of creating an information system is known as ____ development.

The design of the system's processes is completed during the ____ phase of the SDLC.

Systems analysis is used to determine the need for an information system and to establish its limits.

A detailed system specification is part of the ____ phase of the SDLC.

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

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

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

The database is loaded during the ____ phase of the SDLC.

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

In order to develop an accurate data ____________________, the designer must have a thorough understanding of the company's data types, extent, and uses.

In the detailed systems design phase, the designer starts the design of the system's processes.

____ allow(s) physical access to areas by authorized personnel only.

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

The maintenance and evolution phase of the DBLC involves ____.

An initial assessment of the information flow-and-extent requirements must be made during the ____________________ portion of the SDLC.

Making sure that the final product meets user and system requirements is the most critical ______________________________ phase.

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

The Database Approach

Data Models

Relational Model Characteristics

Beginning Structured Query Language Sql

Procedural Language Sql and Advanced Sql

Data Modeling With Entity Relationship Diagrams

Data Modeling Advanced Concepts

Normalizing Database Designs

Distributed Databases

Interacting With Databases Through the Web

Database Administration and Security

Managing Transactions and Concurrency

Managing Database and Sql Performance

Databases for Decision Support

Filters