BTMA 317
Which of the following is not a disadvantage of on-demand CRM? Vendor reliability Integration difficulty Strategic advantage Cost
Cost
Which of the following is a benefit of ERP sytem? A) Business process adaptation B) Cost C) Complexity D) Flexibility
D) Flexibility
Data ________ ensures data meets system constraints A) Consistency B) Independence C) Security D) Integrity
D) Integrity
_____ provide(s) companies with a single version of the truth for their data. A) Data warehouses B) Data marts C) Databases D) Master data management E) Enterprise information management
D) Master data management
__________ is a sales strategy in which the sales person will provide customers the opportunity to purchase higher-value related products or services as opposed to, or along with, the customer's initial product or service selection. A) Cross-selling B)Bundling C) Personalization D)Up-selling
D) Up-selling
Over time, the customer relationship with vendors has become more personal. True False
False
Packaging and assembly take place in the downstream portion of the supply chain. True False
False
The business environment refers to the industry that a company is in. True False
False
When you make a purchase online, that transaction is an example of batch processing. True False
False
Managing account collections is an example of a(n): Production Business Process Management Information Systems Business Process Marketing Business Process Finance Business Process
Finance Business Process
Which of the following is false? ERP systems integrate functional areas within an organization. ERP systems are designed to integrate business processes. ERP systems use a common database. Functional area information systems were usually developed independently. Functional area information systems easily communicate with each other.
Functional area information systems easily communicate with each other
For many organizations, business process re-engineering: is not disruptive to implement. is easy to implement. has a major impact on the corporate culture. is inexpensive. has little impact on facilities.
Has a major impact on the corporate culture
oday's customers have ________. less sophistication higher expectations difficulty in comparing prices less knowledge about products difficulty in finding information about products
Higher exceptions
E-commerce systems are a type of inter-organizational information systems. True False
TRUE
The primary goal of extranets is to do which of the following? To provide security for corporate intranets To enable business partners to better plan mergers and acquisitions To provide effective communications inside corporate intranets To enable corporate employees to view inventory information for their companies To foster collaboration between and among business partners
To foster collaboration between and among business partners
A data mart is a low-cost, scaled-down version of a data warehouse A) True B) False
True
An entity is a person, place, thing, or event about which information is maintained. True False
True
An example of a transaction in a HRIS application is adding a new employee. True False
True
An organization's IT infrastructure consists of the IT components and IT services. True False
True
Cross-functional processes are business processes require the cooperation of multiple functional areas. True False
True
Data marts are designed for the end-user needs in a strategic business unit or department. True False
True
Digital dashboards are special information systems that that support all managers of the organization. True False
True
During the development life cycle, users should be actively involved during the system investigation phase. True False
True
Globalization is the integration and interdependence of many facets of life made possible by rapid advances in information technology. True False
True
Online analytical processing (OLAP) involves the analysis of accumulated data by end users. True False
True
Source data automation involves collecting data from sensors. True False
True
The Emerging Technologies Manager forecasts technology trends; evaluates and experiments with new technologies. True False
True
The goal of SCM systems is to reduce friction along the supply chain. True False
True
Vertical integration is a business strategy in which a company purchases it's _______ suppliers
UPSTREAM
__________ is an inventory strategy where the supplier monitors inventory and then replenishes the products when needed. Vertical integration Vendor-managed inventory Just-in-time Bundling
Vendor-managed inventory
Managing the IS function within an organization is the exclusive responsibility of the IS department in contemporary organizations. True False
b) False
_____________ knowledge can be easily documented Intellectual Complete Tacit Explicit
explicit
When you start a job, you are given an employee handbook which contains the company's tacit knowledge. True False
false
Differentiation is the result of optimizing the marketing and innovation processes. True False
true
The activities of a business process can be measured. True False
true
The long-term goal of business process management is to create a competitive advantage through organizational flexibility. True False
true
A raw supplier is an example of a(n) _______ component of supply chain management. upstream instream downstream internal
upstream
Which of the following is true? A) Customizing an ERP system is permitted. B) Implementing an ERP system will maintain a competitive advantage. C) The benefits of an ERP implementation go down over time. D) The IT costs of an ERP implementation goes down over time. E) Implementing an ERP system will allow a company to operate faster than their competition.
Customizing an ERP
BPM is an implementation of BPR A) True B) False
B) False
____________ involves a group meeting of all analysts and users who agree on system requirements. Scrum JAD RAD Agile
JAD
_____ reports summarize the performance of critical activities. Key indicator Routine Exception Ad hoc Detailed
Key indicator
_____ conveys understanding, accumulated learning, and expertise as they apply to a current problem. Database Knowledge Data Information
Knowledge
_____ can be exercised to solve a problem, whereas _____ may or may not be able to be exercised to solve a problem. Information, knowledge Knowledge, information Data, knowledge Information, data
Knowledge, information
Which of the following has not been identified as a reason for ERP implementation failure? The complexity of the planning Lack of documentation No change management processes Insufficient training Failure to include affected employees in planning
Lack of documentation
The __________ represents the business users and any other stakeholders in the project. scrum team scrum master project owner scrum user
Project Owner
Data dictionaries perform all of the following functions except: Providing information on each record Providing information on why attributes are needed in the database Defining the format necessary to enter data into the database Providing information on the name of each attribute Providing information on how often attributes should be updated
Providing information on each record
The _________ model involves an educated guess about customer demand. make-to-order mass customization push pull
Push
_______________ uses drag-and-drop features to search a database. SQL DBMS QBE DDF
QBE
In a relational database, every row represents a(n) _____. File Record Attribute Primary key Secondary key
Record
ERP ____________ systems have the capability to place automatic requests to buy products from suppliers in real time. ERP AI SCM CRM
SCM
The grade point average (GPA) values coupled with appropriate student names of a class would be considered as information. True False
TRUE
Which of the following activities does not occur within the order fulfillment process? The warehouse prepares the shipment and produces internal documentation. The accounting department issues an invoice to the customer. The sales department forwards a sales order to the warehouse. The sales department receives a customer inquiry and issues a quotation indicating price and availability. The warehouse forwards a purchase requisition in order to buy goods from a vendor.
The warehouse forwards a purchase requisition in order to buy goods from a vendor
Organizations are turning to data governance for which of the following reasons? Their data are typically structured Data across their organizations are generally consistent Their data are usually located in the organization's databases They are responding to federal regulations They have too little data
They are responding to federal regulations
A business process has inputs and outputs
True
A list of football scores with the names of the teams that played the games would be considered information. True False
True
A systems analyst focuses on determining the information requirements and technical specifications for new applications. True False
True
A university registrar who uses her experience with university admissions in reviewing the applicant grades, application essays, and letters of recommendation, would be applying her knowledge in your application process. True False
True
Adding functions after a project has been initiated is called scope creep. True False
True
After the data is stored in your organization's databases, it must be accessible to users in a data warehouse in order to help your organization to make decisions. True False
True
An attribute is any characteristic or quality that describes a particular entity. True False
True
An organization's business processes can create a competitive advantage. True False
True
Best practices are the most successful solutions or problem-solving methods for achieving a business objective. True False
True
Business process management includes methods and tools to support the design, analysis, implementation, management, and optimization of business processes. True False
True
E-Commerce is the process of buying, selling, transferring, or exchanging products, services, or information via computer networks, including the Internet. True False
True
Functional Area Information Systems support major portions of an enterprise. True False
True
HR Information Management System was originally for benefits and tracking vacation. True False
True
Historically, the functional area information systems were developed independently of one another. True False
True
IT Audits can be used to find problems with IT systems. True False
True
In the data hierarchy, the smallest element is the _____. File Bit Byte Character Record
bit
In the relational database model, related tables can be joined when they contain common _____. Primary keys Rows Columns Files Records
columns
Which of the following is not a source for external data? Clickstream data Commercial databases Corporate websites Government reports Corporate databases
corporate database
Refer to the Braintree case. Knowledge management systems such as Confluence allows organizations to: ____________. create and distribute structured who-is and troubleshooting documents that are automatically organized and easy to find create and distribute structured how-to and mining documents that are automatically organized and easy to find create and distribute structured how-to and troubleshooting documents that are manually organized and easy to find create and distribute structured how-to and troubleshooting documents that are automatically organized and easy to find
create and distribute structured how-to and troubleshooting documents that are automatically organized and easy to find
Spending to protect against terrorism is an example of __________ pressure. social market technology economic
social
The push model begins with a forecast. True False
tRUE
Which of the following statements concerning business processes is false? A process has inputs. A process cannot cross functional area boundaries. A process creates value. A process has outputs. A process has activities that can be measured.
A process cannot cross functional area boundries
Which of the following is a limitation of ERP system? A) cost B) Decision making C) Efficiency D) flexibility
A) Cost
Which of the following is the correct hierarchy from the lowest level to the highest level? A) data, information, knowledge B) information, data, knowledge C) information, experience, wisdom D) data, experience, information E) knowledge, information, data
A) Data, information, knowledge
Which of the following is the correct hierarchy from the lowest level to the highest level? data, information, knowledge information, data, knowledge information, experience, wisdom data, experience, information knowledge, information, data
A) Data, information, knowledge
Which of the following is NOT a problem with Big Data? A)Gathering data B)Security C)Decision-making D)Privacy
A) Gathering data
__________ involves the analysis of accumulated data and involves a __________. A) OLAP, data warehouse B) OLAP, database C) OLTP, database D) OLTP, data warehouse
A) OLAP, data warehouse
__________ involves the analysis of accumulated data and involves a __________. A)OLAP, data warehouse B)OLAP, database C)OLTP, database D) OLTP, data warehouse
A) OLAP, data warehouse
the most important benefit of knowledge management systems is: A)They make best practices available to employees. B)They improve employee morale C) They improve customer service D)They enable the organization to retain scarce knowledge when employees retire E) They make product development more efficient
A) They make best practices available to employees
A list of football scores with the names of the teams that played the games would be considered information. True False
A) True
A negative value for a student's grade point average is an example of a data integrity problem. True False
A) True
A university registrar who uses her experience with university admissions in reviewing the applicant grades, application essays, and letters of recommendation, would be applying her knowledge in your application process. A) True B) False
A) True
An informed user of IT can enhance his or her organization's competitive position. True False
A) True
E-Commerce systems are a type of inter-organizational information systems A) True B) False
A) True
Electronic Data interchange is a problem for small businesses A) True B) False
A) True
End-user computing has two components: end-user data entry, reporting, and inquiry (commonly referred to as simply users); and end-user development, where users develop usable systems, such as spreadsheets or programs using programming languages or other development tools. True False
A) True
End-user computing has two components: end-user data entry, reporting, and inquiry (commonly referred to as simply users); and end-user development, where users develop usable systems, such as spreadsheets or programs using programming languages or other development tools. A) True B) False
A) True
IT audits can be used to find problems with IT systems A) True B) False
A) True
In general, informed users tend to get more value from whatever technologies they use. True False
A) True
Information is data that have been organized so that they have meaning to provide value to the recipient. True False
A) True
Information technology relates to any computer-based tools that people use to work with information and to support the information and information-processing needs of an organization. True False
A) True
Knowledge is information in action A) True B) False
A) True
The Information Systems functional area, a department of Information technology, deals with the planning, development, management, and use of management information tools to help people perform all the tasks related to information processing and management. A) True B) False
A) True
The SDLC is relatively inflexible A) True B) False
A) True
The grade point average (GPA) values coupled with appropriate student names of a class would be considered as information. True False
A) True
The real problem with interacting with customers over the Web is that the company does not have an opportunity to make a good first impression in person A) True B) False
A) True
You have just been hired by the largest manufacturer in your area to join their management trainee program. You enjoyed your "computer course" in college and hope that you'll be able to put that knowledge to good use. Which of the following might you expect to do during the management training program? A) code a new application B) recommend new technologies that might impact the organization C) design a new application D) become familiar with tools to support using data for decision making E) work 8 to 5 in your office
D) Become familiar with tools to support using data for decision making
Which of the following is not an example of the growing initiative called green IT? Asking vendors about compliance on environmental standards Building systems that monitor carbon throughout the organization Designing energy-efficient data centres Building computer applications that use less energy Designing an IT infrastructure to support sustainability
D) Building computer applications that use less energy
_____ occurs when various copies of the data agree. Data consistency Data redundancy Data integrity Application/Data dependence Data isolation
Data consistency
It is difficult to manage data. For example, it is common for customers to move and for companies to go out of business. This is an example of ___________. Data security Data degradation Data rot Scattered data
Data degration
You have moved to a different apartment, but your electricity bill continues to be sent to your old address. The Post Office in your town has which problem with its data management? Data dependence Data isolation Data redundancy Data inconsistency Data security
Data inconsistency
_____ occurs when applications cannot access data associated with other applications. Data redundancy Data integrity Data consistency Data isolation Application/Data dependence
Data isolation
Which of the following is an example of an analytical CRM system? Loyalty program Personalized web page Campaign management Data mining
Data mining
_____ occurs when the same data are stored in many places A)Data redundancy B)Application/Data dependence C) Data consistency D)Data isolation E)Data integrity
Data redundancy
Which of the following is a benefit of being an informed user of IT? A) understanding what is "behind" applications you use in your organization B) providing input to enhance your organization's applications C) helping to select new applications D) keeping abreast of new technologies E) all of the above
E) All of the above
Which of the following is not a role that information systems play in businesses processes? Detect problems with the process Establish standards Execute the process Monitor process performance Capture and store process data
Establish standards
an emerging technologies manager ___________. creates the Web sites and pages evaluates new technologies manages data networks is responsible for strategic planning manages the ethical and legal use of information systems
Evaluates new technologies
When the chief financial officer of a company wants a report on business units which have spent 10 percent more than their allotted budget, she would be requesting which type of report? Key indicator Ad hoc Routine Exception Detailed
Exception
_____ reports include only information that falls outside certain threshold standards. Key indicator Exception Routine Detailed Ad hoc
Exception
The bullwhip effect results in __________. excess inventory deficient inventory mass customization mass production
Excess inventory
Historically, management information systems have focused on capturing, storing, managing, and reporting _____ knowledge. Geographical Managerial Cultural Tacit Explicit
Explicit
Data governance is an approach to managing functional area information systems. True False
FALSE
Managing data is easier nowadays since there is so much of it. True False
FALSE
A business process always includes information systems. True False
False
Data rot refers to the quality of the data itself true false
False
Enterprise resource management is an enterprise-wide effort to acquire and retain customers. True False
False
Explicit knowledge refers to the cumulative store of subjective learning, which is personal and hard to formalize. True False
False
For purposes of efficiency, customer data are best stored in the functional areas of the organization. True False
False
Horizontal integration is a business strategy in which a company buys its suppliers. True False
False
If you want to run a multinational company, you need to rent office space and hire at least few employees. True False
False
Information silos were particularly efficient when business processes crossed functional boundaries in an organization. True False
False
Maintenance ends when the new system is implemented and has run long enough for a systems audit. True False
False
Meaningful knowledge is information and meaningful information is data. True False
False
One of the advantages of the buy option is the need to hire specialized personnel. True False
False
The CIO of an organization supervises the day-to-day operations of the data and/or computer centre A) True B) False
False
When data are normalized, attributes in the table depend on the primary key and any secondary keys. True False
False
Which of the following is/are not a fundamental element of a business process? input feedback output resources
Feedback
The procurement process includes the sales function. True False
Flase
The ____________ process originates in the sales department and ends in the accounting department. hiring procurement fulfillment production
Fulfillment
A business process can be a competitive advantage when _____________. the company becomes less responsive and efficient a product or service is delivered to the organization IT enables the company innovate or to execute better than its competitors inputs are translated to outputs
IT enables the company innovate or to execute better than its competitors
As an individual student in your university's student database, you are a(n) _____ of the STUDENT class. Representative Instance Relationship Entity Individual
Instance
____________ is a strategy of producing customized (made to individual specifications) products and services. Make-to-order Mass customization Customer focus Personalization
Makte-to-order
____ provide(s) companies with a single version of the truth for their data. Data warehouses Data marts Databases Master data management Enterprise information management
Mater data management
Explicit knowledge has which of the following characteristics? Slow Costly to transfer Objective Personal Ambiguous
Objective
To effectively manage by exception (i.e., use exception reports), the company must first create: Employee evaluation guides User information requirements Performance standards Best practices A database
Performance standards
____________ conversion introduces the new system in one part of the organization on a trial basis, when the new system is working properly, it is introduced in other parts of the organization. Direct Pilot Parallel Phased
Pilot
_____ tell the database management system which records are joined with others in related tables. Primary keys Common files Secondary keys Common fields Common attributes
Primary Key
__________________ allows users to perform complicated searches by using relatively simple statements or keywords. SSK DBMS SQL QBE
SQL
Procurement is not completed in this functional area: Purchasing Accounting Sales Warehouse
Sales
Enterprise resource planning systems are very _____ software products, meaning that companies typically have to change their _____ to accommodate how the software functions. unstructured, business processes structured, accounting processes structured, business processes unstructured, inventory control structured, reporting relationships
Structured, business processes
SCM helps address which of Porter's Five Forces? Buyer power Supplier power Rivalry Threat of substitutes
Supplier power
The drawbacks of ERP systems include all of the following except: They are complex They are expensive They are time-consuming to implement Companies may need to change existing business processes to fit the software They consist of modules
They consist of modules
Refer to the Nordea Bank case. The data warehouse enabled Nordea to: ____________. To meet the current regulatory requirements more quickly, accurately, and cheaply Find problems with their customers Be able to communicate faster with customers and suppliers All of the above
To meet the current regulatory requirements more quickly, accurately, and cheaply
_____ describes the activities of the business, whereas _____ categorize(s), aggregate(s), and evaluate(s) data generated by the organization's activities. Source data, transaction data Business dimensional data, databases Operational data, master data Transaction data, master data Master data, source data
Transaction data, master data
Collaborative CRM systems provide interaction with customers throughout the entire organization. True False
True
IT is enabling more and more people to communicate, collaborate, and compete, thereby leveling the digital playing field. True False
True
If you have visited Amazon's website previously and then return, Amazon recommends other books that you might like. This is called cross-selling. True False
True
In general, informed users tend to get more value from whatever technologies they use. True False
True
In the past, customer data has been located all over the company, typically in the functional areas. True False
True
Information is data that have been organized so that they have meaning to provide value to the recipient. True False
True
Information systems can be function-specific. True False
True
Managing the massive amounts of data that are critical to organizational success comes at a huge cost. True False
True
Master data are a set of core data that span all of an enterprise's information systems. True False
True
Mobile CRM systems are targeting customers through their portable devices such as smart phones. True False
True
Modality is the minimum number of times an instance of one entity can be associated with an instance of a related entity. True False
True
Modern organizations are concentrating on their core competencies and on becoming more flexible and agile. True False
True
Prototyping allows the users to clarify their information requirements as they use the prototype. True False
True
The IS operational plan is a set of projects that will be executed by the IS department and by functional area managers. True False
True
The IT infrastructure delineates the way an organization's information resources should be used to accomplish its mission. True False
True
Reconciling bank accounts is an example of a(n): Management Information Systems Business Process Accounting Business Process Marketing Business Process Finance Business Process Production Business Process
Accounting Business Process
Refer to Case 5.1 Data Problems at Target Canada. In order for SAP ERP system to work properly, data needs to be: accurate managed properly contain RFID information reenginered All of the above.
Accurat
Greg is mowing lawns in the neighborhood for the summer. Which type of report would he used to see if a particular client still owes him money? Key indicator Ad hoc Detailed Routine Exception
Ad hoc
Which of the following is a benefit of being an informed user of IT? understanding what is "behind" applications you use in your organization providing input to enhance your organization's applications helping to select new applications keeping abreast of new technologies all of the above
All of the above
Which of the following is not a reason why managing data is difficult over time? New systems are developed. The media the data are stored on becomes problematic. New sources of data are created. The amount of data increases exponentially. All of these are reasons why managing data is difficult over time.
All of these are reasons why managing data us difficult over time
__________ CRM systems are used to create statistical models of customer behaviour, to determine the value of customer relationships over time, and to create forecasts about acquiring, retaining, and losing customers. Operational Collaborative Statistical Analytical
Analytical
The data in a data warehouse: Are updated in batch mode, approximately once per day Are updated constantly in real time. Are not updated Are available for MIS analysts, but not users. Are purged constantly as new data enter
Are not updated
In a university's relational database, the student record contains information regarding the student's last name. The last name is a(n): Primary key. File Object Attribute
Attribute
__________ is the result of optimizing operations and supplier processes. A) Quality B) Cost reduction C) Differentiation D) Productivity
B) Cost Reduction
An Electronic Commerce (e-Commerce) system is an intra-organizational information system. A) True B) Flase
B) False
BPR is a strategy for improving the efficiency of an organization's data collection A) True B) False
B) False
CRM means that a company should interact with its customers as a group A) True B) False
B) False
Exception reports show a greater level of detail than is included in routine reports A) True B) False
B) False
_____ conveys understanding, accumulated learning, and expertise as they apply to a current problem. Database Knowledge Data Information
B) Knowledge
____________ pressures are generated by the global economy, intense competition, the changing nature of the workforce, and powerful customers. A) Economic B) Market C) Social D) Technology
B) Market
The Information Systems functional area, a department of Information technology, deals with the planning, development, management, and use of management information tools to help people perform all the tasks related to information processing and management. True False
True
The initial goal of business process management is ____________________. A) to organize around the business process, not the individual task B) to improve profitability by decreasing costs and increasing revenue C) to create a competitive advantage through organizational flexibility D) to be less radical, disruptive, and more incremental
B) To improve profitability by decreasing costs and increasing revenue
As an individual student in your university's student database, you are a(n) _____ of the STUDENT class. A) Representative B) Instance C) Relationship D) Entity E) Individual
B) instance
_____ are the most successful solutions or problem-solving methods for achieving a business objective. Business functions Optimal strategies Enterprise solutions Best practices Business processes
Best practices
The data in a data warehouse: A) Are updated in batch mode, approximately once per day B) Are updated constantly in real time. C) Are not updated D) Are available for MIS analysts, but not users. E) Are purged constantly as new data enter
C) Are not updated
The tittle of the execution who is in charge of the people who design and build information systems, the people who use those systems, and the people responsible for managing those systems is the A) CIS B) CEO C) CIO D) CFO E) CIT
C) CIO
In the relational database model, related tables can be joined when they contain common _____. A) Primary keys B) Rows C) Columns D) Files E) Records
C) Columns
_____________ reduces a relational database to its most streamlined form. A) A database management system B) Streamlining C) Normalization D) A data dictionary
C) Normalization
A(n)_______ is a logical grouping of related fields A) File B) Database C) Record D) Byte E) Field
C) Record
The Information systems (IS) of an organization are intended to support internal processes, therefore all information systems must be owned by the organization itself. True False
True
The Supply Chain Management system is an inter-organizational information system. True False
True
Which of the following statements is TRUE? A) Databases are organized to make queries very easy B) Querying databases is the most effective and efficient way of using data C) Running queries in a data warehouse does not degrade database performance D) Databases are well-suited for making comparisons between records
C) Running queries in a data warehouse does not degrade database performance
Which of the following statements is TRUE? A)Databases are organized to make queries very easy B) Querying databases is the most effective and efficient way of using data C) Running queries in a data warehouse does not degrade database performance D) Databases are well-suited for making comparisons between records
C) Running queries in a data warehouse does not degrade database performance
Tacit knowledge has which of the following characteristics? A) Codified B) Technical C) Unstructured D) Objective E) Rational
C) Unstructured
You have just been hired by the largest manufacturer in your area to join their management trainee program. You enjoyed your "computer course" in college and hope that you'll be able to put that knowledge to good use. Which of the following might you expect to do during the management training program? code a new application recommend new technologies that might impact the organization design a new application become familiar with tools to support using data for decision making work 8 to 5 in your office
C) become familiar with tools to support using data for decision making
The application portfolio in an organization is a set of recommended applications resulting from the planning and justification process in application development. True False
True
The data processed by transaction processing systems provide the inputs for other organizational information systems. True False
True
Total cost of ownership requires that the organization captures all associated costs when purchasing for external providers. True False
True
Tweets can be used as customer touch points. True False
True
When ERP systems are not appropriate in an organization, then that organization can use an enterprise application integration system. True False
True
Whether forecasters overestimate or underestimate demand, the company still faces problems. True False
True
You would be an instance of your university's STUDENT class. True False
True
organizations use low fidelity prototyping because it is quick and gets everyone involved. True False
True
The characteristics of ERP systems include all of the following except: Including a set of interdependent software modules Integrating the planning, management, and use of all resources of the organization They are expensive and time-consuming Typically fitting an organization's existing business processes Providing information necessary to control the business processes of the organization
Typically fitting an organization's existing business processes
Place the following members of the data hierarchy in their correct order: Byte - bit - record - field - database Bit - field - byte - record - file - database Bit - byte - field - record - database - file Bit - byte - field - record - file - database Bit - record - field - byte - file - database
bit-byte-field-record-file-database
A(n) _____ represents a single character, such as a letter, number, or symbol. File Record Byte Database Field
byte
A _______ is eight ________. bit, digits Bit, bytes Byte, characters Byte, bits
byte, bits
What does a systems analyst do? Determines information requirements and technical specifications for new applications Creates Web sites and pages Writes computer code Manages an IS service Forecasts technology trends
determines information requirements and technical specifications for new applications
Which of the following is not a role that information systems play in businesses processes? Detect problems with the process Establish standards Execute the process Monitor process performance Capture and store process data
establish standards
Customer-_________ applications involve direct interaction with customers. interacting touching directing facing
facing
information technology and information systems are the same thing. True False
false
the grade point average (GPA) values of a class would be considered as information. True False
false
Supply chain visibility enhances supply chain _________. e-commerce globalization flexibility cost
flexibility
A data warehouse is a repository of __________ data. Historical Queried Numbered Current
historical
The amount of data we collect is ____________ over time, making it ________ difficult to manage data. Increasing, less Increasing, more Decreasing, more Decreasing, less
increasing, more
_________ flows are all data related to demand, shipments, orders, returns, and schedules as well as to changes in any of these data. Financial Schedule Material Information
information
Data ___________ ensures data meets system constraints. Consistency Independence Security Integrity
integrity
Which of the following is a challenge for developing a knowledge management system? Employees must be willing to share their explicit knowledge. It must be continually maintained and updated. It makes human capital widely accessible All of the above are challenges
it must be continually maintained and updated
_____ is a process that helps organizations identify, select, organize, disseminate, transfer, and apply expertise that are part of the organization's memory and typically reside inside the organization in an unstructured manner. Knowledge management Data mining Decision support Discovery Online analytical processing
knowledge management
At your university, students can take more than one class, and each class can have more than one student. This is an example of what kind of relationship? One-to-many One-to-one Many-to-one Many-to-many
many-to-many
Which of the following statements concerning technology pressures on modern businesses is true? New technologies will never replace existing technologies. The amount of information on the Internet remains stable from year to year. The important information on the Internet is fee-based. New technologies offer alternative service options Technology changes so rapidly that organizations should wait before they release new technology-based products.
new technologies offer alternative service options
____ is a method for analyzing and reducing a relational database to its most streamlined form. Relational analysis Structured query Normalization Joining Query by example
normalization
________ conversion is rarely used today if at all. Direct Pilot Parallel Phased
parallel
Normalized data occurs when attributes in the table depend only on the _______. Data dictionary Record information Primary key Secondary key
primary key
For the following entity-relationship diagram, the attributes you would NOT expect to see in the Computer entity are: disk size memory size type (laptop or desktop). manufacturer student's dorm room
students dorm room
ERP systems integrate the planning, management and use of all resources of the organization. True False
tRUE
The data in a data warehouse have which of the following characteristics? They are coded in different formats They are updated in real time They are organized by subject. They are typically retained for a defined, but limited, period of time They are organized in a hierarchical structure
they are organized by sbject
An information system collects, processes, stores, analyzes, and disseminates information for a specific purpose. True False
true
An organization's supply chain starts at the supplier and ends at the customer. True False
true
Business processes may be located within one functional area or may span multiple functional areas. True False
true
Properly designed CRM systems provide a single, enterprise-wide view of each customer. True False
true
Secondary keys have some identifying information but do not identify a file with complete accuracy. True False
true
Sourcing from external suppliers occurs in the upstream portion of the supply chain. True False
true
Structured query language is a relational database language that enables users to perform complicated searches with relatively simple statements. True False
true
When you start a job, you watch what other employees are doing and ask them to explain why they do it in a particular way. They are sharing their tacit knowledge. True False
true
You should seek to be an informed user of IT because ____________. it is easy to understand how IT works you could end up working in the IT department in your organization everyone uses IT you will be in a position to enhance the quality of IT applications
you will be in a position to enhance the quality of IT applications
_____ tell the database management system which records are joined with others in related tables. Primary keys Common files Secondary keys Common fields Common attributes
A) Primary Keys
Managing purchasing is an example of a(n): A) Production Business Process B) Management Information Systems Business Process C) Finance Business Process D)Marketing Business Process
A) Production Business process
IT architecture focuses on the technical aspects of information resources A) True B) False
B) False
IT only positively affects our quality of life A) True B) False
B) False
IT personnel use the IT infrastructure to develop information systems A) True B) False
B) False
If you want to run a multinational company, you need to rent office space and hire at least few employees A) True B) False
B) False
Productivity is the result of optimizing operations and supplier processes A) True B) Flase
B) False
Technical feasibility determines if the project is an acceptable financial risk and if the organization can afford the expense and time needed to complete the project. True False
B) False
The functional area information systems are the most fundamental information systems in the organization A) True B) False
B) False
The grade point average (GPA) values of a class would be considered as information. A) True B) False
B) False
The overall performance of an organization has little to do with how well it manages its business processes. A) True B) False
B) False
When you start a job, you are given an employee handbook which contains the company's tacit knowledge. True False
B) False
In a jewelry store, a customer places an order for a piece of jewelry (for example, a silver pin in the shape of a tulip). A customer could order more than one piece of jewelry on the same order. Which of the following entity-relationships describes this situation? A)The entities Order and Jewelry Item have a one to many relationship B)The entities Customer and Jewelry Item have a one to many relationship C) The entities Customer and Order have a one to many relationship D) The entities Order and Jewelry Item have a many to many relationship E) The entities Customer and Order have a many to many relationship
A) The entities Order and Jewelry item have a one to many relationship
A business process can be a liability A) True B) False
A) True
A negative value for a student's grade point average is an example of a data integrity problem A) True B) False
A) True
It is important for applications and data to be dependent on each other. True False
B) False
Key-indicator reports shows data at a greater level of detail A) True B) False
B) False
Managing data is easier nowadays since there is so much of it A) True B) False
B) False
Managing the IS function within an organization is the exclusive responsibility of the IS department in contemporary organizations. True False
B) False
Meaningful knowledge is information and meaningful information is data A) True B) False
B) False
Kelly has taken a job with her ideal company and is excited to start in their sales department. During orientation, she is told that the company is very proud of their ERP system from SAP. Looking at the list of modules the company has, Kathy wonders which one she won't be using. From the list below, which one would you tell Kathy is the one she won't be using. A) Human resource management B) Business intelligence C) Operations management D) E-Business E) Customer relationship management
C) Operations management
A(n) _____ is a logical grouping of related fields. File Database Record Byte Field
C) Record
Which of the following statements is false? Competitive advantage enables a company to function effectively within a market. Competitive advantage requires the use of technology. Competitive advantage leads to higher-than-average profits. Competitive advantage applies to companies of all sizes. Competitive advantage is based on some measurement such as cost, quality, or speed.
Competitive advantage requires the use of technology
________ CRM is a CRM system that is hosted by an external vendor in the vendor's data centre. A) Mobile B) On-premises C) Open-source D) On-demand
D) On-demand
_________ is a traditional function of the MIS Department A) Creating business alliances with business partners B)Educating the non-MIS managers about IT C) Managing system integration including the Internet, intranets, and extranets D) Providing technical services
D) Providing technical services
Which of the following is NOT an inter-organizational system? A) SCM B) ERP C) CRM D) TPS
D) TPS
You order a pair of shoes online, but they don't fit. You send them back. This is an example of a(n) _________ transaction. A) downstream B) intraorganizational C) internal D) upstream
D) Upstream
When Walmart sells a package of diapers, the company captures data on that sale at its point-of-sale terminal and transmits the data to the company that makes the diapers. When it is necessary, the diaper company restocks the diapers in that Walmart store. This process is called: A)Supply chain management B) Demand chain management C) Just-in-time inventory D) Vendor-managed inventory E) Enterprise resource planning inventory
D) Vendor-managed inventory
Extranets use __________ technology to make communication over the Internet more secure. A) anti-malware B) videoconferencing C) voice-over IP D) virtual private network telepresence
D) Virtual private network telepresence
Which of the following is NOT an inter-organizational system? a) SCM B) ERP C)CRM D)TPS
D)TPS
_____ is a formal approach to managing data consistently across an entire organization. Data governance Enterprise information management Data mart Database management Data warehousing
Data governance
_____________ is the ability for all organizations in a supply chain to access or view relevant data on purchased materials as these materials move through their suppliers' production processes and transportation networks to their receiving docks. a) Supply chain intelligence b) Horizontal integration c) Supply chain integration d) Vertical integration e) Supply chain visibility
E) Supply Chain visibility
_____ are interorganizational ERP systems that provide Web-enabled links between an organization's key business systems and its customers, suppliers, business partners, and others. Office automation systems Supply chain management systems Transaction processing systems ERP II systems Functional area information systems
ERP II systems
CRM systems focus on marketing to masses of people True False
False
Costs are harder to quantify than benefits. True False
False
Cross-functional processes are executed within a single functional area. True False
False
Customer satisfaction is the result of optimizing and aligning business processes to fulfill customers' needs, wants, and desires. True False
False
_________ flows are all data related to demand, shipments, orders, returns, and schedules as well as to changes in any of these data. Schedule Material Information Financial
Information
An example of cross-function business process is
Procurement
Which of the following does not contribute to the value of a customer? Loyalty Profitability Number of purchases Size
Size
BPM can improve an organization's flexibility
True
A relational database is one big table that contains all the company's records. True False
b) false
An auditing manager focuses on the ethical and legal use of information systems and evaluates the quality or effectiveness of such systems. True False
true
Which of the following is a limitation of ERP systems A) Cost B) Decision-making C) Efficiency D) Flexibility
A) Cost
Which of the following is NOT a problem with Big Data? A) Gathering data B) Security C) Decision-making D) Privacy
A) Gathering data
