wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Compre-Intervention-IS101-Finals

Total questions: 70

Worksheet time: 35mins

Name
Class
Date
1.

A small Filipino craft store wants to expand internationally without building physical branches abroad. Which e-commerce benefit primarily enables this?

a)

Reduced transaction visibility

b)

Global market reach

c)

Faster shipping

d)

Automated returns

e)

Same-day dispatch

2.

A logistics company uses GPS to offer real-time delivery tracking through an app. This feature best illustrates which m-commerce advantage?

a)

Reduced customer expectations

b)

Location-based services

c)

Lower security requirements

d)

Manual transaction processing

e)

Cash-only settlements

3.

A university uses an internal platform that gives staff discounts on canteen meals and merchandise. This represents what model?

a)

B2C

b)

C2C

c)

B2E

d)

G2G

e)

C2B

4.

A customer receives a fake email pretending to be from an online bank asking her to “verify her login.” This describes which threat?

a)

Keylogging

b)

Malware injection

c)

Phishing

d)

Data redundancy

e)

POS downtime

5.

A retail company uses QR-based kiosks in malls that allow customers to scan codes and place orders from their phones. This is an example of:

a)

M-Commerce application

b)

Wholesale procurement

c)

Purely offline engagement

d)

ERP integration only

e)

Non-digital marketing

6.

A B2B client orders 10,000 units of raw materials monthly via automated invoicing. What is the most defining feature of this interaction?

a)

Government compliance

b)

Business-to-business exchange

c)

Random consumer bidding

d)

High product personalization

e)

Content subscription model

7.

A customer abandons an online purchase after seeing unexpected “international handling charges.” This represents which e-commerce issue?

a)

Personalized pricing

b)

Hidden fees

8.

A bakery selling cakes online benefits most from what e-commerce advantage?

a)

Instant digital delivery

b)

24/7 operations

c)

Elimination of logistics

d)

Guaranteed product quality

e)

No competition

9.

A local business adopts PayMaya QR codes for payments. This demonstrates which trend in commerce?

a)

Non-digital remittances

b)

Secure digital payment systems

c)

Decline of mobile apps

d)

Manual ledgers

e)

Limited transaction verification

10.

A company monitors social media for customer complaints and responds through automated chatbots. This practice is part of:

a)

Cross-border taxation

b)

Omnichannel strategy

c)

Product recall

d)

Manual paging services

e)

Warehouse-only operations

11.

An airline uses mobile boarding passes to reduce printed documents. This application belongs to:

a)

Supply chain management

b)

M-commerce

c)

Offline ticketing

d)

Traditional procurement

e)

Inventory auditing

12.

A seller uses online ads to reach users likely to buy based on recent searches. Which capability is used?

a)

Anonymous marketing

b)

Personalized targeting

c)

Random distribution

d)

Low-cost warehousing

e)

C2C broadcasting

13.

An online marketplace allows freelancers to offer graphic design services to corporations. This is:

a)

C2B

b)

B2E

c)

B2C

d)

G2C

e)

C2C

14.

A consumer cannot inspect fragile antiques before buying online. This illustrates a limitation of e-commerce called:

a)

Lack of product comparison

b)

Difficulty inspecting goods

c)

Limited product variety

d)

Faster delivery issues

e)

POS inaccuracy

15.

A small startup fails to adopt new e-commerce technology because employees lack technical skills. This issue refers to:

a)

Limited internet access

b)

Skill shortages

c)

Government overregulation

d)

Hidden charges

e)

Overstaffing

16.

A government portal allowing citizens to renew IDs online operates under which model?

a)

B2B

b)

G2C

c)

C2C

d)

B2E

e)

B2G

17.

A business replaces its manual purchase order system with automated EDI transactions. What is achieved?

a)

Slower processing

b)

Electronic document exchange

c)

Higher physical paperwork

d)

Reduced automation

e)

Manual-only verification

18.

A company notices conflicting sales reports because each department uses a separate spreadsheet. This issue demonstrates:

a)

Perfect data governance

b)

Data silos

c)

Automated replication

d)

Instant consolidation

e)

Universal schema adoption

19.

A school database table contains StudentID, Name, and Program. StudentID is likely a:

a)

Redundant attribute

b)

Foreign key

c)

Primary key

d)

Non-unique identifier

e)

Derived field

20.

A hospital updates patient records and must ensure changes remain even after a system crash. Which ACID property ensures this?

a)

Atomicity

b)

Consistency

c)

Isolation

d)

Durability

e)

Volatility

21.

A system rejects an employee record because a required field is blank. This rule is enforced by which constraint?

a)

UNIQUE

b)

NOT NULL

c)

FOREIGN KEY

d)

ENUM

e)

GREATER THAN

22.

A student enrollment record links a StudentID to a CourseCode. This relationship uses which key?

a)

Private key

b)

Temporal key

c)

Foreign key

d)

Virtual key

e)

Random code

23.

A company wants real-time data access across multiple countries with synchronized systems. Which database design best supports this?

a)

Flat files

b)

Distributed database

c)

Local CSV logs

d)

Paper-based ledgers

e)

Single offline server

24.

A project suffers delays because outdated data was used to estimate risks. This reflects which data management problem?

a)

Perfect accuracy

b)

High reliability

c)

Poor data quality

d)

Automated validation

e)

Strong data lineage

25.

A web application requires a fast, open-source RDBMS commonly used with PHP. Which is appropriate?

a)

Oracle

b)

MySQL

c)

MongoDB

d)

Redis

e)

SAP HANA

26.

A database transaction fails halfway and the entire operation is reversed. What principle is shown?

a)

Redundancy

b)

Atomicity

c)

Parallelism

d)

Normalization

e)

Durability

27.

A manager runs a query to get all BSCs students. This operation uses:

a)

SQL

b)

HTML

c)

BIOS

d)

JSON

e)

SMTP

28.

A company needs a full audit trail to ensure financial records stay valid before and after updates. This refers to which ACID component?

a)

Volatility

b)

Consistency

c)

Rejection control

d)

Encryption

e)

Deletion cascade

29.

A retail database must ensure product prices do not have duplicates. This constraint is enforced by:

a)

NOT NULL

b)

UNIQUE

c)

FOREIGN KEY

d)

TEXT

e)

ANY

30.

A cloud-native DBMS allows horizontal scaling for global users. This characteristic aligns with:

a)

Centralized-only storage

b)

Non-distributed systems

c)

Modern DBMS evolution

d)

Offline-first architecture

e)

Isolated computing

31.

A manager wants to minimize errors caused by inconsistent data entry formats. The best solution is:

a)

Manual corrections

b)

Random updates

c)

Standardized input procedures

d)

Removing validation

e)

Increasing record deletions

32.

Integrating all project data into one repository mainly improves:

a)

System fragmentation

b)

Data redundancy

c)

Real-time consistency

d)

Manual auditing

e)

Spreadsheet dependency

33.

A project team faces resistance to new database systems. This challenge relates to:

a)

Data cleansing

b)

Change management

c)

Table indexing

34.

GDPR emphasizes the need for:

a)

Random data sharing

b)

Minimal auditing

c)

Strict data protection and access control

d)

Unrestricted user access

e)

No encryption at all

35.

A fast-food chain analyzes lunch sales to determine which meal combos sell the most. This converts raw data into:

a)

Random facts

b)

Wisdom

c)

Information

d)

Noise

e)

Redundant entries

36.

A retailer finds through BI that customers who buy noodles also often buy soft drinks. This insight represents:

a)

Data only

b)

Knowledge

c)

Static facts

d)

Unstructured noise

e)

Irrelevant metadata

37.

A company uses insights to redesign its menu and pair popular dishes. This step belongs to:

a)

Data

b)

Information

c)

Knowledge

d)

Wisdom

e)

Static storage

38.

A BI dashboard shows branch performance with updated graphs every hour. This tool belongs to which BI component?

a)

ETL

b)

Data warehouse

c)

Visualization/dashboard

d)

Model base

e)

File server

39.

A manufacturer integrates POS data with social media sentiment to analyze customer preferences. These are examples of:

a)

Physical sources

b)

Internal & external data sources

c)

Irrelevant artifacts

d)

Device logs

e)

Isolated inputs

40.

Before loading into the warehouse, data must be cleaned and standardized. This process is found in:

a)

OLAP

b)

ETL

c)

Knowledge base

d)

AI modeling

e)

Visualization

41.

A manager explores sales by region, month, and product category. This multidimensional view reflects:

a)

EDI

b)

OLAP

c)

SWOT

d)

SMTP

e)

FIFO

42.

UPS uses route optimization through analytics to reduce fuel and time. This is a BI application in:

a)

HR

b)

Operations & logistics

c)

Finance

d)

Retail

e)

Gaming

43.

Starbucks uses BI to personalize offers in its mobile app. This demonstrates BI for:

a)

Inventory depletion

b)

Sales & marketing

c)

Structural auditing

d)

Labor-only analysis

e)

Code refactoring

44.

A firm automates data preparation using AI tools that generate insights through natural language. This trend is called:

a)

Augmented analytics

b)

Manual processing

c)

Static reporting

d)

Data removal

e)

Flat-file modeling

45.

A business owner relies on BI to spot declining product categories. This reflects which BI benefit?

a)

Random movement

b)

Early detection of risks

c)

Isolated processing

d)

Manual-only insights

e)

Non-predictive analysis

46.

A financial firm uses Power BI to analyze risk-adjusted returns. This activity belongs to which domain?

a)

Manufacturing

b)

Finance

c)

Hospitality

d)

Agriculture

e)

Transportation

47.

Employees refuse to use a new BI dashboard due to its complexity. This challenge reflects:

a)

Data scarcity

b)

User resistance

c)

Perfect adoption

d)

Low security concerns

e)

Universal acceptance

48.

A BI system struggles because the old system can’t integrate with it. This is a challenge of:

a)

Legacy system integration

b)

Perfect synchronization

c)

Unlimited compatibility

d)

Predictive modeling

e)

None

49.

A CEO views real-time sales heatmaps and monthly revenue trends. This functionality belongs to:

a)

Encryption systems

b)

BI dashboards

c)

Archive logs

d)

Basic text editors

e)

Unlinked spreadsheets

50.

A retail app uses analytics to predict what products a customer is likely to order next. This is an example of:

a)

Static logs

b)

Predictive insights

c)

Redundant reporting

d)

Manual observation

e)

Zero personalization

51.

A BI report misleads managers because values were inconsistent across branches. This issue refers to:

a)

Data quality problems

b)

Perfect validation

c)

Complete accuracy

d)

Global standardization

e)

Automatic cleanup

52.

A company analyzes employee attrition to improve retention strategies. This is BI used in:

a)

HR

b)

Sales

c)

Database administration

d)

Marine biology

e)

Nuclear physics

53.

A hospital uses a DSS to analyze treatment outcomes and simulate patient recovery options. This role best describes DSS as assisting in:

a)

Simple, routine tasks

b)

Semi-structured decisions

c)

Packaging inventory

d)

Short-term errands

e)

Purely structured tasks

54.

A company uses an IDSS combining data collection and decision models. This means IDSS integrates:

a)

IS only

b)

DSS only

c)

IS + DSS

d)

HR + Finance

e)

Storage only

55.

A bank manager evaluates loan applications using risk analysis tools. This uses which DSS component?

a)

Model base

b)

File archive

c)

Printer queue

d)

Basic UI

e)

Keyboard function

56.

A DSS database integrates internal transaction logs with external economic datasets. This feature allows:

a)

Irrelevant merging

b)

Broader data access for decision-making

c)

Removal of historical data

d)

Restricted inputs only

e)

No external linkage

57.

A user interacts with a DSS through menus, forms, and reports. This is handled by the:

a)

Power supply

b)

Dialogue manager / UI

c)

Router

d)

File compressor

e)

RAM

58.

A firm uses a knowledge-driven DSS that suggests diagnoses for machine failures. This system provides:

a)

Random opinions

b)

Uninformed guesses

c)

Expert-like recommendations

d)

Hardware controls

e)

Manual-only prompts

59.

A remote team collaborates using a system that supports brainstorming, voting, and shared documents. This describes:

a)

Antivirus

b)

Group Decision Support System

c)

Security appliance

d)

Network switch

e)

Spreadsheet tool

60.

An executive monitors high-level KPIs like revenue, market share, and regional performance. This system is:

a)

POS terminal

b)

Executive Support System

c)

General ledger

d)

Low-level robot

e)

Enrollment kiosk

61.

The primary goal of IDSS in organizations is to:

a)

Delay decisions

b)

Improve decision quality

c)

Create redundant reports

d)

Eliminate all managers

e)

Randomize data

62.

A public agency uses DSS simulations to model disaster evacuation routes. This is an example of:

a)

Entertainment

b)

Strategic analysis

c)

Online shopping

d)

Point-of-sale

e)

Idle computations

63.

A DSS that forecasts product demand uses what-if simulations. This belongs to which part of DSS?

a)

Model base

b)

Archive base

c)

Clipboard

d)

Router storage

e)

Basic layout

64.

A manager can quickly view a summarized performance report instead of raw data. This feature is characteristic of:

a)

ESS

b)

BIOS

c)

Manual drafting

d)

Keylogging

e)

CSV-only access

65.

A company implementing a new DSS faces employee resistance. What principle is needed to manage this?

a)

Denormalization

b)

Change management

c)

Hardware tuning

d)

SQL parsing

e)

Network isolation

66.

An organization must restrict DSS data access only to authorized users. This requirement is linked to:

a)

GDPR compliance

b)

No data governance

c)

Unlimited permissions

d)

Free-for-all access

e)

No scanning at all

67.

A university uses IDSS to support enrollment forecasting and staffing plans. IDSS mainly supports:

a)

Non-decision tasks

b)

Organizational planning

c)

Randomized events

d)

Unstructured errors

e)

Manual-only notes

68.

A retail manager interacts with charts and dashboards to choose between promotional strategies. This emphasizes DSS providing:

a)

Tactical & strategic decision support

b)

Raw data archiving

c)

Low-level hardware control

d)

Simple text editing

69.

A city government uses GSS to collect feedback from multiple departments during policy formulation. This helps enhance:

a)

Fragmented communication

b)

Collaborative decision-making

c)

Solo decision-making

d)

Keyboard shortcuts

e)

Network failure rates

70.

A knowledge-based DSS uses embedded rules to recommend solutions. This feature:

a)

Removes all intelligence

b)

Limits decision-making

c)

Mimics expert reasoning

d)

Disallows automation

e)

Replaces all data sources