WorksheetsCompre-Intervention-IS101-Finals
Total questions: 70
Worksheet time: 35mins
A small Filipino craft store wants to expand internationally without building physical branches abroad. Which e-commerce benefit primarily enables this?
Reduced transaction visibility
Global market reach
Faster shipping
Automated returns
Same-day dispatch
A logistics company uses GPS to offer real-time delivery tracking through an app. This feature best illustrates which m-commerce advantage?
Reduced customer expectations
Location-based services
Lower security requirements
Manual transaction processing
Cash-only settlements
A university uses an internal platform that gives staff discounts on canteen meals and merchandise. This represents what model?
B2C
C2C
B2E
G2G
C2B
A customer receives a fake email pretending to be from an online bank asking her to “verify her login.” This describes which threat?
Keylogging
Malware injection
Phishing
Data redundancy
POS downtime
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:
M-Commerce application
Wholesale procurement
Purely offline engagement
ERP integration only
Non-digital marketing
A B2B client orders 10,000 units of raw materials monthly via automated invoicing. What is the most defining feature of this interaction?
Government compliance
Business-to-business exchange
Random consumer bidding
High product personalization
Content subscription model
A customer abandons an online purchase after seeing unexpected “international handling charges.” This represents which e-commerce issue?
Personalized pricing
Hidden fees
A bakery selling cakes online benefits most from what e-commerce advantage?
Instant digital delivery
24/7 operations
Elimination of logistics
Guaranteed product quality
No competition
A local business adopts PayMaya QR codes for payments. This demonstrates which trend in commerce?
Non-digital remittances
Secure digital payment systems
Decline of mobile apps
Manual ledgers
Limited transaction verification
A company monitors social media for customer complaints and responds through automated chatbots. This practice is part of:
Cross-border taxation
Omnichannel strategy
Product recall
Manual paging services
Warehouse-only operations
An airline uses mobile boarding passes to reduce printed documents. This application belongs to:
Supply chain management
M-commerce
Offline ticketing
Traditional procurement
Inventory auditing
A seller uses online ads to reach users likely to buy based on recent searches. Which capability is used?
Anonymous marketing
Personalized targeting
Random distribution
Low-cost warehousing
C2C broadcasting
An online marketplace allows freelancers to offer graphic design services to corporations. This is:
C2B
B2E
B2C
G2C
C2C
A consumer cannot inspect fragile antiques before buying online. This illustrates a limitation of e-commerce called:
Lack of product comparison
Difficulty inspecting goods
Limited product variety
Faster delivery issues
POS inaccuracy
A small startup fails to adopt new e-commerce technology because employees lack technical skills. This issue refers to:
Limited internet access
Skill shortages
Government overregulation
Hidden charges
Overstaffing
A government portal allowing citizens to renew IDs online operates under which model?
B2B
G2C
C2C
B2E
B2G
A business replaces its manual purchase order system with automated EDI transactions. What is achieved?
Slower processing
Electronic document exchange
Higher physical paperwork
Reduced automation
Manual-only verification
A company notices conflicting sales reports because each department uses a separate spreadsheet. This issue demonstrates:
Perfect data governance
Data silos
Automated replication
Instant consolidation
Universal schema adoption
A school database table contains StudentID, Name, and Program. StudentID is likely a:
Redundant attribute
Foreign key
Primary key
Non-unique identifier
Derived field
A hospital updates patient records and must ensure changes remain even after a system crash. Which ACID property ensures this?
Atomicity
Consistency
Isolation
Durability
Volatility
A system rejects an employee record because a required field is blank. This rule is enforced by which constraint?
UNIQUE
NOT NULL
FOREIGN KEY
ENUM
GREATER THAN
A student enrollment record links a StudentID to a CourseCode. This relationship uses which key?
Private key
Temporal key
Foreign key
Virtual key
Random code
A company wants real-time data access across multiple countries with synchronized systems. Which database design best supports this?
Flat files
Distributed database
Local CSV logs
Paper-based ledgers
Single offline server
A project suffers delays because outdated data was used to estimate risks. This reflects which data management problem?
Perfect accuracy
High reliability
Poor data quality
Automated validation
Strong data lineage
A web application requires a fast, open-source RDBMS commonly used with PHP. Which is appropriate?
Oracle
MySQL
MongoDB
Redis
SAP HANA
A database transaction fails halfway and the entire operation is reversed. What principle is shown?
Redundancy
Atomicity
Parallelism
Normalization
Durability
A manager runs a query to get all BSCs students. This operation uses:
SQL
HTML
BIOS
JSON
SMTP
A company needs a full audit trail to ensure financial records stay valid before and after updates. This refers to which ACID component?
Volatility
Consistency
Rejection control
Encryption
Deletion cascade
A retail database must ensure product prices do not have duplicates. This constraint is enforced by:
NOT NULL
UNIQUE
FOREIGN KEY
TEXT
ANY
A cloud-native DBMS allows horizontal scaling for global users. This characteristic aligns with:
Centralized-only storage
Non-distributed systems
Modern DBMS evolution
Offline-first architecture
Isolated computing
A manager wants to minimize errors caused by inconsistent data entry formats. The best solution is:
Manual corrections
Random updates
Standardized input procedures
Removing validation
Increasing record deletions
Integrating all project data into one repository mainly improves:
System fragmentation
Data redundancy
Real-time consistency
Manual auditing
Spreadsheet dependency
A project team faces resistance to new database systems. This challenge relates to:
Data cleansing
Change management
Table indexing
GDPR emphasizes the need for:
Random data sharing
Minimal auditing
Strict data protection and access control
Unrestricted user access
No encryption at all
A fast-food chain analyzes lunch sales to determine which meal combos sell the most. This converts raw data into:
Random facts
Wisdom
Information
Noise
Redundant entries
A retailer finds through BI that customers who buy noodles also often buy soft drinks. This insight represents:
Data only
Knowledge
Static facts
Unstructured noise
Irrelevant metadata
A company uses insights to redesign its menu and pair popular dishes. This step belongs to:
Data
Information
Knowledge
Wisdom
Static storage
A BI dashboard shows branch performance with updated graphs every hour. This tool belongs to which BI component?
ETL
Data warehouse
Visualization/dashboard
Model base
File server
A manufacturer integrates POS data with social media sentiment to analyze customer preferences. These are examples of:
Physical sources
Internal & external data sources
Irrelevant artifacts
Device logs
Isolated inputs
Before loading into the warehouse, data must be cleaned and standardized. This process is found in:
OLAP
ETL
Knowledge base
AI modeling
Visualization
A manager explores sales by region, month, and product category. This multidimensional view reflects:
EDI
OLAP
SWOT
SMTP
FIFO
UPS uses route optimization through analytics to reduce fuel and time. This is a BI application in:
HR
Operations & logistics
Finance
Retail
Gaming
Starbucks uses BI to personalize offers in its mobile app. This demonstrates BI for:
Inventory depletion
Sales & marketing
Structural auditing
Labor-only analysis
Code refactoring
A firm automates data preparation using AI tools that generate insights through natural language. This trend is called:
Augmented analytics
Manual processing
Static reporting
Data removal
Flat-file modeling
A business owner relies on BI to spot declining product categories. This reflects which BI benefit?
Random movement
Early detection of risks
Isolated processing
Manual-only insights
Non-predictive analysis
A financial firm uses Power BI to analyze risk-adjusted returns. This activity belongs to which domain?
Manufacturing
Finance
Hospitality
Agriculture
Transportation
Employees refuse to use a new BI dashboard due to its complexity. This challenge reflects:
Data scarcity
User resistance
Perfect adoption
Low security concerns
Universal acceptance
A BI system struggles because the old system can’t integrate with it. This is a challenge of:
Legacy system integration
Perfect synchronization
Unlimited compatibility
Predictive modeling
None
A CEO views real-time sales heatmaps and monthly revenue trends. This functionality belongs to:
Encryption systems
BI dashboards
Archive logs
Basic text editors
Unlinked spreadsheets
A retail app uses analytics to predict what products a customer is likely to order next. This is an example of:
Static logs
Predictive insights
Redundant reporting
Manual observation
Zero personalization
A BI report misleads managers because values were inconsistent across branches. This issue refers to:
Data quality problems
Perfect validation
Complete accuracy
Global standardization
Automatic cleanup
A company analyzes employee attrition to improve retention strategies. This is BI used in:
HR
Sales
Database administration
Marine biology
Nuclear physics
A hospital uses a DSS to analyze treatment outcomes and simulate patient recovery options. This role best describes DSS as assisting in:
Simple, routine tasks
Semi-structured decisions
Packaging inventory
Short-term errands
Purely structured tasks
A company uses an IDSS combining data collection and decision models. This means IDSS integrates:
IS only
DSS only
IS + DSS
HR + Finance
Storage only
A bank manager evaluates loan applications using risk analysis tools. This uses which DSS component?
Model base
File archive
Printer queue
Basic UI
Keyboard function
A DSS database integrates internal transaction logs with external economic datasets. This feature allows:
Irrelevant merging
Broader data access for decision-making
Removal of historical data
Restricted inputs only
No external linkage
A user interacts with a DSS through menus, forms, and reports. This is handled by the:
Power supply
Dialogue manager / UI
Router
File compressor
RAM
A firm uses a knowledge-driven DSS that suggests diagnoses for machine failures. This system provides:
Random opinions
Uninformed guesses
Expert-like recommendations
Hardware controls
Manual-only prompts
A remote team collaborates using a system that supports brainstorming, voting, and shared documents. This describes:
Antivirus
Group Decision Support System
Security appliance
Network switch
Spreadsheet tool
An executive monitors high-level KPIs like revenue, market share, and regional performance. This system is:
POS terminal
Executive Support System
General ledger
Low-level robot
Enrollment kiosk
The primary goal of IDSS in organizations is to:
Delay decisions
Improve decision quality
Create redundant reports
Eliminate all managers
Randomize data
A public agency uses DSS simulations to model disaster evacuation routes. This is an example of:
Entertainment
Strategic analysis
Online shopping
Point-of-sale
Idle computations
A DSS that forecasts product demand uses what-if simulations. This belongs to which part of DSS?
Model base
Archive base
Clipboard
Router storage
Basic layout
A manager can quickly view a summarized performance report instead of raw data. This feature is characteristic of:
ESS
BIOS
Manual drafting
Keylogging
CSV-only access
A company implementing a new DSS faces employee resistance. What principle is needed to manage this?
Denormalization
Change management
Hardware tuning
SQL parsing
Network isolation
An organization must restrict DSS data access only to authorized users. This requirement is linked to:
GDPR compliance
No data governance
Unlimited permissions
Free-for-all access
No scanning at all
A university uses IDSS to support enrollment forecasting and staffing plans. IDSS mainly supports:
Non-decision tasks
Organizational planning
Randomized events
Unstructured errors
Manual-only notes
A retail manager interacts with charts and dashboards to choose between promotional strategies. This emphasizes DSS providing:
Tactical & strategic decision support
Raw data archiving
Low-level hardware control
Simple text editing
A city government uses GSS to collect feedback from multiple departments during policy formulation. This helps enhance:
Fragmented communication
Collaborative decision-making
Solo decision-making
Keyboard shortcuts
Network failure rates
A knowledge-based DSS uses embedded rules to recommend solutions. This feature:
Removes all intelligence
Limits decision-making
Mimics expert reasoning
Disallows automation
Replaces all data sources
