wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

FINAL TEST MGT300 INFORMATION TECHNOLOGY IN BUSINESS

Total questions: 42

Worksheet time: 4hrs 50mins

Name
Class
Date
1.

Which of the following

represents the different information levels?

a)

Detail, summary, aggregate

b)

Individual, department, enterprise

c)

Document, presentation, spreadsheet, database

d)

Individual, document, presentation, spreadsheet, database

2.

What is one of the biggest pitfalls associated with real-time information?

a)

It is only available to high-level executives due to the expense

b)

It is only available in aggregate levels of granularity

c)

It continually changes

d)

It rarely changes

3.

Which of the following database structures stores information in a tree-like structure that allows repeating information using parent/child relationships, in such a way that it cannot have too many relationships?

a)

Hybrid database

b)

Network database

c)

Hierarchical database

d)

Relational database model

4.

In the relational database model, what is a person, place, thing, transaction, or event about which information is stored?

a)

Entity

b)

Attribute

c)

Constraint

d)

Relationships

5.

Which of the following is incorrect in reference to a database?

a)

Can be relational or network

b)

Information is accessed by logical structure

c)

Information is accessed by physical structure

d)

Users can access different views of information

6.

A data warehouse is a __________ collection of information-gathered from many different __________ databases-that supports business analysis activities and decision-making tasks.

a)

Physical, transactional

b)

Physical, operational

c)

Logical, transactional

d)

Logical, operational

7.

What is data mining?

a)

A particular attribute of information

b)

The common term for the representation of multidimensional information

c)

Process of analyzing data to extract information not offered by the raw data alone

d)

Uses a variety of techniques to find patterns and relationships in large volumes of information and infer rules from them that predict future behavior and guide decision making

8.

When does information cleansing occur in the data warehouse?

a)

During the ETL process

b)

On the information, once it is in the data warehouse

c)

During the ETL process and once it is in the data warehouse

d)

During the ETL process and before it is in the data warehouse

9.

Which of the following is the most commonly used form of AI in the business area?

a)

Neural network

b)

Expert systems

c)

Intelligent system

d)

Artificial intelligence

10.

What is an artificial intelligence system that mimics the evolutionary, survival-of-the-fittest process to generate increasingly better solutions to a problem?

a)

Neural network

b)

Intelligent system

c)

Genetic algorithm

d)

Artificial intelligence

11.

Which of the following is a form of statistical analysis?

a)

Market basket analysis

b)

Prediction of planning

c)

Cluster analysis

d)

Forecasting

12.

Which of the following is NOT of the main links in the supply chain?

a)

Materials flow from suppliers and their “downstream” suppliers at all levels

b)

Distribution of products to customers and their “downstream” customers at all levels

c)

Transformation of materials into semi finished and finished products – the organization’s own production processes

d)

Improve customer service levels are measured by on-time shipments of the right quality product in the appropriate quantity.

13.

DSSs allow managers to examine performance and relationships over the supply chain and among:

a)

Suppliers

b)

Transportation options

c)

Other factors that optimize supply chain performance

d)

All of the above

14.

What is the set of processes that plans for and controls the efficient and effective transportation and storage of suppliers from suppliers to customers?

a)

Logistics

b)

Demand planning

c)

Supply chain planning

d)

Supply chain execution

15.

What is an organization performing when it asks questions such as “why was customer revenue so high”?

a)

CRM reporting technologies

b)

CRM processing technologies

c)

CRM processing technologies

d)

CRM predicting technologies

16.

Which of the following is NOT CRM business drivers?

a)

Accountability

b)

Inventory control

c)

Increase revenues

d)

Automation/productivity/efficiency

17.

Which of the following analytical CRM tools slice-and-dice customer information to create made-to-order views?

a)

Supports traditional transactional processing

b)

Supports day-to-day front-office operations

c)

Supports operations that deal directly with the customers

d)

All of the above

18.

Who are the primary users of SCM systems?

a)

Sales, marketing, customer service

b)

Accounting, finance, logistics, and production

c)

Customers, resellers, partners, suppliers, and distributors

d)

Sales , customers, resellers, partners, suppliers, and distributors

19.

What is an IT–based set of tools that supports the work of teams by facilitating the sharing and flow of information?

a)

Collaboration system

b)

Structured collaboration

c)

Unstructured collaboration

d)

Content management system

20.

Which of the following is the top reason why organizations launch knowledge management systems?

a)

Reduce costs

b)

Increase profits or revenues

c)

Develop new products or services

d)

Improve customer retention and/or satisfaction

21.

Reports for each sales person, product, and part are examples of detail or fine information granularities.

a)

TRUE

b)

FALSE

22.

Timely information must be up-to-the-second to be accurate.

a)

TRUE

b)

FALSE

23.

Data-driven business intelligence occurs when users run queries or use analytical tools, such as a Pivot Table, on a database that is attached to a Web site.

a)

TRUE

b)

FALSE

24.

Relational integrity constraints are rules that enforce basic and fundamental information-based constraints.

a)

TRUE

b)

FALSE

25.

One of the advantages found in a relational database is increased information redundancy.

a)

TRUE

b)

FALSE

26.

The data warehouse is a location for all of a business’s information.

a)

TRUE

b)

FALSE

27.

Extraction, transformation, and loading is a process that extracts information from internal databases, transforms the information using a common set of enterprise definitions, and loads the information into an external database.

a)

TRUE

b)

FALSE

28.

The primary purpose of a data warehouse is to perform transactional processes

a)

TRUE

b)

FALSE

29.

A genetic algorithm is an artificial intelligence system that mimics the evolutionary, survival-of-the-fittest process to generate increasingly better solutions to a problem

a)

TRUE

b)

FALSE

30.

The ultimate goal of AI is the ability to build a system that can mimic human intelligence.

a)

TRUE

b)

FALSE

31.

Consolidation, drill-down, and slice-and-dice are the three most common capabilities offered in an EIS.

a)

TRUE

b)

FALSE

32.

The customers’ customer is upstream in the supply chain.

a)

TRUE

b)

FALSE

33.

Deploy in incremental phases and measure and communicate success is one of the keys to success for SCM.

a)

TRUE

b)

FALSE

34.

Information technology’s primary role in supply chain management is creating the integrations or tight process and information linkages between functions within a firm - such as marketing, sales, finance, manufacturing, and distribution – and between firms.

a)

TRUE

b)

FALSE

35.

RFM stands for Regency, Frequency, and Monetary.

a)

TRUE

b)

FALSE

36.

CRM is a technology based on the premise that those organizations that understand the needs of individual customers are best positioned to achieve sustainable competitive advantage in the future

a)

TRUE

b)

FALSE

37.

The primary difference between operational CRM and analytical CRM is the direct interaction between the organization and its suppliers.

a)

TRUE

b)

FALSE

38.

A collaboration system is an IT–based set of tools that supports the work of teams by facilitating the sharing and flow of information.

a)

TRUE

b)

FALSE

39.

E-commerce is the conducting of business on the Internet, not only buying and selling, but also serving customers and collaborating with business partners.

a)

TRUE

b)

FALSE

40.

One of the primary reasons for ERP explosive growth is that an ERP system is a logical solution to the many incompatible applications found in business today.

a)

TRUE

b)

FALSE

41.

Discuss any TWO (2) advantages of database from a business perspective.

4 lines
42.

Elaborate differences between E-Commerce and E-Business.

4 lines