MIS 311 chap 11

Microsoft Access is an end-user DBMS.

TRUE

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

TRUE

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

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

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

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

TRUE

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

TRUE

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

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

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

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

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

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

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

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

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

Data marts are larger, aggregated legacy databases.

FALSE

The concept for planning good performance of databases is known as: a) Volumetrics b) Econometrics c) Moving averages d) Correlation e) PERT

a) Volumetrics

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

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

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

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

TRUE

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

FALSE

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

FALSE

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

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

Informix is a pure OODBMS package.

FALSE

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

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

FALSE

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

FALSE

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

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

FALSE

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

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

FALSE

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

FALSE

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

FALSE

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

FALSE

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

FALSE

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

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

TRUE

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

TRUE

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

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

TRUE

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

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

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)

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

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

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

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

3. Which of the following is an open source DBMS? a) Microsoft Access b) SQL Server c) MySQL d) Excel e) CASE

c) MySQL

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

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

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

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

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)

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

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

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

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

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

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