Software Systems
What component manages how memory is allocated and freed up for programs?
Memory Management
What OS type runs on mobile phones and tablets?
Mobile Device OS
What is the purpose of clearing the browser cache? (
o free up space and ensure updated content loads
What is the main benefit of a relational database over a flat file?
Can handle multiple users and complex relationships
What SQL command retrieves data?
SELECT
What do you call the software layer that allows the user to manage applications and hardware?
Operating System
What is a Hypervisor Type 1 used for?
Running virtual machines directly on hardware
What feature prevents JavaScript from running in your browser?
Client-side scripting deactivation / script blocker
What are tables made up of in relational databases?
Rows (records) and columns (fields)
What is programmatic access in databases?
Accessing a database via programming languages or APIs
Name one function of the disk management system.
Create, format, or partition disks
What type of file system supports encryption and journaling?
NTFS
What’s the difference between private browsing and regular browsing?
Private mode doesn’t save history, cookies, or search entries
What does a primary key do?
Uniquely identifies each record in a table
What is the purpose of a database dump?
To export the entire database for backup or transfer
What does the task manager allow you to do with a hung application?
Kill Process / End Task
What’s the difference between a GUI and command-line interface?
GUI uses graphics; CLI uses text-based commands
What is a proxy server used for?
It acts as an intermediary between a device and the internet
What are examples of non-relational databases?
Key-value and document-based databases
What type of user interface allows users to interact with databases without coding?
GUI or utility-based interface like Access
What is the difference between embedded OS and server OS?
Embedded OS runs on devices with specific functions; Server OS manages networked devices/services.
What are the tiers in a three-tier application architecture?
Presentation, Logic, and Data
Name two indicators of an invalid certificate in a browser.
Security warning, broken padlock icon
What is the purpose of adding constraints to a table?
To enforce rules for data integrity
What is the difference between data definition and data manipulation commands?
DDL creates/changes structure; DML edits data itself