WorksheetsCC101 Review
Total questions: 150
Worksheet time: 1hrs 15mins
Which of the following best describes “privacy”?
Freedom from unauthorized access to personal information
Protection from computer viruses
Ethical behavior online
Backup of important files
Which of the following is considered a privacy concern?
Data encryption
Tracking user activity without consent
Installation of antivirus software
Regular updates
Which refers to protecting systems against unauthorized access?
Privacy
Security
Ethics
People
Which group plays the most important role in information security?
Software
Hardware
People
Networks
Which of the following is an ethical principle?
Plagiarism
Transparency
Hacking
Data theft
Which practice supports ethical use of technology?
Using licensed software
Pirating videos
Sharing others’ passwords
Installing malware
Which of the following is an example of a security measure?
Data breach
Phishing scam
Two-factor authentication
Social engineering
Which is a situation where privacy is violated?
Using a strong password
Posting someone’s data without permission
Updating your OS
Encrypting files
Ethics in computing focuses on:
Writing code
Choosing hardware
What is right and wrong in the digital environment
Network design
What is the main threat to privacy?
Encryption
Unauthorized data collection
Strong passwords
Antivirus software
Which is an example of unethical behavior?
Reporting vulnerabilities
Using proper citations
Spreading malware
Respecting copyright
Social engineering attacks target:
Databases
People
Hardware
Software
Which of the following helps ensure data privacy?
Sharing passwords
Firewalls
Data exposure
Insider attacks
Ethics help guide:
System storage
System upgrades
Proper digital behavior
System design only
Which is NOT a security threat?
Spyware
Updates
Ransomware
Keyloggers
A data breach refers to:
Successful data backup
Unauthorized release of information
Encryption of files
Access restrictions
Which of the following best describes confidentiality?
Ensuring data is accurate
Ensuring data is accessible
Ensuring only authorized users can access data
Ensuring data is backed up
Ethics in IT promotes:
Fair use
Data theft
Hacking
Malware creation
Privacy policies exist to:
Publish user data
Delete system files
Inform users how their data is collected
Encrypt passwords automatically
A strong security culture begins with:
Password sharing
Employee awareness
Malware installation
Ignoring updates
Netiquette refers to:
Internet threats
Proper online behavior
Hacking techniques
Cyber laws
Which is an example of good netiquette?
Using all caps
Respecting others’ opinions
Cyberbullying
Sharing fake news
Which online threat attempts to trick users into giving information?
DDoS
Phishing
Worm
Firewall
Malware is defined as:
Software used for productivity
Software intended to harm devices
Hardware malfunction
Ethical software
What is a common sign of phishing?
Personalized greetings
Suspicious links
Direct contact numbers
Secure websites
Two-factor authentication increases:
Battery life
Processing speed
Account security
Email storage
Ransomware attacks:
Encrypt files and demand payment
Fix system errors
Delete malware
Protect data
A good password is:
Your birthday
“123456”
Complex and unique
Short and simple
Ethical online behavior includes:
Plagiarizing posts
Respecting copyright
Spamming comments
Fake identity creation
Cyberbullying is:
Online kindness
Online harassment
Data encryption
Network improvement
A digital footprint is:
Hardware component
Permanent online record of activities
Temporary RAM file
Network speed
A common online scam where attackers impersonate someone:
Spoofing
Defragging
Uploading
Debugging
Antivirus software helps:
Create malware
Detect and remove threats
Slow down systems
Break passwords
Ethical online communication avoids:
Trolling
Respectful language
Constructive feedback
Proper grammar
Which is a personal cybersecurity measure?
Ignoring warnings
Avoiding suspicious downloads
Disabling firewalls
Using weak passwords
Digital risks refer to:
Only hardware issues
Potential dangers when using technology
Wi‑Fi signals
Data storage features
Netiquette discourages:
Courtesy
Flaming
Clarity
Respect
A worm differs from a virus because it:
Requires user action
Self-replicates automatically
Cannot spread
Is harmless
Ethical behavior requires:
Respecting privacy
Hacking systems
Sharing private files
Plagiarizing content
A secure website begins with:
http
https
ftp
mailto
Information systems primarily support:
Random activities
Organizational operations
Virus creation
Hardware sales
Information flows in an organization from:
Only top to bottom
Only bottom to top
Multiple directions
Nowhere
Which is NOT a component of a computer-based information system?
Software
People
Hardware
Furniture
The main purpose of a Transaction Processing System (TPS) is to:
Support routine transactions
Make top-level decisions
Predict market trends
Create documents
An MIS provides:
Operational reports
Executive summaries only
Encryption tools
Database recovery
Which system helps in analyzing large amounts of data for decision-making?
TPS
DSS
Printer
Router
Executive Support Systems are designed for:
Clerical staff
Middle managers
Top executives
Students
Organizational information flow that starts from the top is called:
Horizontal
Upward
Downward
Diagonal
A DSS provides:
Routine data only
Analytical tools
Receipts
Passwords
TPS examples include:
Payroll processing
Project planning
Board meetings
Strategy development
Information is considered useful when it is:
Late
Accurate
Incomplete
Outdated
Middle managers primarily use:
ESS
MIS
HTML
CSS
An ESS provides:
Detailed reports
Long-term strategic information
Sales receipts
Program code
Computer-based systems rely heavily on:
Random inputs
Data processing
Furniture
Weather
MIS stands for:
Management Information System
Managed Input System
Main Information Storage
Machine Internal Setup
Vertical information flow usually refers to:
Across departments
From top to bottom
Between competitors
To customers only
TPS is MOST essential for:
Real-time transactions
Strategic planning
HTML formatting
Web design
DSS often includes:
Mathematical models
Chairs
Printers
Keyboards only
What does an IS convert into information?
Programs
Data
Furniture
Images only
MIS reports are usually:
Unstructured
Scheduled
Random
Unreliable
Executive Support Systems emphasize:
Highly detailed data
Soft drink preferences
Long-term decisions
Routine tasks
Computer-based systems include:
Hardware and software
Tables and chairs
Walls and floors
Cabinets
The purpose of IS is to support:
Business processes
Cyberattacks
System errors
Hardware breakdowns
Data becomes information when it is:
Printed
Processed and meaningful
Stored only
Colorful
Which system helps top-level decision makers?
TPS
MIS
ESS
HTML
Horizontal information flow occurs:
Between departments
From managers to employees
From users to servers
Only in databases
A system is considered effective when it:
Fails often
Meets organizational goals
Has no users
Uses outdated technology
Which is a type of computer-based information system?
MIS
Desk
Chair
Wall clock
Information systems exist to:
Process data
Store viruses
Delete passwords
Block users
Which system provides long-term business trends?
TPS
MIS
ESS
HTML
Data refers to:
Raw facts
Processed information
Images only
Hardware tools
Information is:
Raw data
Processed data
Unorganized text
Deleted files
A database is a collection of:
Random files
Organized information
Hardware parts
Software errors
DBMS stands for:
Data Base Maintenance System
Database Management System
Data Backup Monitoring System
Digital Base Model System
The main purpose of a DBMS is to:
Provide entertainment
Manage databases
Format documents
Create viruses
The smallest unit of data is:
File
Field
Bit
Table
A record is a collection of:
Bits
Fields
Tables
Programs
A table consists of:
Software
Columns and rows
Only rows
Only columns
A primary key must be:
Duplicated
Unique
Optional
Random
A foreign key is used to:
Delete tables
Link tables
Print records
Backup data
Which is a type of database?
Relational
Furniture
Computer mouse
Monitor
Data integrity refers to:
Data damage
Data accuracy
Data deletion
Data loss
A data warehouse stores:
Temporary files
Large historical data
Software drivers
Game data
A distributed database is:
Stored in one place
Spread across multiple sites
Only on flash drives
Offline only
Data redundancy means:
Organized data
Duplicate data
Encrypted data
Normalized data
SQL is used for:
Hardware installation
Data manipulation
Graphic design
Web hosting
A DBMS provides:
Security features
Data breaches
Malware
Viruses
Which is a DBMS issue?
High cost
Fast processing
Data retrieval
Security controls
A schema describes:
Hardware specs
Database structure
User password
Network signal
The process of structuring data to reduce redundancy is:
Uploading
Normalization
Execution
Debugging
A field is also known as:
Attribute
Table
DBMS
Query
A query retrieves:
Data
Furniture
Hardware
Colors
A hierarchical database organizes data in:
A tree structure
Tables
Grids
Random form
A relational database organizes data in:
Tables
Chains
Graphs
Audio form
A database administrator is responsible for:
Cleaning desks
Maintaining databases
Making videos
Coding games
A backup ensures:
Data recovery after failure
Data loss
Virus removal
Malware creation
Which is NOT a database issue?
Complexity
Cost
Data security
Orderliness
Metadata refers to:
Data about data
Random data
Hardware data
Online threats
A flat-file database stores data in:
Multiple tables
A single table
A tree
A graph
Which best describes a DBMS?
Software for managing databases
Hardware device
Antivirus program
Operating system
Which database type handles images, audio, and video?
Multimedia database
Flat-file
Hierarchical
Relational
A database transaction must be:
ACID-compliant
Optional
Random
Uncontrolled
A view in a database is:
Physical copy
Virtual table
Hardware component
Data loss
A database index improves:
File deletion
Query performance
Virus detection
Network speed
A redundant database is one that:
Has duplicate data
Has no data
Is always offline
Only stores images
Normal forms are used to:
Style webpages
Organize database structure
Build hardware
Reduce battery usage
The DBMS component that authorizes users is the:
Security manager
Query engine
Index manager
Virus scan
A data dictionary stores:
Program code
Definitions of data
User passwords
Website designs
Which is a common database language?
SQL
HTML
CSS
JS
Data anomalies occur due to:
Redundancy
Normalization
Accurate records
Encryption
A database application software is used to:
Play music
Create and manage database solutions
Design posters
Browse the internet
MS Access is an example of:
Programming language
Database application
Operating system
Malware
Forms in DB applications are used for:
Visual data input
Gaming
Formatting images
Recording audio
A report is used to:
Delete data
Present formatted output
Create viruses
Build web pages
A query enables users to:
Search and retrieve data
Draw images
Encrypt emails
Format slides
A macro in MS Access is used to:
Automate tasks
Install hardware
Convert video
Edit images
A DB application supports:
Data entry
Data manipulation
Data reporting
All of the above
Which file format typically stores Access databases?
.txt
.xlsx
.accdb
.exe
Forms ensure:
Unstructured input
Accurate data entry
Hardware upgrade
File deletion
DB application software is important because:
It improves data accuracy and efficiency
It slows processing
It hides information
It creates malware
The preliminary investigation identifies:
Software colors
System problems and feasibility
Employee tasks
Printer errors
Systems analysis focuses on:
Understanding current system requirements
Designing buildings
Installing hardware only
Creating viruses
Systems design involves:
Defining system architecture
Playing games
Permanent shutdown
Formatting drives
System development phase refers to:
Coding and building the system
System disposal
System crashing
Breakdowns
System implementation includes:
Converting users
Installing and testing the system
Destroying old data
Random typing
Systems maintenance ensures:
System stops working
System remains updated
Data deletion
Hardware failure
A feasibility study includes:
Operational feasibility
Technical feasibility
Economic feasibility
All of the above
A prototype is:
Finished product
Early working model
Deleted program
Virus scanner
Rapid Application Development (RAD) emphasizes:
Speed in system creation
Slow planning
Long coding hours
Manual processing
User requirements are gathered during:
Systems analysis
Systems design
Systems testing
Systems disposal
Implementation strategies include:
Direct conversion
Parallel conversion
Phased conversion
All of the above
Systems documentation includes:
System design details
Hardware pricing
Personal emails
Viruses
System testing ensures:
The system works correctly
The network is always offline
Data is deleted
Users are replaced
A data flow diagram (DFD) shows:
Movement of data
Movement of furniture
Colors
Images
A Gantt chart is used for:
Scheduling projects
Creating images
Testing code
Running servers
Maintenance includes:
Updating the system
Ignoring errors
Stopping operations
Causing failures
The end-user is:
System creator
System analyst
Person who uses the system
Programmer only
The coding phase comes after:
System design
System disposal
System testing
Feasibility study
System documentation helps:
Future maintenance
Virus spread
Hacking
Data loss
System analysis identifies:
User needs
Game rules
Hardware pricing
Web design colors
Programming is the process of:
Writing instructions for a computer
Cleaning hardware
Designing posters
Playing games
Program specification defines:
Problem requirements
Logo design
Network structure
HTML syntax
Program design includes:
Flowcharts and algorithms
Social media posting
File deletion
Reducing RAM
Program code refers to:
Written instructions in a language
Hardware components
Operating system
Internet speed
Testing identifies:
Program errors
Sound quality
Storage capacity
Color themes
Documentation helps:
Users and developers understand the program
Delete files
Turn off computers
Distract developers
Program maintenance includes:
Updating programs after deployment
Breaking the program
Corrupting files
Printing data
OOP stands for:
Object-Oriented Programming
Online Office Program
Operating Output Panel
One-On Processing
1st generation languages are:
Machine languages
High-level languages
SQL languages
Web languages
CASE tools support:
Automated software development
Gaming
Virus creation
File deletion
