3300 Exam 2 possible questions

The financial management system of a software company automatically updates the general ledger whenever there are any transactions in the company's accounts receivable and accounts payable. This is an example of the financial system's ________. A) service delivery applications b) compliance reporting C) exception reporting D) integration of components

D) integration of components

Customers can include: A) internal customers only b) booth internal and intermediate customers C) both intermediate and final customers D) internal, intermediate, and final customers

D) internal, intermediate, and final customers

Strategic partnering means: A) avoiding a mutual dependence b) helping each other get better at that each company does C) focusing on a financial relationship D) eliminating dependence on long-term suppliers

b) helping each other get better at that each company does

The one of the common causes of the bullwhip effect is: A) customers not paying attention to supply b) the batching of orders C) suppliers keeping prices locked D) failure to update forecasts

b) the batching of orders

Which of the following supply chain management software is used to manage and optimize shipping, logistics, fleet routing, and scheduling? A) global trade management software b) transportation management software C) warehouse management software D) supply chain planning software

b) transportation management software

Which of the following database architectures relies on a cooperating collection of existing databases? A) data warehouse appliance b) virtual federated warehouse c) data cubes d) data mining

b) virtual federated warehouse

The type of logical database model that treats data as if they were stored in two-dimensional tables is the : A) hierarchical DBMS b)relational DBMS c) OODBMS D) pre digital dbms

b)relational DBMS

When compared to electronic data interchange, the use of collaborative systems with XML formats to improve visibility between partner companies in a supply chain ________. A- requires less time to create b- is more flexible c- is difficult to create d- requires no trust between partners

b- is more flexible

A schematic of the entire database that describes the relationships in a database is called a : a- intersection relationship diagram b- data definition diagram c- entity-relationship diagram d- data dictionary

c- entity-relationship diagram

In a table for customers, the info about a single customer would reside in a single: A- column b-field c- row d- table

c- row

Every record in a file should contain at least one key field True false

true

A lean operation produces minimum levels of efficiency and effectiveness using a max amount of resources T/F

F

Web marketers launch link-building campaigns to improve their brand image. T/F

False

Which product allows voice commands, sequenced like a natural conversation, as a means to access a database? Oracle MySQL Yelp Siri

Siri

A core capability is a unique set of skills that confers competitive advantage to a firm, because rival firms cannot easily duplicate them. T/F

T

One of the decisions that must be made relating to information management for the supply chain is: A) which hardware should be used b) when should info be deleted c) who info is shared with D) what privacy policies should be implemented

c) who info is shared with

The most prominent data manipulation language today is a) access b- crystal reports c- SQL d- DB2

c- SQL

______ is a metric used to assess the impact of an online ad. a- pagerank b- error rate c- clickthrough rate d- churn rate

c- clickthrough rate

Which of the following is a CRM strategy used to earn more revenue from existing customers? A) foot-in-door technique b- permission marketing c- cross selling d- predictive analytics

c- cross selling

The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called: a- data scrubbing b- data administration c- normalization d- data cleansing

c- normalization

A(n) ________ focuses on informing visitors and empowering them with aggregated information about products from different suppliers. A) flat network b) dashboard c) intranet portal d) infomediary

d) infomediary

What are 5 advantages of databases?

1) reduce redundancy 2) increase information quality 3) flexibility 4) scalability 5) increase information security

The advantage of using a suite with synchronized modules is that ________. A) the introduction of changes in such systems to meet new business needs takes little time B) a common architecture overlays the systems to improve consistency across the modules C) modules can have very rich functionality and can be implemented individually, reducing risk D) the switching costs are far lower for ERP systems with interdependent modules

B) a common architecture overlays the systems to improve consistency across the modules

Electronic filing of tax forms on government websites is an example of a government-to consumer-relationship (G2C). T/F

False

Engineered suites offer solid integration on the back-end and consistent user interfaces throughout. True/false

False

Which of the following is not considered a component of supply chain management? A- strategic partnering b- mutual pricing strategies c- cooperative product design d- distribution network configuration

b- mutual pricing strategies

A ________ is a small text file left on a website visitor's hard drive that is used to personalize the site for the visitor, or track web activities. a) spider b) plug-in c) cookie d) tag cloud

c) cookie

Workforce management modules draw on information stored in sales records that shows when peak demand occurs. T/F

True

Field identified in a tabe as holding the unique identifier of the tables records is called the: a- primary key b- key field c- unique ID d- primary field

a- primary key

Which database architecture is especially used for managing web content and web-based resources? A) object-oriented database b) XML database C) relational database D) hierarchical database

b) XML database

Which of the following is a factor that directly affects a company's choice of suppliers? A) demand forecast accuracy b) business strategy c) sunken costs D) turnover costs

b) business strategy

Which of the following is calculated by adding the average advertising costs for job postings, agency fees, recruiter's salary and benefits, and relocation expenses for new employees? a) turnover cost b) cost per hire c) retention cost d) cost of attrition

b) cost per hire

While using a word processor to create a project report, Ashley includes the subject, title, and the author's name in the report's properties. What type of information is Ashley adding to her report? A) boolean data b) metadata C) count data D) binary data

b) metadata

Other words sometimes substituted for supply chain include: demand chain extended enterprise supply network supply web ALL

ALL

Building interfaces, or bridges, between different databases to link common fields is an integration strategy. A) true b) false

A) true

Which of the following is a function of the Web Accessibility Initiative (WAI)? A)offering tutorials and tips to help organizations improve their sites B) settling disputes over domain names C) developing free assistive technology products and services D) enforcing international anti-cybersquatting laws

A)offering tutorials and tips to help organizations improve their sites

Which of the following websites uses a sequential architecture? A) A website that provides online counseling requires a visitor to enter certain information on the home page, which would then lead him to the subsequent page, until he is matched with a suitable counselor. B)The website of a restaurant provides an image of the restaurant on the home page and links to three pages that provide the story of the restaurant, its location and timings, and its specialties. C) The website of a computer manufacturing firm provides the categories of computers and services provided on the top of the page, while along the left navigation bar it provides links to specific models. D)An e-magazine lists the links to the genres on the home page, and under each genre it lists the links that categorize articles by different authors, which leads to a webpage with the writings by each author.

A) A website that provides online counseling requires a visitor to enter certain information on the home page, which would then lead him to the subsequent page, until he is matched with a suitable counselor.

A _______ supplier produces goods and services directly to the firm. For example, the stock film wholesaler to the movie production company. A) first tier b) second tier C) echelon D) downstream E) None

A) First- Tier

Laid-off workers, who are hired back due to their positive attitude and networking capabilities when businesses recover, are called ________. A) boomerangs b) opinion leaders C) laggards d) freelancers

A) boomerangs

A database schema is used to ________. A) graphically document a data model B) identify redundant information in a database C) record details of the fields in a table D) create a backup of a database

A) graphically document a data model

Which of the following database architectures works well for one-to-many relationships, but is not effective with many-to-many relationships? A) hierarchical database b) object-oriented database C) cluster database D) network database

A) hierarchical database

An advantage of electronic data interchange (EDI) is that it A) improves supply chain performance B) enables a company to easily switch partners C) does not rely on any proprietary software D) takes very little time to be set up in a company

A) improves supply chain performance

Wide fluctuations in demand: A) increase costs for the entire supply chain b) affect only the ends of supply chain c) dont affect inventory levels D) can be eliminated

A) increase costs for the entire supply chain

Process standardization: A) increases productivity b) decreases competitiveness C) reduces barriers of entry D) adds costs b/c of economies of scale

A) increases productivity

The online book review magazine, bookreviewusa.com, offers free access to all their reviews and author interviews; however, only those who have purchased premium access can read book extracts from recently published books. What is the primary web goal of this organization? A) inform or entertain the audience B) facilitate offline relationships C) sell products and commodities D) influence the audience

A) inform or entertain the audience

Which of the following is true of the eXtensible Business Reporting Language (XBRL)? A) it makes data computer readable b- it has failed to advance over electronically delivered PDFs c- it specializes only in financial reporting d- it reduces the transparency in a reporting process

A) it makes data computer readable

Making changes to an integrated database is considered a challenge because ________. A) it takes less time from IT but more from the end users B) it exposes the database to external threats C) it requires extensive changes to the source code D) it renders data obsoluete

A) it takes less time from IT but more from the end users

A drawback of the hierarchical database was that ________. A) it was ineffective at handling many-to-many relationships B) it did not mimic every detail of org chart C) it worked for only one-to-one relationships D) it failed to reduce redundancies introduced by file systems

A) it was ineffective at handling many-to-many relationships

Which of the following is a function of normalization? A) minimizing duplication of info B) assigning incremental numbers to records C) assigning primary keys D) decreasing the functional dependency of data

A) minimizing duplication of info

What are the relationships that the relational database is named for? A) relationships between entities B) relationships between databases C) relationships between rows and columns D) relationships between tables

A) relationships between entities

In the case of ________, companies pay subscription fees to access a vendor's software in the cloud, via the web. A) software-as-a-service(SaaS) products B) web beacons C) middleware D) remote web-application frameworks

A) software-as-a-service(SaaS) products

_________ is the management of processes used to identify, acquire, and administer inputs to the firm. A) Supplier management b) customer management C)Logistics managment D)ALL E) NOne

A) supplier management

Retrieval is very fast through data cubes because ________. A)data cubes represent information in the form of objects, using object-oriented programming languages to access them B) data cubes group data in logical dimensions, such as sales by product, city, region, and country C)data cubes organize data by attaching XML tags to them D) data cubes use a separate server which is tuned for fast retrieval and reporting

B) data cubes group data in logical dimensions, such as sales by product, city, region, and country

________ specifies the characteristics of a field, such as the type of data it will hold. A) an entity B) data defintion C) a record D) database architecture

B) data defintion

________ takes advantage of signals transmitted via the phone to access a database, retrieve account information, and enter data. A) structured query language B) interactive voice response C) electronic reported outcome D) dialog system

B) interactive voice response

Which of the following is the best way to handle complex relationships, such as the data for a company where employees can be assigned to more than one project, and each project can have more than one employee assigned to it? A)creating two or more records for the employee, each of which lists a different project B) normalizing the relationship between "employees" records and "projects" records C)including multiple project fields, such as project 1, project 2, and so on, for the employee D) making the relationship between "employees" records and "projects" records hierarchically dependent

B) normalizing the relationship between "employees" records and "projects" records

The first targets of process improvements through integration of modules and creation of workflows in companies were ________. A) Financial analytics and financial reporting B) procurement and accounts payable C) general ledger and asset management D) cash management and budget planning

B) procurement and accounts payable

One of the uses of databases without boundaries is in ________. A)forming bridging databases between data warehouses and operational databases B)handling unstructured data during emergency disaster relief situations C)hunting for hidden patterns and relationships in large amounts of data D)handling online transactions of e-commerce websites

B)handling unstructured data during emergency disaster relief situations

Sam, the CEO of a product development company, is planning to implement an ERP system in his company. However, most of his colleagues advise him against implementing such a system saying that such systems have more weaknesses than strengths. Why should Sam still go ahead with the implementation? A)ERP implementation rarely affects workflow and therefore requires very little usage training. B)ERP systems are very easy to implement, especially in large organizations. C)Once in place, the ERP can dramatically enhance operational efficiencies and reduce costs. D)Research shows that almost all ERP implementations have been a success.

C) Once in place, the ERP can dramatically enhance operational efficiencies and reduce costs.

In enterprise information management, data ownership issues arise because ________. A) data is often taken from external sources B) quality of data varies across departments C) data is shared by all the stockholders in org D) data is often stored in databases on external servers

C) data is shared by all the stockholders in org

Demand forecast accuracy is important because overestimating demand leads to ________. A) increased prices b) decreased inventory costs C) discount blowouts D) lost sales

C) discount blowouts

The process of retrieving data from multiple sources to be loaded into a data warehouse is called ________. A) normalization b) loading C) extraction D) transformation

C) extraction

Services: A) are tangible b) can be inventoried C) have short lead times D) are often capital intensive

C) have short lead times

Consumer Reports is a magazine that tests consumer products in its labs and disseminates information on the results so consumers can compare brands. Hence, Consumer Reports is an example of a(n) ________. a) intranet b) e-marketplace C) infomediary D) virtual market

C) infomediary

__________ planning such as sales and operations planning seeks to identify and target customer demands for aggregate product families and to establish the inventory and capacity plans needed to satisfy these overall demands. A) strategic b) operational C) tactical D) Both tactical and operational E) None

C) tactical

Registering a replica site with a misspelling in the trademark name that users might easily mistake for the real thing, and displaying negative information about the actual company on the replica site is called ________. A) cybersquatting B) online identity C) typo squatting d) phishing

C) typo squatting

What has become a particular focus of logistics management in the past few years? A) supply chain management software B) supply chain management deployment C)Supply chain sustainability D) All the above

C)Supply chain sustainability

Which of the following is true of compliance reporting? A)Compliance reports primarily help in identifying events that fall outside accepted ranges. B) In the United States, the South Eastern Conference (SEC) mandates all aspects of compliance. C)Supply chain management systems carry the major burden of compliance reporting. D) Compliance reports relying on XBRL are more advanced than electronic PDFs.

Compliance reports relying on XBRL are more advanced than electronic PDFs.

_________ is the management of the customer interface, including all aspects of order processing and fulfillment. A) supplier management b) customer management c) logistics managment d) all E) none

Customer management

Why is it a challenge for organizations to implement supply chain management software in developing countries? A) software compatibility issues B) 24/7 access C) language and currency discrepancies D) All of the above

D) All of the above

Which of the following is true regarding the use of electronic data interchange (EDI) between partner companies in a supply chain? A) EDI takes very little time to set up b) EDI enables companies to easily switch partners when required C) EDI more flexible than systems with machine-readable formats D)EDI often relies on private networks and proprietary software

D) EDI often relies on private networks and proprietary software

Which of the following technologies is better equipped than relational databases to handle big data? A) SQL server B) MySQL C) ETL D) Hadoop

D) Hadoop

________ is a website structure in which the top-level homepage contains links to second-level pages, which then link to further relevant pages. A) multidimensional website architecture B) sequential architecture C) flat website architecture D) Hierarchical website archetutrue

D) Hierarchical website architecture

Which of the following is true about assistive technologies? A)Assistive technologies, such as screen readers for the visually impaired, are high-tech devices and software that help people with disabilities. B) Making accessibility changes after completing the entire website broadens the potential base of customers and thus makes good business sense. C) Designers should address accessibility issues in the site's information architecture, with design elements that work well with assistive technologies such as optical scanners. D) Offering tutorials to help organizations improve their sites and understand how design techniques can radically alter a site's accessibility.

D) Offering tutorials to help organizations improve their sites and understand how design techniques can radically alter a site's accessibility.

Which of the following was not a motivating force behind the adoption of a supply chain management? A) improved communication brought about by better tech B) recognition that customer decision dictate costs for suppliers C) increased competition D) cost-cutting efforts by dominant companies in supply chains

D) cost cutting efforts by dominant companies in supply chains

The goal of using XBRL in compliance reporting is to ________. A) identify events that fall outside accepted ranges b) encourage diversity in reporting practices C) create streamlined, manual workflows D) develop a common language for financial reporting

D) develop a common language for financial reporting

During a time of global competition in the 1970s to 1990s, ________ emerged as key technical advances. A) interchangable parts and emerging transportation networks B) movement to urban areas and new machines and economies of scale C) increased automation and the introduction of computers and quantitive analysis D) just in time systems and the emergence of stat process control E) Internet and enhanced communication and transportation technologies

D) just in time systems and the emergence of stat process control

Demand forecast accuracy is important because underestimating demand leads to ________. A) customer satisfaction b) discount blowouts C) high inventory costs D) lost sales

D) lost sales

Which of the following would improve a website's accessibility? A)creating very tiny clickable areas B) using fixed text sizes C) using click her for more rather than more on cosmetic dentistry D) making bold headings, short paragraphs, and orderly paragraph arrangements

D) making bold headings, short paragraphs, and orderly paragraph arrangements

The database model that organizes information into tables of records that are connected to one another by linking a field in one table to a field in another table is called ________. A) hierarchical database B) object-oriented database C) Network Database D) relational database

D) relational database

Which of the following uses databases without boundaries? A) bank website b) management information system c) government website offering info to visitors D) social networking website

D) social networking website

Consistency in a company's financial management system is maintained by ________. A) creating compliance reports that conform to international regulations B)generating exception reports regarding unusual financial events C)supporting multiple finance-related activities and processes D)creating bridges and interfaces to other information systems

D)creating bridges and interfaces to other information systems

An online retail website has a low rate of customer retention. Which of the following would be the most effective way to help the company increase its retention rate? A)promoting the website through conventional advertising to gain visibility B)building seamless financial workflows C)using uninvited pop-up chat to encourage customers to buy products D)using a CRM system to track customer behavior when they visit the site

D)using a CRM system to track customer behavior when they visit the site

What are the functions of database management software (DBMS)? Name some common database management software.

Database management software (DBMS) is used to create and manage the database. It provides tools for ensuring security, replication, retrieval, and other administrative and housekeeping tasks. The DBMS serves as a kind of gateway to the database itself and as a manager for handling creation, performance tuning, transaction processing, general maintenance, access rights, deletion, and backups. Microsoft Access, Microsoft SQL Server, Oracle, and MySQL are some commonly used DBMS.

Which of the following statements is true? A) logistics and supply chain are same B) physical distribution and logistics are the same C) transportation and logistics are same D) supply chain is a subset of logistics E) logistics is a subset of supply chain

E) logistics is a subset of supply chain

A supply chain is the global network of organizations and activities involved in: A) designing a set of goods and services and their related processes B) transforming inputs into goods and services C) consuming these goods and services D) disposing of these goods and services E) ALL

E- all

How does exception reporting differ from compliance reporting?

Exception reports can help identify events that fall outside accepted ranges. Financial systems generate exception reports that automatically tag unusual events-ones that human beings must review. Such reports are used to spot mistakes and fraud. For example, average losses per incident may not be huge, but if the same mistake or fraud is repeated over and over, major losses can add-up. For example, if sales reps exaggerate mileage for trips, or travelers submit receipts twice, exception reports would spot the fraud.Financial systems also carry the major burden of compliance reporting, and in doing so they must conform to local, national, and international regulations that grow increasingly strict. In the United States, the Security and Exchange Commission (SEC) mandates many aspects of compliance, and electronic reporting is required, relying on eXtensible Business Reporting Language.

How are databases used across organizational boundaries? Illustrate with an example.

In databases without boundaries, people outside the enterprise enter and manage most of the records. For example, Craig Newmark, founder of Craigslist.com, initially sought to help people in San Francisco find apartments and jobs. Craigslist is very customer-centric, and although the enterprise owns the database, the records are almost completely created by its customers. The site relies on the community of users-not just to generate all the ads, but also to reply privately to inquiries outside the Craigslist site. Compared to other websites with the same level of traffic, Craigslist employs extremely few people. Like other networking sites, this one provides a framework that works for a growing community of users who pay nothing to use it, and they are the ones who make it successful.

What are the ways in which information is classified in terms of structure? Explain with examples.

Information is classified into three types, based on how ordered and organized it is. Facts and data that are reasonably ordered, can be broken down into component parts, and organized into hierarchies are called structured information. For example, a credit card company maintains customer records in a structured format with elements such as last name, first name, street address, phone number, and email address.Information that has no inherent structure or order is called unstructured information. For example, a manila folder in which educational certificates, employment records, bills, warranties, and medical prescriptions are stored.The information category that falls between structured and unstructured information is called semi-structured information. It includes facts and data that show at least some structure, such as web pages and documents, which bear creation dates, titles, and authors

List some of the common metrics used in HCM systems.

Some common HCM metrics include:1. Turnover: The percentage of workers who left and were replaced during a time period2. Turnover costs: The total of termination costs, hiring costs, training costs, and other costs related to replacing a worker3. Cost per hire: Average advertising costs + agency fees + recruiter's salary and benefits + relocation expenses for new employees4. Human capital return on investment: The return on investment produced by an organization's expenditures on salaries, benefits, bonuses, and other costs for human talent5. Employee satisfaction: Measures of job satisfaction, usually assessed through employee surveys or exit interviews

What are the requirements for successful master data management?

The most successful efforts at master data management focus on a limited number of entities that are most important, or on key areas, such as customers. Teams from different business units participate in master data management to negotiate and resolve differences. Select people, called data stewards, have to skillfully persuade people to reconcile different formats and meanings in the multiple databases, especially because the benefits may seem somewhat remote to those less concerned about summary reports that conflict. Master data management depends largely on people, processes, and governance. Good coordination among organizational units and persuasive stewards are essential to the integration process.

Chad Autry believes social issues- not just production, transportation, storage, and demand planning and management - should be a key pillar in supply chain metrics True/False

True

Changes to an integrated database take less time from IT but more from the end users. True False

True

Cloud computing, social networking and collaborative platforms are emerging as foundations for manufacturers to build global quality control ecosystems. T/F

True

DBMS separate the logical and physical views of data true false

True

Every characteristic or quality describing a particular entity is called an attribute True False

True

For using the web, mouse foot pedals, screen readers, Braille displays, head-mounted pointers, joysticks, and speech-to-text translators for the deaf can all improve access. T/F

True

Functional groups directly concerned with customer management have names such as distribution, sales, order fulfillment, and customer service T/F

True

Implementing ERPs very often result in dismal success rates and runaway costs. T/F

True

Online magazines usually have the primary web goal of informing or entertaining the audience. T/F

True