Computer Awareness Compendium — Acronyms, History & Exam Traps
Free study material · concepts, shortcuts & solved questions
Introduction: Your Exam Reference Guide
This chapter is a reference compendium designed for last-minute exam preparation. It consolidates critical terminology, timeline milestones, commonly confused concepts, and exam traps from all previous chapters.
Use this chapter:
- During preparation: Memorize acronyms and timelines
- Day before exam: Verify you know all acronyms and major milestones
- After each chapter: Review relevant sections
Section 1: Master Acronym List (100+ Terms)
Hardware Acronyms
| Acronym | Full Form | Meaning | Context |
|---|---|---|---|
| CPU | Central Processing Unit | Brain of computer; executes instructions | Measured in GHz |
| RAM | Random Access Memory | Temporary, fast memory; volatile (loses data on shutdown) | 8GB, 16GB typical |
| ROM | Read-Only Memory | Permanent memory; non-volatile; can't erase or modify | BIOS stored in ROM |
| SSD | Solid State Drive | Fast storage using flash memory; no moving parts | ~500 MB/s read speed |
| HDD | Hard Disk Drive | Slower storage with spinning magnetic disk | Cheaper but slower than SSD |
| GPU | Graphics Processing Unit | Specialized processor for graphics/parallel computation | Mining, AI, gaming |
| USB | Universal Serial Bus | Standard port for connecting peripherals | USB-A, USB-C types |
| HDMI | High-Definition Multimedia Interface | Cable for video/audio transmission | Monitor, TV connection |
| BIOS | Basic Input/Output System | Firmware that initializes hardware before OS loads | Pre-boot menu: Delete key |
| UEFI | Unified Extensible Firmware Interface | Modern replacement for BIOS | Better security, GUI |
| CMOS | Complementary Metal-Oxide-Semiconductor | Chip storing BIOS settings; powered by coin battery | Cleared to reset BIOS |
| NAND | NAND Flash Memory | Non-volatile storage technology (SSDs, USB drives, phones) | Data persists without power |
| MHz | Megahertz | Million clock cycles per second; CPU speed unit | Older: MHz; modern: GHz |
| GHz | Gigahertz | Billion clock cycles per second | 2.4 GHz CPU = 2.4 billion cycles/sec |
| TB | Terabyte | 1 trillion bytes (~1000 GB) | Hard drive capacity |
| GB | Gigabyte | 1 billion bytes (~1000 MB) | RAM capacity, file sizes |
| MB | Megabyte | 1 million bytes (~1000 KB) | Small file sizes |
| KB | Kilobyte | 1000 bytes | Text file sizes |
Memory Hook: "RAM = Temporary (RAM-bunctious, quick but forgetful); ROM = Permanent (Roman statues, lasting)"
Network & Internet Acronyms
| Acronym | Full Form | Meaning | Context |
|---|---|---|---|
| TCP | Transmission Control Protocol | Reliable data transmission with error checking | Guarantees delivery order |
| UDP | User Datagram Protocol | Fast but unreliable transmission | Video streaming, online gaming |
| IP | Internet Protocol | Addresses and routing packets across networks | IPv4 (32-bit), IPv6 (128-bit) |
| DNS | Domain Name System | Translates domain names to IP addresses | example.com → 142.250.185.46 |
| URL | Uniform Resource Locator | Web address identifying resource location | https://www.example.com/path |
| HTTP | HyperText Transfer Protocol | Protocol for transferring web pages (unsecured) | Port 80 |
| HTTPS | HTTP Secure | HTTP with SSL/TLS encryption | Port 443; padlock icon |
| FTP | File Transfer Protocol | Protocol for uploading/downloading files | Port 21; insecure |
| SFTP | SSH File Transfer Protocol | Secure FTP (encrypted) | Recommended over FTP |
| SMTP | Simple Mail Transfer Protocol | Sending emails to server | Port 25 (or 587) |
| POP3 | Post Office Protocol 3 | Receiving emails (destructive; deletes from server) | Port 110 |
| IMAP | Internet Message Access Protocol | Receiving emails (non-destructive; stays on server) | Port 143; modern standard |
| ISP | Internet Service Provider | Company providing internet connectivity | Jio, Airtel (India); Comcast, Verizon (US) |
| VPN | Virtual Private Network | Encrypted tunnel for privacy and security | Creates secure connection |
| SSL | Secure Sockets Layer | Encryption protocol for HTTPS | Older term; replaced by TLS |
| TLS | Transport Layer Security | Modern replacement for SSL | Secures HTTPS connections |
| DDoS | Distributed Denial of Service | Attack overwhelming server with fake requests | Makes service unavailable |
| 2FA | Two-Factor Authentication | Second verification (OTP, biometric) after password | Greatly improves security |
| VR | Virtual Reality | Complete immersion in digital environment | Headsets, games |
| AR | Augmented Reality | Digital overlays on real world | Pokemon Go, Snapchat filters |
| RFID | Radio-Frequency Identification | Wireless technology tracking objects | Passports, payment cards |
| IoT | Internet of Things | Connected devices sharing data | Smartwatch, smart home |
| 3D | Three-Dimensional | 3D printing, 3D modeling, 3D displays | Depth in all three axes |
Memory Hook: "HTTP = Insecure web; HTTPS = Secure web (S = Secure)"
Software & Programming Acronyms
| Acronym | Full Form | Meaning | Context |
|---|---|---|---|
| OS | Operating System | System software managing hardware (Windows, Linux, macOS) | Core software layer |
| API | Application Programming Interface | Rules for software communication | Allows apps to talk to each other |
| SDK | Software Development Kit | Tools for developing software | Includes libraries, compiler, debugger |
| IDE | Integrated Development Environment | Complete coding environment | Visual Studio, VS Code, PyCharm |
| GUI | Graphical User Interface | Visual interface with icons/menus | Point-and-click (vs. CLI) |
| CLI | Command-Line Interface | Text-based interface (typing commands) | Terminal, PowerShell |
| HTML | HyperText Markup Language | Markup language for web pages (structure) | , , tags |
| CSS | Cascading Style Sheets | Language for styling HTML (appearance) | Colors, fonts, spacing |
| JS | JavaScript | Programming language for web interactivity | Runs in browsers; now also servers (Node.js) |
| JSON | JavaScript Object Notation | Lightweight data format (human-readable) | APIs, config files |
| XML | Extensible Markup Language | Data format with custom tags | More verbose than JSON |
| SQL | Structured Query Language | Language for querying databases | SELECT, INSERT, UPDATE, DELETE |
| CSV | Comma-Separated Values | Simple data format (spreadsheets) | One row per line |
| AJAX | Asynchronous JavaScript and XML | Fetch data without reloading page | Modern web apps |
| CMS | Content Management System | Software for managing website content | WordPress, Drupal |
| ERP | Enterprise Resource Planning | Software integrating business operations | SAP, Oracle ERP |
| CRM | Customer Relationship Management | Software managing customer interactions | Salesforce, HubSpot |
| AI | Artificial Intelligence | Machines performing intelligent tasks | Broad umbrella term |
| ML | Machine Learning | Learning from data (subset of AI) | Training data improves performance |
| DL | Deep Learning | Neural networks with multiple layers (subset of ML) | Breakthrough in image/language recognition |
| NLP | Natural Language Processing | Computers understanding human language | ChatGPT, Google Translate |
| LLM | Large Language Model | Neural networks trained on massive text | ChatGPT, Bard, Claude |
| RNN | Recurrent Neural Network | Neural network for sequence data | Text generation, translation |
| CNN | Convolutional Neural Network | Neural network for image recognition | Computer vision |
| GIT | Version Control System | Tracks code changes | GitHub, GitLab |
| SSH | Secure Shell | Secure remote access protocol | Linux servers, secure login |
| PAT | Personal Access Token | Authentication token (GitHub, APIs) | Alternative to passwords |
Memory Hook: "HTML = Skeleton (structure); CSS = Clothes (appearance); JS = Brain (behavior)"
Security & Database Acronyms
| Acronym | Full Form | Meaning | Context |
|---|---|---|---|
| SPF | Sender Policy Framework | Prevents email spoofing | DNS record |
| DKIM | DomainKeys Identified Mail | Digitally signs emails | Verifies authenticity |
| DMARC | Domain-based Message Authentication, Reporting, Conformance | Email authentication policy | Combines SPF + DKIM |
| ACL | Access Control List | Defines who can access what | File permissions |
| PKI | Public Key Infrastructure | System for managing encryption keys | Digital certificates |
| CA | Certificate Authority | Issues digital certificates | Verisign, Comodo, Let's Encrypt |
| ACID | Atomicity, Consistency, Isolation, Durability | Database transaction guarantees | Relational databases |
| RDBMS | Relational Database Management System | Software managing relational databases | MySQL, PostgreSQL, Oracle |
| NoSQL | Not Only SQL | Non-relational databases | MongoDB, Cassandra |
| ETL | Extract, Transform, Load | Data pipeline process | Business intelligence |
Cloud & Architecture Acronyms
| Acronym | Full Form | Meaning | Context |
|---|---|---|---|
| IaaS | Infrastructure as a Service | Cloud providing VMs/storage | AWS EC2, Google Compute Engine |
| PaaS | Platform as a Service | Cloud providing development platform | Heroku, Firebase |
| SaaS | Software as a Service | Cloud providing applications | Google Workspace, Salesforce |
| AWS | Amazon Web Services | Largest cloud provider (~32% share) | EC2, S3, RDS services |
| GCP | Google Cloud Platform | Google's cloud (~11% share) | BigQuery, Dataflow |
| RTO | Recovery Time Objective | How long to restore service after disaster | Target: 2 hours |
| RPO | Recovery Point Objective | Max acceptable data loss | Target: 1 hour |
| SLA | Service Level Agreement | Uptime guarantee | 99.9% = 43 min/month downtime |
| CDN | Content Delivery Network | Delivers content from nearest server | CloudFlare, Akamai |
Section 2: Timeline of Computing Milestones
Organized chronologically from 1940s to 2024—essential for exam prep:
1940s-1950s: The Computer Birth
| Year | Event | Significance |
|---|---|---|
| 1946 | ENIAC (Electronic Numerical Integrator and Computer) completed | First general-purpose electronic computer; weighed 30 tons; used 18,000 vacuum tubes |
| 1947 | Transistor invented at Bell Labs | Replaced vacuum tubes; smaller, faster, more reliable |
| 1956 | Dartmouth Conference | Birth of Artificial Intelligence; researchers optimistic about AI |
1960s-1970s: Networks & Protocols
| Year | Event | Significance |
|---|---|---|
| 1969 | ARPANET launched | Precursor to Internet; first message sent UCLA → Stanford |
| 1972 | Email invented | Ray Tomlinson sends first network email |
| 1974 | Microprocessors proliferate | Intel 4004, Apple II begins era of personal computers |
| 1977 | Apple II released | First personal computer for mass market |
1980s: Personal Computers Boom
| Year | Event | Significance |
|---|---|---|
| 1980 | IBM PC released | Established PC standard; widespread adoption |
| 1981 | MS-DOS 1.0 released | Operating system for IBM PC |
| 1984 | Apple Macintosh released | First GUI (Graphical User Interface) for consumers |
| 1985 | Windows 1.0 released | Microsoft's GUI for IBM PCs |
| 1985 | C++ programming language created | Object-oriented extension of C |
1990s: Internet Goes Mainstream
| Year | Event | Significance |
|---|---|---|
| 1989 | World Wide Web invented (Tim Berners-Lee, CERN) | Web revolutionizes information sharing; HTTP, HTML, URLs |
| 1991 | Linux kernel released | Linus Torvalds creates free, open-source OS |
| 1991 | Windows 3.0 released | Mature GUI; drives Windows adoption |
| 1991 | Python created | Emphasis on readability; becomes data science favorite |
| 1995 | JavaScript created | Brendan Eich creates language for web interactivity (10 days!) |
| 1995 | Java released | "Write once, run anywhere"; JVM enables platform independence |
| 1995 | Windows 95 released | GUI becomes standard; drives PC adoption |
| 1995 | Amazon founded | Pioneering e-commerce |
| 1995 | eBay founded | Online auction platform |
| 1998 | Google founded | Revolutionizes search with PageRank algorithm |
2000s: Mobile & Social Era Begins
| Year | Event | Significance |
|---|---|---|
| 2001 | Wikipedia launched | Free, crowdsourced encyclopedia (disrupted Britannica) |
| 2003 | MySpace launches | Social networking pioneer |
| 2003 | WordPress released | Content management system; powers ~43% of websites today |
| 2004 | Facebook launched | Social network becomes dominant platform |
| 2005 | YouTube launched | Video sharing; revolutionizes content consumption |
| 2006 | Twitter launched | Microblogging; 500M+ users |
2007-2010: Mobile Revolution
| Year | Event | Significance |
|---|---|---|
| 2007 | iPhone released (Steve Jobs) | Revolutionizes mobile; capacitive touchscreen, intuitive OS |
| 2008 | Android released | Open-source mobile OS; dominates market share |
| 2008 | Bitcoin whitepaper published | "Satoshi Nakamoto" introduces blockchain cryptocurrency |
| 2009 | Bitcoin network launches | First blockchain implementation live |
| 2010 | iPad released | Tablets become viable computing device |
2010s: AI & Cloud Expansion
| Year | Event | Significance |
|---|---|---|
| 2011 | IBM Watson wins Jeopardy! | AI defeats champion in language-based game |
| 2012 | Deep Learning Renaissance | Geoffrey Hinton's team wins ImageNet competition dramatically |
| 2016 | AlphaGo defeats Lee Sedol | DeepMind AI beats world champion in Go using deep learning |
| 2017 | Transformer Architecture (Attention Is All You Need) | Breakthrough enabling modern LLMs |
| 2017 | WannaCry ransomware attacks | Largest cyberattack wave; hospitals affected |
2020s: AI Explosion & Multimodal Era
| Year | Event | Significance |
|---|---|---|
| 2020 | COVID-19 accelerates cloud/remote work | Zoom, Google Meet become essential |
| 2022 | ChatGPT released (Nov 30) | Reaches 100M users in 2 months; fastest software adoption ever |
| 2023 | GPT-4 released (Mar) | Multimodal (text + images); passes bar exam |
| 2023 | Google Bard launched (Dec) | Competes with ChatGPT |
| 2023 | LLM explosion | Copilot, Gemini, Claude 2, Llama 2 released |
| 2024 | Multimodal AI standard | Text, image, video understanding in single models |
Memory Hook:
- 1969 = ARPANET (Internet born)
- 1989 = Web (Tim Berners-Lee)
- 1995 = JavaScript, Java, Windows 95, Amazon, eBay, Google founding year (1998)
- 2007 = iPhone (mobile revolution)
- 2022 = ChatGPT (AI mainstream)
Section 3: Commonly Confused Concepts (8 Critical Distinctions)
1. Internet vs. Intranet vs. Web
| Aspect | Internet | Intranet | Web (WWW) |
|---|---|---|---|
| Scope | Global, public network | Private, organizational network | Service on Internet using HTTP/HTTPS |
| Access | Anyone with connection | Only organization employees | Anyone accessing web pages |
| Technology | TCP/IP protocols | TCP/IP (same as Internet) | HTTP, HTML, URLs |
| Example | The worldwide network | Company internal network | Google.com, Wikipedia |
| Exam Tip | "Internet = global; Intranet = private; Web = one service on Internet" |
2. RAM vs. ROM
| Aspect | RAM | ROM |
|---|---|---|
| Volatility | Volatile (loses data on shutdown) | Non-volatile (retains data) |
| Speed | Very fast (~10 nanoseconds) | Slower |
| Capacity | Typically 8-32 GB | Typically 256 KB - 4 MB |
| Purpose | Temporary workspace for running programs | Firmware (BIOS), bootloader |
| Write | Can read/write (temporary changes) | Read-only (can't modify) |
| Cost | Expensive | Cheap |
| Exam Trap | Question: "What happens when you turn off computer?" Answer: RAM loses data; ROM keeps data |
3. HTTP vs. HTTPS
| Aspect | HTTP | HTTPS |
|---|---|---|
| Encryption | None (plain text) | Encrypted (SSL/TLS) |
| Security | Low (anyone can intercept) | High (encrypted) |
| Port | 80 | 443 |
| Visual | No padlock | Padlock icon in browser |
| Usage | Static content only | Login, payments, sensitive data |
| Exam Trap | "Never enter passwords on http:// site" |
4. Hardware vs. Software
| Aspect | Hardware | Software |
|---|---|---|
| Nature | Physical, tangible | Intangible, instructions |
| Drop on foot | Hurts! | No physical damage |
| Examples | CPU, RAM, keyboard, monitor | Windows, Photoshop, Chrome |
| Lifespan | Years (degrades over time) | Indefinite (doesn't wear out) |
| Exam Tip | "Hardware = Physical; Software = Programs" |
5. AI vs. Machine Learning
| Aspect | AI | Machine Learning |
|---|---|---|
| Scope | Umbrella (broad) | Subset of AI (specific) |
| Method | Various (rules, learning, etc.) | Learns from data |
| Learning | Doesn't always learn | Always learns from data |
| Example | Chess engine using tables | Spam detector learning from emails |
| Hierarchy | AI ⊃ ML ⊃ DL | ML is part of AI |
| Exam Trap | "Is all AI machine learning?" Answer: NO |
6. Compiled vs. Interpreted Languages
| Aspect | Compiled | Interpreted |
|---|---|---|
| Process | Entire code → Machine code → Run | Line-by-line conversion at runtime |
| Speed | Faster (pre-compiled) | Slower (runtime interpretation) |
| Development | Slower (must recompile after change) | Faster (write, run immediately) |
| Errors | Caught at compile time | Caught at runtime |
| Platform | Platform-specific binaries | Platform-independent (if interpreter available) |
| Examples | C, C++, Go | Python, JavaScript, PHP |
| Exam Tip | Speed matters? Compiled. Flexibility matters? Interpreted. |
7. Virus vs. Malware
| Aspect | Virus | Malware |
|---|---|---|
| Scope | Specific type of malware | Umbrella (includes virus, worm, trojan, etc.) |
| Replication | Yes (copies itself to files) | May or may not replicate |
| Host | Requires host file to replicate | Some don't need host (worms) |
| Example | Attaches to .exe files | Trojan, ransomware, spyware all malware |
| Exam Trap | "All viruses are malware; not all malware is virus" |
8. Authentication vs. Authorization
| Aspect | Authentication | Authorization |
|---|---|---|
| Definition | Proving who you are | Granting what you can do |
| Question | "Are you who you claim?" | "What are you allowed to do?" |
| Method | Password, fingerprint, 2FA | Access control, permissions |
| Example | Login to Gmail | Gmail user can read emails but not access admin settings |
| Order | Happens first | Happens after authentication |
| Exam Tip | "Authentication = Identity; Authorization = Permissions" |
Section 4: Exam Traps & Red Flags
Trap 1: Confusing Internet and Web
Question: "Which is older, the Internet or the Web?" Trap Answer: "They're the same thing" → WRONG Correct Answer: "Internet (ARPANET, 1969) is 20 years older than Web (1989)"
Trap 2: Port Number Confusion
Question: "What's the default port for HTTPS?" Trap Answer: "80" (HTTP default) → WRONG Correct Answer: "443"
Trap 3: SQL Injection Misconception
Question: "How to prevent SQL injection?" Trap Answer: "Use firewalls only" → WRONG Correct Answer: "Use parameterized queries"
Trap 4: Blockchain ≠ Bitcoin
Question: "What's blockchain's primary use?" Trap Answer: "Only cryptocurrency (Bitcoin)" → WRONG Correct Answer: "Supply chain, smart contracts, voting, etc.; Bitcoin is just one application"
Trap 5: Cloud Uptime Misconception
Question: "Does cloud guarantee 100% uptime?" Trap Answer: "Yes" → WRONG Correct Answer: "No; typical SLAs are 99.9%, 99.99% (not 100%)"
Trap 6: Open-Source ≠ Free
Question: "Are all open-source programs free?" Trap Answer: "Yes" → Mostly true but misleading Correct Answer: "Open-source = source code available; often free but not always; Freeware = free but source not available"
Trap 7: Compiled Faster Than Interpreted
Question: "Why is C faster than Python?" Trap Answer: "C is more powerful" → WRONG Correct Answer: "C compiles to machine code; Python is interpreted (slower execution); C's speed is due to compilation model"
Trap 8: Data Loss Myths
Question: "Backup in cloud prevents all data loss?" Trap Answer: "Yes" → WRONG Correct Answer: "Cloud backup helps but 3-2-1 rule better (3 copies, 2 media types, 1 off-site)"
Trap 9: Encryption Solves Everything
Question: "Does encryption prevent all cyberattacks?" Trap Answer: "Yes" → WRONG Correct Answer: "Encryption protects data in transit/storage; doesn't prevent phishing, malware in email"
Trap 10: 2FA Guarantees Security
Question: "Is 2FA completely secure?" Trap Answer: "Yes" → WRONG Correct Answer: "2FA greatly improves security but doesn't guarantee it; social engineering can bypass 2FA"
Section 5: Last-Minute Memorization Checklist
Acronyms You MUST Know (27 Critical)
- CPU, RAM, ROM, SSD, HDD → Hardware
- TCP, IP, DNS, URL, HTTP, HTTPS → Networking
- SMTP, POP3, IMAP → Email
- HTML, CSS, JS → Web
- SQL, NoSQL → Databases
- AI, ML, DL → Artificial Intelligence
- IaaS, PaaS, SaaS → Cloud
- VPN, 2FA, DDoS → Security
- Git, API, SDK → Development
- IoT, VR, AR → Emerging tech
Timeline You MUST Know (15 Key Dates)
- 1969 = ARPANET
- 1989 = World Wide Web (Tim Berners-Lee)
- 1998 = Google founded
- 2004 = Facebook launched
- 2007 = iPhone released (mobile revolution)
- 2008 = Bitcoin whitepaper
- 2016 = AlphaGo defeats Lee Sedol
- 2022 = ChatGPT released (Nov 30)
- 1995 = JavaScript, Java, Windows 95
- 2001 = Wikipedia
Confused Pairs You MUST Distinguish (8 Pairs)
- Internet vs. Web = Global network vs. one service
- RAM vs. ROM = Temporary/fast vs. permanent/slow
- HTTP vs. HTTPS = Unencrypted vs. encrypted
- Hardware vs. Software = Physical vs. instructions
- AI vs. ML = Umbrella vs. subset
- Compiled vs. Interpreted = Pre-conversion vs. runtime
- Virus vs. Malware = Specific vs. umbrella
- Authentication vs. Authorization = Identity vs. permissions
Numbers to Remember (Memory Hooks)
- IPv4: 4 numbers, each 0-255
- IPv6: 128 bits (vs. IPv4's 32)
- Ports: 80 (HTTP), 443 (HTTPS), 25 (SMTP), 110 (POP3), 143 (IMAP)
- ChatGPT: 100M users in 2 months
- Dartmouth: 1956 (AI birth)
- Cloud: IaaS > PaaS > SaaS (Most control → Least control)
Section 6: Pre-Exam Confidence Checks
Day Before Exam: 30-Minute Power Review
First 5 minutes: Random 5 acronyms and define them
- Example: ACID, SSH, CDN, RPO, SFTP
Next 5 minutes: Timeline quiz (name the year)
- When did AlphaGo beat Lee Sedol? → 2016
- When was ChatGPT released? → Nov 2022
- When was ARPANET launched? → 1969
Next 10 minutes: Confused pairs disambiguation
- "Is email part of Internet or Web?" → Internet
- "Is ML part of AI or vice versa?" → ML is part of AI
- "What's faster: RAM or ROM?" → RAM
Last 10 minutes: Exam traps
- "Can viruses spread without host files?" → Some can (worms)
- "Is open-source always free?" → Usually yes, but not always
- "Can blockchain reverse transactions?" → No; immutable
Section 7: Master Reference Table (Exam Quick-Lookup)
Operating Systems Quick Reference
| OS | Creator | Launch | Market | Strength |
|---|---|---|---|---|
| Windows | Microsoft | 1985 | ~74% | Business, gaming |
| macOS | Apple | 1984 | ~15% | Designers, professionals |
| Linux | Linus Torvalds | 1991 | ~2% desktop; huge server | Free, open-source |
| Android | 2008 | ~70% mobile | Mobile devices | |
| iOS | Apple | 2007 | ~27% mobile | iPhones, iPads |
Programming Languages Quick Reference
| Language | Year | Type | Best For | Difficulty |
|---|---|---|---|---|
| Python | 1991 | Interpreted | AI, data science, scripting | Easy |
| JavaScript | 1995 | Interpreted | Web frontend/backend | Easy |
| Java | 1995 | Compiled (bytecode) | Enterprise, Android | Medium |
| C | 1972 | Compiled | OS, embedded, performance | Hard |
| Go | 2009 | Compiled | Concurrency, microservices | Medium |
Database Quick Reference
| Type | Structured | ACID | Scalability | Use Case | Example |
|---|---|---|---|---|---|
| Relational (SQL) | Yes | Yes | Medium | Business data | MySQL, PostgreSQL |
| NoSQL | No | No (eventual) | High | Web apps, IoT | MongoDB, Cassandra |
Cloud Providers Quick Reference
| Provider | Market Share | Strength | Best For |
|---|---|---|---|
| AWS | ~32% (largest) | Widest services | Enterprises, startups |
| Azure | ~23% | Windows integration | Microsoft shops |
| GCP | ~11% | Data/AI | Data science, ML |
Section 8: Final Exam Tips
During the Exam
60-Second Strategy:
- Read question completely (don't rush)
- Identify key terms (look for traps)
- Check if multiple definitions apply (pick most specific)
- Review answers (A, B, C, D) for logical flow
Red Flag Questions:
- "Which of the following is NOT..." → Tricky; read carefully
- "Which BEST describes..." → May have multiple correct answers; pick most complete
- Acronym questions → Check if acronym fully expanded correctly
Last-Minute Guess Strategy:
- Networking/Security questions? Check port numbers (likely option)
- Timeline questions? Think about order (earlier vs. recent)
- Confusion questions? Pick option emphasizing distinction
Common Wrong Answer Patterns
Trap Pattern 1: "Uses old term"
- Question about SSL → Answer says "TLS" (more modern; both acceptable)
- Eliminate answers using obsolete terminology
Trap Pattern 2: "Opposite of correct"
- Question: "What's volatile?"
- Trap: "ROM" (non-volatile; opposite)
- Correct: "RAM" (volatile)
Trap Pattern 3: "Partial truth"
- Question: "SQL prevents all attacks?"
- Trap: "Yes, SQL is secure"
- Correct: "Parameterized queries prevent SQL injection"
Section 9: Formula-Based Answer Keys (Systematic Approach)
For "Which is fastest?" Questions
Fastest to Slowest:
- CPU registers (nanoseconds)
- L1/L2/L3 cache (nanoseconds to microseconds)
- RAM (nanoseconds)
- SSD (microseconds)
- HDD (milliseconds)
- Internet (milliseconds to seconds)
For "Which is more secure?" Questions
More Secure:
- 2FA > 1FA (two factors > one)
- HTTPS > HTTP (encrypted > plain)
- VPN > No VPN (encrypted tunnel > open)
- Parameterized queries > Direct queries (prevents injection)
- Hashed password > Plain password (irreversible > readable)
For "Which is more scalable?" Questions
More Scalable:
- NoSQL > Relational (distributed > single server)
- Microservices > Monolith (independent > monolithic)
- Cloud > On-premises (elastic > fixed)
- Distributed > Centralized (spread out > concentrated)
Final Exam Revision Checklist
Complete this 1 hour before exam:
- Can I define 20 acronyms from acronym list?
- Can I name 10 tech milestones in order?
- Can I distinguish all 8 confused pairs?
- Do I know port numbers: 80, 443, 25, 110, 143?
- Can I explain HTTPS security (SSL/TLS)?
- Can I distinguish SQL/NoSQL databases?
- Do I understand cloud models: IaaS > PaaS > SaaS?
- Can I list 5 SQL operations: CREATE, SELECT, INSERT, UPDATE, DELETE?
- Do I know AI timeline: 1956 (Dartmouth), 2016 (AlphaGo), 2022 (ChatGPT)?
- Can I explain blockchain: distributed, immutable, transparent?
- Do I understand IoT examples: smartwatch, smart home, smart city?
- Can I distinguish virus vs. worm vs. trojan vs. ransomware?
- Do I know authentication vs. authorization difference?
- Can I name 3 cloud providers and their main strength?
- Do I understand SDLC phases: requirements → design → dev → testing → deploy → maintain?
If YES to 14/15: You're ready. If NO to 3+: Review those sections.
MCQs (23 Questions)
1. ARPANET was launched in:
- A) 1972
- B) 1969
- C) 1989
- D) 1995
2. The World Wide Web was invented by:
- A) Vint Cerf and Bob Kahn
- B) Tim Berners-Lee in 1989
- C) Jonathan Postel
- D) Robert Metcalfe
3. Which technology was invented first?
- A) Internet (ARPANET)
- B) World Wide Web
- C) Email
- D) TCP/IP protocol
4. ChatGPT reached 100 million users in approximately:
- A) 6 months
- B) 3 months
- C) 2 months
- D) 1 month
5. The default port for HTTPS is:
- A) 80
- B) 110
- C) 143
- D) 443
6. The default port for SMTP is:
- A) 25
- B) 110
- C) 143
- D) 443
7. IPv4 uses how many bits for addressing?
- A) 16 bits
- B) 32 bits
- C) 64 bits
- D) 128 bits
8. IPv6 uses how many bits for addressing?
- A) 32 bits
- B) 64 bits
- C) 128 bits
- D) 256 bits
9. RAM differs from ROM in that RAM is:
- A) Non-volatile like ROM
- B) Volatile (loses data on shutdown)
- C) Permanent storage
- D) Never used for temporary data
10. AlphaGo defeated world champion Lee Sedol in:
- A) 2014
- B) 2015
- C) 2016
- D) 2017
11. Which language was created first?
- A) Python (1991)
- B) Java (1995)
- C) C++ (1985)
- D) JavaScript (1995)
12. The Dartmouth Conference (birth of AI) was held in:
- A) 1952
- B) 1956
- C) 1960
- D) 1964
13. Facebook was launched in:
- A) 2003
- B) 2004
- C) 2005
- D) 2006
14. The iPhone was released in:
- A) 2005
- B) 2006
- C) 2007
- D) 2008
15. Linux kernel was released by:
- A) Dennis Ritchie
- B) Bill Gates
- C) Linus Torvalds
- D) Tim Berners-Lee
16. GitHub was founded in:
- A) 2005
- B) 2006
- C) 2008
- D) 2010
17. Cloud computing models ranked by control (most to least) are:
- A) SaaS, PaaS, IaaS
- B) IaaS, PaaS, SaaS
- C) PaaS, IaaS, SaaS
- D) SaaS, IaaS, PaaS
18. Which is NOT part of the TCP/IP suite?
- A) TCP
- B) IP
- C) HTTP
- D) DNS
19. Which email protocol sends emails?
- A) IMAP
- B) POP3
- C) SMTP
- D) HTTP
20. Blockchain technology is characterized by being:
- A) Centralized
- B) Mutable (changeable)
- C) Transparent and immutable
- D) Requires trusted authority
21. The 3-2-1 backup rule means:
- A) 3 backups per day, 2 automatic, 1 manual
- B) 3 copies of data, 2 storage types, 1 off-site location
- C) 3 hours backup interval, 2 sites, 1 cloud
- D) 3 servers, 2 backups, 1 database
22. Which of the following is a relational database?
- A) MongoDB
- B) Cassandra
- C) PostgreSQL
- D) Redis
23. AI, ML, and DL relationship is:
- A) Three separate, unrelated concepts
- B) All the same thing
- C) AI contains ML; ML contains DL
- D) ML is bigger than AI
Answer Key: 1-B, 2-B, 3-A, 4-C, 5-D, 6-A, 7-B, 8-C, 9-B, 10-C, 11-C, 12-B, 13-B, 14-C, 15-C, 16-C, 17-B, 18-C, 19-C, 20-C, 21-B, 22-C, 23-C