Question 1

A default value is:

Accepted Answer

A) The first value in a table 
B) The median value in a table 
C) The smallest value in a table 
D) A value that probably occurs most frequently 
E) A mistake made by Dee (aka the name "Dee's fault") 
A) The first value in a table 
B) The median value in a table 
C) The smallest value in a table 
D) A value that probably occurs most frequently 
E) A mistake made by Dee (aka the name "Dee's fault")

Question 2

Informix is a pure OODBMS package.

Accepted Answer

A) True 
 B)False

Question 3

This type of file is used to update a master file:

Accepted Answer

A) Roster Files 
B) Training files 
C) Master files 
D) Transaction files 
E) Integrated files 
A) Roster Files 
B) Training files 
C) Master files 
D) Transaction files 
E) Integrated files

Question 4

One of the goals of the data storage design activity in the Design Phase of the SDLC is to revise logical use cases into physical use cases.

Accepted Answer

A) True 
 B)False

Question 5

An 'international key' is used to relate two tables together (like customer ID from the customer table is an international key in the order table).

Accepted Answer

A) True 
 B)False

Question 6

A great advantage of object oriented database management systems is their easy of learning.

Accepted Answer

A) True 
 B)False

Question 7

Mike is an analyst doing data storage design activities.He will probably want to make sure that the DFDs and the ERDs balance.

Accepted Answer

A) True 
 B)False

Question 8

DBMS stands for Direct Binary Manipulation System.

Accepted Answer

A) True 
 B)False

Question 9

Data marts are larger,aggregated legacy databases.

Accepted Answer

A) True 
 B)False

Question 10

The most efficient tables in a relational database in terms of storage space have no redundant data and very few null values.

Accepted Answer

A) True 
 B)False

Question 11

In chapter 2,we talked about 'technical feasibility' (with the interpretation of 'can we build it').How might that apply to selecting a relational database,a object database,or a multidimensional database?

Accepted Answer

If a company / development group is very

Question 12

Which is NOT a type of database file?

Accepted Answer

A) Hierarchical databases 
B) Relational databases 
C) Object databases 
D) Multidimensional databases 
E) Federal database 
A) Hierarchical databases 
B) Relational databases 
C) Object databases 
D) Multidimensional databases 
E) Federal database

Question 13

The acronym for the standard language used to access data in relational databases is:

Accepted Answer

A) ERD 
B) CRM 
C) ERP 
D) BPR 
E) SQL 
A) ERD 
B) CRM 
C) ERP 
D) BPR 
E) SQL

Question 14

What is the purpose of data storage design?

Accepted Answer

The purpose of data storage design is to

Question 15

This type of file records "before" and "after" images of data as the data gets altered.

Accepted Answer

A) Intelligent files 
B) Audit files 
C) Master files 
D) Raw files 
E) Prime files 
A) Intelligent files 
B) Audit files 
C) Master files 
D) Raw files 
E) Prime files

Question 16

Barb is working on a database design.For the most efficient storage she should remove: ______ and ______.

Accepted Answer

A) Primary keys and foreign keys 
B) International keys and redundancy 
C) Adjectives and adverbs 
D) Redundancy and null values 
E) Special characters and primary keys 
A) Primary keys and foreign keys 
B) International keys and redundancy 
C) Adjectives and adverbs 
D) Redundancy and null values 
E) Special characters and primary keys

Question 17

An activity of the data storage design process is to:

Accepted Answer

A) Convert logical ERDs into physical ERDs 
B) Convert logical use cases into physical use cases 
C) Convert program specifications into actual code 
D) Convert flat files into Access database tables 
E) B and C above 
A) Convert logical ERDs into physical ERDs 
B) Convert logical use cases into physical use cases 
C) Convert program specifications into actual code 
D) Convert flat files into Access database tables 
E) B and C above

Question 18

The most popular type of database today is the:

Accepted Answer

A) Hierarchical database 
B) Tree database 
C) Green database 
D) Relational database 
E) Piecemeal database 
A) Hierarchical database 
B) Tree database 
C) Green database 
D) Relational database 
E) Piecemeal database

Question 19

One activity in the data storage design activity is to update the CRUDE matrix.

Accepted Answer

A) True 
 B)False

Question 20

The most efficient tables (in terms of storage efficiency)in relational database management systems:

Accepted Answer

A) Have duplicate data, especially for when more than one table is joined together for queries 
B) Have no redundant data 
C) Are denormalized 
D) Have entire tables duplicated 
E) Use plasma technologies 
A) Have duplicate data, especially for when more than one table is joined together for queries 
B) Have no redundant data 
C) Are denormalized 
D) Have entire tables duplicated 
E) Use plasma technologies

A default value is:

Informix is a pure OODBMS package.

This type of file is used to update a master file:

One of the goals of the data storage design activity in the Design Phase of the SDLC is to revise logical use cases into physical use cases.

An 'international key' is used to relate two tables together (like customer ID from the customer table is an international key in the order table).

A great advantage of object oriented database management systems is their easy of learning.

Mike is an analyst doing data storage design activities.He will probably want to make sure that the DFDs and the ERDs balance.

DBMS stands for Direct Binary Manipulation System.

Data marts are larger,aggregated legacy databases.

The most efficient tables in a relational database in terms of storage space have no redundant data and very few null values.

In chapter 2,we talked about 'technical feasibility' (with the interpretation of 'can we build it').How might that apply to selecting a relational database,a object database,or a multidimensional database?

Which is NOT a type of database file?

The acronym for the standard language used to access data in relational databases is:

What is the purpose of data storage design?

This type of file records "before" and "after" images of data as the data gets altered.

Barb is working on a database design.For the most efficient storage she should remove: and .

An activity of the data storage design process is to:

The most popular type of database today is the:

One activity in the data storage design activity is to update the CRUDE matrix.

The most efficient tables (in terms of storage efficiency)in relational database management systems:

The Systems Analyst and Information Systems Development

Project Selection and Management

Requirements Determination

Systems Analysis and Design

Process Modeling

Data Modeling

Moving Into Design

Architecture Design

Dennis/wixom/roth

Program Design

Moving Into Implementation

Transition to the New System

the Movement to Objects

Filters

Exam 11: Data Storage Design

A default value is:

Informix is a pure OODBMS package.

This type of file is used to update a master file:

One of the goals of the data storage design activity in the Design Phase of the SDLC is to revise logical use cases into physical use cases.

An 'international key' is used to relate two tables together (like customer ID from the customer table is an international key in the order table).

A great advantage of object oriented database management systems is their easy of learning.

Mike is an analyst doing data storage design activities.He will probably want to make sure that the DFDs and the ERDs balance.

DBMS stands for Direct Binary Manipulation System.

Data marts are larger,aggregated legacy databases.

The most efficient tables in a relational database in terms of storage space have no redundant data and very few null values.

In chapter 2,we talked about 'technical feasibility' (with the interpretation of 'can we build it').How might that apply to selecting a relational database,a object database,or a multidimensional database?

Which is NOT a type of database file?

The acronym for the standard language used to access data in relational databases is:

What is the purpose of data storage design?

This type of file records "before" and "after" images of data as the data gets altered.

Barb is working on a database design.For the most efficient storage she should remove: ______ and ______.

An activity of the data storage design process is to:

The most popular type of database today is the:

One activity in the data storage design activity is to update the CRUDE matrix.

The most efficient tables (in terms of storage efficiency)in relational database management systems:

The Systems Analyst and Information Systems Development

Project Selection and Management

Requirements Determination

Systems Analysis and Design

Process Modeling

Data Modeling

Moving Into Design

Architecture Design

Dennis/wixom/roth

Program Design

Moving Into Implementation

Transition to the New System

the Movement to Objects

Filters

Barb is working on a database design.For the most efficient storage she should remove: and .