MIS Exam 3

_____________ is the duplication of information, or storing the same information in multiple places.

Information Redundancy

What is information redundancy? a) All of these. b) Storing the same information in multiple places. c) Storing duplicate information in multiple places. d) Duplication of information.

a) All of these.

What is an integration? a) Allows separate systems to communicate directly with each other. b) Takes information entered into a given system and sends it to the DBMS. c) Takes information entered into a given system and sends it to the database. d) Takes information entered into a given system and sends it to other processes.

a) Allows separate systems to communicate directly with each other.

What is an interactive website kept constantly updated and relevant to the needs of its customers through the use of a database? a) Data-driven database b) Customer-driven database c) Customer-driven website d) Data-driven website

a) Data-driven database

What type of website is best to build for a continually changing information, including press releases, new product information, and updated pricing? a) Data-driven website b) Relational website c) All of these d) Static website

a) Data-driven website

In the relational database model, what is a person, place, thing, transaction, or event about which information is stored? a) Entity b) Physical view c) Attribute d) Logical view

a) Entity

A foreign key is a field (or group of fields) that uniquely identifies a given record in a table. a) False b) True

a) False

Ideally, an organization wants to build only forward integrations. a) False b) True

a) False

One of the advantages found in a relational database is increased information redundancy. a) False b) True

a) False

Purchasing stocks is an example of analytical information. a) False b) True

a) False

Timely information must be up-to-the-second to be accurate. a) False b) True

a) False

Which of the following is true in regard to eliminating redundant information? a) Improves information quality. b) All of these. c) Uses additional hard disk space. d) Makes performing information updates harder.

a) Improves information quality.

All of the following are advantages of database-stored information except: a) Increased information redundancy b) Increased information integrity c) Increased flexibility d) Increased performance

a) Increased information redundancy

Which of the following is incorrect in reference to a database? a) Information is accessed by physical structure. b) Users can access different views of information. c) Can be relational or network. d) Information is accessed by logical structure.

a) Information is accessed by physical structure.

What are the different types of information? a) Levels, formats, granularities b) Levels, forms, data c) Levels, forms, granularities d) Data, formats, granularities

a) Levels, formats, granularities

Which of the following measures how quickly a system performs a certain process or transaction? a) Performance b) Information integrity c) Redundancy d) Scalability

a) Performance

Which of the following is an example of transactional information? a) Purchasing stocks b) Sales projections c) All of these d) Trends

a) Purchasing stocks

All of the following are characteristics of information except: a) Quantity b) Analytical c) Timeliness d) Transactional

a) Quantity

What is a backward integration? a) Takes information entered into a given system and sends it automatically to all upstream systems and processes. b) Takes information entered into a given system and sends it automatically to all downstream systems and processes. c) Takes information entered into a given system and sends it to the application-generation component. d) Takes information entered into a given system and sends it to the DBMS.

a) Takes information entered into a given system and sends it automatically to all upstream systems and processes.

Which of the following is correct in reference to a database? a) A database can support only one logical view. b) A database can support many logical views. c) A database can support up to three logical views. d) A database can support many physical views.

b) A database can support many logical views.

What encompasses all organizational information and its primary purpose is to support the performance of managerial analysis tasks? a) Transactional information b) Analytical information c) Quality d) Timeliness

b) Analytical information

Which of the following implies that aggregate or summary information is in agreement with detailed information? a) Accuracy b) Consistency c) Completeness d) Uniqueness

b) Consistency

Which of the following represents the different information levels? a) Document, presentation, spreadsheet, database b) Individual, department, enterprise c) None of these d) Detail, summary, aggregate

b) Individual, department, enterprise

What provides real-time information in response to requests? a) Information level b) Real-time systems c) Real-time information d) All of these

b) Real-time systems

All of the following are business-critical integrity constraints except: a) The system will not allow shipping a product to a customer who does not have a valid address. b) The system will not allow returns of fresh produce after 15 days past delivery. c) The system will not allow shipping a nonexistent product to a customer. d) The system will not allow an entry for an order for a nonexistent customer.

b) The system will not allow returns of fresh produce after 15 days past delivery.

Organizational information comes at different levels and in different formats and granularities. a) False b) True

b) True

Relational integrity constraints are rules that enforce basic and fundamental information-based constraints. a) False b) True

b) True

Reports for each salesperson, product, and part are examples of detailed, or fine, information granularities. a) False b) True

b) True

Transactional information is used when performing operational tasks and repetitive decisions, such as analyzing daily sales reports and production schedules to determine how much inventory to carry. a) False b) True

b) True

Which of the following is an example of transactional information? a) Purchasing stock b) Withdrawing cash from an ATM c) All of these d) Making an airline reservation

c) All of these

Which of the following is a valid type of integrity constraint? a) Business integrity constraint b) Relational-critical integrity constraint c) Business-critical integrity constraint d) Critical constraint

c) Business-critical integrity constraint

Which of the following represents the different information granularities? a) Document, presentation, spreadsheet, database b) None of these c) Detail, summary, aggregate d) Individual, department, enterprise

c) Detail, summary, aggregate

What are the rules that help ensure the quality of information? a) Relational integrity constraints b) Business-critical integrity constraints c) Integrity constraints d) Information integrity

c) Integrity constraints

What refers to how well a system can adapt to increased demands? a) Performance b) Information integrity c) Scalability d) Redundancy

c) Scalability

What type of website is best to build for a general informational website with static information? a) Data-driven website b) Relational website c) Static website d) All of these

c) Static website

What is a forward integration? a) Takes information entered into a given system and sends it to the application-generation component. b) Takes information entered into a given system and sends it to the DBMS. c) Takes information entered into a given system and sends it automatically to all downstream systems and processes. d) Takes information entered into a given system and sends it automatically to all upstream systems and processes.

c) Takes information entered into a given system and sends it automatically to all downstream systems and processes.

What is a foreign key? a) Characteristics or properties of an entity. b) A field (or group of fields) that uniquely identifies a given entity in a table. c) A field (or group of fields) that uniquely identifies a given attribute in a table. d) A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.

d) A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.

Which of the following types of information can be found in a database? a) Transactions b) Employees c) Inventory d) All of these

d) All of these

What is the physical view of information? a) Deals with the logical storage of information on a storage device such as a hard disk. b) Focuses on how users physically access information to meet their particular business needs. c) Focuses on how users logically access information to meet their particular business needs. d) Deals with the physical storage of information on a storage device such as a hard disk.

d) Deals with the physical storage of information on a storage device such as a hard disk.

What is one of the biggest pitfalls associated with real-time information? a) It rarely changes. b) It is only available to high-level executives. c) It is only available in aggregate levels of granularity. d) It continually changes.

d) It continually changes.

What is a real-time system? a) Encompasses all of the information contained within a single business process or unit of work, and its primary purpose is to support the performance of daily operational tasks. b) Encompasses all organization information, and its primary purpose is to support the performance of managerial analysis tasks. c) Provides immediate, up-to-date real-time information. d) Provides real-time information in response to requests.

d) Provides real-time information in response to requests.

Which of the following is not one of the five characteristics common to high-quality information? a) Consistency b) Completeness c) Accuracy d) Quantity

d) Quantity

Why do relational databases use primary keys and foreign keys? a) To create physical relationships. b) All of these. c) To create a database. d) To create logical relationships.

d) To create logical relationships.

What encompasses all of the information contained within a single business process or unit of work and its primary purpose is to support the performance of daily operational tasks? a) Quality b) Timeliness c) Analytical information d) Transactional information

d) Transactional information