ITM 100 M/C Examples 2 2025/2026 Midterm Review

Identify the key term based on a definition

The technical term for a row in a relational database table is a/an:

a)Tuple

b)Primary key

c)Element

d)Key field

e)Attribute

a) Tuple

Recognize a key term described in an example

Which of the following technologies would you consider to support and assist in making a long-range strategic decision such as launching a new product?

a)TPS

b)DSS

c)DBMS

d)BI

e)ETL

b) DSS

Fill in the blanks in the form of multiple choice

A(n) ________ system centralizes data from various key business processes and stores the data in a single, comprehensive data repository, and usable by all units of the organization.

a)Transaction processing system

b)Enterprise system

c)Automatic reporting system

d)Management information system

e)Operational management system

b) Enterprise system

Fill in the blanks in the form of multiple choice

In a DBMS the _____ presents the data as they would be perceived by end users, whereas the _______ shows how data are actually organized and structured on the computer’s storage media.

a)linear view, lateral view

b)physical view, logical view

c)logical view, physical view

d)user’s view, computer’s view

e)computer’s view, user’s view

c) logical view, physical view

Which of the following is NOT correct?

a)Blockchain is a distributed ledger system

b)CRM systems provide a single point for users to manage and evaluate marketing campaigns across multiple channels

c)A DBMS contains multiple redundant copies of all data entities

d)Global Supply Chains are complex and easier to manage with SCM systems

c) A DBMS contains multiple redundant copies of all data entities

In computer technology (hardware and software) the Operating System (OS)…

a)Provides an interface between the user and the technology platform

b)Provide integration between the hardware, the application systems and the databases

c)Is specific to the underlying hardware, e.g., MS Windows on Intel hardware

d)A) and B)

e)All of the above

e) All of the above

All of the following statements are true EXCEPT:

a)A foreign key is used to link tables in a relational database.

b)A primary key is made of exactly one field.

c)A foreign key in one table is a primary key in another table.

d)A primary key must have a unique value for each record in the table.

e)Each table must have at least one key field.

b) A primary key is made of exactly one field.

Which one of the following is not a part of a typical business intelligence environment?

a)Business data

b)Business intelligence data warehouse

c)Managerial users and methods

d)Data centre

e)Data analytic tools and techniques

d) Data centre

In our organization, we need users to obtain online answers to ad-hoc questions in a rapid amount of time. Which one of the following tools will be helpful?

a)OLAP

b)Web Mining

c)Data Mining

d)Data warehouse

e)DBMS such as Oracle

a) OLAP

As a sales manager, it is your responsibility to track sales of your company’s products. You notice that your sales numbers are down. What is the period of time called when you have the information and before you are able to take action?

a)Data latency

b)Decision latency

c)Memory latency

d)Analysis paralysis

e)Action elapsed time

b) Decision latency