INFS Study Cards

Most OLAP tools offer the following capabilities A) Pivot B) Drill-down C) Slice-and-Dice D) All of the above E) None of the above

D) All of the above -

Which of the following are components of an information system? A) Hardware Resources B) Software Resources C) Data and Information D) All of the above E) None of the above

D) All of the above -

21. If the office worker inserts the record below into the table in Figure A which problem will occur? A) Accuracy B) Completeness C) Uniqueness D) Timeliness E) No data quality problem with this record

D) Timeliness

_________________________ refers to the buying and selling of goods and services over the Internet A) E business B) E commerce C) CRM D) ERP E) None of the above

E-commerce

24. If the office worker inserts the record below into the table in Figure A which problem will occur? A) Accuracy B) Completeness C) Uniqueness D) Timeliness E) No data quality problem with this record

A) Accuracy

25. If the office worker inserts the record below into the table in Figure A which problem will occur? A) Accuracy B) Completeness C) Uniqueness D) Timeliness E) No data quality problem with this record

D) Timeliness

36. What basic OLAP operation when applied to the table in Figure D will result in more data being displayed: A) Drill down only B) Pivot only C) Slice and dice only D) Drill up only E) Both C and D

A) Drill down only

What is the relationship between the loyalty programs and customer power? A) Loyalty Programs reduce the customer power B) Loyalty programs increase the customer power C) Loyalty programs are not related to customer power D) Customer power and loyalty programs are the same thing E) Loyalty programs no longer exist in today's commerce

A) Loyalty Programs reduce the customer power -

If we drill up the result shown in Figure D by combining the Camping and Footwear units sold, which of the following numbers will not appear in the new result A) 11 B) 7 C) 4 D) 3 E) 1

4

Information Systems is A) The raw material in the production of information B) A computer based system that collects, stores, and manipulates data C) Data and information only D) All of the above E) None of the above

B) A computer based system that collects, stores, and manipulates data -

What is the most appropriate and fertile source of data for meaningful organization, the retailer is where in the SCM: A) Upstream B) Downstream C) Middle stream D) Parallel stream E) None of the above

B) Downstream -

Most ERP systems offer: A) SCM component only B) CRM compnent only C) A and B only D) Both A and B and other components E) None of the above

C) A and B only -

Which of these is not a Basic Supply Chain Management Activity? A) Plan B) Source C) Advertise D) Deliver E) Return

C) Advertise

Which one of the listed terms does not fit into the category Information Technology A) Networks B) Hardware Resources C) Business Users D) Software Resources E) All of the above terms terms fit into the category Information Systems

C) Business Users -

E-bay is an example of what business model A) Brick-and-Mortar businesses B) Consumer to business (C2B) C) Consumer to Consumer (C2C) D) ERP E) None of the above

C) Consumer to Consumer (C2C) -

Organization use Porter's Five Force Model to determine what property of an industry A) Level of computer use within the industry B) Past profitability of the industry C) Relative attractiveness of the industry D) All of the above E) None of the above

C) Relative attractiveness of the industry -

What sequence of OLAP operations applied to the table in Figure D will produce the total number of footware sold for female customers in all stores combined (Store 1, 2, and 3): A) Slice and Dice Camping, Drill up Stores, Slice and dice Male B) Drill up Stores , Slice and dice Male, Slice and dice Camping C) Slice and dice Camping, Slice and dice Male, Drill up Stores, D) All of the above E) None of the above

C) Slice and dice camping, Slice and dice Male, Drill up Stores,

22. If the office worker inserts the record below into the table in Figure A which problem will occur? A) Accuracy B) Completeness C) Uniqueness D) Timeliness E) No data quality problem with this record

C) Uniqueness

___________________________ oversees all uses of IT and ensures the strategic alignment of IT with business goals and objectives A) Chief Technology Officer (CTO) B) Chief Security Officer (CSO) C) Chief Privacy Officer (CPO) D) Chief Information Officers (CIO) E) None of the above

Chief Information Officers (CIO) -

The patterns discovered through the data mining should be: A) Accurate B) Meaningful C) Understandable D) Actionable E) All of the above

E) All of the above -

37. What basic OLAP operation when applied to the table in Figure D will result in less data being displayed: A) Drill down only B) Pivot only C) Slice and dice only D) Drill up only E) Both C and D

E) Both C and D

23. If the office worker inserts the record below into the table in Figure A which problem will occur? A) Accuracy B) Completeness C) Uniqueness D) Timeliness E) No data quality problem with this record

E) No data quality problem with this record

14. Which is true for the rule C---> A A) Support 1%, Confidence 50% B) Support 2%, Confidence 50% C) Support 2%, Confidence 100% D) Support 3%, Confidence 50% E) Support 1%, Confidence 100%

E) Support 1%, Confidence 100% -

T/F Operational CRM supports back - office operations and strategic opperations and strategic analysis and includes all systems that do not deal directly with the customers

False

T/F Buyer (customer) power - is low when buyers have many choices of whom to buy from and high when their choices are few

False -

T/F Data warehouse collects and presents operational information in support of daily operational procedures and processes

False -

T/F ERP is always the only way to achieve an integrated enterprise information system

False -

T/F The purpose of BRP is to select the best-run business process within the organization and then make that process even better ( the best it could ever be)

False -

T/F Direct interaction refers to communicating with a database without a DBMS

False -

A retailer that sells exclusively through their web-site is: A) Brick-and-Mortar businesses B) Pure-play (Virtual) business C) Click-and-Mortar business D) C2C E) None of the above

Pure-play (Virtual) business -

Which of the following define BRP? A) Automating the existing business processes B) Streamlining the existing business processes C) Re-designing and changing the business process D) All of the above E) None of the above

Re-designing and changing the business process -

38. All information about Footwear (rows 2,4, and 6) can be removed from the table in Figure D without affecting any other information using which of the following operations? A) Drill down B) Pivot C) Slice and dice D) Drill up E) None of the above

Slice and dice

_______________ can make customers reluctant to switch to another product or service.

Switching cost -

Usability refers to A) The number of customers an organization "touches" for the first time and convinces to purchase products or service B) Number of hours a system is available C) The ease with which people preform transactions and/or find information D) None of the above E) All of the above

The ease with which people preform transactions and/or find information -

The purpose of the Data Warehouse is: A) To provide a collection of function-specific commercial off-the-shelf software (COTS) systems B) To provide the ability to support data analysis without disrupting the day-to-day operations C) To replace systems supporting day-to-day operations D) All of the above E) A & B only

To provide the ability to support data analysis without disrupting the day-to-day operations -

T/F Data describing that customer X bought product Y in store Z can have both an operational an analytical purpose

True

T/F Customer Relationship Management (CRM) involves managing all aspects of a customer's relationship with an organization to increase customer loyalty and retention and an organization's profitability

True -

T/F Key Performance Indicators (KPIs) are quantifiable measurements, agreed to beforehand, that reflects the critical success factors of an organization

True -

T/F Threat of substitute products or services is high when there are many alternatives to a product or service and low when there are few alternatives from which to choose

True -