Question 1

A CRUD matrix shows exactly how data are used and created by major processes in the system.

Accepted Answer

A) True 
 B)False

Question 2

What is the difference between MIS,DSS,and EIS?

Accepted Answer

MIS is management information system;DSS

Question 3

A type of relational database that is used extensively in data warehousing is:

Accepted Answer

A) Multidimensional databases 
B) Visio databases 
C) Brick-and-mortar databases 
D) Stacking databases 
E) More than one of the above 
A) Multidimensional databases 
B) Visio databases 
C) Brick-and-mortar databases 
D) Stacking databases 
E) More than one of the above

Question 4

What is the difference between files and relational databases?

Accepted Answer

Files are electronic lists of data (and

Question 5

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 6

One process when considering data storage design is to move from physical data models to logical data models.

Accepted Answer

A) True 
 B)False

Question 7

Null values

Accepted Answer

A) Are valuable in database storage as they provide space for growth 
B) Will be replaced with zeros when the tables are optimized 
C) Threaten data integrity because they are difficult to interpret 
D) Only exist in multidimensional databases 
E) Have been outlawed by California and six other states 
A) Are valuable in database storage as they provide space for growth 
B) Will be replaced with zeros when the tables are optimized 
C) Threaten data integrity because they are difficult to interpret 
D) Only exist in multidimensional databases 
E) Have been outlawed by California and six other states

Question 8

Which of the following is NOT a possible process in denormalization?

Accepted Answer

A) Include a parent entity's attributes in its child entry on the physical data model 
B) Look carefully at relationships to see which entities are frequently accessed together 
C) Rewarding abnormal actions with more processing MIPS 
D) Develop look-up tables that include the description along with the code 
E) Use a star schema design to imitate a multidimensional database 
A) Include a parent entity's attributes in its child entry on the physical data model 
B) Look carefully at relationships to see which entities are frequently accessed together 
C) Rewarding abnormal actions with more processing MIPS 
D) Develop look-up tables that include the description along with the code 
E) Use a star schema design to imitate a multidimensional database

Question 9

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 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

A good time-saver for accessing data might be the use of:

Accepted Answer

A) A red-green tree 
B) PERT 
C) An index 
D) Relational calculus 
E) Inverted menus 
A) A red-green tree 
B) PERT 
C) An index 
D) Relational calculus 
E) Inverted menus

Question 12

This type of file stores 'core information that is important to the business' and for the application (such as customer mailing lists).

Accepted Answer

A) History Files 
B) Audit files 
C) Master files 
D) Transaction files 
E) Intelligent files 
A) History Files 
B) Audit files 
C) Master files 
D) Transaction files 
E) Intelligent files

Question 13

In a registration database,Ross has tables for student,professor,classroom,class,class-hour.Since his campus has about 12,000 students,when he runs queries about what student is in what class,taught by what professor in what classroom at which hour,the DBMS software will have to perform many _________

Accepted Answer

A) Axes 
B) Parallels 
C) Concretes 
D) Joins 
E) Enrolls 
A) Axes 
B) Parallels 
C) Concretes 
D) Joins 
E) Enrolls

Question 14

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 15

Which of the following is NOT a relational database management system product?

Accepted Answer

A) MySQL 
B) Access 
C) Photoshop 
D) Oracle 
E) Informix 
A) MySQL 
B) Access 
C) Photoshop 
D) Oracle 
E) Informix

Question 16

What is SQL? And what is its usage in relational databases?

Accepted Answer

SQL is the acronym for Structured Query

Question 17

Maria is working for the Minneapolis Dance Troop (MDT)and wants a database that can support text,numbers,video,and audio.She will probably select the multidimensional database format.

Accepted Answer

A) True 
 B)False

Question 18

Volumetrics is:

Accepted Answer

A) The use of indexes for each table 
B) The joining of primary keys, secondary keys and foreign keys. 
C) The estimating of the amount of data that the hardware will need to support 
D) Muting the sound aspects of multimedia files on multidimensional databases 
E) When one overuses hairspray 
A) The use of indexes for each table 
B) The joining of primary keys, secondary keys and foreign keys. 
C) The estimating of the amount of data that the hardware will need to support 
D) Muting the sound aspects of multimedia files on multidimensional databases 
E) When one overuses hairspray

Question 19

Which of the following is a concept not generally associated with decision support systems?

Accepted Answer

A) Data warehouses 
B) Data marts 
C) Aggregated data 
D) Object orientation 
E) Multidimensional databases 
A) Data warehouses 
B) Data marts 
C) Aggregated data 
D) Object orientation 
E) Multidimensional databases

Question 20

MIS stands for Management Information Systems.

Accepted Answer

A) True 
 B)False

A CRUD matrix shows exactly how data are used and created by major processes in the system.

What is the difference between MIS,DSS,and EIS?

A type of relational database that is used extensively in data warehousing is:

What is the difference between files and relational databases?

Which of the following is an open source DBMS?

One process when considering data storage design is to move from physical data models to logical data models.

Null values

Which of the following is NOT a possible process in denormalization?

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

The two basic formats for data storage:

A good time-saver for accessing data might be the use of:

This type of file stores 'core information that is important to the business' and for the application (such as customer mailing lists).

The CRUD matrix shows

Which of the following is NOT a relational database management system product?

What is SQL? And what is its usage in relational databases?

Maria is working for the Minneapolis Dance Troop (MDT)and wants a database that can support text,numbers,video,and audio.She will probably select the multidimensional database format.

Volumetrics is:

Which of the following is a concept not generally associated with decision support systems?

MIS stands for Management Information 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 CRUD matrix shows exactly how data are used and created by major processes in the system.

What is the difference between MIS,DSS,and EIS?

A type of relational database that is used extensively in data warehousing is:

What is the difference between files and relational databases?

Which of the following is an open source DBMS?

One process when considering data storage design is to move from physical data models to logical data models.

Null values

Which of the following is NOT a possible process in denormalization?

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

The two basic formats for data storage:

A good time-saver for accessing data might be the use of:

This type of file stores 'core information that is important to the business' and for the application (such as customer mailing lists).

The CRUD matrix shows

Which of the following is NOT a relational database management system product?

What is SQL? And what is its usage in relational databases?

Maria is working for the Minneapolis Dance Troop (MDT)and wants a database that can support text,numbers,video,and audio.She will probably select the multidimensional database format.

Volumetrics is:

Which of the following is a concept not generally associated with decision support systems?

MIS stands for Management Information 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