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