Deck 11: Data Storage Design

Question 1

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

Answer 1

D

Question 2

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

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

Answer 2

E

Question 3

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

Answer 3

B

Question 4

The data storage design activity is done in which phase of the Systems Development Life Cycle?

A)Planning
B)Analysis
C)Design
D)Implementation
E)Evaluation

Question 5

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 6

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 7

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

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 10

Which of the following is an open source DBMS?

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

Question 11

Which is NOT a type of database file?

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

Question 12

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 13

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

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

Question 14

A pure OODBMS product named in the textbook is:

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

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

An activity of the data storage design process is to:

A)Convert logical ERDs into physical ERDs
B)Convert logical use cases into physical use cases
C)Convert program specifications into actual code
D)Convert flat files into Access database tables
E)B and C above

Question 17

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

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

Question 18

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 19

The most popular type of database today is the:

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

Question 20

Which is not an enterprise DBMS?

A)Microsoft Access
B)SQL Server
C)Oracle
D)DB2
E)Jasmine

Question 21

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 22

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 23

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 24

Which is not an element of a CRUD matrix?

A)Combine or join
B)Update or refresh
C)Erase or delete
D)Read or retrieve
E)Make or create

Question 25

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 26

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 27

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

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

Question 28

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 29

Null values

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

Omar is creating an order database for a multiple site car dealership.The data will be fairly simple: names,addresses,city,state,zipcode,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 32

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:

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 33

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 34

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 35

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 36

Which is not a common data type?

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

Question 37

Which is NOT a step in moving from a logical data model to a physical data model?

A)Change entities to tables (or files)
B)Change data flows to create / read / update / delete (CRUD)operations
C)Change Attributes to Fields
D)Add primary keys
E)Add foreign keys

Question 38

Ralph is looking at a table with the following key fields:
Order ID Customer ID
2156 428
2157 873
2158 201
2159 428
2160 043
2161 195
This table:

A)Is table is not fully normalized
B)Is in third normal form
C)Has a primary key of customer id
D)Has a foreign key of order id
E)Cannot be fully evaluated from the data provided

Question 39

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 40

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 41

One of the goals of the data storage design activity in the Design Phase of the SDLC is to revise logical use cases into physical use cases.

Question 42

Data storage components are designed and developed by the programming staff in the Implementation phase of the SDLC.

Question 43

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

Question 44

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

Question 45

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 46

Changing the logical data model into a physical data model is one of the activities of data storage design.

Question 47

Applications are of little use without the data that they support.

Question 48

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

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

Question 49

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 50

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 51

Mike is an analyst doing data storage design activities.He will probably want to make sure that the DFDs and the ERDs balance.

Question 52

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 53

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 54

Volumetrics is:

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 55

Sometimes in data storage design there will need to be trade-offs between storage efficiency and processing speed and efficiency.

Question 56

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

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 57

Data is generally stored in one of two different formats: as files or as databases.

Question 58

Generally,the best way to optimize data storage for efficiency is:

A)Normalization
B)Redundancy
C)Null values
D)Insertion of hard returns after all fields
E)Through minimizing the data to be collected to no more than seven fields per table

Question 59

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

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

Question 60

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 61

DB2 is a enterprise database management system.

Question 62

Data marts are larger,aggregated legacy databases.

Question 63

MySQL is a popular database management system made by Microsoft.

Question 64

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

Question 65

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

Question 66

Data warehousing is the practice of taking data from a company's transaction processing systems,transforming the data and storing the data for use in decision support systems.

Question 67

Microsoft Access is an end-user DBMS.

Question 68

The most popular kind of database for applications development today is the relational database.

Question 69

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 70

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

Question 71

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

Question 72

Informix is a pure OODBMS package.

Question 73

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 74

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

Question 75

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 76

Files are paper files that have been scanned into PDF files for quicker access.

Question 77

DBMS stands for Direct Binary Manipulation System.

Question 78

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

Question 79

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

Question 80

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