mis final for 5/18/16

  1. The rows in a database are called ________.
    • A) records
    • B) tables
    • C) files
    • D) fields
  2. Albert creates a relational database to store employee performance statistics. He stores each employee's data in independent rows and creates a column named "Employee Number" to assign unique numbers to each employee. This column is referred to as a(n) ________.
    • A) primary key
    • B) identifier
    • C) foreign key
    • D) functionally dependent record
  3. Relational databases represent relationships using ________.
    • A) foreign keys
    • B) file systems
    • C) metadata
    • D) unique identifiers
  4. A(n) ________ is a program used to create, process, and administer a database.
    • A) operating system
    • B) DBMS
    • C) information system
    • D) data mart
  5. Which of the following is an international standard language for processing a database?
    • A) Cassandra
    • B) DB2
    • C) SQL
    • D) MS Access
  6. A ________ is a collection of forms, reports, queries, and programs that serves as an intermediary between users and database data.
    • A) database application
    • B) database design
    • C) data field
    • D) data model
  7. Brenda, the sales manager of a firm, wants to generate a particular report containing sales analyses of the second and third quarter of the year. She should use a ________ to obtain the information that she wants from the database.
    • A) report
    • B) data model
    • C) database administrative function
    • D) query
  8. A ________ describes the data and relationships that will be stored in a database.
    • A) data aggregator
    • B) query model
    • C) data model
    • D) data application
  9. A student management system allows students to have multiple advisors, and advisers are assigned to handle multiple students and courses. This is an example of a(n) ________ relationship.
    • A) 1:N
    • B) 1:1
    • C) N:M
    • D) M:1
  10. In an E-R diagram, a(n) ________ on a line means that at least one entity of that type is required.
    • A) small oval
    • B) vertical bar
    • C) arrow
    • D) triangular block
  11. Every table in a normalized database has a ________.
    • A) one-to-one relationship between entities
    • B) single theme
    • C) foreign key
    • D) specialized query format
  12. Which of the following is true about the database development process?
    • A) The easiest time to change the database structure is during the data modeling stage.
    • B) Changing a relationship from 1:N to N:M in an existing database is simply a matter of changing notations.
    • C) User review of the data model is avoided as it is not helpful in data modeling.
    • D) A database is a model of how the developers view their business world
  13. ________ are the final judges as to what data the database should contain and how the records in that database should be related to one another.
    • A) Administrators
    • B) Developers
    • C) Users
    • D) Designers
  14. Which of the following characteristics is a disadvantage of in-house hosting?
    • A) dependency on vendor
    • B) loss of control over data location
    • C) cost uncertainties
    • D) lack of visibility into security details
  15. Which of the following factors makes cloud-based hosting advantageous today?
    • A) expensive processors
    • B) expensive data storage
    • C) advent of virtualization
    • D) advent of private IP addressing
  16. A private internet that is used exclusively within an organization is called a(n) ________.
    • A) Ethernet
    • B) intranet
    • C) cloud
    • D) server
  17. To enable a seamless flow of data across the networks that comprise an internet, an elaborate scheme called a ________ is used.
    • A) layered protocol
    • B) virtual private network
    • C) three-tier system
    • D) remote access system
  18. Which of the following is true of digital subscriber line signals?
    • A) Digital subscriber line signals do not interfere with telephone signals.
    • B) Digital subscriber line signals use the same protocols as cable modems do for data transmission.
    • C) Digital subscriber line signals replace phone signals and are sent to the ISP.
    • D) Digital subscriber line signal data transmission and telephone conversations cannot occur simultaneously.
  19. Which of the following refers to the three tiers in the three-tier architecture?
    • A) TCP, IP, and HTTP
    • B) HTML, XML, and JSON
    • C) user, server, and database
    • D) tunnel, switch, and access point
  20. A computer ________ is a collection of computers that communicate with one another over transmission lines or wirelessly.
    • A) database
    • B) application
    • C) network
    • D) server
  21. The protocols used on the Internet are arranged according to a structure known as the ________ protocol architecture
    • A) FTP
    • B) SMTP
    • C) HTTP
    • D) TCP/IP
  22. Which of the following is a function of an ISP?
    • A) It transmits data over short distances, replacing cables.
    • B) It serves as a gateway to the Internet.
    • C) It describes how messages must be processed for wired transmission.
    • D) It connects computers within a LAN.
  23. Which of the following is the most basic cloud offering?
    • A) SaaS
    • B) PaaS
    • C) IaaS
    • D) VPN
  24. A ________ is a cloud that is owned and operated by an organization for its own benefit.
    • A) private cloud
    • B) virtual private network
    • C) wide area network
    • D) Service as a cloud
  25. ________ are programs that run on a server-tier computer and manage traffic by sending and receiving Web pages to and from clients.
    • A) Web servers
    • B) Web browsers
    • C) Server farms
    • D) Server racks
  26. A(n) ________ is a number that identifies a particular device.
    • A) domain
    • B) IP address
    • C) hyperlink
    • D) href
  27. Information systems improve process quality by ________.
    • A) duplicating data
    • B) controlling process flow
    • C) changing the work culture
    • D) entirely replacing human activity
  28. Which of the following workgroup processes is related to operations business processes?
    • A) account updating and tracking
    • B) sales forecasting
    • C) finished goods inventory management
    • D) treasury and account management
  29. ________ processes span an organization and support activities in multiple departments.
    • A) Enterprise
    • B) Inter-enterprise
    • C) Strategic
    • D) Reactive
  30. The two dimensions of process quality are ________.
    • A) efficiency and effectiveness
    • B) performance and reliability
    • C) conformance and durability
    • D) perception and serviceability
  31. Joseph wishes to increase the operational efficiency of his new startup. What should Joseph do?
    • A) Joseph should use integrated data stored in his firm's central database to analyze its day-to-day activities.
    • B) Joseph should avoid analyzing his firm's distribution systems as they do not play a role in its daily activities.
    • C) If Joseph plans to support formally defined and documented activities in his firm, he should use a dynamic planning system over a structured planning system.
    • D) If Joseph plans to include less specific and fluid activities in his firm, he should use a structured planning system over a dynamic planning system.
  32. ________ is a measure of the ratio of process outputs to inputs.
    • A) Process effectiveness
    • B) Process efficiency
    • C) Process conformance
    • D) Process reliability
  33. Which of the following conditions exist when data are isolated in separated information systems?
    • A) information overload
    • B) encapsulation
    • C) information silo
    • D) data segregation
  34. ________ is the activity of altering existing and designing new business processes to take advantage of new information systems.
    • A) Business process modeling
    • B) Business process reengineering
    • C) Business process outsourcing
    • D) Enterprise resource planning
  35. Enterprise application integration is a ________.
    • A) suite of software applications that consolidates existing systems by providing layers of software that connect applications together
    • B) strategy that uses business process management to radically enhance the customer service experience from any customer base
    • C) suite of applications called modules, a database, and a set of inherent processes for consolidating business operations into a single, consistent, computing platform
    • D) 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
  36. To reduce the substantial work that needs to be done to customize an ERP application to a particular customer, ERP vendors provide ________.
    • A) service descriptions
    • B) industry-specific solutions
    • C) inherent processes
    • D) DIY modules
  37. The two top-ranked ERP vendors are ________.
    • A) Epicor and Oracle
    • B) SAP and Oracle
    • C) Microsoft Dynamics and Infor
    • D) Microsoft Dynamics and SAP
  38. Carla, a restaurateur who is new to the field, meets a veteran chef and restaurateur, Giovanni. Carla wishes to analyze the purchasing pattern of her customer base. Which of the following is most likely to be a piece of sound advice that Giovanni would offer Carla?
    • A) Carla should use her restaurant's distributed systems to know more about her customers' buying patterns.
    • B) Carla should avoid using the restaurant's integrated system to analyze her customers' purchasing patterns.
    • C) Carla should support strategic and less structured managerial decisions to ensure that standardization occurs.
    • D) Carla should support less specific and fluid managerial decisions to ensure that standardization occurs.
  39. ________ is defined as information containing patterns, relationships, and trends of various forms of data.
    • A) Process mining
    • B) Business process management
    • C) Business intelligence
    • D) Spatial intelligence
  40. Which of the following is a fundamental category of BI analysis?
    • A) automation
    • B) catalog
    • C) report servers
    • D) data mining
  41. Push publishing delivers business intelligence ________.
    • A) according to a schedule or as a result of an event or particular data condition
    • B) through reporting, data mining, and knowledge management
    • C) by obtaining, cleaning, organizing, relating, and cataloging source data
    • D) in response to requests from users
  42. ________ is a term that refers to the level of detail represented by the data.
    • A) Granularity
    • B) Intricacy
    • C) Elaboration
    • D) Complexity
  43. Which of the following statements is true about reporting applications?
    • A) Reporting applications deliver business intelligence to users as a result of an event or particular data condition.
    • B) Reporting applications consist of five standard components: hardware, software, data, procedures, and people.
    • C) Two important reporting applications are RFM analysis and OLAP.
    • D) Reporting applications produce business intelligence using highly sophisticated operations
  44. A sales team should attempt to up-sell more expensive products to a customer who has an RFM score of ________.
    • A) 311
    • B) 555
    • C)113
    • D) 545
  45. 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
  46. Which of the following terms is used as a synonym for data mining?
    • A) regression analysis
    • B) data warehousing
    • C) knowledge discovery in databases
    • D) parallel processing in databases
  47. Which of the following is true of unsupervised data mining?
    • A) Analysts do not create a model or hypothesis before running the analysis.
    • B) Neural networks are a popular unsupervised data mining application.
    • C) Unsupervised data mining requires tools such as regression analysis.
    • D) Unsupervised data mining requires analysts to fit data to suggested hypotheses
  48. Which of the following shows the products that customers tend to buy together?
    • A) regression analysis
    • B) market-basket analysis
    • C) neural networks
    • D) cluster analysis
  49. In market-basket terminology, the ratio of confidence to the base probability of buying an item is called ________.
    • A) confidence
    • B) support
    • C) granularity
    • D) lift
  50. In the context of KM systems, ________ attempted to directly capture employee expertise.
    • A) expert networks
    • B) expert systems
    • C) expert analyses
    • D) expert decisions
  51. ________ refers to the ability to model system components and show how the component inputs and outputs relate to one another.
    • a. Abstract reasoning
    • b. Systems thinking  
    • c. Dynamic correlation         
    • d. Operational logic
  52. Which of the following is NOT true?
    • a. Microsoft Lync provides features such as audio- and videoconferencing that enables users to meet and work online.
    • b. SharePoint Online works for users to manage and control content in the cloud.
    • c. GoogleDocs is a collaboration tool that provide workflow control.
    • d. Businesses can enhance competitive advantage by developing new work procedure to solve problems.
  53. Which of the following principles of competitive advantage is related to business process implementations?
    • a. creating new products or services
    • b. enhancing products or services
    • c. reducing costs and locking in customers
    • d. differentiating the products or services
  54. Which of the following factors determines the structure, features, and functions of an information system used in a company?
    • a. the technology used by competitors
    • b. the value of its brands
    • c. the size of the company
    • d. the competitive strategy
  55. Which of the following is NOT true?
    • a. Disruptive innovation brings solutions to the market that serve a new population of consumers.
    • b. Businesses use IT so that they can always have access to the latest cutting-edge technology out in the field.
    • c. Businesses use IT and IS in order to gain competitive advantage that would enable them to achieve its goals and objectives.d.
    • d. Positive-sum competition refers to the 'win-win' situation where no one wins at someone expense, and the sum of winnings and losses is positive
  56. SactoCycle is a company that rents bicycles. It provides "best-of-breed" rentals to executives at a high-end conference resort in Lake Tahoe. The company is using a ________ strategy
    • a. scaling
    • b. operational
    • c. differentiation                    
    • d. developmental
  57. Which of the following is a primary activity in the value chain?
    • a. receiving and distributing inputs to the product
    • b. negotiating prices with vendors
    • c. finding suitable vendors to supply raw materials
    • d. setting up contractual arrangements with various suppliers
  58. Which of the following is NOT true?
    • a. Moore’s law states that the number of transistors per square inch on an integrated chip doubles every 18 months.
    • b. Michael Porter argues that the corporate strategy document should be kept secret and should not be widely available and shared within an organization.
    • c. In planning phase of project management, if the schedule of an IT project is not acceptable, more resources can be added to the project or the project scope can be modified.
    • d. Locking in customers by making it difficult or expensive for customers to move to another product is called establishing high switching cost.
  59. As CEO of a large company, you had asked the human resources manager to send you information about the rate of employee turnover in your organization for the last quarter. The manager sends you the salary details of new hires during the same period. The information is likely to be of little use to you because it is ________.
    • a. not timely
    • b. irrelevant
    • c. just sufficient                     
    • d. too expensive
  60. Which of the following observations about the relationship between decision type and decision process is true?
    • a. The higher levels of decision making are associated with unstructured decision processes.
    • b. Managerial decisions tend to be highly structured whereas operational decisions are unstructured.
    • c. Higher level organizational decisions should be highly structured.
    • d. Need for collaboration is highly significant for lower-level, structured decisions.
  61. Which of the following is an example of sharing content with version control?
    • a. Microsoft Lync
    • b. wikis
    • c. Google Docs                       
    • d. Microsoft SharePoint
  62. ____________ decisions concern the broader scope organizational issues and the planning and forecasting in the high-level management.
    • a. Operational
    • b. Practical
    • c. Technical                
    • d. Strategic 
  63. Which of the following is true?
    • a. Businesses can buy IT, but can never buy an IS.
    • b. The five components of an information system are computer hardware, software, data, procedures, and policy.
    • c. Moving a factory from Detroit to Mexico is an example of an operational decision requiring collaboration.
    • d. Email that we use every day is a form of synchronous communication.
  64. Which of the following is true?
    • a. Optical disk is a nonvolatile memory device.
    • b. Individuals who edit large pictures, sound, or video files need a 64-bit processor to effectively use more than
    • c. 4 GB of main memory. 10 TB is equivalent to 1,024 gigabytes.
    • d. Internet Explorer is an open-source Web browser.
  65. Carlos is a business student doing an internship at Bruno and Venus, a firm specializing in exports of sophisticated equipment to other countries. He finds that he is unable to create a representative chart depicting the relation between processes such as procurement, shipping, and billing. This indicates that he lacks ________ skills.
    • a. abstract reasoning
    • b. collaborative    
    • c. experimental          
    • d. systems thinking
  66. Which of the following is NOT true?
    • a. Student names and IDs would be an example of the data component of a course registration system. b. Porter’s Five Forces model allows us to determine how profitable the industry is.
    • c. According to Michael Porter, margin refers to the amount of money that a customer is willing to pay for a service.
    • d. Strategic decisions concern the planning and forecasting in the high-level management.
  67. According to J. Richard Hackman, which of the following is a primary criterion for judging team success?
    • a. successful outcome
    • b. experience in collaborating
    • c. ability to be dynamic
    • d. availability of external help
  68. The effectiveness of a collaborative effort is driven by three critical factors, such as communication, content management, and ____________.
    • a. workflow control
    • b. operation
    • c. technology use       
    • d. synchronous processes
  69. Which of the following is true?
    • a. Operational decisions require a high degree of collaboration.
    • b. Version management applications offer a higher degree of control than the version control applications.
    • c. Need for collaboration increases as the decisions become more structured.
    • d. Information can be defined as data presented in a meaningful context. 
  70. The main purpose of the planning phase in a project is to ________.
    • a. set up the project scope and initial budget
    • b. accomplish the project tasks effectively
    • c. determine who will do what and by when
    • d. decide if the task status reporting process is needed or not
  71. Which of the following is true?
    • a. Brad who works in the marketing department has the ability to collaborate well with others. According to Mr. Reich, Brad's ability to collaborate is an example of a routine skill.
    • b. Ability to experiment involves modeling system components and show how components inputs and outputs related to one another.
    • c. The term information technology refers to the management and use of information systems that help businesses achieve their strategies.
    • d. MIS can help future business professionals and managers assess, evaluate, and apply IT to business to gain competitive advantage by developing non-routine skills.
  72. ________ is a process that occurs when the collaboration tool limits, and sometimes even directs, user activity.
    • a. Document monitoring
    • b. Version control
    • c. Document tracking
    • d. Version management
  73. Which of the following is NOT true?
    • a. Native applications are sometimes called thick-client applications.
    • b. Android is a mobile client operating system which controls the device’s resources.
    • c. A thin-client application is designed to run within computer browsers, such as Firefox and Internet Explorer
    • d. Thin applications are programs that are written to use a particular operating system
  74. Which of the following value chain activities involves transforming raw materials into a finished product or service?
    • a. operations
    • b. inbound logistics                
    • c. marketing               
    • d. maintenance
  75. Which of the following is NOT true?
    • a.  According to Reich, collaboration is a routine cognitive skill.
    • b. The planning and implementation of video conferencing systems using proprietary technologies is not cost effective.
    • c. Collaborative information systems enabled small-and medium-sized companies to compete against large companies.
    • d. Innovative thinking can help business to understand problems from a new perspective.
  76. The operating system employs _________ so that users can run multiple applications and files at the same time.
    • a. main memory
    • b. patches
    • c. rotational delay      
    • d. memory swapping
    • e. seek time
  77. Which of the following is not the evaluation criteria for choosing right collaboration IS?
    • a. task management
    • b. industry profitability
    • c. ease of use             
    • d. cost
  78. Which of the following is true?
    • a. Desktop virtualization enables a personal computer, such as a desktop computer, to host several different operating systems.
    • b. A computer system asking username and password would be an example of the hardware component of an information system.
    • c. The CPU keeps frequently used instructions in the cache so as to increase its overall throughput.
    • d. Android is a mobile operating system licensed by Apple.
  79. Mike runs both Windows 7 and Linux on his desktop computer. This process is called _____.
    • a. Memory utilization
    • b. server farming      
    • c. cloud computing       
    • d. PC virtualization 
  80. Which of the following is NOT true?
    • a. Word processing software has the capability of creating documents.
    • b. OpenOffice allows you to create a sophisticated document without paying licensing fee.
    • c. Firmware assists in creating, maintaining, and manipulating data.
    • d. RFID tags can facilitate inventory tracking by signaling their presence to scanners.
  81. The automobile industry is characterized by many manufacturers and intense competition among them. According to Porter's five forces model, this statement illustrates ________.
    • a. low threat of substitutions
    • b. high bargaining power of suppliers
    • c. high levels of rivalry
    • d. low bargaining power of customers
  82. Which of the following is NOT true?
    • a. Hardware consists of electronic components that are used to input, process, output, and store data.
    • b. User interface refers to the presentation format of an application.
    • c. A megabyte, or MB, is equal to 1,024 bytes.
    • d. The cache and main memory are volatile.
    • e. Linux is a version of Unix that was developed by an open source community.
  83. An organization implements an information system to optimize its supply chain. The system helps the organization decrease wastages. Hence, the system provides a competitive advantage to the organization. Here, the information system helped the organization achieve competitive advantage by ________.
    • a. locking in customers
    • b. reducing costs
    • c. locking in suppliers
    • d. differentiating the products
  84. Which of the following is a true statement?
    • a. A bar code scanner would be an example of an output device.
    • b. 4GB USB drive can store approximately 1,300 3MB MP3 song files.
    • c. Horizontal-market applications are developed for specific, unique needs of an industry.
    • d. The term "open source" means that the source code of the program is not available to the public.
  85. SacTimes, a software package installed in hospitals, is used to schedule appointments and bill patients. This is an example of ________.
    • a. horizontal-market application software
    • b. vertical-market application software
    • c. security patches  
    • d. operating systems
  86. Which of the following is NOT true?
    • a. WebEx is a popular commercial webinar product used in virtual sales presentations.
    • b. Browser-based applications are more dynamic and better suited to today's world than native applications.
    •   c.  A thin-client application is designed to run within a program such as Google Chrome.
    • d. Browser applications are thin-client applications that need to be pre-installed on the users' computers.
  87. Who among the following are most likely to use asynchronous communication?
    • a. A group of directors who regularly meet for board meetings
    • b. managers who work in the same office
    • c. employees who work in an assembly line
    • d. members of a team who work in different time zones 
  88. Which of the following is an advantage to an organization if its BYOD policy offers wireless network to mobile devices?
    • a. The organization can sniff employees' mobile traffic.
    • b. Employees gain public access from any device, not just mobile devices.
    • c. The policy appears to be permissive without actually being so.
    • d. Employees resist turning over the management of their own hardware to the organization.
  89. Which of the following is NOT true?
    • a. A private cloud is a cloud that is owned and operated by an organization for its own benefit.
    • b. An organization responds to the structure of its industry by choosing a competitive strategy.
    • The CPU is sometimes called "the brain" of the computer.
    • d. Main memory is also known as random access memory.
    • e. Bits are grouped into 8-bit chunks called strings
  90. What is the title of the MIS 101 textbook?
    • a. Planning MIS
    • b. Managing MIS                
    • c. Using MIS               
    • d. Implementing MIS
Card Set
mis final for 5/18/16
for final cumulative exam