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