Question 1

What is the difference between files and relational databases?

Accepted Answer

Files are electronic lists of data (and

Question 2

Most relational database systems support:

Accepted Answer

A) Referential integrity 
B) Pop-up menus 
C) Customizable user-interface colors and graphics 
D) The 'three-clicks' rule 
E) Broadband connectivity 
A) Referential integrity 
B) Pop-up menus 
C) Customizable user-interface colors and graphics 
D) The 'three-clicks' rule 
E) Broadband connectivity

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

Which of the following is not a characteristic of Big Data?

Accepted Answer

A) Huge volume 
B) Rapid velocity 
C) Great variety 
D) All are characteristics 
E) None are characteristics 
A) Huge volume 
B) Rapid velocity 
C) Great variety 
D) All are characteristics 
E) None are characteristics

Question 5

Microsoft Access is an end-user DBMS.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following is NOT a file type described in the textbook?

Accepted Answer

A) History files 
B) Audit files 
C) Look-up files 
D) Algebra files 
E) Transaction files 
A) History files 
B) Audit files 
C) Look-up files 
D) Algebra files 
E) Transaction files

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

What is the difference between end-user databases and enterprise databases (and give at least one end-user database product and at least one enterprise database)?

Accepted Answer

An end-user database can reside on the e

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

When changing logical data models to physical data models,you will want to change entities to tables or files.

Accepted Answer

A) True 
 B)False

Question 11

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 an 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 an object-oriented structure like Ariel

Question 12

Which is not a common data type?

Accepted Answer

A) Character 
B) Text 
C) Integer 
D) Date 
E) Video 
A) Character 
B) Text 
C) Integer 
D) Date 
E) Video

Question 13

A relational database that is used extensively in data warehousing is a multidimensional database.

Accepted Answer

A) True 
 B)False

Question 14

If you were considering a media rich database,what type of database organization might be best and why?

Accepted Answer

Object Databases would be a wi

Question 15

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 16

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 17

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

Accepted Answer

SQL is the acronym for Structured Query

Question 18

The concept of putting records that are somehow related together on the same server (or storage device)is called:

Accepted Answer

A) Carmelization 
B) Clustering 
C) Joining 
D) Normalization 
E) Hybrid technologies 
A) Carmelization 
B) Clustering 
C) Joining 
D) Normalization 
E) Hybrid technologies

Question 19

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 20

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

What is the difference between files and relational databases?

Most relational database systems support:

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

Which of the following is not a characteristic of Big Data?

Microsoft Access is an end-user DBMS.

Which of the following is NOT a file type described in the textbook?

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

What is the difference between end-user databases and enterprise databases (and give at least one end-user database product and at least one enterprise database)?

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

When changing logical data models to physical data models,you will want to change entities to tables or files.

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

Which is not a common data type?

A relational database that is used extensively in data warehousing is a multidimensional database.

If you were considering a media rich database,what type of database organization might be best and why?

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

Which is NOT a type of database file?

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

The concept of putting records that are somehow related together on the same server (or storage device)is called:

Primary keys are:

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

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

What is the difference between files and relational databases?

Most relational database systems support:

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

Which of the following is not a characteristic of Big Data?

Microsoft Access is an end-user DBMS.

Which of the following is NOT a file type described in the textbook?

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

What is the difference between end-user databases and enterprise databases (and give at least one end-user database product and at least one enterprise database)?

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

When changing logical data models to physical data models,you will want to change entities to tables or files.

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

Which is not a common data type?

A relational database that is used extensively in data warehousing is a multidimensional database.

If you were considering a media rich database,what type of database organization might be best and why?

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

Which is NOT a type of database file?

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

The concept of putting records that are somehow related together on the same server (or storage device)is called:

Primary keys are:

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

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