Question 1

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 2

The standard method language for accessing the data in relational database tables is: SQL - Standard Query Logic.

Accepted Answer

A) True 
 B)False

Question 3

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 4

Referential integrity is the idea of ensuring that values linking the tables together through the primary and foreign keys are valid and correctly synchronized.

Accepted Answer

A) True 
 B)False

Question 5

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 6

Data marts are larger,aggregated legacy databases.

Accepted Answer

A) True 
 B)False

Question 7

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 8

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 9

The CRUD matrix shows

Accepted Answer

A) The crud that is coming into the system and how to quarantine it 
B) Exactly how data are used and created by the major processes in the system 
C) The 1:M relationships on an ERD diagram 
D) The external entities,process and major data flows from the Context DFD diagram 
E) Where customer,relationships,users and developers will interact with a system 
A) The crud that is coming into the system and how to quarantine it 
B) Exactly how data are used and created by the major processes in the system 
C) The 1:M relationships on an ERD diagram 
D) The external entities,process and major data flows from the Context DFD diagram 
E) Where customer,relationships,users and developers will interact with a system

Question 10

The two basic formats for data storage:

Accepted Answer

A) Spreadsheets and documents 
B) Files and databases 
C) Databases and presentations 
D) Flash and web forms 
E) ERDs and Use cases 
A) Spreadsheets and documents 
B) Files and databases 
C) Databases and presentations 
D) Flash and web forms 
E) ERDs and Use cases

Question 11

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 12

What is the CRUD matrix and why should it be updated in the data storage design activity? Give an example of who can "C","R","U" and "D" for a company and sample systems.

Accepted Answer

CRUD stands for create,read,update and d

Question 13

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 14

Which of the following is an open source DBMS?

Accepted Answer

A) Microsoft Access 
B) SQL Server 
C) MySQL 
D) Excel 
E) CASE 
A) Microsoft Access 
B) SQL Server 
C) MySQL 
D) Excel 
E) CASE

Question 15

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 16

Document-oriented databases have the following characteristics,except:

Accepted Answer

A) Large bit files 
B) Audio files 
C) Video files 
D) Files with uniform structure 
E) image files 
A) Large bit files 
B) Audio files 
C) Video files 
D) Files with uniform structure 
E) image files

Question 17

Many ________ tools like ERwin can help you with database size information and the calculation of volumetrics.

Accepted Answer

A) ERD master 
B) DFD master 
C) Denormalization 
D) Pop-up menu 
E) CASE 
A) ERD master 
B) DFD master 
C) Denormalization 
D) Pop-up menu 
E) CASE

Question 18

CRUD stands for 'create','read','update' and 'delete'.

Accepted Answer

A) True 
 B)False

Question 19

Rachel wants aggregated data like find the number of banking customers who have savings accounts over $100,000 and home mortgages with her bank.She probably wants to use a Decision Support System.

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

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

The standard method language for accessing the data in relational database tables is: SQL - Standard Query Logic.

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

Referential integrity is the idea of ensuring that values linking the tables together through the primary and foreign keys are valid and correctly synchronized.

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

Data marts are larger,aggregated legacy databases.

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.

One common method to increase access speed is to:

The CRUD matrix shows

The two basic formats for data storage:

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

What is the CRUD matrix and why should it be updated in the data storage design activity? Give an example of who can "C","R","U" and "D" for a company and sample systems.

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

Which of the following is an open source DBMS?

A default value is:

Document-oriented databases have the following characteristics,except:

Many ________ tools like ERwin can help you with database size information and the calculation of volumetrics.

CRUD stands for 'create','read','update' and 'delete'.

Rachel wants aggregated data like find the number of banking customers who have savings accounts over $100,000 and home mortgages with her bank.She probably wants to use a Decision Support System.

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

The Systems Analyst and Information Systems Development

Project Selection and Management

Requirements Determination

Use Case Analysis

Process Modeling

Data Modeling

Moving Into Design

Rchitecture Design

User Interface Design

Program Design

Moving Into Implementation

Transition to the New System

The Movement to Objects

Filters

Exam 11: Data Storage Design

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

The standard method language for accessing the data in relational database tables is: SQL - Standard Query Logic.

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

Referential integrity is the idea of ensuring that values linking the tables together through the primary and foreign keys are valid and correctly synchronized.

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

Data marts are larger,aggregated legacy databases.

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.

One common method to increase access speed is to:

The CRUD matrix shows

The two basic formats for data storage:

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

What is the CRUD matrix and why should it be updated in the data storage design activity? Give an example of who can "C","R","U" and "D" for a company and sample systems.

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

Which of the following is an open source DBMS?

A default value is:

Document-oriented databases have the following characteristics,except:

Many ________ tools like ERwin can help you with database size information and the calculation of volumetrics.

CRUD stands for 'create','read','update' and 'delete'.

Rachel wants aggregated data like find the number of banking customers who have savings accounts over $100,000 and home mortgages with her bank.She probably wants to use a Decision Support System.

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

The Systems Analyst and Information Systems Development

Project Selection and Management

Requirements Determination

Use Case Analysis

Process Modeling

Data Modeling

Moving Into Design

Rchitecture Design

User Interface Design

Program Design

Moving Into Implementation

Transition to the New System

The Movement to Objects

Filters