Question 1

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

Accepted Answer

DBLC
Database Life C

Question 2

____________________ security allows the assignment of access rights to specific authorized users.

Accepted Answer

The answer of ____________________ security allows the assignment of access...

Question 3

Training principles and methodologies are planned during the implementation phase.

Accepted Answer

A) True 
 B)False

Question 4

The implementation of ____-produced applications tends to prolong the operational life of systems by making them easier to update and maintain.

Accepted Answer

A)  database 
B)  network 
C)  CASE 
D)  design 
A)  database 
B)  network 
C)  CASE 
D)  design

Question 5

What are the classical approaches to database design?

Accepted Answer

There are two classical approaches to da

Question 6

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 7

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 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 result of analysis should be a better understanding of the system's functional areas,actual and potential problems,and opportunities.

Accepted Answer

A) True 
 B)False

Question 10

The implementation of the logical design in IBM's DB2 would require that you assign the rights to use the database to a(n)_________________________.

Accepted Answer

database a

Question 11

The detailed systems design phase includes all the necessary technical specifications for the screens,menus,reports,and other devices used to make the system more efficient.

Accepted Answer

A) True 
 B)False

Question 12

Because every request for structural changes requires retracing the SDLC steps,the system is always at some stage of the SDLC.

Accepted Answer

A) True 
 B)False

Question 13

Performance evaluation is rendered more difficult by the fact that there are standard measurements for database performance.

Accepted Answer

A) True 
 B)False

Question 14

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 15

Analyzing the company situation is part of the ____ phase of the DBLC.

Accepted Answer

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

Question 16

The primary objective of database design is ____.

Accepted Answer

A)  to create the most efficient database possible 
B)  to create complete, normalized, nonredundant, and fully integrated conceptual, logical, and physical database models 
C)  to create the fastest queries 
D)  to be able to add data quickly 
A)  to create the most efficient database possible 
B)  to create complete, normalized, nonredundant, and fully integrated conceptual, logical, and physical database models 
C)  to create the fastest queries 
D)  to be able to add data quickly

Question 17

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 design 
A)  database analysis and requirements 
B)  ER modeling and normalization 
C)  data-model verification 
D)  distributed database design

Question 18

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

Accepted Answer

A)  planning 
B)  analysis 
C)  implementation 
D)  maintenance 
A)  planning 
B)  analysis 
C)  implementation 
D)  maintenance

Question 19

The conceptual design step that defines the DBMS and data model to use is ____.

Accepted Answer

A)  database analysis and requirements 
B)  ER modeling and normalization 
C)  data-model verification 
D)  distributed database design 
A)  database analysis and requirements 
B)  ER modeling and normalization 
C)  data-model verification 
D)  distributed database design

Question 20

"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)  maintenance 
A)  planning 
B)  analysis 
C)  implementation 
D)  maintenance

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

____________________ security allows the assignment of access rights to specific authorized users.

Training principles and methodologies are planned during the implementation phase.

The implementation of ____-produced applications tends to prolong the operational life of systems by making them easier to update and maintain.

What are the classical approaches to database design?

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

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

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

The result of analysis should be a better understanding of the system's functional areas,actual and potential problems,and opportunities.

The implementation of the logical design in IBM's DB2 would require that you assign the rights to use the database to a(n)_________________________.

The detailed systems design phase includes all the necessary technical specifications for the screens,menus,reports,and other devices used to make the system more efficient.

Because every request for structural changes requires retracing the SDLC steps,the system is always at some stage of the SDLC.

Performance evaluation is rendered more difficult by the fact that there are standard measurements for database performance.

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

Analyzing the company situation is part of the ____ phase of the DBLC.

The primary objective of database design is ____.

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

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

The conceptual design step that defines the DBMS and data model to use is ____.

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

Database Systems

Data Models

The Relational Database Model

Entity Relationship (ER)Modeling

Advanced Data Modeling

Normalization of Database Tables

Introduction to Structured Query Language (SQL)

Advanced SQL

Transaction Management and Concurrency Control

Database Performance Tuning and Query Optimization

Distributed Database Management Systems

Business Intelligence and Data Warehouses

Database Connectivity and Web Technologies

Database Administration and Security

Filters

Exam 9: Database Design

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

____________________ security allows the assignment of access rights to specific authorized users.

Training principles and methodologies are planned during the implementation phase.

The implementation of ____-produced applications tends to prolong the operational life of systems by making them easier to update and maintain.

What are the classical approaches to database design?

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

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

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

The result of analysis should be a better understanding of the system's functional areas,actual and potential problems,and opportunities.

The implementation of the logical design in IBM's DB2 would require that you assign the rights to use the database to a(n)_________________________.

The detailed systems design phase includes all the necessary technical specifications for the screens,menus,reports,and other devices used to make the system more efficient.

Because every request for structural changes requires retracing the SDLC steps,the system is always at some stage of the SDLC.

Performance evaluation is rendered more difficult by the fact that there are standard measurements for database performance.

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

Analyzing the company situation is part of the ____ phase of the DBLC.

The primary objective of database design is ____.

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

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

The conceptual design step that defines the DBMS and data model to use is ____.

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

Database Systems

Data Models

The Relational Database Model

Entity Relationship (ER)Modeling

Advanced Data Modeling

Normalization of Database Tables

Introduction to Structured Query Language (SQL)

Advanced SQL

Transaction Management and Concurrency Control

Database Performance Tuning and Query Optimization

Distributed Database Management Systems

Business Intelligence and Data Warehouses

Database Connectivity and Web Technologies

Database Administration and Security

Filters