MIS Ch. 1-3, Module C

_____ is a tool you use to enter information and commands. A. An input device B. An output device C. A storage device D. A connecting device

A. An input device An input device is a tool you use to enter information and commands. Input devices include such tools as keyboard, mouse, touch screen, game controller, and bar code reader.

You rent a Blu-ray disc of "A Clockwork Orange" for $25. This is an example of ______. A. Data B. Information System C. Software D. Information System

A. Data Data are raw facts that describe a particular phenomenon such as the current temperature, the price of a movie rental, or your age.

_____ refers to the physical devices that make up a computer. A. Hardware B. Software C. Data D. Information

A. Hardware Hardware is the physical devices that make up a computer.

Which of the following ERP software is most suitable for Exacto, a precision instrument manufacturer with 400 seats? a. Infor ERP Solution b. Microsoft Dynamics AX c. SAP Business One d. Intuit QuickBooks Enterprise

A. Infor ERP Solution Suitable ERP software for medium businesses (with 100-500 seats) are Microsoft Dynamics GP or NAV, SAP Business All-In-One, Infor ERP Solution, Epicor ERP Solution for Mid-Sized Businesses, SYSPRO, and Sage MAS 90 ERP, MAS 200 ERP, or Accpac Extended Enterprise Suite.

Which of the following is an example of application software? A. Microsoft Word B. Microsoft Windows XP C. Microsoft Antivirus D. Microsoft Vista

A. Microsoft Word Application software is the software that enables you to solve specific problems and perform specific tasks. Microsoft Word, for example, can help you write term papers. From an organizational point of view, payroll software, collaborative software, and inventory management software are all examples of application software.

_____ is defined by Porter as offering the same or better quality product or service at a price that is less than what any of the competition is able to do. A.Overall cost leadership B. Price differentiation C. Product differentiation D. Focus

A. Overall Cost Leadership Overall cost leadership is defined by Porter as offering the same or better quality product or service at a price that is less than what any of the competition is able to do.

In the soft drink industry, Coca Cola, Pepsi, and Dr Pepper Snapple Group would be categorized under which of the following forces in Porter's model? A. Rivalry among existing rivals B. Buyer power C. Supplier power D. Competition from new entrants

A. Rivalry among existing rivals The rivalry among existing competitors in the Five Forces Model is high when competition is fierce in a market, and low when competition is more complacent.

Which of the following terms is used to define the set of instructions that a computer executes to carry out a specific task for you? A. Software B. Utilities C. Hardware D. Rules

A. Software Software is the set of instructions that your hardware executes to carry out a specific task for you.

Which of the following information quality attributes pertains to having access to information when one needs it? A. Timeliness B. Form C. Location D. Relevance

A. Timeliness Timeliness covers two aspects: if you have access to information when you need it and if the information describes the time period or periods you're considering.

AskSocrates is a Web site that provides definitions and descriptions of many concepts. AskSocrates is not peer-reviewed (a group of peers or experts do not verify the quality of information). Because of this, AskSocrates may not demonstrate which of the following quality attributes? A. Validity B. Timeliness C. Relevance D. Form

A. Validity Validity addresses the credibility of information. As information is all over the Internet, one needs to check if it came from a credible source.

The _____ is the hardware that interprets and executes the system and application software instructions and coordinates the operation of all the hardware. A. central processing unit (CPU) B. digital versatile disc (DVD) C. connecting unit D. output unit

A. central processing unit (CPU) The central processing unit (CPU) is the hardware that interprets and executes the system and application software instructions and coordinates the operation of all the hardware.

The grade you earn for a specific college course is _____ and your overall GPA is ____. A. data, information B. information, data C. knowledge, business intelligence D. business intelligence, information system

A. data, information Data are raw facts that describe a particular phenomenon such as the current temperature, the price of a movie rental, or your age. Information is data that have a particular meaning within a specific context.

According to Porter, when there are many alternative products or services to the ones your business provides: A. threat of substitute products or services is high. B. supplier power is high. C. buyer power is low. D. threat of substitute products or services is low.

A. threat of substitute products or services is high. The threat of substitute products or services in the Five Forces Model is high when there are many alternatives to a product or service, and low when there are few alternatives from which to choose.

Which of the following is true of an information-literate knowledge worker? A. He knows how and where to obtain information. B. He cannot define the information needed. C. He understands the information before it is received. D. He can transform business intelligence into information.

A.He knows how and where to obtain information. An information-literate knowledge worker can define what information is needed, knows how and where to obtain information, understands the information once it is received (i.e., can transform the information into business intelligence), and can act appropriately based on the information to help the organization achieve the greatest advantage.

Why is technology called "invasive"? A. Technology is an integral part of our personal, as well as our professional lives. B. Technology has destroyed many values of society. C. It has forced certain businesses to shut down for good. D. Technology requires that employees work more than 40 hours per week.

A.Technology is an integral part of our personal, as well as our professional lives. We live in the "digital age," where we live, work, learn, play, drive, network, eat, and shop in a digital world. The influence of technology permeates everything we do. Every part of our life depends on technology. Therefore, technology is so pervasive in our life it is often considered "invasive."

Businesses typically act as both buyers and suppliers. Which of the following is true regarding the goal of a company as a supplier organization in an industry? A. Buyer power and supplier power should be low. B. Buyer power should be low and supplier power should be high. C. Buyer power should be high and supplier power should be low. D. Buyer power and supplier power should be high.

B. Buyer power should be low and supplier power should be high. Supplier power in the Five Forces Model is high when buyers have few choices from whom to buy, and low when their choices are many. Supplier power is the opposite of buyer power: As a supplier organization in an industry, you want buyer power to be low and your supplier power to be high.

_____ is the total of all costs that you incur whether or not you sell anything. A. Variable cost B. Fixed cost C. Marginal cost D. Opportunity cost

B. Fixed Costs Fixed cost is the total of all costs that you incur whether or not you sell anything.

Carrio Arrento, a car rental company, operates in two cities and offers low-rental cars specifically to college students from these areas. This is an example of a(n) _______. A. overall cost leadership strategy B. focus strategy C. loyalty program D. entry barrier

B. Focus Strategy Focus as a strategy is usually defined as focusing on offering products and services (1) to a particular market segment or buyer group, (2) within a segment of a product line, and/or (3) to a specific geographic market.

Which of the following auto manufacturers use an overall cost leadership strategy? A. Mercedes Benz B. Hyundai C. Rolls-Royce D. Aston Martin

B. Hyundai Automobile makers Hyundai and Kia similarly attempt to sell reliable low-cost vehicles to a wide audience, in contrast to Rolls-Royce, Aston Martin, Hummer and Mercedes-Benz which have no overall cost leadership strategy.

The average price of a movie ticket in the city of New York. is $8. This is an example of _______. A. Data B. Information C. Software D. Metadata

B. Information Information is data that have a particular meaning within a specific context. The current temperature becomes information if you're deciding what to wear; in deciding what to wear, the data describing the price of a movie rental are not pertinent information (and therefore only data in that context). The price of a ticket at a theater in a city would be data but the average price of a ticket at theaters in the city (in this case, New York) is information.

_____ refers to any computer-based tool that people use to work with information and support the information and information-processing needs of an organization. A. Information system B. Information technology C. Information superhighway D. Information science

B. Information Technology Information technology (IT) refers to any computer-based tool that people use to work with information and support the information and information-processing needs of an organization.

_____ deals with the planning for, development, management, and use of information technology tools to help people perform all tasks related to information processing and management. A. Management by Objectives B. Management Information System (MIS) C. Transaction Processing System D. Executive Information System

B. Management Information System (MIS) Management information systems (MIS) deals with the planning for, development, management, and use of information technology tools to help people perform all tasks related to information processing and management.

_____ is a temporary holding area for the information you're working with as well as the system and application software instructions that the CPU currently needs. A. ROM B. RAM C. DVD D. VCD

B. RAM RAM, or random access memory, is a temporary holding area for the information you're working with as well as the system and application software instructions that the CPU currently needs.

Data refers to ____. A. Factual information that a person knows B. Raw facts that describe a particular phenomenon C. Knowledge acquired through study, experience, or instruction D. Information that have a particular meaning within a specific context

B. Raw facts that describe a particular phenomenon Data are raw facts that describe a particular phenomenon such as the current temperature, the price of a movie rental, or your age.

Mary wishes to upgrade her current home communications system. She wants to replace her current Internet, TV, and phone to a fiber optics system. As a buyer, Mary needs to consider the ___. A. threat of new entrants B. switching costs C. entry barriers D. first-mover advantages

B. Switching costs Ideally, your organization would like to be a supplier organization in a market in which there are few substitutes for the products and services you offer. Of course, that's seldom possible in any market today, but you can still create a competitive advantage by increasing switching costs. Switching costs are costs that make customers reluctant to switch to another product or service supplier. What you need to realize is that a switching cost does not necessarily have to be an actual monetary cost.

Doodle Corp. wants to increase customer loyalty toward its currently one-of-a-kind software, Bonkers EP. It does so by offering additional services like automatic updates and free upgrades. Which of the following forces in Porter's model is Doodle Corp. addressing in this situation? A. Threat of substitute products or services B. Threat of new entrants C. Buyer power D. Supplier power

B. Threat of New Entrants The threat of new entrants in the Five Forces Model is high when it is easy for new competitors to enter a market, and low when there are significant entry barriers to entering a market.

Which quality attribute of information addresses the credibility of information? A. Weight B. Validity C. Application D. Relevance

B. Validity Validity addresses the credibility of information.

Information refers to ____. A. a message expressing an opinion based on incomplete evidence B. a collection of facts from which conclusions may be drawn C. is data that have a particular meaning within a specific context D. raw facts that describe a particular phenomenon

C. Information is data that have a particular meaning within a specific context.

Which of the following is true of ethics? A. Ethics and laws are the same. B. Laws and ethics clearly require or prohibit and action. C. Ethics are more subjective than laws. D. Laws are more a matter of personal or cultural interpretation, unlike ethics.

C. Ethics are more subjective than laws. Your ethics have consequences for you just as laws do. But ethics are different from laws. Laws either clearly require or prohibit an action. Ethics are more subjective, more a matter of personal or cultural interpretation.

If you were visiting Disney World and you used its touch-screen monitors to locate a restaurant, what type of hardware device would you be using? A. Output Device B. Connecting Device C. Input Device D. Storage Device

C. Input Device Input devices include such tools as keyboard, mouse, touch screen, game controller, and bar code reader.

Which of the following categories of technology allows you to see, hear, or recognize the results of your information-processing requests? A. Connecting device B. Telecommunication device C. Output device D. CPU

C. Output device An output device is a tool you use to see, hear, or otherwise recognize the results of your information-processing requests. Output devices include such tools as printer, monitor, and speakers.

Which of the following is a telecommunication device? A. Satellite B. Port C. Cord D. Bar code scanner

C. Satellite A telecommunications device is a tool you use to send information to and receive it from another person or computer in a network. Modem and satellite are examples of telecommunications devices.

Which of the following includes drivers for your printer and scanner and utility software? A. Payroll software B. Collaborative software C. System software D. Application software

C. System Software System software includes network operating system software, drivers for your printer and scanner, operating system software such as Windows XP and Mac OS, and utility software such as anti-virus software, uninstaller software, and file security software.

Which of the following is a connecting device? A. Modem B. ROM C. USB Port D. Printer

C. USB Port Connecting devices include such things as a USB port into which you would connect a printer, connector cables to connect your printer to the USB port, and internal connecting devices on the motherboard.

_____ allows you to use the Internet for making phone calls instead of leasing traditional telephone lines from the phone company. A. Digital storefronts B. Telecommuting C. VoIP D. Cloud computing

C. VoIP VoIP or Voice over IP allows you to use the Internet for making phone calls instead of leasing traditional telephone lines from the phone company. A popular variation on VoIP is Skype.

A loyalty program is: A. a program that rewards suppliers when delivery of products and services exceeds expectations. B. an analysis of customers and their recurring purchasing habits with your business. C. a reward system for customers based on the amount of business they do with your business. D. a process of moving into a new market for a particular product or service.

C. a reward system for customers based on the amount of business they do with your business. Programs which reward customers based on the amount of business they do with a particular organization, are called loyalty programs.

Information exhibits high quality only if: A. there is an abundance of it. B. it leads to business intelligence. C. it is pertinent, relevant, and useful to you. D. you have access to it 24/7.

C. it is pertinent, relevant, and useful to you. Information exhibits high quality only if it is pertinent, relevant, and useful to you.

A technology-literate worker: A. is a computer-saavy worker B. knows all computer programming languages. C. knows how and when to apply technology. D. is knowledgeable about emerging technology.

C. knows how and when to apply technology. A technology-literate knowledge worker knows how and when to apply technology

Ethics are: A. the set of laws established by the government. B. promises of loyalty or allegiance to a cause or a person. C. the principles and standards that guide our behavior toward other people. D. a list of common religious customs and traditions.

C. the principles and standards that guide our behavior toward other people. Ethics are the principles and standards that guide our behavior toward other people.

_____ is a tool you use to save information for use at a later time. A. An input device B. An output device C. A connecting device D. A storage device

D. A storage device A storage device is a tool you use to store information for use at a later time. Storage devices include such tools as thumb drive, flash memory card, and DVD.

_____ enables you to solve specific problems and perform specific tasks. A. Connecting Device B. Operating System C. System Software D. Application Software

D. Application software Application software is the software that enables you to solve specific problems and perform specific tasks.

The compilation of average SAT scores for students enrolled in your college, along with an analysis of enrollment information and a statistical analysis of these scores compared to competitive schools, is an example of ____. A. Data B. Information C. Knowledge D. Business Intelligence

D. Business Intelligence Business intelligence (BI) is collective information that gives you the ability to make effective, important, and often strategic decisions.

_____ is collective information that gives you the ability to make effective, important, and often strategic decisions. A. Data B. Knowledge C. Information D. Business Intelligence

D. Business Intelligence Business intelligence (BI) is collective information that gives you the ability to make effective, important, and often strategic decisions.

Which of the following is an IT-enabled variable cost reduction initiative? A. Telecommuting B. VoIP C. Cloud computing D. Crowdsourcing

D. Crowdsourcing Virtual goods and crowdsourcing are two of the many IT-enabled methods for reducing variable costs.

Which of the following has the highest threat of substitution? A. A Patek Philippe watch B. A YSL perfume C. Bentley Continental GT D. Lifebuoy soap

D. Lifebuoy soap The threat of substitute products or services in the Five Forces Model is high when there are many alternatives to a product or service, and low when there are few alternatives from which to choose.

What category of hardware technology does a speaker fall into? A. Input device B. Telecommunications device C. Connecting device D. Output device

D. Output Device Output devices include such tools as printer, monitor, and speakers

What is the single most important resource in any organization? A. Money B. Opportunity C. Technology D. People

D. People The single most important resource in any organization is its people. People set goals, carry out tasks, make decisions, serve customers, and, in the case of IT specialists, provide a stable and reliable technology environment so the organization can run smoothly and gain a competitive advantage in the marketplace.

To minimize the threat of substitute products or services, some businesses will create switching costs. What are switching costs? A. The start-up costs incurred when replacing old technology with new B. The costs incurred due to the inability to switch back to your first brand after moving to an alternative brand C. A non-refundable fine levied against the customer for switching to a competitor D. The costs that make customers reluctant to switch to another project or service supplier

D. The costs that make customers reluctant to switch to another project or service supplier Switching costs are costs that make customers reluctant to switch to another product or service supplier. What you need to realize is that a switching cost does not necessarily have to be an actual monetary cost.

If you were to create a unique industry Web site for your customers that allowed them to build virtual communities with other customers by sharing information, how would you be enhancing your competitive strategy? A. Through focus B. Through overall cost leadership C. Through loyalty enhancement D. Through differentiation

D. Through Differentiation Differentiation is defined by Porter as offering a product or service that is perceived as being "unique" in the marketplace.

According to Porter's Five Forces Model, the rivalry among existing competitors is high when: A. competition is more complacent in a market. B. supplier power is high in a market. C. buyer power is low in a market. D. competition is fierce in a market.

D. competition is fierce in a market The rivalry among existing competitors in the Five Forces Model is high when competition is fierce in a market, and low when competition is more complacent. Simply put, competition is more intense in some industries than in others, although the overall trend is toward increased competition in just about every industry.

Companies like Amazon and eBay that only have a presence in the virtual world have significantly lower fixed costs in terms of retail space than companies that have to pay for retail space, like retail stores you would find in a mall. This technological concept is known as: A.VoIP. B. telecommuting. C. cloud computing. D. digital storefronts.

D. digital storefronts Companies like Amazon and eBay that only have a presence in the virtual world have significantly lower fixed costs in terms of retail space than companies that have to pay for retail space, like retail stores you would find in a mall. This is known as a digital storefront.

You visit your local florist to order flowers for a party you were preparing for. The florist, however, did not have the type of flower arrangement you hoped for but the florist was able to immediately find, order, and deliver this arrangement directly to your home from their supplier. What kind of relationship does this represent? a. An information partnership b. A collaborative business c. Dynamic communication d. Customer sharing

a. An information partnership Information partnership refers to two or more companies cooperating by integrating their IT systems, thereby providing customers with the best of what each can offer.

Which systems are typically used to fulfill and support customer orders? a. Back office systems b. Front office systems c. Side office systems d. Decision support systems

a. Back office systems The back office systems are used to fulfill and support customer orders and they also send all their customer information to the database

A(n) _____ helps you specify the logical organization for a database and access and use the information within a database. a. DBMS b. ERP c. CRM d. EIS

a. DBMS A database management system (DBMS) helps you specify the logical organization for a database and access and use the information within a database.

Which of the following functions plans for, oversees the development of, and monitors the information resource of an organization? a. Data administration b. Strategic management c. Data manipulation d. Operational planning

a. Data administration Data administration is the function in an organization that plans for, oversees the development of, and monitors the information resource. This function must be completely in tune with the strategic direction of the organization to assure that all information requirements can be and are being met.

Which part of a relational database contains the logical structure for the information? a. Data dictionary b. Relation c. Query d. SQL

a. Data dictionary In the relational database model, a data dictionary contains the logical structure for the information in a database. When you create a database, you first create its data dictionary.

_____ is a subset of a data warehouse in which only a focused portion of the data warehouse information is kept. a. Data mart b. Data mine c. Data dictionary d. Database

a. Data mart A data mart is a subset of a data warehouse in which only a focused portion of the data warehouse information is kept.

_____ are the most essential and important quantifiable measures used in analytics initiatives to monitor success of a business activity. a. KPIs b. DPIs c. QBEs d. SQLs

a. KPIs The key items of information are called key performance indicators (KPIs), the most essential and important quantifiable measures used in analytics initiatives to monitor success of a business activity.

If you were looking at information in a database and you are able to see only the information you needed in the format you wanted, what type of database view is it? a. Logical view b. High-level view c. Subjective view d. Physical view

a. Logical view The logical view of information, on the other hand, focuses on how you as a knowledge worker need to arrange and access information to meet your particular business needs.

Which of the following supply chain activities keeps the cost of transporting materials as low as possible consistent with safe and reliable delivery? a. Logistics b. Production c. Cost and Price d. Fulfillment

a. Logistics Logistics keeps the cost of transporting materials as low as possible consistent with safe and reliable delivery.

_____ is the process of assuring that a relational database structure can be implemented as a series of two-dimensional relations or tables. a. Normalization b. Standardization c. Planning d. Cross-functional modeling

a. Normalization Normalization is a process of assuring that a relational database structure can be implemented as a series of two-dimensional relations.

Which of the following ERP vendors is particularly used in financials? a. Oracle b. Infor c. Microsoft d. SAP

a. Oracle Each vendor has a specialty in one particular module area such as Oracle/PeopleSoft in financials.

_____ is a delivery model for software in which you pay for software on a pay-per-use basis instead of buying the software outright. a. SaaS b. IaaS c. PaaS d. DSS

a. SaaS Software-as-a-service (SaaS) is a delivery model for software in which you pay for software on a pay-per-use basis instead of buying the software outright.

Which data administration facility allows you to control who has access to what information and what type of access those people have? a. Security management facilities b. Query optimization facilities c. Reorganization facilities d. Concurrency control facilities

a. Security management facilities Security management facilities—allow you to control who has access to what information and what type of access those people have. Always remember CRUD—Create, Read, Update, and Delete. Identifying who can perform those functions on various database information is vitally important.

Social media is fueled by ____. a. Web 2.0 technologies b. CRM technologies c. SCM technologies d. ERP technologies

a. Web 2.0 technologies Social media is fueled by Web 2.0 technologies.

An enterprise resource planning (ERP) system is: a. a collection of integrated software for every functional area within an organization. b. a collaborative document management system that stores and manages documents needed by the entire organization. c. a database management system that maintains information on the information resources for the entire enterprise. d. a strategic planning methodology that promotes enterprise-wide planning rather than decentralized planning.

a. a collection of integrated software for every functional area within an organization. An enterprise resource planning (ERP) system is a collection of integrated software for business management, accounting, finance, human resources management, project management, inventory management, service and maintenance, transportation, e-business, supply chain management, customer relationship management, and e-collaboration.

SQL is: a. a standardized fourth generation language found in most DBMSs. b. a storage tool that holds the data and definitions for a database. c. an administrative tool that allows you to set access rights for database users. d. a programming language that can be used instead of a DBMS.

a. a standardized fourth generation language found in most DBMSs. Structured query language (SQL) is a standardized fourth-generation query language found in most DBMSs. SQL performs the same function as QBE, except that you perform the query by creating a statement instead of pointing, clicking, and dragging.

A _____ is a collection of information that you organize and access according to the logical structure of that information. a. database b. data dictionary c. data mart d. data mine

a. database Any database is a collection of information that you organize and access according to the logical structure of that information.

A(n) _____ key is a primary key of one file that appears in another file. a. foreign b. secondary c. identifying d. duplicate

a. foreign A foreign key is a primary key of one file that appears in another file

The Web 2.0: a. is a technology that focuses on online collaboration, users as both creators and modifiers of content, dynamic and customized information feeds, and many other engaging Web-based services. b. is a computer network consisting of a collection of internet sites that offer text and graphics and sound and animation resources through the hypertext transfer protocol. c. is a reference that points to a whole document or to a specific element within a document. d. is a computer network consisting of a worldwide network of computer networks that use the TCP/IP network protocols to facilitate data transmission and exchange.

a. is a technology that focuses on online collaboration, users as both creators and modifiers of content, dynamic and customized information feeds, and many other engaging Web-based services. Social media is fueled by Web 2.0 technologies. The Web 2.0 is the so-called second generation of the Web and focuses on online collaboration, users as both creators and modifiers of content, dynamic and customized information feeds, and many other engaging Web-based services.

An E-R diagram includes five basic symbols. Which of the following denotes a single relationship between entity classes? a. A crow's foot (shown as <) b. A "|" symbol c. A dotted line d. A circle

b. A "|" symbol The symbol "|" denotes a single relationship in an E-R diagram.

_____ is a form of a microblog and allows you to send and receive text messages of roughly 140 characters or fewer. a. Huddle b. A tweet c. Sparks d. A Circle

b. A tweet

_____ refers to collective information that gives you the ability to make effective, important, and often strategic business decisions. a. Query-by-example b. Business intelligence c. Information analysis d. SQL

b. Business intelligence Business intelligence (BI) refers to collective information about your customers, your competitors, your business partners, your competitive environment, your own internal operations that gives you the ability to make effective, important, and often strategic business decisions.

An E-R diagram includes five basic symbols. Which one denotes an optional relationship between entity classes? a. Dotted line b. Correct Circle c. Triangle d. Straight, vertical symbol ( | )

b. Circle In an E-R diagram, an "O" is used to denote a zero or optional relationship.

Which organizational function is responsible for the more technical and operational aspects of managing information repositories? a. Strategic management b. Database administration c. Information resource planning d. Operational planning

b. Database Administration Database administration is the function in an organization that is responsible for the more technical and operational aspects of managing the information contained in organizational information repositories (databases, data warehouses, and data marts).

_____ are the technology tools that directly support OLTP. a. OLAP and Hypercubes b. Databases and DBMSs c. EIS and DSS d. CRM and ERP

b. Databases and DBMS's Databases and DBMSs are the technology tools that directly support OLTP.

Which of the following systems is the primary interface to customers and sales channels, typically used to support customers or sales? a. Back office systems b. Front office systems c. Decision support systems d. Executive information systems

b. Front office systems The front office systems are the primary interface to customers and sales channels; they send all the customer information they collect to the database.

If you were to purchase a car and the assembly of that car was dictated by your requirements before it was manufactured, you would be utilizing which type of manufacturing process? a. Customer-driven manufacturing b. Just-in-time manufacturing c. Customized construction d. Transaction-based production

b. Just-in-time manufacturing Most large manufacturing companies use just-in-time manufacturing processes, which ensure that the right parts are available as products in process move down the assembly line. Just-in-time (JIT) is a method for producing or delivering a product or service just at the time the customer wants it.

Allmart is a retail store chain with branches in more than 20 states in the US. They are planning to change their ERP software to a more retail management-specific one. Which of the following ERP vendors would best suit Allmart? a. SAP b. Microsoft c. Oracle d. Infor

b. Microsoft Each vendor has a specialty in one particular module area such as SAP in logistics, Oracle/PeopleSoft in financials, Infor in manufacturing, and Microsoft in retail management.

If you were a programmer and needed to view information as it was stored by the database, what type of database view would you see? a. Logical view b. Physical view c. Stored view d. Objective view

b. Physical The physical view of information deals with how information is physically arranged, stored, and accessed on some type of storage device such as a hard disk.

Which of the following is a popular ERP vendor? a. Apple b. SAP c. Symantec d. Samsung

b. SAP The dominating ERP software suppliers are SAP, Oracle/PeopleSoft, Infor, and Microsoft.

_____ is the use of a mobile device and its location to check into locations such as businesses and entertainment venues, find friends and their locations, and receive rewards and take advantage of "specials" based on location. a. MMORPG b. Social locationing c. Mobile locationing d. Social gaming

b. Social Locationing Also called location-based services, social locationing is the use of a mobile device and its location (as determined by GPS) to check into locations such as businesses and entertainment venues, find friends and their locations, and receive rewards and take advantage of "specials" based on location.

In relation to SCM, what is an information partnership? a. Sharing production information with potential customers b. Two or more companies cooperating by integrating their IT systems c. Competitive suppliers providing production schedules to the manufacturer d. Functional areas within your business sharing information

b. Two or more companies cooperating by integrating their IT systems Information partnership refers to two or more companies cooperating by integrating their IT systems, thereby providing customers with the best of what each can offer.

Which data manipulation tool allows you to see the contents of a database file and make whatever changes you want? a. Report Generator b. View c. Query-by-example tools d. SQL

b. View The data manipulation subsystem of a DBMS helps you add, change, and delete information in a database and query it for valuable information.

A supply chain management (SCM) system is an IT system that supports supply chain management activities by: a. helping decision makers compile useful information to identify and solve problems and make decisions. b. automating the tracking of inventory and information among business processes and across companies. c. collecting, storing, modifying, and retrieving the transactions of an organization. d. providing easy access to both internal and external information relevant to meeting the strategic goals of the organization.

b. automating the tracking of inventory and information among business processes and across companies. A supply chain management (SCM) system is an IT system that supports supply chain management activities by automating the tracking of inventory and information among business processes and across companies.

A _____ is a special form of a database that contains information gathered from operational databases for the purpose of supporting decision-making tasks. a. data mine b. data warehouse c. data dictionary d. data entry

b. data warehouse A data warehouse is, in fact, a special form of a database that contains information gathered from operational databases for the purpose of supporting decision-making tasks.

A(n) _____ displays key information gathered from several sources on a computer screen in a format tailored to the needs and wants of an individual knowledge worker. a. hypercube b. digital dashboard c. intelligent agent d. neural network

b. digital dashboard A digital dashboard displays key information gathered from several sources on a computer screen in a format tailored to the needs and wants of an individual knowledge worker.

If you were able to quickly pull information from student records with course records to build students' schedules, you would be using a _____ tool. a. data administration b. query-by-example c. data definition d. data manipulation

b. query-by-example Query-by-example (QBE) tools help you graphically design the answer to a question.

What type of software tool is used to query information stored in a data warehouse? a. OLTP b. Data dictionary c. Data-mining d. Decision support

c. Data mining Data-mining tools are the software tools you use to query information in a data warehouse. These data-mining tools support the concept of OLAP—the manipulation of information to support decision-making tasks.

What term is used to describe the use and distribution of information regardless of title or department? a. Open source information b. Info mining c. Information sharing d. Info distribution

c. Information sharing

Which type of constraint ensures the quality of information in a relational database? a. Environmental constraint b. Business constraint c. Integrity constraint d. Production constraint

c. Integrity constraint By defining the logical structure of information in a relational database, you're also developing integrity constraints—rules that help ensure the quality of the information.

_____ is the professional equivalent of Facebook. a. Google+ b. Orkut c. LinkedIn d. MySpace

c. LinkedIn

Qriosity Inc., a company of less than 100 seats, is in need of suitable ERP software. The company having had a long, fruitful relationship with Microsoft for more than 10 years, wants to buy a Microsoft ERP product? Which of the following is suitable ERP software for Qriosity Inc.? a. Microsoft Dynamics AX b. Microsoft Dynamics GP c. Microsoft Dynamics SL d. Microsoft Dynamics NAV

c. Microsoft Dynamics SL Suitable ERP software for small businesses (with less than 100 seats) are: Microsoft Dynamics SL, SAP Business One, Sage ERP X3, Exact Software EXACT ONLINE Solution, and Intuit QuickBooks Enterprise.

Which of the following ERP software is most suitable for Forca, an aircraft manufacturer with more than 20000 employees? a. SYSPRO b. SAP Business One c. Oracle ERP d. Sage MAS 90 ERP

c. Oracle ERP Microsoft Dynamics AX, Oracle, SAP, and Agresso Business World ERP Solution are some of the most suitable ERP products for large businesses with more than 500 seats.

Which data manipulation tool allows you to graphically design the answer to your business questions? a. Report generators b. Application reports c. Query-by-example tools d. Data administration tools

c. Query-by-example tools Query-by-example (QBE) tools help you graphically design the answer to a question.

Which type of database model organizes and accesses information according to its logical structure rather than its physical structure? a. Hierarchical b. File-based c. Relational d. Conventional

c. Relational Using the relational database model, you organize and access information according to its logical structure, not its physical position.

Which data manipulation tool allows you to quickly define the formats of needed business reports from information stored in a database? a. Query reporting tools b. SQL reports c. Report generators d. Application reports

c. Report Generators Report generators help you quickly define formats of reports and what information you want to see in a report.

MailEx is a logistics company currently in need of an ERP product for managing the firm better. Which of the following ERP vendors would best suit a logistics company like MailEx? a. Infor b. Oracle/PeopleSoft c. SAP d. Microsoft

c. SAP Each vendor has a specialty in one particular module area such as SAP has in logistics.

What is the difference between SCM and CRM? a. CRM records information about products and services; SCM records information about customers. b. CRM stores and processes transactional information; CRM stores and processes business intelligence. c. SCM manages production and delivery information; CRM manages customer information. d. CRM records and processes operational data; SCM records and processes tactical information.

c. SCM manages production and delivery information; CRM manages customer information. A supply chain management (SCM) system is an IT system that supports supply chain management activities by automating the tracking of inventory and information among business processes and across companies. A customer relationship management (CRM) system uses information about customers to gain insights into their needs, wants, and behaviors in order to serve them better.

Which type of application requires that you know the physical location of information before you are able to access it? a. CRM b. ERP c. Spreadsheets d. Word processor

c. Spreadsheets Using a spreadsheet, it would be almost impossible to ensure that each field in a given column is unique. This reinforces the notion that, while spreadsheets work with information according to physical location, databases work with information logically.

Which of the following is a fundamental goal of CRM systems? a. To produce and deliver a product or service at the time the customer wants it. b. To lower the costs of maintaining inventory systems. c. To manage and track customer interactions. d. To continuously improve the quality of products and processes.

c. To manage and track customer interactions. A fundamental goal of a CRM system is the management and tracking of all customer interactions. The communications within the various channels must be organized and carefully recorded for each customer.

Just-in-time (JIT) is: a. a method for continuously improving the quality of products and processes. b. a method of manufacturing where large inventories need to be maintained. c. a method for producing or delivering a product or service precisely when the customer wants it. d. a method that considers the expenditure of resources for any goal other than the creation of value for the end customer to be wasteful.

c. a method for producing or delivering a product or service precisely when the customer wants it. Just-in-time (JIT) is a method for producing or delivering a product or service just at the time the customer wants it.

_____ is the science of fact-based decision making. a. Statistics b. Synthesis c. Analytics d. Deduction

c. analytics Analytics is the science of fact-based decision making. Analytics is a growing field of study, research, and career opportunities that focuses on the integrated use of technology tools and statistical techniques to create real-time, high-quality, fact based business intelligence in support of decision making.

If the file containing your student information appears in two different places with two different birth dates, your data would not be considered ____. a. legitimate b. valid c. clean d. acceptable

c. clean This is an example of "unclean" information. (Your name appears twice in a database, once with your middle initial and once without it. Or your name may appear twice in a database with two different spellings of your last name.)

A(n) _____ is a field or group of fields that uniquely describes each record. a. identifying key b. relational key c. primary key d. main key

c. primary key A primary key is a field (or group of fields in some cases) that uniquely describes each record.

If your phone number was used in a clothing store to uniquely identify you as a customer, the phone number would be considered a(n) ____. a. identifying field b. relational field c. primary key d. principle key

c. primary key A primary key is a field (or group of fields in some cases) that uniquely describes each record.

An intersection relation consists of: a. summary information. b. primary keys for all entity classes in the relational database. c. primary key fields from the intersecting relations. d. definitions for the intersecting relations.

c. primary key fields from the intersecting relations. An intersection relation will have a composite primary key that consists of the primary key fields from the two intersecting relations.

Which term refers to a specific piece of information that is stored in a database file? a. Relation b. Category c. Class d. Attribute

d. Attriubte Within each file, you can see specific pieces of information called attributes.

Which of the following systems uses information about customers to gain insights into their needs, wants, and behaviors in order to serve them better? a. SCM b. TPS c. ERP d. CRM

d. CRM A customer relationship management (CRM) system uses information about customers to gain insights into their needs, wants, and behaviors in order to serve them better.

_____ ensure the validity of database updates when multiple users attempt to access and change the same information. a. Backup and recovery facilities b. Query optimization facilities c. Change management facilities d. Concurrency control facilities

d. Concurrency control facilities Concurrency control facilities—ensure the validity of database updates when multiple users attempt to access and change the same information.

Which of the following is true of data administration and database administration? a. Data administration focuses on the development of the data dictionary whereas database administration focuses on the raw data. b. Data administration focuses on OLTP whereas database administration focuses on OLAP. c. Data administration and database administration are terms that can be used interchangeably. d. Data administration focuses on strategic management whereas database administration focuses on operational issues.

d. Data administration focuses on strategic management whereas database administration focuses on operational issues. Data administration is the function in an organization that plans for, oversees the development of, and monitors the information resource. This function must be completely in tune with the strategic direction of the organization to assure that all information requirements can be and are being met. Database administration is the function in an organization that is responsible for the more technical and operational aspects of managing the information contained in organizational information repositories (databases, data warehouses, and data marts).

Which of the following supply chain activities ensures that the right quantity of parts arrive at the right time for production or sale? a. Logistics b. Production c. Cost and Price d. Fulfillment

d. Fulfillment Fulfillment ensures that the right quantity of parts for production or products for sale, arrive at the right time.

Which of the following is true of push and pull technologies? a. The early Web was characterized by pushing static information. b. In push technologies, organizations provide users with standardized information. c. In pull technologies, organizations provide users with customized information based on each user's individual profile. d. In pull technologies, users research, find, request, and retrieve the information they want.

d. In pull technologies, users research, find, request, and retrieve the information they want. Pull technology users research, find, request, and retrieve the information they want. In push technology, organizations provide users with customized, personalized, and timely information based on each user's individual profile.

Forca, an aircraft manufacturing firm, needs an ERP product which specializes particularly in module area of manufacturing. Which of the following ERP vendors would best suit Forca? a. Microsoft b. Oracle/PeopleSoft c. SAP d. Infor

d. Infor Each vendor has a specialty in one particular module area such as Infor in manufacturing.

Which of the following is true about an entity class? a. It is a field or class of fields that uniquely identifies information about an entity. b. It is an occurrence of an entity class. c. It represents a group or class of information that sits separately from other information in the database. d. It typically consists of people, places, or things that you wish to store information about in the database.

d. It typically consists of people, places, or things that you wish to store information about in the database. An entity class is a concept—typically people, places, or things—about which you wish to store information and that you can identify with a unique key (called a primary key).

_____ is the gathering of input information, processing that information, and updating existing information to reflect the gathered and processed information. a. Online analytical processing (OLAP) b. Business intelligence (BI) c. File management systems (FMS) d. Online transaction processing (OLTP)

d. Online tranaction processing (OLTP) Online transaction processing (OLTP) is the gathering of input information, processing that information, and updating existing information to reflect the gathered and processed information.

What is the most popular model for creating databases? a. Hierarchical database model b. Object-oriented database model c. Ecological database model d. Relational database model

d. Relational database model The relational database model is the most popular model for creating databases.

Which of the following supply chain activities ensures no sales are lost because shelves are empty? a. Logistics b. Production c. Cost and Price d. Revenue and profit

d. Revenue and profit Revenue and profit ensures no sales are lost because shelves are empty.

_____ is a collection of Web-based and mobile technologies that create true interactivity among users, most usually allowing users to be both creators and consumers of content. a. World Wide Web b. ERP c. CRM d. Social media

d. Social media Social media is a collection of Web-based and mobile technologies that create true interactivity among users, most usually allowing users to be both creators and consumers of content.

What must you define before adding any information to a relational database? a. The intended audience b. The physical hardware structure c. The administrative rights of users d. The logical structure of the database

d. The logical structure of the database When you create a workbook, you can immediately begin typing in information and creating formulas and functions. You can't do that with a database. You must define its logical structure before you can begin typing in any information.