Deck 11: Data Storage Design

Question 1

The most popular type of database today is the:

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

Answer 1

D

Question 2

Which of the following is an open source DBMS?

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

Answer 2

C

Question 3

Which is NOT a type of database file?

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

Answer 3

E

Question 4

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

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

Question 5

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

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

Question 6

The two basic formats for data storage:

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

Question 7

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

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

Question 8

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

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

Question 9

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

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

Question 10

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

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

Question 11

Legacy databases might include ________ and ______________

A)Master files and transaction files
B)Audit files and look-up files
C)Hierarchical databases and network databases
D)Tree databases and leaf databases
E)Red databases and Green databases

Question 12

Which of the following is not a RDBMS?

A)Oracle
B)NoSQL
C)SQL
D)MySQL
E)None of these

Question 13

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

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

Question 14

In most cases,decision support systems are best at:

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 15

Most relational database systems support:

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

Question 16

Document-oriented databases have the following characteristics,except:

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

Question 17

Omar is creating an order database for a multiple site car dealership.The data will be fairly simple: names,addresses,city,state,zip code,make of car,model,style,color,etc.Probably the best choice for him would be a _____________ database.

A)Multidimensional
B)Hierarchical
C)Legacy
D)Object
E)Relational

Question 18

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

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 19

New databases collectively referred to as NoSQL databases have appeared in recent years.Which of the following are categorized as a NoSQL database?

A)Document-oriented database
B)Wide column stores
C)Graph databases
D)Extensible record stores
E)Relational Database system

Question 20

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

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

Question 21

The CRUD matrix shows

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 22

Which is not a common data type?

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

Question 23

Primary keys are:

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 24

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

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 25

Systems that support decision making will probably:

A)Do a lot of updating of data
B)Be transaction processing systems
C)Be audit files
D)Use Gantt charts
E)Usually just read data - and often in ad hoc ways

Question 26

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

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

Question 27

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

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 28

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 _________

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

Question 29

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

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

Question 30

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

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 31

FoodTitan is a large grocery store chain in the Chicago,Milwaukee,and the Upper Midwest.Generally their stores have from 18 to 36 checkout lanes with scanners.When somebody scans a bar code,the system is probably using a _____ to process the purchased items.

A)Executive support system (ESS)
B)Barcode processing system (BPS)
C)Management information system (MIS)
D)Transaction Processing system (TPS)
E)A grocery store processing system (GSPS)

Question 32

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.

Question 33

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

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

Question 34

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

Question 35

One common method to increase access speed is to:

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 36

A default value is:

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 37

The purpose of creating physical ERDs is to:

A)Show implementation details and to explain more about the 'how' of the final system
B)Normalize the database to third normal form
C)Do a new technology analysis
D)Drive the users nuts
E)Help junior analysts to find the transactions between systems

Question 38

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

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

Question 39

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

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

Question 40

Marco is working for iTunes and needs to have a database that can store complex data.His best choice might be:

A)An object database
B)A relational database
C)A red-green database
D)A tree database
E)A spanning database

Question 41

A DSS is a design support structure and does the 'ETL' (extract,transform and load)to create data warehouses.

Question 42

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

Question 43

When changing from logical data models to physical data models,you will want to change the attributes of the logical ERD to fields in the physical ERD.

Question 44

Microsoft Access is an end-user DBMS.

Question 45

Systems to support decision making generally need to update data frequently with a large volume of data.

Question 46

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.

Question 47

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

Question 48

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.

Question 49

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

Question 50

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

Question 51

Data marts are larger,aggregated legacy databases.

Question 52

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

Question 53

Informix is a pure OODBMS package.

Question 54

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

Question 55

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

Question 56

Decision support systems are not designed to find individual records,but to find aggregated information (such as 'what three products sold the best in Boston in February').

Question 57

When working on a major project,project teams will always select and stay with only one database format for consistency of development and use.

Question 58

Jasmine is an example of an object-oriented database system.

Question 59

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

Question 60

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.

Question 61

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

Question 62

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

Question 63

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

Question 64

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

Question 65

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.

Question 66

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

Question 67

Although TJ did a lot of work normalizing the database so that it is in third normal form (3NF),he may want to 'denormalize' it so that access might be faster.

Question 68

When moving from logical data models to physical data models,you should update your CRUD matrix.

Question 69

What is the difference between files and relational databases?

Question 70

The two primary ways to optimize a relational database are (a)for storage efficiency and (b)for using the smallest amount of space.

Question 71

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

Question 72

When converting a logical ERD into a physical data model,you will want to specify both primary keys and international keys.

Question 73

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

Question 74

Sanjay is creating a screen form that interfaces with a relational database.He should use the median (middle)value in the database as his default value - as that will make it easier for the users to move up and down in the table.