Question 1

When you join two relational database tables together,frequently the primary key in one table will be a ____________ in the other table.

Accepted Answer

A) Foreign key 
B) International key 
C) Primary key 
D) Linked list 
E) Entity 
A) Foreign key 
B) International key 
C) Primary key 
D) Linked list 
E) Entity

Question 2

Juan is using a file that is created by an older,legacy system.It is likely that the data is:

Accepted Answer

A) Unusable 
B) In a proprietary format 
C) In a standard format (like comma separated value) 
D) Is sorted by customer's middle name 
E) In a object-oriented structure like Ariel 
A) Unusable 
B) In a proprietary format 
C) In a standard format (like comma separated value) 
D) Is sorted by customer's middle name 
E) In a object-oriented structure like Ariel

Question 3

One common method to increase access speed is to:

Accepted Answer

A) Use legacy databases in a indexed sequential access method 
B) Encrypt all data with 256 byte encryption 
C) Denormalize the tables 
D) Delete all primary keys 
E) Only use alphabetic data 
A) Use legacy databases in a indexed sequential access method 
B) Encrypt all data with 256 byte encryption 
C) Denormalize the tables 
D) Delete all primary keys 
E) Only use alphabetic data

Question 4

The project team is very knowledgeable about relational database management systems.In terms of feasibility,this might be best known as:

Accepted Answer

A) Technical feasibility ('can we build it') 
B) Economic feasibility ('should we build it') 
C) Managerial feasibility ('why would we build it') 
D) Graphical feasibility ('does it fit this project') 
E) Organizational feasibility ('if we build it, will they use it') 
A) Technical feasibility ('can we build it') 
B) Economic feasibility ('should we build it') 
C) Managerial feasibility ('why would we build it') 
D) Graphical feasibility ('does it fit this project') 
E) Organizational feasibility ('if we build it, will they use it')

Question 5

One goal is data storage design is to spread the data over all storage devices so that the redundancy will make for more efficient storage.

Accepted Answer

A) True 
 B)False

Question 6

The concept for planning good performance of databases is known as:

Accepted Answer

A) Volumetrics 
B) Econometrics 
C) Moving averages 
D) Correlation 
E) PERT 
A) Volumetrics 
B) Econometrics 
C) Moving averages 
D) Correlation 
E) PERT

Question 7

Which of the following is not a general function of any application program?

Accepted Answer

A) Data storage 
B) Presentation logic 
C) Data access logic 
D) Linked-list modules 
E) Application logic 
A) Data storage 
B) Presentation logic 
C) Data access logic 
D) Linked-list modules 
E) Application logic

Question 8

Brian wants an e-commerce system to be able to do a lot of rapid processing - like search for particular keywords in documents;return the price of an item;update quantities in the shopping cart.He is probably building an Expert System.

Accepted Answer

A) True 
 B)False

Question 9

The type of processing system that creates reports for supervisors (and other functional users)probably would be a:

Accepted Answer

A) Transaction Processing System (TPS) 
B) Management Information System (MIS) 
C) Executive Support System (ESS) 
D) Decision Support System (DSS) 
E) Rebate Management System (RMS) 
A) Transaction Processing System (TPS) 
B) Management Information System (MIS) 
C) Executive Support System (ESS) 
D) Decision Support System (DSS) 
E) Rebate Management System (RMS)

Question 10

Leon has been reading about new technologies in data storage and he is really excited about object databases.In particular,the new SANS storage with fiber optic connection was recently written up in CIO Magazine as an exciting new development on the database scene.The project team should:

Accepted Answer

A) Go with Leon's idea as it seems to be an exciting development 
B) Go with a cube database system as it might be the bridge between SANS storage/ object databases and relational databases 
C) Ignore Leon as a terrible dreamer who has no concept of reality 
D) Discuss the options as a group, but try to caution Leon about the potential steep learning curve 
E) None of the above 
A) Go with Leon's idea as it seems to be an exciting development 
B) Go with a cube database system as it might be the bridge between SANS storage/ object databases and relational databases 
C) Ignore Leon as a terrible dreamer who has no concept of reality 
D) Discuss the options as a group, but try to caution Leon about the potential steep learning curve 
E) None of the above

Question 11

Relational databases are based on collections of tables each of which has a primary key.

Accepted Answer

A) True 
 B)False

Question 12

Microsoft Access is an end-user DBMS.

Accepted Answer

A) True 
 B)False

Question 13

Most relational database management systems support 'sticky' quantitative processing.

Accepted Answer

A) True 
 B)False

Question 14

Object databases support the concept that all things have both _______ and _____________.

Accepted Answer

A) Length and width 
B) Depth and stature 
C) Primary keys and secondary keys 
D) Positives and negatives 
E) Data and processes 
A) Length and width 
B) Depth and stature 
C) Primary keys and secondary keys 
D) Positives and negatives 
E) Data and processes

Question 15

Primary keys are:

Accepted Answer

A) The same as default keys (or default values) 
B) Unique values for each record in a file or table 
C) Elementary values (like 'primary' school) 
D) Prime numbers in a Fibonacci sequence 
E) The same as foreign keys 
A) The same as default keys (or default values) 
B) Unique values for each record in a file or table 
C) Elementary values (like 'primary' school) 
D) Prime numbers in a Fibonacci sequence 
E) The same as foreign keys

Question 16

One of the activities of the design phase is to design the data storage component of the system.

Accepted Answer

A) True 
 B)False

Question 17

In most cases,decision support systems are best at:

Accepted Answer

A) Finding particular records that are stored in legacy databases 
B) Finding processes that are stored in object databases 
C) Finding aggregated data 
D) Analyzing audit (or log)files for possible intrusion and security breaches 
E) Red and green linked list processing 
A) Finding particular records that are stored in legacy databases 
B) Finding processes that are stored in object databases 
C) Finding aggregated data 
D) Analyzing audit (or log)files for possible intrusion and security breaches 
E) Red and green linked list processing

Question 18

A pure OODBMS product named in the textbook is:

Accepted Answer

A) Belle 
B) Ariel 
C) Jasmine 
D) Emerald 
E) Informix 
A) Belle 
B) Ariel 
C) Jasmine 
D) Emerald 
E) Informix

Question 19

The best design for accessing data faster is generally the most efficient storage as well.

Accepted Answer

A) True 
 B)False

Question 20

Object databases are build on the concept that all things should be treated as objects that have both data and processes.

Accepted Answer

A) True 
 B)False

When you join two relational database tables together,frequently the primary key in one table will be a ____________ in the other table.

Juan is using a file that is created by an older,legacy system.It is likely that the data is:

One common method to increase access speed is to:

The project team is very knowledgeable about relational database management systems.In terms of feasibility,this might be best known as:

One goal is data storage design is to spread the data over all storage devices so that the redundancy will make for more efficient storage.

The concept for planning good performance of databases is known as:

Which of the following is not a general function of any application program?

Brian wants an e-commerce system to be able to do a lot of rapid processing - like search for particular keywords in documents;return the price of an item;update quantities in the shopping cart.He is probably building an Expert System.

The type of processing system that creates reports for supervisors (and other functional users)probably would be a:

Leon has been reading about new technologies in data storage and he is really excited about object databases.In particular,the new SANS storage with fiber optic connection was recently written up in CIO Magazine as an exciting new development on the database scene.The project team should:

Relational databases are based on collections of tables each of which has a primary key.

Microsoft Access is an end-user DBMS.

Most relational database management systems support 'sticky' quantitative processing.

Object databases support the concept that all things have both _ and _______.

Primary keys are:

One of the activities of the design phase is to design the data storage component of the system.

In most cases,decision support systems are best at:

A pure OODBMS product named in the textbook is:

The best design for accessing data faster is generally the most efficient storage as well.

Object databases are build on the concept that all things should be treated as objects that have both data and processes.

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

When you join two relational database tables together,frequently the primary key in one table will be a ____________ in the other table.

Juan is using a file that is created by an older,legacy system.It is likely that the data is:

One common method to increase access speed is to:

The project team is very knowledgeable about relational database management systems.In terms of feasibility,this might be best known as:

One goal is data storage design is to spread the data over all storage devices so that the redundancy will make for more efficient storage.

The concept for planning good performance of databases is known as:

Which of the following is not a general function of any application program?

Brian wants an e-commerce system to be able to do a lot of rapid processing - like search for particular keywords in documents;return the price of an item;update quantities in the shopping cart.He is probably building an Expert System.

The type of processing system that creates reports for supervisors (and other functional users)probably would be a:

Leon has been reading about new technologies in data storage and he is really excited about object databases.In particular,the new SANS storage with fiber optic connection was recently written up in CIO Magazine as an exciting new development on the database scene.The project team should:

Relational databases are based on collections of tables each of which has a primary key.

Microsoft Access is an end-user DBMS.

Most relational database management systems support 'sticky' quantitative processing.

Object databases support the concept that all things have both _______ and _____________.

Primary keys are:

One of the activities of the design phase is to design the data storage component of the system.

In most cases,decision support systems are best at:

A pure OODBMS product named in the textbook is:

The best design for accessing data faster is generally the most efficient storage as well.

Object databases are build on the concept that all things should be treated as objects that have both data and processes.

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

Object databases support the concept that all things have both _ and _______.