ISM 3012 Final Exam Review

In a database, __________ are grouped into columns.

Bytes

Which of the following is a basic operation used by reporting applications to produce business intelligence? A) Coalescing B) Transposing C) Dispersing D) Calculating E) Diffusing

Calculating

Information systems improve process quality by ________.

Controlling Process Flow

__________ is the application of statistical techniques to find patterns and relationships among data for classification and prediction.

Data Mining

A particular BI analysis might require data from an ERP system, an e-commerce system, and a social networking application, but such a data collection will likely have relationships that are not represented in primary key/foreign key relationships. This is an example of ________.

Data Not Integrated

Tony requests a credit approval of $25,000. Instead, he gets $15,000 approved as customer credit. Which of the following problems caused by information silos is most likely the reason behind it? A) Limited Information B) Isolated Decisions C) Data Duplication D) Disjointed Process E) Improper Data Normalization

Disjointed Process

The remarkable characteristic of OLAP reports is that they are ________, as they are online and the viewer of the report can change their format.

Dynamic

___________ is a suite of applications called modules, a database, and a set of inherent processes for consolidating business operations into a single, consistent, computing platform.

Enterprise Resource Planning

Which of the following is a developmental task of database administration? A) Monitoring backup procedures B) Conducting training for users C) Evaluating an application design D) Testing backup procedures E) Managing configuration changes in systems

Evaluating an application design

A data mart is larger than a data warehouse.

False

Both structured processes and dynamic processes are formally defined processes.

False

Data mart is another term used for a data warehouse.

False

Dynamic processes are standardized processes that involve day-to-day operations.

False

Katrina is a sales representative for an online retailer. She needs to update her customer list with new contact information for five customers. Which of the following elements will help Katrina modify her data? A) Reports B) Forms C) Queries D) Operations E) Triggers

Forms

Sina looks over annual performance evaluations for all employees in the sales department. Based on their performance, she determines who is eligible for merit-based salary increases. Sina belongs to the ___________ workgroup.

Human Resources

Ajax Inc. is one of the customers of a well-known linen manufacturing company. Ajax has not ordered linen in some time, but when it did order in the past it ordered frequently, and its orders were of the highest monetary value. Under the given circumstances, Ajax is most likely to have an RFM score of ________. A) 151 B) 555 C) 515 D) 511 E) 155

155

A group of similar rows or records is known as __________.

A Table

Which of the following statements correctly describes the relationship between drones and video in Falcon Security's database? A) A drone takes one and only one video; a video is taken by many drones B) A video is taken by many drones; a drone takes many videos C) A video is taken by many drones D) A drone takes many videos; a video is taken by one and only one drone E) A video is taken by one and only one drone; a drone takes one and only one video

A drone takes many videos; a video is taken by one and only one drone

__________ is an example of an inter-enterprise information system.

ARES

Which of the following statements is TRUE about unsupervised data mining? A) Neural networks are a popular unsupervised data mining application. B) Data miners develop a model prior to the analysis and apply statistical techniques to data. C) Hypotheses must be made before running the analysis. D) Analysts do not create a model or hypothesis before running the analysis. E) Unsupervised data mining requires tools such as regression analysis.

Analysts do not create a model or hypothesis before running the analysis.

The term ___________ implies that either all transactions related to a traditional relational DBMS are processed or none of them are processed.

Atomic

Which of the following is an example of a measure in an OLAP report? A) customer type B) purchase date C) sales region D) average cost

Average Cost

________ is defined as information containing patterns, relationships, and trends of various forms of data.

Business Intelligence

__________ is the activity of altering existing and designing new business processes to take advantage of new information systems.

Business Process Reengineering

Which of the following is the smallest element in a database? A) Field B) Record C) Byte D) Zetta E) Metadata

Byte

Which of the following workgroup processes is related to manufacturing? A) Order Entry and Tracking B) Capacity Planning and Scheduling C) Compensation D) Product and Brand Management E) Finished Goods Inventory Management

Capacity Planning and Scheduling

Dollar Bill Supermarket is one of the best in the city. However, shoppers prefer other supermarkets to it as there is always a long queue at the billing counter. The outdated billing registers make the entire process inefficient. Which of the following steps should the supermarket management take to improve the billing process? A) Limit the number of products customers can buy B) Limit the number of customers in the supermarket C) Change the Process Structure D) Change Process Resources

Change Process Resources

Capturing customers' clicking behavior is referred to as ________.

Clickstream Data

In ________, statistical techniques can identify groups of entities that have similar characteristics.

Cluster Analysis

Samuel, a researcher, deduces that single women between the ages of 25 and 30, who usually live in the suburbs and make thrifty purchases, prefer a particular brand of washing machines. In this case, Samuel uses ________ to understand customer behavior.

Cluster Analysis

A(n) _________ system is a suite of applications, a database, and a set of inherent processes for managing all the interactions with the customer, from lead generation to customer service.

Customer Relationship Management

________ is the process of obtaining, cleaning, organizing, relating, and cataloging source data.

Data Acquisition

When an organization has inconsistent duplicated data, it is said to have a(n) __________.

Data Integrity Problem

In large organizations, a group of people manage and run a(n) ________, which is a facility for managing an organization's BI data.

Data Warehouse

Metadata is/are ________.

Data that describes data

A _________ is a collection of forms, reports, queries, and programs that serves as an intermediary between users and database data.

Database Application

A(n) ___________ is a program used to create, process, and administer a database.

Database management system

Sonya is the database administrator for RedTriangle media. She is responsible for validating the data model to be used by the DBMS, and specifying the database requirements to endure all appropriate user input is considered. This is an example of Sonya's ________ tasks.

Development

Problematic operational data is termed as ________.

Dirty Data

__________ are flexible, informal, and adaptive processes that normally involve strategic and less structured managerial decisions and activities.

Dynamic Process

Process __________ is a measure of how well a process achieves organizational strategy.

Effectiveness

SmartToy Corporation's current market strategy is to gain a larger share of the high-end toy market by integrating IBM's AI, named Watson, into its teddy bears. The new line of AI enhanced teddy bears is a hit. SmartToy's market share increases fivefold. This is an example of the company's ___________.

Effectiveness

The two dimensions of process quality are ___________.

Efficiency and Effectiveness

The major benefit of enterprise application integration is that it ___________.

Enables organizations to use existing applications

__________ is a suite of applications called modules, a database, and a set of inherent processes for consolidating business operations into a single, consistent, computing platform.

Enterprise Resource Planning

Dynamic processes support operational activities.

False

Inter-enterprise processes span an organization and support activities in multiple departments.

False

It is better to have data with too coarse a granularity than too fine.

False

The procedures for using workgroup information systems need to be understood only by the IT department of an organization.

False

The structure of a process has no bearing on its efficiency.

False

The columns in a database are also called __________.

Fields

Which of the following data elements is placed higher than records in the database hierarchy? A) Field B) Byte C) Character D) Bit E) File

File

Which of the following workgroup processes is related to operations? A) Treasury and Account Management B) Finished Goods Inventory Management C) Account Updating and Tracking D) Account Tracking E) Sales Forecasting

Finished Goods Inventory Management

_____________ keys are the (primary) keys of a different (foreign) table than the one in which they reside.

Foreign

Achilles Gear has four major retail customers. Based on the following RFM scores of these customers, the sales team at Achilles' should attempt to up-sell more expensive sporting goods to ________. A) Five Star Stores with an RFM score of 214 B) Cable Sports Inc. with an RFM score of 545 C) Pelican Stores with an RFM score of 113 D) WindyRiver Sports with an RFM score of 225 E) Goalkeeper with an RFM score of 551

Goalkeeper with an RFM score of 551

Which of the following is used to process and display browser database application forms, reports, and queries? A) COBOL B) C++ C) HTML D) DB2 E) VisualBasic

HTML

When an area code changes, the phone number for a given customer before the change will not match the customer's number afterward. This is an example of _________.

Inconsistent Data

When an area code changes, the phone number for a given customer before the change will not match the customer's number afterward. This is an example of __________.

Inconsistent Data

Which of the following conditions exists when data are isolated in separated information systems? A) Data Branching B) Encapsulation C) Data Segregation D) Information Silo E) Information Overload

Information Silo

__________ are predesigned procedures for using software products.

Inherent Processes

The primary purpose of an ERP system is ___________.

Integration

Supply chain management is an example of a(n) ___________.

Inter-Enterprise Information System

Which of the following is performed by enterprise application integration? A) It connects system "islands" via a new layer of software B) It prevents a gradual move to ERP C) It prevents existing applications from communicating and sharing data D) It duplicates the data because each application has its own database

It connects system "islands" via a new layer of software

Which of the following accurately defines a dimension in an OLAP report? A) It is a characteristic of a measure. B) It is the data item of interest. C) It is referred to as a decision tree. D) It is the item that is processed in the OLAP report.

It is a characteristic of a measure

Which of the following is TRUE of MySQL? A) It is license-free for most applications. B) It is a paid and proprietary database product. C) It limits databases to 2 TB in size. D) It is a Microsoft product. E) It uses Static Query Language (SQL) to manage a database.

It is license-free for most applications.

Which of the following terms is used as a synonym for data mining? A) Knowledge Discovery in Databases (KDD) B) Data warehousing C) Regression Analysis.

Knowledge Discovery in Databases (KDD)

Which of the following workgroup processes is related to sales and marketing? A) Order Management B) Accounts Receivable C) HR Planning D) Customer Support E) Lead Tracking

Lead Tracking

A database is used instead of a spreadsheet when __________.

Lists involve data with multiple themes

Which phase of the customer life cycle categorizes customers according to value and attempt to win back high-value customers?

Loss/Churn

Charles and Irene are editors at a content development firm. Both of them, unknowingly, are working on the same copy of the annual report. Irene finishes editing the report and saves her copy; Charles saves his report an hour after Irene. Charles's report overwrites Irene's, and her changes are lost. This scenario is an example of the ___________.

Lost-Update Problem

A ____________ is an unsupervised data mining technique for determining sales patterns.

Market-Basket Analysis

Striking Apparels has launched its new stock of summer wear. It plans to target shoppers between the ages of twenty & thirty to sell its products. Daniel is responsible for sending out promotional emails & messages to these target customers. Daniel belongs to the ___________ department of Striking Apparels.

Marketing

A data _________ is a data collection, smaller than the data warehouse that addresses the needs of a particular department or functional area of the business.

Mart

A ________ is the data item of interest in an OLAP report.

Measure

________ refers to the source, format, assumptions and constraints, and other facts about the data.

Metadata

A(n) ______ is a complicated set of possibly nonlinear equations.

Neural Network

OLAP stands for __________

Online Analytical Processing

Jed is a database administrator for a mid-sized computer component manufacturer. Part of his duties include managing security, tracking problems, and monitoring the performance of the database. This is an example of Jed's ________ tasks.

Operation

The finance department of Global Couriers decides that half of the previous year's profit should be reinvested into the business. The marketing department, however, plans to extend the company's services to five more cities, which would require additional investment. The department heads hold a meeting at the end of the quarter to discuss the company's strategies; the meeting is, however, adjourned when they realized that their opinions clash. Information silo, in this case, has led to __________ .

Organized Inefficiency

Matt works at a take-out restaurant. His job is to take orders over the phone and then pass it on to the kitchen staff. As a result of being short-staffed, the restaurant management decided to automate Matt's job and assign him kitchen duties instead. In this case, information systems are ___________.

Performing an Activity

A ___________ is a column or group of columns that identifies a unique row in a table.

Primary Key

Maria creates a relational database to keep track of cars in her repair shop. She stores information about each car in the "vehicle_ID" where she stores the vehicle VIN number. The "vehicle_ID" column is used to connect the relational data and is referred to as a __________.

Primary Key

__________ is a measure of the ratio of process outputs to inputs.

Process Efficiency

The modification or deletion of data in a database is an example of ___________ operations of a database management system.

Processing

__________ is the process of delivering business intelligence to the knowledge workers who need it.

Publish Results

________ requires the user to request business intelligence (BI) results.

Pull Publishing

_________ delivers business intelligence to users without any request from the users.

Push Publishing

__________ analysis is a way of analyzing and ranking customers according to their purchasing patterns.

RFM

The rows in a database are also called ___________.

Records

__________ analysis is used in supervised data mining to measure the effect of a set of variables on another variable.

Regression

Which phase of the customer life cycle focuses on increasing the value of existing customers by selling them more product?

Relationship Management

U.S. Steel Corp. is a well-known steel manufacturing company. SAMCROW, one of the customers of U.S. Steel Corp. holds an RFM score of 111. Which of the following characteristics relates SAMCROW with its RFM score? A) SAMCROW has ordered recently, but orders infrequently, and it orders the most expensive goods. B) SAMCROW has not ordered anything for a while and it did not order frequently, but when it did order, it bought the least expensive items. C) SAMCROW has ordered recently and orders frequently, but it orders the least expensive goods. D) SAMCROW has ordered recently and orders frequently, and it orders the most expensive goods. E) SAMCROW has not ordered anything for a while, but when it did order in the past, it ordered frequently, and its orders were of the highest monetary value.

SAMCROW has not ordered anything for a while and it did not order frequently, but when it did order, it bought the least expensive items.

Which of the following is an international standard language for processing a database? A) SQL B) Cassandra C) MS Access D) Relational LM E) DB2

SQL

An OLAP report has measures and dimensions. Which of the following is an example of a dimension? A) total sales B) average sales C) sales region D) average cost

Sales Region

__________ are formally defined, standardized processes that involve day-to-day operations.

Structured Processes

In __________, data miners develop a model prior to the analysis and apply statistical techniques to data to estimate parameters of the model.

Supervised Data Mining

An Enterprise Resource Planning (ERP) solution does NOT include __________.

The Company's Operational Data

Which of the following is true of single-user databases? A) They are displayed and processed using html5, css3, and JavaScript. B) They use JavaScript for user-side processing. C) The Internet is used to access the DBMS server computer. D) The application, the DBMS, and the database all reside on the user's computer.

The application, the DBMS, and the database all reside on the user's computer

Which of the following is TRUE of in-memory DBMS products? A) They support or extend the relational model B) They do not provide ACID transaction support C) They are a hotbed of development D) MongoDB is an in-memory DBMS product E) They are low-volume, but high integrity DBMS product

They support or extend the relational model

Which of the following is a characteristic of dynamic processes?

They support strategic and less structured managerial decisions

Traditional database application programs are ___________.

Thick applications that need to be installed on users' computers

A(n) __________ is a computer program stored within a database that runs to keep the database consistent when certain conditions arise.

Trigger

A user must have user account credentials to access and process a database.

True

Adding process resources increases process effectiveness but adds costs.

True

An OLAP cube and an OLAP report are the same thing.

True

An advantage of OLAP reports is their ability to let users drill down into the data.

True

Business intelligence (BI) systems have five standard components called hardware, software, data, procedures and people.

True

Dynamic processes are adaptive processes that change structure rapidly and readily.

True

Enterprise processes span an organization and support activities in multiple departments.

True

Granularity is a term that refers to the level of detail represented by the data.

True

NoSQL DBMS refer to nonrelational databases that support very high transaction rates processing relatively simple data structures, replicated on many servers in the cloud.

True

Operational data is structured for fast and reliable transaction processing.

True

Process efficiency is a measure of the ratio of process outputs to inputs.

True

Push publishing can deliver results according to a schedule or as a result of an event or particular data condition.

True

Reports refer to the structured presentation of data using sorting, grouping, filtering, and other operations.

True

The purpose of a database is to keep track of lists of data that involve multiple themes.

True

The three primary activities in the business intelligence (BI) process are to acquire data, perform analysis, and publish results.

True

Workgroups can develop information systems for their own needs, but, over time, this would result in information silos.

True