MIS Chapter 11
39. One activity in the data storage design activity is to update the CRUDE matrix.
False
40. 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.
False
42. Most relational database management systems support 'sticky' quantitative processing.
False
44. The standard method language for accessing the data in relational database tables is: SQL - Standard Query Logic.
False
45. 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).
False
47. A great advantage of object oriented database management systems is their easy of learning.
False
48. Informix is a pure OODBMS package.
False
50. Data marts are larger, aggregated legacy databases.
False
51. A DSS is a design support structure and does the 'ETL' (extract, transform and load) to create data warehouses.
False
53. When working on a major project, project teams will always select and stay with only one database format for consistency of development and use.
False
54. 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.
False
55. 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.
False
57. Systems to support decision making generally need to update data frequently with a large volume of data.
False
58. One process when considering data storage design is to move from physical data models to logical data models.
False
61. 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.
False
62. When converting a logical ERD into a physical data model, you will want to specify both primary keys and international keys.
False
66. The two primary ways to optimize a relational database are (a) for storage efficiency and (b) for using the smallest amount of space.
False
67. The best design for accessing data faster is generally the most efficient storage as well.
False
41. Microsoft Access is an end-user DBMS.
True
43. Referential integrity is the idea of ensuring that values linking the tables together through the primary and foreign keys are valid and correctly synchronized.
True
46. Jasmine is an example of an object-oriented database system.
True
49. A relational database that is used extensively in data warehousing is a multidimensional database.
True
52. 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').
True
56. 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.
True
59. When changing logical data models to physical data models, you will want to change entities to tables or files.
True
60. 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.
True
63. When moving from logical data models to physical data models, you should update your CRUD matrix.
True
64. CRUD stands for 'create', 'read', 'update' and 'delete'.
True
65. A CRUD matrix shows exactly how data are used and created by major processes in the system.
True
68. 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.
True
69. The most efficient tables in a relational database in terms of storage space have no redundant data and very few null values.
True
21. 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
a) An object database
30. 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
a) Foreign Key
12. 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
a) Referential integrity
26. 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
a) Show implementation details and to explain more about the 'how' of the final system
25. 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')
a) Technical feasibility ('can we build it')
37. The concept for planning good performance of databases is known as: a) Volumetrics b) Econometrics c) Moving averages d) Correlation e) PERT
a) Volumetrics
8. 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
b) Audit files
36. 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
b) Clustering
31. 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
b) Exactly how data are used and created by the major processes in the system
2. 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
b) Files and databases
32. 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
b) Have no redundant data
4. 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
b) In a proprietary format
23. 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)
b) Management Information System (MIS)
16. Which of the following is not a RDBMS? a) Oracle b) NoSQL c) SQL d) MySQL e) None of these
b) NoSQL
29. 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
b) Unique values for each record in a file or table
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
c) Denormalize the tables
19. 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
c) Finding aggregated data
10. 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
c) Hierarchical databases and network databases
6. 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
c) Master files
3. Which of the following is an open source DBMS? a) Microsoft Access b) SQL Server c) MySQL d) Excel e) CASE
c) MySQL
28. 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")
d) A value that probably occurs most frequently
5. 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
d) Algebra files
17. 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
d) All are characteristics
15. 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
d) Files with uniform structure
34. 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
d) Joins
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
d) Linked-list modules
18. 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
d) Object orientation
33. 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
d) Redundancy and null values
11. The most popular type of database today is the: a) Hierarchical database b) Tree database c) Green database d) Relational database e) Piecemeal database
d) Relational database
22. 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)
d) Transaction Processing System (TPS)
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
d) Transaction files
38. 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
e) CASE
9. Which is NOT a type of database file? a) Hierarchical databases b) Relational databases c) Object databases d) Multidimensional databases e) Federal database
e) Federal database
20. 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
e) Relational
14. 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
e) Relational Database System
13. The acronym for the standard language used to access data in relational databases is: a) ERD b) CRM c) ERP d) BPR e) SQL
e) SQL
24. 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
e) Usually just read data - often in ad hoc ways
27. Which is not a common data type? a) Character b) Text c) Integer d) Date e) Video
e) Video
