Font size
WorksheetsFundamentals of Information Systems — MCQ Worksheet Extraction
Total questions: 77
Worksheet time: 39hrs 30mins
Which of the following best defines an information system (IS)?
A set of unrelated programs
A collection of interrelated components that collect, process, and disseminate data
A single database system
A network of computers only
The value of information is directly linked to:
Its accuracy
How it helps decision makers achieve goals
The number of users accessing it
The system’s hardware speed
Which of the following is NOT a component of a computer-based information system?
Hardware
Software
Procedures
Electricity
The activity of gathering and capturing raw data is called:
Input
Output
Processing
Feedback
E-commerce between companies and consumers is called:
B2B
C2C
B2C
P2P
Which of the following systems supports day-to-day business operations?
Executive Support Systems (ESS)
Management Information Systems (MIS)
Transaction Processing Systems (TPS)
Decision Support Systems (DSS)
DSS primarily supports:
Routine tasks
Problem-specific decision making
Payroll calculation
Data entry
Knowledge Management Systems (KMS) are designed to:
Store data temporarily
Create, share, and use organizational knowledge
Track customer orders
Manage employee attendance
M-commerce differs from e-commerce because:
It only involves desktop computers
It uses wireless handheld devices
It does not require internet access
It excludes financial services
Outsourcing in system development allows a company to:
Lose control over its data
Focus on core activities and delegate others
Increase internal costs
Reduce innovation
The ALU in the CPU is responsible for:
Storing data
Performing arithmetic and logical operations
Decoding instructions
Managing I/O devices
A group of 8 bits is known as:
Word
Byte
Register
Bus
Moore’s Law states that:
Processor speed halves every 18 months
Transistor density doubles every 18 months
Storage decreases every year
Software efficiency doubles annually
Cache memory is used to:
Replace hard disks
Speed up data access near the CPU
Store programs permanently
Transfer files between computers
The binary system uses:
8 symbols
10 digits
2 digits (0 and 1)
16 digits
The digital media equivalent of a printed book is called:
E-paper
E-book
Online catalog
PDF reader
Which of the following is a hardware device for reading e-books?
Kindle
iPod
iMac
Google Glass
The device that displays video in front of one eye using optical technology is called:
Virtual headset
Eyebud screen
LCD monitor
AR lens
Which organization uses special-purpose computers?
Schools
CIA and NASA
Banks
Small businesses
General-purpose computers are mainly used for:
One specific scientific task
Multiple general applications
Encryption only
A handheld computer is mainly characterized by:
Large storage capacity
Multi-user operation
Ease of portability
High processing speed
A thin client lacks:
CD/DVD drive and expansion slots
Monitor
Operating system
Network connection
Which computer type is designed for engineering and technical computing?
Server
Desktop
Workstation
Tablet
Mainframe computers are primarily used:
By a single user
In entertainment systems
For concurrent users in organizations
In smartphones
The most powerful computers used for rapid computation are:
Mainframes
Workstations
Supercomputers
Servers
The relational database model represents data as:
Hierarchical trees
Network structures
Two-dimensional tables
Object collections
Which operation removes rows that do not meet a specific condition?
Project
Join
Select
Link
Which operation combines columns from two or more tables based on a common attribute?
Select
Project
Join
Domain
Data cleanup is mainly used to:
Increase database size
Eliminate data redundancy and inconsistency
Encrypt database data
Speed up network connections
A schema is best described as:
A software application
A programming language
A description of the entire database structure
A database backup file
Which language is used to define database structures such as tables and relationships?
DML
SQL
DDL
OLAP
Which of the following is the standard query language for relational databases?
DDL
DML
SQL
API
Who is responsible for managing and maintaining the database system?
System analyst
Network administrator
Database Administrator (DBA)
Programmer
A data warehouse is mainly designed to support:
Daily transaction processing
Management decision making
Operating system functions
Network security
Data mining refers to:
Storing large amounts of data
Creating database schemas
Automated discovery of patterns in data
Data backup operations
Systems software is mainly responsible for:
Helping users write documents
Controlling computer hardware and supporting applications
Designing databases
Creating multimedia files
Which of the following is an example of systems software?
Microsoft Excel
Adobe Photoshop
Operating System
Web browser
The kernel is:
A user interface
The core part of the operating system
An application program
A utility program
Multitasking allows:
One user to access multiple computers
Multiple users to share one file
More than one program to run at the same time
Multiple operating systems to run together
Middleware is used to:
Replace operating systems
Improve graphics performance
Allow different systems to communicate
Compress files
Which software helps groups work together efficiently?
Personal productivity software
Groupware
Systems software
Utility software
ERP software is classified as:
Personal application software
Workgroup software
Enterprise application software
Utility software
A compiler is used to:
Execute programs directly
Convert source code into machine language
Manage memory
Control hardware devices
Open-source software is characterized by:
High cost
Hidden source code
Freely modifiable source code
Limited usage rights
Which type of software is not protected by copyright laws?
Shareware
Freeware
Public domain software
Licensed software
Data and information mean exactly the same thing.
True
False
Information systems only involve computers.
True
False
Feedback helps improve future system inputs or processes.
True
False
M-commerce requires physical cash for transactions.
True
False
ROM is a nonvolatile form of memory.
True
False
Cache memory is slower than main memory.
True
False
Parallel processing can link multiple processors to work simultaneously.
True
False
Byte is smaller than a bit.
True
False
System maintenance ensures that systems continue to meet changing needs.
True
False
E-commerce can enhance a company’s stock value and efficiency.
True
False
Relational Model Structure: In a relational database, each row represents a data entity, while the columns represent attributes.
True
False
Flat Files: A "Flat file" is a simple database program where records have no relationship to one another, rather than a complex system.
True
False
Data Definition Language (DDL): DDL is the collection of instructions used to define and describe data and their relationships within a specific database.
True
False
Structured Query Language (SQL): SQL is the recognized standard query language for relational databases.
True
False
Data Cleanup: This is the process of fixing inconsistencies to ensure data is accurate, complete, and free of redundancies.
True
False
Data Warehouse vs. Data Mart: A "Data Mart" is a focused subset of a data warehouse, not a database holding every single source in an enterprise.
True
False
Data Mining: This involves the automated discovery of patterns and relationships within a data warehouse.
True
False
Business Intelligence (BI): BI is defined as the process of getting the right information to the right person in a timely and usable form.
True
False
Middleware: Middleware is a type of system software that acts as a "bridge" between different applications to support organizational goals.
True
False
What is an information system?
A collection of interrelated components that collect, process, store, and distribute data and information to support decision making and control in an organization
A single software application used to send emails across a company
A set of unrelated files stored on a computer with no defined purpose
A hardware-only setup that replaces human decision making entirely
Explain the importance of feedback in an information system.
It helps the system adjust by using output results to modify inputs or processes for better accuracy and efficiency
It eliminates the need for user input entirely
It stores historical data without influencing current operations
It speeds up hardware clock cycles regardless of workload
What are the main characteristics of valuable information?
Accurate
Complete
Timely
Irrelevant
Verifiable
What is the purpose of a Transaction Processing System (TPS)?
To record and process daily business transactions such as sales, payroll, and inventory management
To perform complex statistical modeling for executive decision making only
To replace all human resources functions with automation
To store multimedia content for marketing campaigns
Explain the relationship between MIS, DSS, and ESS in organizations: TPS provides data to MIS; MIS summarizes data into reports; DSS and ESS use that information for higher-level decision making.
TPS feeds MIS; MIS produces summaries; DSS and ESS use those summaries for higher-level decisions
MIS collects raw transactions; TPS converts them into executive dashboards; ESS archives them for compliance
ESS generates transactions; DSS converts them to summaries; MIS sends them back to TPS
DSS records daily transactions; ESS handles payroll; MIS manages hardware resources
What is the function of cache memory and where is it located?
It temporarily stores frequently used data near the CPU to speed processing; it is located on or close to the CPU chip
It provides permanent storage for the operating system on the hard drive
It holds archived backups on external media
It stores user profiles on the network server
List and describe the three basic types of computer memory: RAM (temporary storage for active data), ROM (permanent storage for essential system instructions), and Cache (high-speed memory for quick access to frequent data). Which statement best summarizes them?
RAM is temporary, ROM is permanent for system instructions, and Cache is high-speed for frequent data
RAM is permanent, ROM is temporary, and Cache is used only for graphics
RAM and ROM are both high-speed caches, Cache is long-term archival storage
ROM and Cache are temporary while RAM is permanent
What is the difference between parallel computing and multiprocessing?
Multiprocessing uses multiple CPUs for different tasks simultaneously, while parallel computing divides a single task across several processors to complete it faster
Parallel computing uses a single CPU to emulate many, while multiprocessing splits one task across network storage devices
Multiprocessing and parallel computing are identical terms with no practical difference
Parallel computing uses only GPUs, while multiprocessing uses only CPUs
Explain the main function of a server.
It manages network or Internet tasks, providing services and data to multiple users
It replaces client computers entirely with centralized terminals
It only stores web pages without running applications
It is used solely for offline backups with no network role
How do Selecting and Projecting differ in relational database manipulation?
Selecting filters data by eliminating rows based on criteria, while projecting narrows data by eliminating specific columns
Selecting eliminates columns while projecting removes entire tables
Selecting sorts records alphabetically, while projecting groups records by keys
Selecting joins two tables, while projecting creates new tables from queries
What is the main goal of the Data Cleanup process?
To fix inconsistencies and errors so data is accurate, complete, and free of redundancies
To compress files to save disk space regardless of accuracy
To delete old records without validation
To encrypt all data for security only
What is the primary difference between a Data Warehouse and a Data Mart?
A Data Warehouse stores information from the entire enterprise, whereas a Data Mart is a smaller subset focused on a specific department
A Data Warehouse is always a real-time system, while a Data Mart is always batch-based
A Data Mart stores data for the whole organization, while a Data Warehouse serves one team
A Data Warehouse holds only raw logs; a Data Mart holds only summarized data
What is the function of Middleware in software systems?
It acts as a software bridge that allows different applications to communicate and exchange data with one another
It is a hardware component that increases CPU clock speed
It is a database solely for storing middleware configuration files
It is a user application for editing documents
