Question 1

In the database development process,the _________________ phase uses entity relationship diagrams (ERDs)and converts them into relational table designs.

Accepted Answer

The answer of In the database development process,the _________________ phase...

Question 2

Physical database design takes place during:

Accepted Answer

A)  Systems implementation 
B)  Systems design 
C)  Systems design and system implementation 
D)  Systems analysis

Question 3

An system is a set of unrelated components that work independently to accomplish some objectives.

Accepted Answer

A) True 
 B)False

Question 4

_____________________ is a database design activity which removes redundancies in table design using constraints or dependencies among columns.

Accepted Answer

The answer of _____________________ is a database design activity which...

Question 5

Due to the high cost costs of developing new systems,a system is seldom changed once it has been implemented.

Accepted Answer

A) True 
 B)False

Question 6

In the database development process,important choices about indexes and data placement occur during the _____________________ phase.

Accepted Answer

The answer of In the database development process,important choices about...

Question 7

One of the common characteristics of data quality is _________________,meaning failures or interferences do not corrupt the database.

Accepted Answer

The answer of One of the common characteristics of data...

Question 8

In the database development process,the _________________ phase involves choices about the location of data and processes so that performance can be optimized.

Accepted Answer

The answer of In the database development process,the _________________ phase...

Question 9

In the database development process,a graphical representation that depicts entities and relationships among entities is a(n)_____________________.

Accepted Answer

The answer of In the database development process,a graphical representation...

Question 10

The characteristic of consistency in data quality is achieved when each part of the database has only one meaning.

Accepted Answer

A) True 
 B)False

Question 11

The following is usually a component(s)of an information system:

Accepted Answer

A)  Databases 
B)  Procedures 
C)  Software 
D)  All of the above

Question 12

When designing a database,which of the following is not a required feature?

Accepted Answer

A)  Support of organizational policies 
B)  Provide high quality data 
C)  Limit data access to very few users 
D)  Allow efficient access to data

Question 13

If an information system consistently reports outdated inventory levels that causes delays in re-stocking orders,this would be an example of a lack of what characteristic of data quality?

Accepted Answer

A)  Completeness 
B)  Ambiguity 
C)  Reliability 
D)  Timeliness

Question 14

Although establishing a common vocabulary among different parts of an organization is not easy,a database can unify an organization by accomplishing this.

Accepted Answer

A) True 
 B)False

Question 15

Choose the most appropriate statement.

Accepted Answer

A)  A database is synonymous with information system 
B)  An information system is part of a database 
C)  Databases are essential components of many information systems. 
D)  A database is usually not a component of an information system

Question 16

The Internal Schema is output from the following phase of Database Development:

Accepted Answer

A)  Physical Database Design 
B)  Conceptual Data Modeling 
C)  Logical Database Design 
D)  Distributed Database Design

Question 17

In database design,a CASE tool analysis function which converts a table design to an ERD is known as _________________.

Accepted Answer

The answer of In database design,a CASE tool analysis function...

Question 18

A design approach in which ERDs are constructed for each group of users and merged into a complete conceptual schema is referred to as _____________________________.

Accepted Answer

The answer of A design approach in which ERDs are...

Question 19

Relational Database Tables are output from the following phase of Database Development:

Accepted Answer

A)  Physical Database Design 
B)  Conceptual Data Modeling 
C)  Logical Database Design 
D)  Distributed Database Design

Question 20

Analysis functions,which are supported by most products,are the most widely used function in CASE tools.

Accepted Answer

A) True 
 B)False

Exam 2: Introduction to Database Development

In the database development process,the _________________ phase uses entity relationship diagrams (ERDs)and converts them into relational table designs.

Physical database design takes place during:

An system is a set of unrelated components that work independently to accomplish some objectives.

_____________________ is a database design activity which removes redundancies in table design using constraints or dependencies among columns.

Due to the high cost costs of developing new systems,a system is seldom changed once it has been implemented.

In the database development process,important choices about indexes and data placement occur during the _____________________ phase.

One of the common characteristics of data quality is _________________,meaning failures or interferences do not corrupt the database.

In the database development process,the _________________ phase involves choices about the location of data and processes so that performance can be optimized.

In the database development process,a graphical representation that depicts entities and relationships among entities is a(n)_____________________.

The characteristic of consistency in data quality is achieved when each part of the database has only one meaning.

The following is usually a component(s) of an information system:

When designing a database,which of the following is not a required feature?

If an information system consistently reports outdated inventory levels that causes delays in re-stocking orders,this would be an example of a lack of what characteristic of data quality?

Although establishing a common vocabulary among different parts of an organization is not easy,a database can unify an organization by accomplishing this.

Choose the most appropriate statement.

The Internal Schema is output from the following phase of Database Development:

In database design,a CASE tool analysis function which converts a table design to an ERD is known as _________________.

A design approach in which ERDs are constructed for each group of users and merged into a complete conceptual schema is referred to as _____________________________.

Relational Database Tables are output from the following phase of Database Development:

Analysis functions,which are supported by most products,are the most widely used function in CASE tools.