SF Prep Notes
12 MP Police SI Prelims 2026 — Master Notes πŸ•’ Updated 2026-09-30
MP Police SI 2026 β€” Prelims English 10 Questions / 100

πŸ’» Basic Computer Knowledge

Basics, History, Hardware, Memory, I/O, Software, OS/Windows, MS Word/Excel/PowerPoint, Internet, Email, Networking, Protocols, Cyber Security, IT Act, Backup/Cloud, Number System, Abbreviations, Latest Tech β€” with 113 PYQs from the official 2025 paper

πŸ“Š Analysis of the 2025 paper (12 shifts Γ— 10 = 120 Computer questions): Most questions came from Internet/Browser/URL/IP (β‰ˆ20), Windows/OS (β‰ˆ16), Cyber Security (β‰ˆ10), Backup & Cloud Storage (β‰ˆ8), Software types (β‰ˆ8), Memory/Storage (β‰ˆ7) and Excel (β‰ˆ7). Level: easy to medium, with some "applied" (practical) questions. That is why every topic gives a concept + practical example β€” understanding matters along with memorising.

πŸ“Œ 1. Computer Basics (6 min read)

1.1 What is a Computer?

  • Computer = an electronic machine that takes data as input, processes it according to instructions (a program), and gives information as output. The word "compute" = to calculate.
  • A computer is also called a "Data Processor", because it can store data, process it and retrieve it whenever needed.
  • Data = raw facts, e.g. marks 45, 67. Information = processed, meaningful data, e.g. "average 56".
  • IPO Cycle: Input β†’ Process β†’ Output (+ Storage). The 3 sub-activities of data processing: (1) capturing input data, (2) manipulating data, (3) managing output results.
  • GIGO = Garbage In, Garbage Out β€” wrong input or a faulty program β†’ wrong output. The computer does not make mistakes by itself; the mistake lies in the input/program.

1.2 Components of a Computer

PartMeaningExample
HardwarePhysical parts that can be touchedKeyboard, CPU, Hard disk, Floppy drive, Monitor
SoftwareA set of programs / instructions (cannot be touched)Windows, MS Word, Compiler, Antivirus
FirmwareSoftware permanently written into hardware (ROM chip)BIOS
Liveware / Humanware / PeoplewarePeople who use the computer (users)Operator, programmer

⚠️ Hardware alone cannot do anything β€” it needs software instructions. And software needs hardware to run.

1.3 Characteristics of a Computer

CharacteristicMeaning
SpeedLakhs to crores of operations per second; time is measured in microseconds (10⁻⁢), nanoseconds (10⁻⁹), picoseconds (10⁻¹²)
AccuracyAlways the correct result for correct input (errors = GIGO)
DiligenceWorks continuously without tiring or resting; free from monotony, tiredness and lack of concentration
VersatilityThe same computer can do different jobs β€” banking, gaming, scientific
Storage / MemoryCan store a large amount of data and recall it at any time
ReliabilityDependable; gives the same result over a long time

Limitations: No I.Q. β€” a computer cannot take decisions by itself; it has to be told what to do and in what order (sequence). No Feelings β€” it cannot make judgments based on emotions/instinct.

1.4 Types of Computers

BasisTypes
Way of workingAnalog (continuous data β€” thermometer, speedometer), Digital (discrete 0/1 β€” PC, laptop), Hybrid (combination of both β€” hospital ICU monitoring)
Size / PowerMicro (PC, laptop, desktop) β†’ Mini (medium organisations) β†’ Mainframe (banks, railway reservation; thousands of users through terminals) β†’ Supercomputer (fastest; weather forecasting, nuclear research; speed in FLOPS)
PurposeGeneral purpose (PC) vs Special purpose (ATM, washing machine controller)
  • Dumb Terminal: A keyboard + monitor connected to a mainframe that has no processing or storage of its own β€” the mainframe does all the work. (A smart terminal has some processing.)
  • Computer Simulation: Running a real-world system on a computer as a mathematical model (e.g. flight simulator, weather model).
  • Applications: CAD (Computer-Aided Design) and CAM β€” in manufacturing/engineering design; e-governance, banking, healthcare, education, defence.
⚠️ Exam Traps:
  • "Works continuously without rest" = Diligence (not Speed). "Different jobs" = Versatility.
  • "No IQ" = cannot take decisions by itself. "No feelings" = cannot judge based on emotion. The two are separate options.
  • A compiler is software, not hardware.
  • The full form of GIGO is "Garbage In Garbage Out" β€” avoid distractors like GIGA/GOGA.
🎯 PYQs β€” Official MPESB SI Prelims 2025 paper
Q1. What do the characteristics "No I.Q." represent? MPESB SI Prelims 2025 β€” 16 Jan 2026, Shift 1
(A) Cannot make judgments based on feelings/instincts
(B) Cannot take decisions by itself; has to be told what to do and in what order
(C) Can store a lot of information and recall it
(D) Is free from monotony and tiredness
Correct answer: (B)
No IQ = the computer is a "dumb" machine; it does not use a mind of its own. (A) is the definition of "No Feelings", (C) Storage, (D) Diligence.
Q2. Which of the following statements is true? (Data processing) MPESB SI Prelims 2025 β€” 16 Jan 2026, Shift 2
(A) Data processing has 3 sub-activities: input capture, data manipulation, managing output results
(B) 2 sub-activities: input capture and manipulation
(C) 4 sub-activities: capture, calculate, manipulate, output
(D) None of the above
Correct answer: (A)
Standard textbook definition: data processing = capturing input data + manipulating data + managing output results (three).
Q3. According to the description of software, data and users, which statement is NOT correct? MPESB SI Prelims 2025 β€” 16 Jan 2026, Shift 2
(A) Program = a set of instructions written in a language the computer understands
(B) Hardware alone can work without software instructions
(C) Data are raw facts which, when processed, become meaningful information
(D) Users are also called skinware, liveware, humanware, peopleware
Correct answer: (B)
Hardware is useless without software β€” this statement is wrong; the other three are correct.
Q4. What is the main characteristic of a dumb terminal in a mainframe system? MPESB SI Prelims 2025 β€” 17 Jan 2026, Shift 2
(A) Can store data but cannot process it
(B) Can neither store data nor do processing by itself
(C) Has its own storage and processing capability
(D) Can process but cannot display output
Correct answer: (B)
A dumb terminal only sends input and shows output; the mainframe does the storage/processing.
Q5. Which feature allows a computer to switch between banking, gaming and scientific tasks? MPESB SI Prelims 2025 β€” 18 Jan 2026, Shift 2
(A) Isolation
(B) Versatility
(C) Humanness
(D) Infallibility
Correct answer: (B) Versatility
One machine, many kinds of jobs = versatility.
Q6. Which application area uses computers for CAD (Computer-Aided Design)? MPESB SI Prelims 2025 β€” 18 Jan 2026, Shift 2
(A) Manufacturing
(B) Education
(C) Defense
(D) Healthcare
Correct answer: (A) Manufacturing
CAD/CAM are used in the design and manufacturing of products and machine parts (software like AutoCAD).
Q7. Computers that work continuously without rest show which characteristic? MPESB SI Prelims 2025 β€” 20 Jan 2026, Shift 1
(A) Emotion
(B) Diligence
(C) Transparency
(D) Randomness
Correct answer: (B) Diligence
Q8. A computer is often called a ____, because it can store, process and retrieve data whenever required. MPESB SI Prelims 2025 β€” 20 Jan 2026, Shift 1
(A) Data analyzer
(B) Data processor
(C) Data compiler
(D) Data converter
Correct answer: (B) Data processor
Q9. Which of the following is NOT an example of hardware? MPESB SI Prelims 2025 β€” 20 Jan 2026, Shift 1
(A) Keyboard
(B) Hard disk drive
(C) Floppy disk drive
(D) Compiler
Correct answer: (D) Compiler
A compiler is software (a language translator).
Q10. What is the primary purpose of computer simulation? MPESB SI Prelims 2025 β€” 20 Jan 2026, Shift 1
(A) To carry out real-world experiments physically
(B) To run a mathematical model that represents a real-world system
(C) To replace analytical solutions with manual calculation
(D) Only to visualise graphical output
Correct answer: (B)
Q11. Errors caused by wrong input data or unreliable programs are called ____. MPESB SI Prelims 2025 β€” 21 Jan 2026, Shift 2
(A) garbage-in-garbage-out (GIGO)
(B) garbage-in-garbage-add (GIGA)
(C) garbage-out-garbage-add (GOGA)
(D) None of the above
Correct answer: (A) GIGO
✍️ Practice MCQs (self-made, not PYQs)
P1. Thermometers and speedometers are examples of which type of computing device? Practice MCQ
(A) Digital
(B) Analog
(C) Hybrid
(D) Mainframe
Answer: (B) Analog β€” they measure a continuous (constantly changing) quantity.
P2. Which computer is used for very large calculations such as weather forecasting? Practice MCQ
(A) Microcomputer
(B) Minicomputer
(C) Supercomputer
(D) Laptop
Answer: (C) Supercomputer

πŸ“Œ 2. History, Fathers & Generations (7 min read)

2.1 Timeline β€” from calculating devices to computers

Device / MachineBy whom / WhenPoint to remember
AbacusAncient times (China/Mesopotamia)The very first calculating device; addition-subtraction with beads
Napier's BonesJohn Napier, 1617Rods for multiplication
PascalineBlaise Pascal, 1642First mechanical adding machine (addition-subtraction)
Stepped ReckonerLeibniz, 1673Could also multiply and divide
Jacquard LoomJoseph Marie Jacquard, 1804Cloth designs using punch cards β€” the punch card idea came from here
Difference Engine (1822) & Analytical Engine (1830s)Charles BabbageThe Analytical Engine had a Mill (β‰ˆCPU), a Store (β‰ˆMemory) and punch card input β€” the basis of the modern computer. Hence Babbage = "Father of Computer"
β€”Ada LovelaceWrote a program for the Analytical Engine β€” the world's first programmer
Tabulating MachineHerman Hollerith, 1890 (US census)Data processing with punch cards; his company later became IBM
Mark I (ASCC)Howard Aiken + IBM; 1937–44 (designed in 1937, handed to Harvard in 1944)Electromechanical computer
ENIACJ. Presper Eckert & John Mauchly; made public in 1946First general-purpose electronic digital computer; about 18,000 vacuum tubes
EDSACMaurice Wilkes, 1949 (Cambridge)First practical stored-program computer
UNIVAC IEckert & Mauchly, 1951First commercial computer (USA)

Von Neumann Architecture: John von Neumann's stored-program concept β€” both program and data are stored in memory. Almost all of today's computers are based on it.

2.2 Generations of Computers

GenerationTechnologyFeatures / Examples
1st (β‰ˆ1940–1956)Vacuum TubeVery large, hot, used a lot of power; machine language; punch cards; ENIAC, EDVAC, UNIVAC I
2nd (β‰ˆ1956–1963)Transistor (1947, Bell Labs)Smaller, faster; assembly language, FORTRAN/COBOL began; IBM 1401
3rd (β‰ˆ1964–1971)IC (Integrated Circuit) β€” Jack Kilby, 1958Keyboard-monitor, operating system, multiprogramming; IBM System/360
4th (β‰ˆ1971–present)Microprocessor (VLSI) β€” Intel 4004 (1971) was the first microprocessorPersonal Computer (IBM PC 1981), GUI, internet, laptop
5th (present–future)AI (Artificial Intelligence), ULSI, parallel processingNatural language, robotics, expert systems, quantum computing research

Note: different books differ by 1–2 years; in the exam the order of technology (Vacuum tube β†’ Transistor β†’ IC β†’ Microprocessor β†’ AI) matters most.

2.3 "Father of ..." β€” the most frequently asked

FieldFatherFieldFather
ComputerCharles BabbageFirst programmerAda Lovelace
Modern Computer Science (Turing Machine, Turing Test)Alan TuringArtificial Intelligence (term 1956)John McCarthy
Internet (TCP/IP)Vint Cerf & Bob KahnWorld Wide Web (1989)Tim Berners-Lee
Email (1971, use of @)Ray TomlinsonComputer MouseDouglas Engelbart
QWERTY keyboardChristopher Latham SholesStored program conceptJohn von Neumann
Linux (1991)Linus TorvaldsC language (1972) / UNIXDennis Ritchie (UNIX: with Ken Thompson)
JavaJames GoslingPythonGuido van Rossum
Indian Supercomputer (PARAM)Vijay BhatkarIndian IT industryF. C. Kohli
Hotmail (co-founder)Sabeer BhatiaUSB (co-inventor, Intel)Ajay Bhatt

2.4 Computers in India

  • HEC-2M β€” the first electronic digital computer installed in India; Indian Statistical Institute (ISI), Kolkata, 1956 (an initiative of Prof. P.C. Mahalanobis). It was British-built.
  • TIFRAC β€” the first (indigenous) digital computer designed and built in India itself; TIFR Mumbai; formally commissioned in 1960 (named by Pandit Nehru).
  • PARAM 8000 β€” India's first indigenous supercomputer (1991), built by C-DAC, Pune. PARAM = "Parallel Machine" / in Sanskrit "param" (supreme).
⚠️ Exam Traps:
  • Father of Computer = Babbage; father of modern computer science = Turing; father of AI = McCarthy.
  • Internet β‰  WWW: the father of the Internet is Vint Cerf; of the WWW, Tim Berners-Lee.
  • 1st gen = vacuum tube, 2nd = transistor, 3rd = IC, 4th = microprocessor. Do not swap "IC" and "microprocessor".
  • Mark I (1944) was electromechanical; ENIAC was the first fully electronic general-purpose computer.
🎯 PYQs β€” Official MPESB SI Prelims 2025 paper
Q1. In which year was the Mark I computer built? MPESB SI Prelims 2025 β€” 17 Jan 2026, Shift 2
(A) 1937-44
(B) 1947-48
(C) 1837-44
(D) 1847-49
Correct answer: (A) 1937-44
Howard Aiken gave the proposal/design in 1937; IBM built it and handed it to Harvard in 1944.
✍️ Practice MCQs (self-made, not PYQs)
P1. Transistors were used in which generation of computers? Practice MCQ
(A) First
(B) Second
(C) Third
(D) Fourth
Answer: (B) Second (2nd)
P2. Who is considered the world's first computer programmer? Practice MCQ
(A) Grace Hopper
(B) Ada Lovelace
(C) Marie Curie
(D) Alan Turing
Answer: (B) Ada Lovelace
P3. Which organisation built India's first indigenous supercomputer PARAM 8000? Practice MCQ
(A) ISRO
(B) BARC
(C) C-DAC
(D) DRDO
Answer: (C) C-DAC (Pune)

πŸ“Œ 3. CPU, Motherboard & Ports (Hardware) (6 min read)

3.1 CPU (Central Processing Unit) β€” "The Brain of the Computer"

CPU = ALU + CU + Registers (along with cache memory).

PartFunction
ALU (Arithmetic Logic Unit)All calculations (+ βˆ’ Γ— Γ·) and logical operations (AND, OR, NOT, comparison: >, <, =)
CU (Control Unit)Controls/coordinates the whole computer; gets instructions fetched β†’ decoded β†’ executed. Does not process data itself. "Manager/traffic police of the computer"
RegistersThe fastest and smallest memory inside the CPU (Accumulator, Program Counter, Instruction Register, MAR, MDR)
  • Machine cycle: Fetch β†’ Decode β†’ Execute β†’ Store.
  • Clock speed is measured in Hertz β€” today in GHz (gigahertz). Multi-core = several processing cores on one chip (dual-core, quad-core).
  • Microprocessor = the whole CPU on one chip. First: Intel 4004 (1971). Companies: Intel, AMD; in mobiles Qualcomm Snapdragon, MediaTek, Apple.
  • GPU (Graphics Processing Unit) β€” a separate processor for graphics/video/AI.

3.2 Parts of the Motherboard and Cabinet

  • Motherboard = the main circuit board (PCB); it has the CPU socket, RAM slots, chipset, BIOS chip, expansion slots (PCIe) and the CMOS battery (keeps the BIOS settings and the clock running).
  • SMPS (Switched-Mode Power Supply) β€” converts AC power into DC and supplies it to the parts. UPS = backup when the power goes.
  • Bus = paths that carry data: Data bus (data), Address bus (address of the memory location), Control bus (control signals).

3.3 Ports and Connectors (asked in the 2025 paper)

Port / ConnectorUse
RJ45Connecting a computer to a network (LAN/Ethernet)
RJ11Telephone line / DSL modem
USB (Universal Serial Bus)Pen drive, mouse, printer; plug-and-play, hot-swap. Type-A, Type-B, Type-C (fits either way up)
HDMIDigital audio + video in a single cable (TV, projector). Type A (standard), Type C (Mini HDMI), Type D (Micro HDMI)
VGAOld analog video port (15-pin) β€” monitor/projector
FireWire (IEEE 1394)High-speed bus β€” mainly for video cameras and external hard drives
PS/2Old keyboard (purple) and mouse (green)
Serial (COM) / Parallel (LPT)Old modem / printer
SATAConnects the internal hard disk / SSD to the motherboard
⚠️ Exam Traps:
  • The ALU does both calculation and comparison (logic); the CU only controls.
  • Network cable = RJ45; phone cable = RJ11. VGA/HDMI = display, PS/2 = keyboard/mouse.
  • The fastest memory inside the CPU = Register (not cache).
🎯 PYQs β€” Official MPESB SI Prelims 2025 paper
Q1. Which connector is used to connect a computer to a network? MPESB SI Prelims 2025 β€” 16 Jan 2026, Shift 2
(A) VGA Connector
(B) FireWire
(C) RJ45 Connector
(D) PS/2
Correct answer: (C) RJ45
An Ethernet (LAN) cable has an RJ45 connector at both ends.
Q2. ____ is another bus which is nowadays used mainly for video cameras and external hard drives. MPESB SI Prelims 2025 β€” 21 Jan 2026, Shift 2
(A) FireWire
(B) USB Port
(C) SCSI Port
(D) PS/2
Correct answer: (A) FireWire
The textbook describes FireWire (IEEE 1394) as the bus for "video cameras and external hard drives".
✍️ Practice MCQs (self-made, not PYQs)
P1. Which part of the CPU compares two numbers? Practice MCQ
(A) CU
(B) ALU
(C) RAM
(D) Register
Answer: (B) ALU β€” logical/comparison operations are also done in the ALU.
P2. Which port sends both digital audio and video in a single cable? Practice MCQ
(A) VGA
(B) PS/2
(C) HDMI
(D) RJ11
Answer: (C) HDMI

πŸ“Œ 4. Memory & Storage (8 min read)

4.1 Memory Hierarchy (fast β†’ slow)

Registers β†’ Cache β†’ RAM (main memory) β†’ SSD β†’ Hard Disk β†’ Optical disc / Tape
Going up: speed ↑, cost per byte ↑, capacity ↓. Going down: cheaper, bigger, slower.

4.2 Primary vs Secondary Memory

Primary (Main) MemorySecondary (Auxiliary) Memory
Accessed directly by the CPUNot accessed directly by the CPU; first loaded into RAM
Fast, costly, small capacitySlow, cheap, very large capacity
RAM (volatile) + ROMHard disk, SSD, pen drive, CD/DVD, memory card, tape
β€”Why is it needed? To make up for the limited capacity and volatility (data is erased as soon as power goes) of primary storage

4.3 RAM and ROM

RAM (Random Access Memory)ROM (Read Only Memory)
Volatile (temporary) β€” power off = data lostNon-volatile (permanent)
Both Read + WriteMainly Read only
Holds the programs/data currently runningBIOS/firmware, booting instructions
  • SRAM (Static RAM): made of flip-flops; does not need refreshing; very fast, costly β†’ used as cache memory.
  • DRAM (Dynamic RAM): made of capacitors; the charge leaks, so the data has to be continuously read and rewritten (refreshed) by a refresh circuit; cheap β†’ main memory. SDRAM, DDR4, DDR5 are its forms.
  • Types of ROM: PROM (programmed once), EPROM (erased by UV light), EEPROM (erased electrically), Flash memory (a fast form of EEPROM β€” pen drive, SSD, memory card).

4.4 Cache and Virtual Memory

  • Cache memory: very fast (SRAM) memory between the CPU and RAM; holds frequently used data. L1 cache = closest to the CPU core, fastest, smallest; then L2, then L3 (large, shared between cores).
  • Virtual memory: when RAM runs short, part of the hard disk/SSD is used like RAM ("paging file" in Windows).

4.5 Secondary Storage Devices

TypeExamplesKey facts
MagneticHard Disk (HDD), floppy, magnetic tapeMagnetic disk (HDD) = the most widely used secondary storage (traditionally). Tape = sequential access (for backup)
OpticalCD, DVD, Blu-rayRead by a laser; data stored as pits and lands
Solid-state / FlashSSD, pen drive, memory cardNo moving parts; many times faster than an HDD
  • Structure of a hard disk: rotating platters β†’ circular paths called tracks β†’ pieces of tracks called sectors. A sector traditionally holds 512 bytes (4096 bytes in newer "Advanced Format" disks). A group of matching tracks = cylinder. The read/write head reads/writes data. Speed in RPM (e.g. 5400, 7200 RPM).
  • Access time = seek time (moving the head to the track) + rotational latency (the sector coming under the head).
  • Capacity (approx.): Floppy 3.5" = 1.44 MB; CD = 700 MB; DVD = 4.7 GB (single layer), 8.5 GB (dual layer); Blu-ray = 25 GB (single layer, blue-violet laser).
  • CD-ROM = can only be read; CD-R = write once (WORM β€” Write Once Read Many); CD-RW = write and erase again and again.
  • DVD-ROM is also optical storage (digital video or computer data), the same size as a CD (12 cm) but with more capacity.

4.6 Units of Memory

UnitEqualsUnitEquals
1 Bit0 or 1 (Binary digit) β€” the smallest unit1 GB (Gigabyte)1024 MB
1 Nibble4 bits1 TB (Terabyte)1024 GB
1 Byte8 bits (one character)1 PB (Petabyte)1024 TB
1 KB (Kilobyte)1024 bytes (2¹⁰)1 EB (Exabyte)1024 PB
1 MB (Megabyte)1024 KB1 ZB β†’ 1 YBZettabyte β†’ Yottabyte

Remember the order: Bit β†’ Nibble β†’ Byte β†’ KB β†’ MB β†’ GB β†’ TB β†’ PB β†’ EB β†’ ZB β†’ YB. (Hard disk companies often count 1 KB = 1000 bytes, so a 1 TB disk shows slightly less in Windows.)

⚠️ Exam Traps:
  • DRAM needs refreshing, SRAM does not. DRAM is volatile (not non-volatile).
  • RAM = volatile; ROM = non-volatile. Cache is also volatile.
  • Fastest: Register > L1 > L2 > L3 > RAM.
  • In a CD/DVD, data is stored not by magnetic charge but by pits & lands (laser reflection).
  • 1 KB = 1024 bytes (not 1000 in the exam).
🎯 PYQs β€” Official MPESB SI Prelims 2025 paper
Q1. How does a CD-ROM represent binary data? MPESB SI Prelims 2025 β€” 16 Jan 2026, Shift 1
(A) Magnetic charges
(B) Pits and lands that reflect laser light
(C) Electrical pulses
(D) Ink marks on the surface
Correct answer: (B) Pits and lands
The laser reflects differently from pits and lands β€” this is how 0/1 is read.
Q2. Which statement about DRAM is correct? MPESB SI Prelims 2025 β€” 17 Jan 2026, Shift 1
(A) It does not need refreshing to hold data
(B) It continuously reads and rewrites data using a refresh circuit
(C) It is non-volatile and holds data without power
(D) It is slower than ROM
Correct answer: (B)
DRAM stores charge in capacitors, which leaks, so refreshing is necessary.
Q3. Which is the most widely used secondary storage medium? MPESB SI Prelims 2025 β€” 17 Jan 2026, Shift 2
(A) Semiconductor chip
(B) Magnetic disk
(C) Optical fiber
(D) Cache memory
Correct answer: (B) Magnetic disk
The hard disk (magnetic disk) is traditionally the most common secondary storage. Cache is memory on the primary side; optical fiber is a cable.
Q4. Which cache level is closest to the CPU core and the fastest? MPESB SI Prelims 2025 β€” 17 Jan 2026, Shift 2
(A) L1 Cache
(B) L2 Cache
(C) L3 Cache
(D) Virtual Cache
Correct answer: (A) L1 Cache
Q5. Why is secondary storage used in a computer system? MPESB SI Prelims 2025 β€” 19 Jan 2026, Shift 2
(A) To increase processing speed
(B) To make up for the limited capacity and volatility of primary storage
(C) To execute instructions during processing
(D) To convert data into binary codes
Correct answer: (B)
Q6. How many bytes does a hard disk store per sector? MPESB SI Prelims 2025 β€” 20 Jan 2026, Shift 2
(A) 256 bytes
(B) 512 bytes
(C) 1024 bytes
(D) 2048 bytes
Correct answer: (B) 512 bytes
The standard/traditional sector size is 512 bytes (newer Advanced Format disks use 4096 bytes β€” but that is not among the options).
Q7. Compared with a CD-ROM, which statement about a DVD-ROM is correct? MPESB SI Prelims 2025 β€” 21 Jan 2026, Shift 2
(A) DVD-ROM uses magnetic storage
(B) DVD-ROM is an optical storage device that stores digital video or computer data
(C) DVD-ROM cannot store video data
(D) DVD-ROM is physically smaller than a CD-ROM
Correct answer: (B)
A DVD is also optical, the same size as a CD (12 cm), with more capacity.
✍️ Practice MCQs (self-made, not PYQs)
P1. How many bits make 1 Nibble? Practice MCQ
(A) 2
(B) 4
(C) 8
(D) 16
Answer: (B) 4
P2. Which ROM can be erased with ultraviolet (UV) light? Practice MCQ
(A) PROM
(B) EPROM
(C) EEPROM
(D) Mask ROM
Answer: (B) EPROM (EEPROM is erased electrically)
P3. The data of which memory is erased when the power goes? Practice MCQ
(A) ROM
(B) Hard disk
(C) RAM
(D) Pen drive
Answer: (C) RAM (volatile)

πŸ“Œ 5. Input / Output Devices (6 min read)

5.1 Input Devices (give data to the computer)

DeviceKey point
KeyboardQWERTY layout (C. L. Sholes); function keys F1–F12; toggle keys: Caps Lock, Num Lock, Scroll Lock
MousePointing device (Douglas Engelbart); left/right click, scroll wheel; optical/laser. Gaming mouse = programmable buttons + high-precision laser/optical sensor
Trackball, Touchpad, Joystick, Light pen, StylusPointing devices; joystick β€” games/simulators
ScannerConverts a paper image into digital form (flatbed, handheld)
OCR (Optical Character Recognition)Converts printed/written text into editable text
OMR (Optical Mark Reader)Reads circles/bubbles β€” OMR answer sheet
MICR (Magnetic Ink Character Recognition)Reads the magnetic-ink numbers at the bottom of a bank cheque
BCR (Barcode Reader), QR scannerProduct barcodes in shops
BiometricFingerprint, iris, face (Aadhaar authentication)
Microphone, Webcam, Digitizer/Graphics tabletVoice, video, drawing input

5.2 Output Devices

  • Monitor (VDU β€” Visual Display Unit): CRT (old), LCD, LED, OLED. The smallest unit of the screen = pixel (picture element). Resolution = pixels (e.g. 1920Γ—1080).
  • Printer (hard copy), Plotter (large engineering drawings/maps/CAD), Speaker, Headphone, Projector.
  • Soft copy = on screen; Hard copy = on paper (printout).
  • Both (Input + Output): Touchscreen, Headset (mic+speaker), Modem.

5.3 Printers

Impact printers (strike the paper)Non-impact printers (without striking)
Dot Matrix β€” pins strike a ribbon to make dots; noisy, can make carbon copies; speed in CPS (characters per second)Laser β€” toner (powder) + drum; prints the whole page at once β†’ hence "Page Printer"; speed in PPM (pages per minute); best quality
Daisy Wheel β€” print head is a wheel shaped like a daisy flower; letter-quality text, no graphicsInkjet β€” sprays droplets of liquid ink; cheap for home use; colour photos
Line printers (Drum, Chain) β€” one line at a time; speed in LPM (lines per minute); mainframeThermal β€” heat-sensitive paper (ATM slip, bill receipt); 3D printer β€” 3-D objects

Print quality = DPI (dots per inch).

⚠️ Exam Traps:
  • "Page printer" = Laser. "Daisy flower head" = Daisy wheel.
  • Cheque = MICR; exam answer sheet = OMR; printed text β†’ editable = OCR.
  • Scanner = input; Plotter = output; Touchscreen = both.
🎯 PYQs β€” Official MPESB SI Prelims 2025 paper
Q1. Which type of printer is also known as a page printer? MPESB SI Prelims 2025 β€” 17 Jan 2026, Shift 1
(A) Ink-jet printer
(B) Laser printer
(C) Dot matrix printer
(D) Daisy wheel printer
Correct answer: (B) Laser printer
A laser printer forms the image of the whole page on the drum and prints it at once.
Q2. Which feature distinguishes a gaming mouse? MPESB SI Prelims 2025 β€” 20 Jan 2026, Shift 2
(A) USB connectivity
(B) Programmable buttons and laser optics
(C) Infrared motion sensing
(D) Built-in display
Correct answer: (B)
Every mouse has USB; a gaming mouse is identified by extra programmable buttons + a precise sensor.
Q3. Which printer uses a print head shaped like a daisy flower? MPESB SI Prelims 2025 β€” 21 Jan 2026, Shift 2
(A) Dot Matrix Printer
(B) Daisy Wheel Printer
(C) Drum Printer
(D) Line Printer
Correct answer: (B) Daisy Wheel Printer
✍️ Practice MCQs (self-made, not PYQs)
P1. Which technology is used to read the numbers printed at the bottom of a bank cheque? Practice MCQ
(A) OMR
(B) OCR
(C) MICR
(D) BCR
Answer: (C) MICR
P2. Which of these is an impact printer? Practice MCQ
(A) Laser
(B) Inkjet
(C) Dot matrix
(D) Thermal
Answer: (C) Dot matrix

πŸ“Œ 6. Software & Programming Languages (7 min read)

6.1 System Software vs Application Software

System SoftwareApplication Software
Runs the hardware and provides a platform for other softwareFor the user's specific tasks (writing letters, editing photos, billing)
Manages resources such as memory, CPU and I/O devices and allocates them to different programsRuns on top of system software
Examples: Operating System, device drivers, utility programs (antivirus, disk cleanup, defragmenter, file compression), language translators, firmware (BIOS)Examples: MS Word, Excel, browser, VLC, Tally, Photoshop, games, railway reservation software
  • Device driver = system software that lets the OS talk to a hardware device (printer, graphics card). (Not application software!)
  • Firmware = system-level software kept permanently inside hardware (ROM/flash), e.g. BIOS. (Not application software!)
  • Horizontal application = general-purpose, used by people in every industry (Word, Excel, browser). Vertical application = for one particular industry (hospital management, bank core-banking, school ERP).
  • History: in the late 1940s, application software was custom-written by users themselves according to their own hardware and needs β€” ready-made software came later.
  • The word "App" was made popular by the launch of Apple's iOS App Store in 2008.

6.2 Features and Drawbacks of the OS / System Software

  • Functions: process/processor management (scheduling), memory management, file management, device management, security, job accounting, error-detecting aids (dumps, traces, error messages, debugging), user interface.
  • Drawbacks (disadvantages): System Overhead β€” it occupies CPU/RAM itself, which can slow the computer down; Limited Customizability β€” hard to change the computing experience to suit yourself; Dependency; Cost; Need for upgrades.

6.3 Software by Licence

TypeMeaningExample
Open SourceSource code open to everyone; can be changed/sharedLinux, Android (AOSP), Firefox, LibreOffice, VLC
Proprietary / ClosedCode belongs to the company; a licence must be boughtWindows, MS Office, macOS
FreewareFree of cost but code is closedAdobe Acrobat Reader
Shareware / TrialFree for some days, then paidTrial versions

6.4 Programming Languages and Translators

  • Machine language (0 and 1) β€” the only language the CPU understands directly. Assembly language β€” mnemonics (ADD, MOV). High-level language β€” English-like (C, Java, Python).
  • Assembler: assembly β†’ machine code. Compiler: translates the whole program at once, then gives a list of errors (C, C++). Interpreter: translates and runs line by line; stops right there at an error (Python, BASIC).
  • First high-level language: FORTRAN (1957, IBM β€” scientific). COBOL β€” business. C β€” Dennis Ritchie (1972). Java β€” James Gosling (Sun). Python β€” Guido van Rossum. HTML β€” a markup language for making web pages (not a programming language).
  • Source code (written by the programmer) β†’ Object code (after translation). A mistake in a program = bug; removing it = debugging.
  • Algorithm = step-by-step solution; Flowchart = its diagram β€” Oval (start/end), Parallelogram (input/output), Rectangle (process), Diamond (decision).
⚠️ Exam Traps:
  • OS, device driver, utility, firmware = system software. Word/Excel/browser = application.
  • System software provides the platform; application software does the user's specific task β€” the reversed option is wrong.
  • Compiler β€” whole program at once; interpreter β€” line by line.
  • The drawback that slows performance = System overhead; being unable to personalise = Limited customizability.
🎯 PYQs β€” Official MPESB SI Prelims 2025 paper
Q1. Which drawback of system software can slow down the computer's performance? MPESB SI Prelims 2025 β€” 16 Jan 2026, Shift 2
(A) Cost
(B) Upgrades
(C) Dependency
(D) System Overhead
Correct answer: (D) System Overhead
System software itself uses resources (CPU time, RAM) β€” this can reduce performance.
Q2. Which of the following statements is correct? MPESB SI Prelims 2025 β€” 17 Jan 2026, Shift 2
(A) System software manages and allocates resources such as memory, CPU and I/O devices among programs
(B) The OS schedules processes through its file management
(C) Device drivers are a type of application software
(D) Firmware is a type of application software
Correct answer: (A)
(B) is wrong β€” scheduling is a job of process management; (C), (D) are wrong β€” drivers and firmware are system software.
Q3. Which statement correctly states the difference between system software and application software? MPESB SI Prelims 2025 β€” 18 Jan 2026, Shift 1
(A) System software is for end-user tasks (documents)
(B) Application software provides a platform for other software
(C) System software provides a platform for other software, while application software lets users do specific tasks
(D) Both are interchangeable
Correct answer: (C)
Q4. Which statement about application software was true in the late 1940s? MPESB SI Prelims 2025 β€” 19 Jan 2026, Shift 2
(A) Hardware manufacturers supplied it
(B) Computer users custom-wrote it themselves for specific hardware and needs
(C) It came bundled with the OS
(D) Only for gaming
Correct answer: (B)
Q5. What is the main difference between horizontal and vertical application software? MPESB SI Prelims 2025 β€” 19 Jan 2026, Shift 2
(A) Horizontal is niche, vertical is general-purpose
(B) Horizontal is general-purpose; vertical is industry-specific
(C) Both are industry-specific
(D) Both are general-purpose
Correct answer: (B)
Q6. Which feature of system software is related to producing dumps, traces, error messages and debugging? MPESB SI Prelims 2025 β€” 20 Jan 2026, Shift 2
(A) Scheduling
(B) Memory Management
(C) Error-detecting Aids
(D) Processor Management
Correct answer: (C) Error-detecting Aids
Q7. Which event made the abbreviation "app" popular? MPESB SI Prelims 2025 β€” 20 Jan 2026, Shift 2
(A) Windows Store in 2011
(B) Launch of the iOS App Store in 2008
(C) Android OS in 2007
(D) Mac App Store in 2010
Correct answer: (B) 2008 β€” iOS App Store
Apple's App Store arrived in July 2008; after this the word "app" came into everyday use.
Q8. Which drawback of system software refers to the difficulty of personalising the computing experience? MPESB SI Prelims 2025 β€” 21 Jan 2026, Shift 2
(A) Limited Customizability
(B) Upgrades
(C) Dependency
(D) Cost
Correct answer: (A) Limited Customizability
✍️ Practice MCQs (self-made, not PYQs)
P1. Which translator translates and runs a high-level program line by line? Practice MCQ
(A) Compiler
(B) Assembler
(C) Interpreter
(D) Loader
Answer: (C) Interpreter
P2. Which of these is open-source software? Practice MCQ
(A) MS Windows
(B) Linux
(C) MS Office
(D) macOS
Answer: (B) Linux

πŸ“Œ 7. Operating System & Windows (10 min read)

7.1 What is an Operating System (OS)?

  • OS = the interface between the user and the hardware + a resource manager. The main software that loads first as soon as the computer is switched on.
  • Booting = loading the OS into RAM. BIOS/UEFI β†’ POST (Power-On Self-Test) β†’ bootloader β†’ OS. Cold boot = starting from off; Warm boot = restart.
  • Interface: CLI (Command Line β€” MS-DOS, Linux terminal; commands are typed) vs GUI (Graphical β€” icons, windows, mouse: Windows, macOS).
  • Types: Batch, Multiprogramming, Multitasking/Time-sharing, Multiprocessing, Real-Time OS (instant response β€” missile, ABS brake, medical), Distributed, Network OS, Mobile OS, Embedded.
OSCompany / By whomType
WindowsMicrosoft (the company of Bill Gates & Paul Allen); Windows 1.0 β€” 1985; Windows 11 β€” 2021Proprietary graphical OS
MS-DOSMicrosoftCLI, single-user
macOS / iOSAppleProprietary
LinuxLinus Torvalds (kernel, 1991)Open source; distros β€” Ubuntu, Fedora, Debian; BOSS Linux (India, C-DAC)
UNIXKen Thompson & Dennis Ritchie, Bell Labs (1969)Multi-user
AndroidGoogle (based on the Linux kernel)Open-source mobile OS
  • Why was Linux made? Richard Stallman's GNU project (a free OS) did not have a working kernel; Linus Torvalds's Linux kernel + GNU tools = a complete free OS (GNU/Linux).
  • Linux desktop environments: GNOME, KDE Plasma, Xfce. (X11 and Wayland = display server/protocol; LAMP = Linux-Apache-MySQL-PHP web stack β€” these are not desktop environments.)

7.2 Parts of Windows (Desktop & Taskbar)

  • Desktop β€” the first screen; icons (This PC, Recycle Bin). Wallpaper = background image.
  • Taskbar (the strip at the bottom): Start button, search, Task View, pinned/open apps, and in the right corner the Notification Area (System Tray) β€” clock, date, volume, network, battery, notifications.
  • Right-click on an empty part of the taskbar β†’ Taskbar context menu (Task Manager, Taskbar settings).
  • Task View (Win + Tab) β€” all open windows and virtual desktops together.
  • Recycle Bin β€” deleted files go here (they can be restored). Shift + Delete = direct permanent delete (not to the Recycle Bin). Files deleted from a pen drive usually do not go to the Recycle Bin.

7.3 Control Panel

OptionFunction
Programs and FeaturesUninstall / change software
Ease of AccessAccessibility for users with disabilities β€” Narrator, Magnifier, On-Screen Keyboard, high contrast
Device ManagerView/update hardware and drivers
Network and Sharing CenterNetwork settings

Ways to open the Control Panel: from the Start menu/search; by typing "control" in the Run dialog (Win + R); by typing "control" in the Command Prompt. The Control Panel does not open from BIOS settings (BIOS is the firmware setup that comes before the OS loads).

7.4 Files and Folders

  • File = a named collection of data (document, photo). Folder (Directory) = a container for files; you can create subfolders/subdirectories inside a folder for better management. Files can also be renamed later (F2).
  • Root directory = the top-most folder of a drive, e.g. C:\. Path = C:\Users\Anjali\Documents\notes.docx.
  • In Windows the default maximum path length = 260 characters (MAX_PATH); a single file/folder name can be max 255 characters.
  • These characters cannot be used in a file name: \ / : * ? " < > |
  • The file extension (the part after the name, e.g. .docx) tells what type the file is and which default program will open it. In Windows, extensions are not case-sensitive (.PDF = .pdf).
  • Command Prompt (cmd) commands: dir (list files), dir /a (all files including hidden), cd (change folder), md/mkdir (make folder), rd (remove folder), copy, del, cls (clear screen), ipconfig (see IP), ping (check connection). (ls -a is a Linux command.)
  • Silent Installation = installing software without user interaction/prompts (in IT departments). For an .msi package: msiexec /quiet /i filename.msi (or msiexec /i filename.msi /quiet).

7.5 Windows Keyboard Shortcuts (very important)

ShortcutFunctionShortcutFunction
Ctrl + C / X / VCopy / Cut / PasteCtrl + Z / YUndo / Redo
Ctrl + ASelect allF2Rename
Ctrl + Shift + NNew folder (File Explorer)Shift + DeletePermanent delete
Win + DShow desktopWin + EFile Explorer
Win + LLock computerWin + TabTask View
Alt + TabSwitch between open windowsAlt + F4Close window/program
Ctrl + Shift + EscTask Manager directlyCtrl + Alt + DelSecurity screen (Lock, Task Manager)
Win + RRun dialogWin + ISettings
Win + Shift + SScreenshot (Snipping)Alt + EnterProperties
⚠️ Exam Traps:
  • Windows = proprietary graphical OS (not open source). Linux = open source.
  • Clock/notifications = Notification Area (System Tray), not the Start menu.
  • Uninstall = Programs and Features; accessibility = Ease of Access.
  • To show hidden files in Windows cmd: dir /a (dir /h is not a standard option; ls -a is Linux).
  • Win + Tab = Task View; Alt + Tab = switch windows.
  • Path limit is 260 (not 256).
🎯 PYQs β€” Official MPESB SI Prelims 2025 paper
Q1. Which statement about file extensions is correct? MPESB SI Prelims 2025 β€” 16 Jan 2026, Shift 1
(A) Extensions are case-sensitive in Windows
(B) Extensions can contain spaces
(C) The extension decides which default program will open the file
(D) Extensions are optional in Windows
Correct answer: (C)
.docx β†’ Word, .xlsx β†’ Excel, .pdf β†’ PDF reader. Extensions are not case-sensitive in Windows.
Q2. What is the function of "Ease of Access" in the Control Panel? MPESB SI Prelims 2025 β€” 16 Jan 2026, Shift 1
(A) Managing accessibility features for users with disabilities
(B) Configuring network settings
(C) Uninstalling programs
(D) Managing storage devices
Correct answer: (A)
Q3. Which part of the taskbar usually displays system notifications and the clock? MPESB SI Prelims 2025 β€” 17 Jan 2026, Shift 1
(A) Start Menu
(B) Quick Launch
(C) Notification Area (System Tray)
(D) Task View
Correct answer: (C) Notification Area (System Tray)
Q4. What happens when you right-click on an empty area of the taskbar? MPESB SI Prelims 2025 β€” 17 Jan 2026, Shift 1
(A) File Explorer opens
(B) Desktop icons are shown
(C) A Taskbar context menu with options such as Task Manager
(D) The Start Menu opens
Correct answer: (C)
Q5. What type of operating system is Microsoft Windows? MPESB SI Prelims 2025 β€” 18 Jan 2026, Shift 1
(A) Open-source graphical OS
(B) Command-line based OS
(C) Proprietary graphical operating system
(D) Only a real-time embedded OS
Correct answer: (C) Proprietary graphical OS
Q6. Which of the following is a common Linux desktop environment? MPESB SI Prelims 2025 β€” 18 Jan 2026, Shift 1
(A) GNOME
(B) X11
(C) Wayland
(D) LAMP
Correct answer: (A) GNOME
X11/Wayland are display protocols; LAMP is a web server stack.
Q7. The Control Panel option for uninstalling programs is called ____. MPESB SI Prelims 2025 β€” 18 Jan 2026, Shift 1
(A) Programs and Features
(B) Network and Sharing Center
(C) Device Manager
(D) Ease of Access
Correct answer: (A) Programs and Features
Q8. Who designed the Linux kernel and why? MPESB SI Prelims 2025 β€” 19 Jan 2026, Shift 1
(A) Richard Stallman, to replace Windows
(B) Linus Torvalds, because GNU lacked a working kernel
(C) Dennis Ritchie, to improve Unix performance
(D) Ken Thompson, for embedded systems
Correct answer: (B) Linus Torvalds
Q9. What maximum path length is supported by default in Windows? MPESB SI Prelims 2025 β€” 19 Jan 2026, Shift 1
(A) 128 characters
(B) 256 characters
(C) 260 characters
(D) Unlimited
Correct answer: (C) 260 characters
Microsoft documentation: MAX_PATH = 260.
Q10. Which statement about creating and organising files in Windows is correct? MPESB SI Prelims 2025 β€” 19 Jan 2026, Shift 1
(A) Files can be created only from the Command Prompt
(B) Files can be organised into folders and subdirectories for better management
(C) The name cannot be changed after creation
(D) Files must always be kept in the root directory
Correct answer: (B)
Q11. What does silent installation do in Windows? MPESB SI Prelims 2025 β€” 19 Jan 2026, Shift 2
(A) Installs software without user interaction or prompts
(B) Installs with detailed logs and prompts
(C) Installs only in Safe Mode
(D) Installs without creating shortcuts
Correct answer: (A)
Q12. The command used to install an .msi package silently is ____. MPESB SI Prelims 2025 β€” 20 Jan 2026, Shift 1
(A) msiexec /quiet /i filename.msi
(B) install filename.msi
(C) setup filename.msi
(D) wmic install filename.msi
Correct answer: (A)
msiexec is the Windows Installer tool; /i = install, /quiet = without prompts.
Q13. Which command in the Windows Command Prompt displays all files (including hidden files)? MPESB SI Prelims 2025 β€” 20 Jan 2026, Shift 2
(A) show hidden
(B) ls -a
(C) dir /a
(D) dir /h
Correct answer: (C) dir /a
/a = all attributes (including hidden, system). ls -a is a Linux command.
Q14. Which shortcut is used to open Task View in Windows 10/11? MPESB SI Prelims 2025 β€” 21 Jan 2026, Shift 1
(A) Ctrl + Tab
(B) Windows + Tab
(C) Shift + Tab
(D) Alt + Tab
Correct answer: (B) Windows + Tab
Q15. Which method of opening the Control Panel in Windows is NOT valid? MPESB SI Prelims 2025 β€” 21 Jan 2026, Shift 1
(A) Start Menu
(B) Run dialog (control)
(C) Command Prompt (control)
(D) BIOS settings
Correct answer: (D) BIOS settings
Q16. Which shortcut key is used to create a new folder in Windows Explorer? MPESB SI Prelims 2025 β€” 21 Jan 2026, Shift 2
(A) Alt + N
(B) Shift + F10
(C) Ctrl + Shift + N
(D) Ctrl + N
Correct answer: (C) Ctrl + Shift + N
Ctrl + N opens a new window in File Explorer; Shift + F10 = right-click menu.
✍️ Practice MCQs (self-made, not PYQs)
P1. What is the shortcut to delete a file permanently without sending it to the Recycle Bin? Practice MCQ
(A) Ctrl + Delete
(B) Alt + Delete
(C) Shift + Delete
(D) Win + Delete
Answer: (C) Shift + Delete
P2. What is the hardware check (self-test) done when a computer starts called? Practice MCQ
(A) BOOT
(B) POST
(C) BIOS
(D) CMOS
Answer: (B) POST β€” Power-On Self-Test (run by the BIOS).
P3. Which type of OS is used in missile guidance or ABS brakes? Practice MCQ
(A) Batch OS
(B) Real-Time OS
(C) Time-sharing OS
(D) Network OS
Answer: (B) Real-Time OS

πŸ“Œ 8. MS Word (Word Processor) (8 min read)

8.1 Basics

  • MS Word = a word processor β€” for typing and formatting letters, reports and applications. Part of Microsoft Office. (Free alternatives: LibreOffice Writer, Google Docs.)
  • File extension: .docx (from Word 2007), old .doc; template .dotx; with macros .docm.
  • Default font: from Word 2007 Calibri, 11 pt; in the newer Microsoft 365 versions Microsoft has made the default Aptos.
  • Orientation: Portrait (upright page) / Landscape (sideways page). Zoom range 10%–500%.

8.2 Ribbon Tabs β€” which feature is where

TabFeatures
HomeFont, bold/italic, alignment, bullets, Styles, Find/Replace, Format Painter (copying formatting)
InsertTable, Picture, Shapes, SmartArt, Chart, Hyperlink, Header/Footer, Page Number, Text Box, WordArt, Symbol, Equation, Object β†’ Text from File
DesignThemes, Watermark, Page Color, Page Borders
LayoutMargins, Orientation, Size, Columns, Breaks (Page/Section)
ReferencesTable of Contents, Footnote (at the bottom of the page), Endnote (at the end of the document), Citations
MailingsMail Merge, Envelopes, Labels
ReviewSpelling & Grammar, Thesaurus, Word Count, Comments, Track Changes, Restrict Editing
ViewRead Mode, Print Layout, Web Layout, Outline, Draft; Ruler, Zoom, Macros

8.3 Understand the Important Features

  • Mail Merge β€” making the same letter/invitation for many people with their names and addresses. Two things: Main document + Data source (Excel/list).
  • Combining several documents into one β€” Insert β†’ Object β†’ Text from File. (Mail merge does not do this.)
  • Track Changes β€” a record of who changed what (editing/review).
  • Section Break β€” divides the document into sections that can have different formatting (different orientation, header, page numbering). Page Break (Ctrl + Enter) β€” just sends the content to the next page.
  • Restrict Editing (Review tab) β€” limits formatting and editing permissions on a document (e.g. allowing only comments).
  • Styles = ready-made formatting for text (Heading 1, Heading 2) β€” the Table of Contents is made from these. Themes = a set of colours + fonts + effects for the whole document. Templates = a ready-made document design file (.dotx), e.g. resume, letter.
  • Drop Cap = the large first letter of a paragraph. Watermark = faint text/logo behind the page ("CONFIDENTIAL").

8.4 Word Shortcuts

ShortcutFunctionShortcutFunction
Ctrl + N / O / SNew / Open / SaveF12Save As
Ctrl + PPrintCtrl + WClose document
Ctrl + B / I / UBold / Italic / UnderlineCtrl + E / L / R / JCenter / Left / Right / Justify
Ctrl + KHyperlinkCtrl + FFind (Navigation pane)
Ctrl + HFind and ReplaceCtrl + G (or F5)Go To
Ctrl + EnterPage breakF7Spelling & Grammar
Shift + F7Thesaurus (synonyms)Shift + F3Change case (UPPER/lower)
Ctrl + Shift + > / <Increase / decrease font sizeCtrl + DFont dialog
Ctrl + 1 / 2 / 5Line spacing 1 / 2 / 1.5Ctrl + = / Ctrl + Shift + =Subscript / Superscript
Ctrl + Home / EndStart / end of the documentCtrl + Shift + C / VCopy / paste format
⚠️ Exam Traps:
  • Ctrl + H = Replace (in Word); Ctrl + K = Hyperlink; Ctrl + R = right align (not Redo β€” Redo is Ctrl + Y).
  • In Word F5 = Go To; in PowerPoint F5 = Slide show.
  • Combining docs = Insert β†’ Object β†’ Text from File; Mail Merge = one letter to many people.
  • Spelling check = F7; Thesaurus = Shift + F7.
🎯 PYQs β€” Official MPESB SI Prelims 2025 paper
Q1. Which MS Word feature is used to combine several documents into one? MPESB SI Prelims 2025 β€” 17 Jan 2026, Shift 1
(A) Merge Tool
(B) Insert β†’ Object β†’ Text from File
(C) Track Changes
(D) Mail Merge
Correct answer: (B) Insert β†’ Object β†’ Text from File
This brings the whole text of another Word file into the current document. Mail Merge makes one letter for many recipients.
Q2. What does the "Restrict Editing" feature do in MS Word? MPESB SI Prelims 2025 β€” 19 Jan 2026, Shift 2
(A) Hides text
(B) Limits formatting and editing permissions for the document
(C) Locks the document completely
(D) Converts the document to PDF
Correct answer: (B)
(Note: in the English question "C feature" was printed due to a typing error; the Hindi version clearly said "Restrict Editing".)
Q3. What is the difference between a "Section Break" and a "Page Break" in MS Word? MPESB SI Prelims 2025 β€” 20 Jan 2026, Shift 1
(A) A Section Break divides content into sections with independent formatting; a Page Break only moves content to the next page
(B) Both do the same job
(C) A Page Break changes orientation, a Section Break does not
(D) A Section Break deletes headers
Correct answer: (A)
Q4. The shortcut key to open the "Find and Replace" dialog box in MS Word is: MPESB SI Prelims 2025 β€” 20 Jan 2026, Shift 2
(A) Ctrl + H
(B) Ctrl + F
(C) Ctrl + G
(D) Ctrl + R
Correct answer: (A) Ctrl + H
In newer Word, Ctrl + F opens the Navigation pane (search); the Find and Replace dialog opens with Ctrl + H.
Q5. The shortcut key to insert a hyperlink in MS Word is ____. MPESB SI Prelims 2025 β€” 21 Jan 2026, Shift 1
(A) Ctrl + K
(B) Ctrl + H
(C) Ctrl + L
(D) Ctrl + U
Correct answer: (A) Ctrl + K
✍️ Practice MCQs (self-made, not PYQs)
P1. In which tab is Mail Merge found in MS Word? Practice MCQ
(A) Insert
(B) Review
(C) Mailings
(D) References
Answer: (C) Mailings
P2. What is the shortcut key for spelling and grammar check in MS Word? Practice MCQ
(A) F5
(B) F7
(C) F12
(D) F1
Answer: (B) F7
P3. What is the shortcut in Word to align text evenly to both margins (Justify)? Practice MCQ
(A) Ctrl + E
(B) Ctrl + J
(C) Ctrl + L
(D) Ctrl + R
Answer: (B) Ctrl + J

πŸ“Œ 9. MS Excel (Spreadsheet) (10 min read)

9.1 Basics

  • Excel = a spreadsheet program β€” tables, calculations, charts. A file = Workbook (.xlsx; old .xls; macro .xlsm; template .xltx); inside a workbook are Worksheets (sheets).
  • Row = number (1, 2, 3…), Column = letter (A, B, C…). Cell = where a row and column meet; address e.g. C5. Range = A1:A10. The selected cell = Active cell.
  • One sheet has 1,048,576 rows Γ— 16,384 columns (last column XFD) β€” since Excel 2007.
  • Name Box (address of the active cell) and Formula Bar (formula/content of the cell).
  • History: the first spreadsheet was VisiCalc (1979); the dominant one in the 1980s was Lotus 1-2-3 β€” Excel (1985) initially competed with Lotus 1-2-3. Alternatives: Google Sheets, LibreOffice Calc.

9.2 Formulas and Cell References

  • Every formula starts with = (equals sign). Order of operators: ^ (power) β†’ * / β†’ + βˆ’; & = joining text. Example: =2+3*4 = 14; =(2+3)*4 = 20.
  • Relative reference (A1) β€” changes when copied. Absolute ($A$1) β€” stays fixed when copied. Mixed ($A1 or A$1). Pressing F4 switches between them.

9.3 Important Functions

FunctionUse / Example
SUM, AVERAGE, MAX, MIN=SUM(A1:A5) total; AVERAGE = mean
COUNT / COUNTA / COUNTBLANKCOUNT = only cells with numbers; COUNTA = all non-empty; COUNTBLANK = empty
COUNTIF, SUMIFCounting/adding with a condition β€” =COUNTIF(B2:B50,">=33")
IF=IF(B2>=33,"Pass","Fail")
VLOOKUPSearches vertically for a value in the first column of a table and returns the value from another column of the same row β€” =VLOOKUP(101,A2:D50,3,FALSE)
HLOOKUP / XLOOKUPHLOOKUP = horizontally (in the first row); XLOOKUP = new, works in both directions
CONCATENATE / CONCAT / TEXTJOINJoins the text of several cells into one cell (or =A1&" "&B1)
TODAY(), NOW()Today's date; date + time
ROUND, INT, MOD, ABS, SQRT, POWER=ROUND(3.456,2)=3.46; =MOD(10,3)=1; =SQRT(16)=4; =POWER(2,3)=8
LEN, UPPER, LOWER, PROPER, TRIM=LEN("MP Police")=9 (the space is also counted)

9.4 Features

  • Conditional Formatting β€” formatting based on the value of a cell (e.g. marks below 33 in red).
  • Data Validation β€” limits what can be entered in a cell (e.g. only 1–100, dropdown list).
  • Sort, Filter (Ctrl + Shift + L), Pivot Table (summary of large data), Freeze Panes (keeping the heading row fixed), Goal Seek / What-If Analysis, Flash Fill, Macros.
  • Charts: Column, Bar, Line (trend), Pie (parts of one series β€” whole = 100%), Scatter.
  • Error values: #DIV/0! (division by 0), #N/A (value not found β€” lookup), #NAME? (wrong function name), #REF! (cell reference deleted), #VALUE! (wrong type of data), #NUM!, #NULL!, ##### (column is too narrow).

9.5 Excel Shortcuts

ShortcutFunctionShortcutFunction
Ctrl + 1Format Cells dialogAlt + F1Insert chart (embedded on the same sheet)
F11Chart on a separate chart sheetShift + F11New worksheet
F2Edit cellF4Toggle reference $ / repeat last action
Alt + =AutoSumCtrl + ; / Ctrl + Shift + ;Today's date / time
Alt + EnterNew line inside a cellCtrl + Page Up/DownMove between sheets
Ctrl + Space / Shift + SpaceSelect entire column / rowCtrl + D / Ctrl + RFill down / Fill right
Ctrl + TCreate tableCtrl + HomeGo to cell A1
⚠️ Exam Traps:
  • Relative changes, Absolute ($) stays fixed β€” the reversed option is wrong.
  • VLOOKUP = vertical lookup (not validation/sum/chart).
  • Chart = Alt + F1 (or F11); Shift + F11 = new sheet. Format Cells = Ctrl + 1.
  • Colour based on value = Conditional Formatting; restricting entry = Data Validation.
  • The function to join text = CONCATENATE/CONCAT (MERGE() or COMBINE() are not functions).
🎯 PYQs β€” Official MPESB SI Prelims 2025 paper
Q1. Which major spreadsheet software did Microsoft Excel originally compete with? MPESB SI Prelims 2025 β€” 16 Jan 2026, Shift 1
(A) VisiCalc
(B) Lotus 1-2-3
(C) Quattro Pro
(D) Google Sheets
Correct answer: (B) Lotus 1-2-3
In the 1980s Lotus 1-2-3 dominated the market; Excel (1985) came to challenge it.
Q2. What is the function of VLOOKUP in Excel? MPESB SI Prelims 2025 β€” 16 Jan 2026, Shift 1
(A) Validating data in a cell
(B) Searching for a value vertically in a table and returning a related value
(C) Calculating vertical sums
(D) Creating a chart
Correct answer: (B)
Q3. The shortcut key to insert a chart in Excel is ____. MPESB SI Prelims 2025 β€” 17 Jan 2026, Shift 1
(A) Alt + F1
(B) Ctrl + F1
(C) Shift + F11
(D) Ctrl + Alt
Correct answer: (A) Alt + F1
Alt + F1 makes a chart of the selected data on the same sheet (F11 on a separate chart sheet). Shift + F11 inserts a new worksheet; Ctrl + F1 collapses/expands the ribbon.
Q4. The shortcut key to open the "Format Cells" dialog box in Excel is ____. MPESB SI Prelims 2025 β€” 18 Jan 2026, Shift 2
(A) Ctrl + 1
(B) Ctrl + F
(C) Ctrl + Shift + F
(D) Alt + F1
Correct answer: (A) Ctrl + 1
Q5. The function used to combine the text of several cells into one cell is ____. MPESB SI Prelims 2025 β€” 19 Jan 2026, Shift 1
(A) CONCATENATE or CONCAT/TEXTJOIN
(B) MERGE()
(C) COMBINE()
(D) SumUp()
Correct answer: (A)
Q6. What is the difference between "Relative" and "Absolute" cell references in Excel? MPESB SI Prelims 2025 β€” 19 Jan 2026, Shift 2
(A) Absolute references are not used in formulas
(B) Relative references change when copied; absolute references stay fixed
(C) Both are the same
(D) Relative are fixed, absolute change
Correct answer: (B)
Q7. The Excel feature that applies formatting based on cell values is called ____. MPESB SI Prelims 2025 β€” 19 Jan 2026, Shift 2
(A) Data Validation
(B) Conditional Formatting
(C) AutoFormat
(D) Pivot Formatting
Correct answer: (B) Conditional Formatting
✍️ Practice MCQs (self-made, not PYQs)
P1. What will be the result of =2^3*2 in Excel? Practice MCQ
(A) 12
(B) 16
(C) 64
(D) 10
Answer: (B) 16 β€” first 2^3 = 8, then 8Γ—2 = 16.
P2. Which error does Excel show when a number is divided by 0? Practice MCQ
(A) #N/A
(B) #REF!
(C) #DIV/0!
(D) #NAME?
Answer: (C) #DIV/0!
P3. Which is an absolute cell reference in Excel? Practice MCQ
(A) A1
(B) $A1
(C) A$1
(D) $A$1
Answer: (D) $A$1 ((B), (C) are mixed)

πŸ“Œ 10. MS PowerPoint & File Extensions (6 min read)

10.1 PowerPoint Basics

  • PowerPoint = presentation software; each page = a slide. File: .pptx (old .ppt); .ppsx = opens directly in slide show; template .potx.
  • Slide Master β€” make a change in one place and the design applies to all slides. Layouts β€” title slide, title & content, etc.
  • Transition = the effect when moving from one slide to the next. Animation = an effect on an object (text/picture) within a slide.
  • Animation Pane β€” list of all animations, their order and timing. Animation Painter β€” copies the animation of one object quickly to other objects (like Format Painter). Motion Path β€” moves an object along a custom path.
  • Group (Ctrl + G) β€” joins several objects into one object; Ungroup = Ctrl + Shift + G. (Align = lining objects up.)
  • Views: Normal, Outline View, Slide Sorter (all slides in small form β€” to change the order), Notes Page, Reading View, Slide Show; Presenter View for the presenter. Speaker notes and Handouts can be printed.

10.2 PowerPoint Shortcuts

ShortcutFunctionShortcutFunction
F5Slide show from the beginningShift + F5Slide show from the current slide
Ctrl + MNew slideCtrl + DDuplicate
EscEnd slide showB / WBlack / white screen during the show
Ctrl + GGroupN or β†’ / P or ←Next / previous slide

10.3 Important File Extensions

ExtensionFile typeExtensionFile type
.docx / .docWord document.txtPlain text (Notepad)
.xlsx / .xls / .csvExcel / comma-separated data.pdfPortable Document Format (Adobe)
.pptx / .ppt / .ppsxPowerPoint / show.accdb / .mdbMS Access database
.jpg/.jpeg, .png, .gif, .bmp, .tiff, .svgImages (GIF supports animation).mp3, .wav, .aacAudio
.mp4, .avi, .mkv, .movVideo.exe, .msiWindows program / installer
.zip, .rar, .7zCompressed.html / .htmWeb page
.apkAndroid app.isoDisc image
.batBatch file (commands).dll, .sysWindows system library/files

Other MS Office apps: Access (database), Outlook (email/calendar), OneNote (notes), Publisher (brochures). Google's alternatives: Docs, Sheets, Slides.

⚠️ Exam Traps:
  • F5 = from the beginning; Shift + F5 = from the current slide.
  • Transition = slide-to-slide; Animation = on an object.
  • Joining objects = Group (not Merge/Combine). Copying animation = Animation Painter.
🎯 PYQs β€” Official MPESB SI Prelims 2025 paper
Q1. Which PowerPoint feature lets you join several objects together? MPESB SI Prelims 2025 β€” 18 Jan 2026, Shift 1
(A) Group
(B) Merge
(C) Combine
(D) Align
Correct answer: (A) Group
Q2. Which PowerPoint feature lets you quickly apply the same animation effect to several objects? MPESB SI Prelims 2025 β€” 19 Jan 2026, Shift 1
(A) Animation Painter
(B) Animation Pane
(C) Slide Master
(D) Motion Path
Correct answer: (A) Animation Painter
Q3. The shortcut key to start a slide show from the beginning in PowerPoint is ____. MPESB SI Prelims 2025 β€” 20 Jan 2026, Shift 2
(A) F5
(B) Shift + F5
(C) Ctrl + F5
(D) Alt + F5
Correct answer: (A) F5
✍️ Practice MCQs (self-made, not PYQs)
P1. What is the shortcut to add a new slide in PowerPoint? Practice MCQ
(A) Ctrl + N
(B) Ctrl + M
(C) Ctrl + S
(D) Ctrl + D
Answer: (B) Ctrl + M (Ctrl + N = new presentation)
P2. Which view shows all slides as small thumbnails so you can change their order? Practice MCQ
(A) Notes Page
(B) Reading View
(C) Slide Sorter
(D) Outline
Answer: (C) Slide Sorter

πŸ“Œ 11. Internet, WWW, Browser, URL, IP & DNS (12 min read β€” most PYQs)

11.1 Internet and WWW

  • Internet = a network of computer networks all over the world ("network of networks"). It began with ARPANET (1969, USA). It runs on the TCP/IP protocol (Vint Cerf & Bob Kahn). The world's largest WAN.
  • Internet for the general public in India: started by VSNL on 15 August 1995. A company that provides internet = ISP (Internet Service Provider) β€” Jio, Airtel, BSNL.
  • Intranet = a private network inside an organisation; Extranet = the part of an intranet given to partners/vendors.
  • WWW (World Wide Web) = a service that runs on the internet β€” a collection of web pages linked by hyperlinks. Tim Berners-Lee, 1989, CERN. Web pages are made in HTML and delivered through HTTP/HTTPS.
  • Website = a group of web pages; the first page = Home page; websites are kept on a web server. Hyperlink = clicking to go to another page.
  • Web 1.0 = read-only (static); Web 2.0 = interactive/social (users create content); Web 3.0 = semantic/decentralised web.

11.2 Web Browser

BrowserCompany / Year
WorldWideWeb (later Nexus)Tim Berners-Lee, 1990 β€” the first browser
MosaicNCSA (Marc Andreessen), 1993 β€” the first popular graphical browser; it made the internet popular among ordinary people
Netscape Navigator1994
Internet Explorer β†’ EdgeMicrosoft (IE 1995; Edge 2015)
FirefoxMozilla (open source), 2004
SafariApple, 2003
ChromeGoogle, 2008
  • Browser features: tabs, bookmarks, history, cache, cookies, extensions, Incognito/Private mode (history/cookies are not saved after the session β€” but it does not hide you from the ISP/website).
  • Sandboxing β€” running each web page/tab in a separate "box" so that malicious code cannot affect the whole browser/computer. Present in both Chrome and Firefox; along with HTTPS enforcement (HTTPS-only mode).
  • PWA (Progressive Web App) β€” running/installing a website like an app, without installing a native app.
  • Both Chrome and Firefox support HTTP/2 and HTTP/3 for faster page loading (HTTP/3 = based on the QUIC protocol).

11.3 Search Engine

  • Google β€” 1998, Larry Page & Sergey Brin; the PageRank algorithm for ranking (named after Larry Page); Google introduced "Featured Snippets" for quick answers.
  • Bing β€” Microsoft (2009). Yahoo, DuckDuckGo (privacy β€” no tracking), Baidu (China), Yandex (Russia).
  • A search engine reads pages with a web crawler/spider, builds an index, then ranks them. SEO = Search Engine Optimization.

11.4 URL (Uniform Resource Locator) β€” web address

https://www.mppolice.gov.in:443/recruitment/notice.html?id=5#top

PartExampleMeaning
Scheme / ProtocolhttpsWhich protocol will be used (the part of the URL that tells the protocol)
Subdomainwwwβ€”
Domain name / Hostmppolice.gov.inName of the website; TLD = .in
Port number:443Optional β€” if not written, the default is used (HTTP 80, HTTPS 443)
Path/recruitment/notice.htmlPath of the file on the server
Query string / Fragment?id=5 / #topExtra parameters / part of the page
  • Domain types: generic TLD β€” .com (commercial), .org (organisation), .net, .edu (education), .gov (US govt); country code β€” .in (India), .uk, .us. Government of India sites: .gov.in, .nic.in. The domain/IP system of the world is managed by ICANN; the .in registry is NIXI.

11.5 IP Address, DNS, MAC

  • IP address = the unique identity of every device/host on a network (like a house address).
    • IPv4 = 32-bit, 4 parts separated by dots, each part 0–255: 192.168.0.178 (about 4.3 billion addresses).
    • IPv6 = 128-bit, 8 groups in hexadecimal, separated by colons (:): 2001:CDBA:0000:0000:0000:0000:3257:9652 (consecutive zero groups can be shortened with "::").
    • 255.255.255.0 = subnet mask (not an IP address). CIDR (Classless Inter-Domain Routing, e.g. /24) = flexible subnetting and efficient IP allocation.
    • Static IP (fixed) vs Dynamic IP (given afresh each time by DHCP). Private IPs: 192.168.x.x, 10.x.x.x.
  • DNS (Domain Name System) = converts a domain name (google.com) into an IP address β€” "the phonebook of the internet". At the top are 13 root server identities (A to M), run by 12 organisations; through anycast they have thousands (2000+) of instances around the world.
  • MAC address = a 48-bit physical address put into the NIC (network card) at the factory, e.g. 00:1A:2B:3C:4D:5E. The first 24 bits (OUI) = identify the manufacturer; the last 24 bits = the device's serial. IP = logical address, MAC = physical address.

11.6 Cookies

CookieMeaning
Cookie (general)A small text file kept in the browser by a website (to remember login, cart, preferences)
Session cookieTemporary β€” erased as soon as the browser is closed
Persistent cookieStays for a fixed time
Authentication cookieRemembers that you are logged in
Third-party / tracking cookieBelongs to another company; user behaviour tracking β†’ targeted ads
Zombie cookieRecreates itself after being deleted β€” a threat to privacy

11.7 Social Media

  • Common feature: creating a user profile and sharing photos/videos (multimedia), like, comment, follow.
  • Microblogging = short posts β€” Twitter (now X, since 2023). Facebook (2004), YouTube (video), Instagram (photos/reels), LinkedIn (professional networking), WhatsApp (messaging β€” end-to-end encrypted chats).
  • Targeted ads β€” through user behaviour tracking and cookies.
  • Ethical problems: fake news / misinformation, violation of privacy, cyberbullying, deepfakes, trolling.
⚠️ Exam Traps:
  • Internet β‰  WWW. The WWW is one service of the internet.
  • Bing = Microsoft (not Google/Yahoo). PageRank & Featured Snippets = Google.
  • In a URL the port is optional; the part that tells the protocol = scheme.
  • IPv4: dots (.) + 32 bit; IPv6: colons (:) + 128 bit. 255.255.255.0 is a subnet mask.
  • Root DNS = 13 (identities A–M), 12 operators.
  • The first 24 bits of a MAC = manufacturer.
  • The cookie that comes back after deletion = zombie cookie.
  • The first popular graphical browser = Mosaic (not Chrome).
🎯 PYQs β€” Official MPESB SI Prelims 2025 paper
Q1. The Bing search engine is developed and maintained by which company? MPESB SI Prelims 2025 β€” 16 Jan 2026, Shift 1
(A) Google
(B) Microsoft
(C) Yahoo
(D) Amazon
Correct answer: (B) Microsoft
Q2. Which part of a URL is optional? MPESB SI Prelims 2025 β€” 16 Jan 2026, Shift 1
(A) Scheme
(B) Host
(C) Port number
(D) Domain name
Correct answer: (C) Port number
If the port is not written, the browser uses the default port (80/443).
Q3. How many root DNS servers exist worldwide for domain name resolution? MPESB SI Prelims 2025 β€” 16 Jan 2026, Shift 2
(A) 10
(B) 13
(C) 32
(D) Unlimited
Correct answer: (B) 13
root-servers.org: 13 root server identities (A–M), 12 operators; physical instances number in the thousands.
Q4. Which feature allows Chrome and Firefox to run web apps without installing native apps? MPESB SI Prelims 2025 β€” 16 Jan 2026, Shift 2
(A) AppCache
(B) WebAssembly
(C) Virtual DOM
(D) Progressive Web Apps (PWA)
Correct answer: (D) PWA
Q5. Which algorithm is mainly associated with Google's search ranking system? MPESB SI Prelims 2025 β€” 16 Jan 2026, Shift 2
(A) PageRank
(B) RankNet
(C) HITS
(D) SALSA
Correct answer: (A) PageRank
Q6. Which feature is common on most social media platforms? MPESB SI Prelims 2025 β€” 16 Jan 2026, Shift 2
(A) End-to-end encryption for all posts
(B) The facility to create a user profile and share multimedia content
(C) Compulsory paid subscription
(D) No interaction between users
Correct answer: (B)
Q7. What is considered a major ethical issue in social media? MPESB SI Prelims 2025 β€” 16 Jan 2026, Shift 2
(A) Increased bandwidth
(B) Fake news and misinformation
(C) Use of the HTTPS protocol
(D) Profile customization
Correct answer: (B) Fake news and misinformation
Q8. Which of the following is a correct representation of an IPv6 address? MPESB SI Prelims 2025 β€” 17 Jan 2026, Shift 1
(A) 192.168.0.178
(B) 2001:CDBA:0000:0000:0000:0000:3257:9652
(C) 255.255.255.0
(D) 2001.3257.9652.0000
Correct answer: (B)
IPv6 = 8 hex groups, separated by colons. (A) IPv4, (C) subnet mask, (D) wrong format.
Q9. Which protocol upgrades do both Chrome and Firefox support for loading web pages faster? MPESB SI Prelims 2025 β€” 17 Jan 2026, Shift 2
(A) HTTP/1.1
(B) HTTP/2 and HTTP/3
(C) FTP
(D) SMTP
Correct answer: (B) HTTP/2 and HTTP/3
Q10. What does an IP address mainly identify? MPESB SI Prelims 2025 β€” 17 Jan 2026, Shift 2
(A) The domain name of a website
(B) A unique device or host on a network
(C) The title of a web page
(D) The browser session
Correct answer: (B)
Q11. Which search engine introduced "Featured Snippets" for instant answers? MPESB SI Prelims 2025 β€” 18 Jan 2026, Shift 1
(A) Bing
(B) Google
(C) Yahoo
(D) DuckDuckGo
Correct answer: (B) Google
Q12. What is the purpose of CIDR in IP addressing? MPESB SI Prelims 2025 β€” 18 Jan 2026, Shift 1
(A) Encrypting IP packets
(B) Flexible subnetting and efficient IP allocation
(C) Converting IP to MAC
(D) Defining DNS records
Correct answer: (B)
Converting IP β†’ MAC is the job of ARP; encryption is done by IPsec.
Q13. Which feature is common to both Chrome and Firefox for secure browsing? MPESB SI Prelims 2025 β€” 18 Jan 2026, Shift 2
(A) Built-in VPN
(B) Sandboxing and HTTPS enforcement
(C) Proprietary encryption algorithm
(D) No support for extensions
Correct answer: (B)
Q14. Which feature allows social media platforms to show targeted ads? MPESB SI Prelims 2025 β€” 18 Jan 2026, Shift 2
(A) End-to-end encryption
(B) User behavior tracking and cookies
(C) Manual ad placement by users
(D) Randomized ad display
Correct answer: (B)
Q15. Which type of cookie can regenerate itself after being deleted, posing a privacy risk? MPESB SI Prelims 2025 β€” 18 Jan 2026, Shift 2
(A) Session cookie
(B) Authentication cookie
(C) Zombie cookie
(D) Magic cookie
Correct answer: (C) Zombie cookie
Q16. Which of the following is an example of a microblogging platform? MPESB SI Prelims 2025 β€” 19 Jan 2026, Shift 1
(A) Facebook
(B) Twitter (X)
(C) LinkedIn
(D) Pinterest
Correct answer: (B) Twitter (X)
Q17. Which part of a URL indicates the protocol? MPESB SI Prelims 2025 β€” 19 Jan 2026, Shift 1
(A) Domain name
(B) Scheme
(C) Path
(D) Query string
Correct answer: (B) Scheme (e.g. https://)
Q18. Which browser introduced the concept of a graphical user interface and made the internet popular? MPESB SI Prelims 2025 β€” 20 Jan 2026, Shift 1
(A) Mosaic
(B) Chrome
(C) Safari
(D) Opera
Correct answer: (A) Mosaic (NCSA, 1993)
Q19. Which part of a MAC address identifies the manufacturer of the Network Interface Card (NIC)? MPESB SI Prelims 2025 β€” 21 Jan 2026, Shift 1
(A) Last 24 bits
(B) First 24 bits
(C) Last 12 bits
(D) First 12 bits
Correct answer: (B) First 24 bits (OUI β€” Organizationally Unique Identifier)
Q20. Which feature in Chrome and Firefox isolates web pages so that malicious code cannot affect the whole browser? MPESB SI Prelims 2025 β€” 21 Jan 2026, Shift 1
(A) Multi-threading
(B) Sandboxing
(C) Virtualization
(D) DNS caching
Correct answer: (B) Sandboxing
✍️ Practice MCQs (self-made, not PYQs)
P1. How many bits make an IPv4 address? Practice MCQ
(A) 16
(B) 32
(C) 64
(D) 128
Answer: (B) 32 (IPv6 = 128)
P2. Who invented the World Wide Web? Practice MCQ
(A) Vint Cerf
(B) Tim Berners-Lee
(C) Bill Gates
(D) Ray Tomlinson
Answer: (B) Tim Berners-Lee (1989, CERN)
P3. What converts a domain name into an IP address? Practice MCQ
(A) DHCP
(B) FTP
(C) DNS
(D) SMTP
Answer: (C) DNS

πŸ“Œ 12. Email (5 min read)

  • Email (Electronic Mail) β€” the first network email was sent by Ray Tomlinson in 1971; he also started the use of the @ symbol.
  • Address format: username@domain, e.g. anjali.si@gmail.com (username = anjali.si, domain = gmail.com).
  • Webmail: Gmail (Google), Outlook/Hotmail (Microsoft; co-founder of Hotmail Sabeer Bhatia), Yahoo Mail. Government: NIC email (@nic.in / @gov.in).
Field / FolderMeaning
ToMain recipient
CC (Carbon Copy)Copy β€” this address is visible to all recipients
BCC (Blind Carbon Copy)Copy β€” BCC addresses are not visible to others
Subject / Body / Attachment (πŸ“Ž)Topic / message / attached file
Reply / Reply All / ForwardOnly to the sender / to everyone / sending it on to a new person
Inbox / Outbox / Sent / Drafts / TrashReceived mail / queue waiting to be sent / sent mail / unfinished / deleted
Spam / JunkUnwanted bulk/fraud mail

Email Protocols

ProtocolFunctionPort
SMTP (Simple Mail Transfer Protocol)Sending email (to the server/server-to-server)25 (submission 587)
POP3 (Post Office Protocol v3)Downloads email and usually deletes it from the server β€” for a single device110 (SSL: 995)
IMAP (Internet Message Access Protocol)Keeps email on the server, synced across all devices143 (SSL: 993)
  • Secure email transmission: SSL/TLS over SMTP (SMTPS/STARTTLS), IMAPS, POP3S. (HTTPS is for web pages; FTP is for files.)
  • SNMP (Simple Network Management Protocol) β€” monitoring of network devices; not an email protocol.
⚠️ Exam Traps:
  • Sending = SMTP; fetching = POP3/IMAP. Keeping on the server = IMAP; downloading and removing = POP3.
  • Hidden recipients = BCC.
  • SMTP vs SNMP β€” watch the spelling; SNMP is not for email.
🎯 PYQs β€” Official MPESB SI Prelims 2025 paper
Q1. Which protocol downloads emails from the server and usually deletes them from the server after receiving? MPESB SI Prelims 2025 β€” 16 Jan 2026, Shift 2
(A) SMTP
(B) POP3
(C) IMAP
(D) HTTP
Correct answer: (B) POP3
Q2. Which of the following ensures secure transmission of email data? MPESB SI Prelims 2025 β€” 17 Jan 2026, Shift 1
(A) HTTP
(B) HTTPS
(C) SSL/TLS over SMTP
(D) FTP
Correct answer: (C) SSL/TLS over SMTP
Email travels through SMTP; encrypting it with SSL/TLS = secure email. HTTPS is for web browsing.
Q3. Which of the following is NOT a valid email protocol? MPESB SI Prelims 2025 β€” 18 Jan 2026, Shift 2
(A) SMTP
(B) POP3
(C) IMAP
(D) SNMP
Correct answer: (D) SNMP β€” a network management protocol.
Q4. Which protocol is used to receive emails from an email server and keep them on the server itself? MPESB SI Prelims 2025 β€” 20 Jan 2026, Shift 2
(A) POP3
(B) IMAP
(C) SMTP
(D) HTTP
Correct answer: (B) IMAP
Q5. Which email field allows sending a copy to additional recipients without showing their address to others? MPESB SI Prelims 2025 β€” 20 Jan 2026, Shift 2
(A) CC
(B) To
(C) BCC
(D) Reply-To
Correct answer: (C) BCC
✍️ Practice MCQs (self-made, not PYQs)
P1. Which protocol is mainly used to send email? Practice MCQ
(A) POP3
(B) IMAP
(C) SMTP
(D) FTP
Answer: (C) SMTP
P2. Who first used "@" in an email address? Practice MCQ
(A) Tim Berners-Lee
(B) Ray Tomlinson
(C) Sabeer Bhatia
(D) Vint Cerf
Answer: (B) Ray Tomlinson

πŸ“Œ 13. Computer Networking (9 min read)

13.1 Types of Networks (by area)

TypeAreaExample
PAN (Personal Area Network)A few metres (β‰ˆ10 m)Phone-earbuds via Bluetooth
LAN (Local Area Network)One room / building / campusNetwork of an office, school, police station (Ethernet, Wi-Fi)
MAN (Metropolitan Area Network)One cityCity cable TV network, bank branches of a city
WAN (Wide Area Network)Country / worldInternet (the largest WAN), a national network like CCTNS

Order by size: PAN < LAN < MAN < WAN. Architecture: Client-Server (one central server) vs Peer-to-Peer (all equal).

13.2 Topology (structure of the network)

TopologyStructureKey point
BusAll on a single main cable (backbone)Cheap; if the main cable breaks, the whole network stops; terminators at both ends
StarAll connected to one central hub/switchMost common; if one computer fails the rest keep working; if the hub/switch fails, all stop
RingA circular loop, data in one directionToken passing
MeshEvery device connected to every otherMost reliable, costly; a full mesh of n devices has n(nβˆ’1)/2 links
TreeHierarchical form of Star + BusLarge organisations
HybridCombination of two or more topologiesβ€”

13.3 Network Devices

DeviceFunction
NIC (Network Interface Card)The card that connects a computer to a network; the MAC address is in it
HubSends data to all ports (dumb, broadcast)
SwitchConnects many devices within a LAN; sends data only to the correct device (MAC address) β€” smart
RouterConnects different networks (e.g. home LAN ↔ internet); chooses the path based on the IP address
Modem (Modulator-Demodulator)Converts Digital ↔ Analog signals; connects to the ISP. Types: Dial-up, DSL (phone line), Cable, Satellite, Cellular (4G/5G)
Wireless RouterRouter + built-in wireless access point + Ethernet switch (home Wi-Fi router)
Access PointAdds Wi-Fi to a wired network
RepeaterMakes a weak signal strong again (regenerates it)
BridgeConnects two LAN segments
GatewayA "translator" between networks using different protocols
FirewallBlocks/allows incoming and outgoing traffic according to rules (security)

Drawback of a simple modem (compared with a router): it has no NAT (Network Address Translation), Wi-Fi, traffic management or multi-device support β€” it connects only one device.

13.4 Transmission Media and Modes

  • Wired: Twisted pair (Ethernet β€” RJ45; telephone β€” RJ11), Coaxial (cable TV), Optical fibre (light signals, total internal reflection; fastest, long distance, no interference).
  • Wireless: Radio waves (Wi-Fi, Bluetooth), Microwave, Infrared (TV remote), Satellite.
  • Wi-Fi (IEEE 802.11) β€” main bands 2.4 GHz (more range, less speed) and 5 GHz (more speed, less range); the newer Wi-Fi 6E/7 also use 6 GHz. Bluetooth (IEEE 802.15.1) β€” 2.4 GHz, short range. Ethernet = IEEE 802.3 (wired LAN).
  • Transmission modes: Simplex β€” one direction (keyboardβ†’CPU, TV/radio broadcast); Half-duplex β€” both directions but one at a time (walkie-talkie); Full-duplex β€” both directions at the same time (mobile phone call).
  • Bandwidth = data rate, in bps (bits per second) β€” Kbps, Mbps, Gbps.

13.5 OSI Model (7 layers) and TCP/IP

#OSI LayerFunction / Example
7ApplicationServices for the user's apps β€” HTTP, FTP, SMTP, DNS
6PresentationData format, encryption, compression
5SessionStarting/ending a session
4TransportEnd-to-end delivery β€” TCP (reliable), UDP (fast)
3NetworkIP address, routing β€” Router
2Data LinkMAC address β€” Switch, Bridge
1PhysicalCable, signal, bits β€” Hub, Repeater

Memory trick (bottom to top, 1β†’7): "Please Do Not Throw Sausage Pizza Away" = Physical, Data Link, Network, Transport, Session, Presentation, Application. The OSI model was made by ISO. The TCP/IP model has 4 layers: Network Access (Link), Internet, Transport, Application.

⚠️ Exam Traps:
  • Connecting devices within a LAN = Switch; connecting networks = Router.
  • ISP via phone line = DSL modem; cable TV line = cable modem.
  • Wi-Fi + switch in one box = Wireless router.
  • Wi-Fi bands = 2.4 GHz & 5 GHz (900 MHz/1.8 GHz are mobile network bands).
  • Router = Layer 3; Switch = Layer 2; Hub = Layer 1.
🎯 PYQs β€” Official MPESB SI Prelims 2025 paper
Q1. Which type of modem connects to the ISP through phone lines using DSL access? MPESB SI Prelims 2025 β€” 17 Jan 2026, Shift 2
(A) Cable modem
(B) Satellite modem
(C) DSL modem
(D) Cellular modem
Correct answer: (C) DSL modem (DSL = Digital Subscriber Line)
Q2. What is a common disadvantage of a simple modem compared with a router? MPESB SI Prelims 2025 β€” 18 Jan 2026, Shift 1
(A) It lacks NAT, Wi-Fi, traffic management and multi-device support
(B) It works only at Layer 3
(C) It cannot modulate analog signals
(D) It needs satellite communication
Correct answer: (A)
Modulation is the basic job of a modem, so (C) is wrong.
Q3. Which device is commonly used to connect many devices within a LAN for communication and data sharing? MPESB SI Prelims 2025 β€” 19 Jan 2026, Shift 1
(A) Router
(B) Switch
(C) Modem
(D) Firewall
Correct answer: (B) Switch
Q4. Which device usually has a built-in wireless access point and Ethernet switch? MPESB SI Prelims 2025 β€” 19 Jan 2026, Shift 2
(A) Satellite modem
(B) Wireless router
(C) Core router
(D) DSL modem
Correct answer: (B) Wireless router
Q5. Which frequency bands are commonly used in Wi-Fi? MPESB SI Prelims 2025 β€” 20 Jan 2026, Shift 1
(A) 900 MHz and 1.8 GHz
(B) 2.4 GHz and 5 GHz
(C) 10 GHz and 20 GHz
(D) 60 GHz only
Correct answer: (B) 2.4 GHz and 5 GHz
✍️ Practice MCQs (self-made, not PYQs)
P1. In which topology are all computers connected to a central hub/switch? Practice MCQ
(A) Bus
(B) Ring
(C) Star
(D) Mesh
Answer: (C) Star
P2. How many links are needed in a full mesh network of 5 computers? Practice MCQ
(A) 5
(B) 10
(C) 20
(D) 25
Answer: (B) 10 β€” n(nβˆ’1)/2 = 5Γ—4/2 = 10.
P3. At which layer of the OSI model does a router work? Practice MCQ
(A) Physical
(B) Data Link
(C) Network
(D) Transport
Answer: (C) Network (Layer 3)
P4. A walkie-talkie is an example of which transmission mode? Practice MCQ
(A) Simplex
(B) Half-duplex
(C) Full-duplex
(D) Multiplex
Answer: (B) Half-duplex

πŸ“Œ 14. Protocols & Ports (5 min read)

Protocol = the rules of communication between computers. Every service has a default port number.

ProtocolFull formFunctionDefault port
HTTPHyperText Transfer ProtocolWeb pages (without encryption)80
HTTPSHTTP SecureEncrypted web (SSL/TLS) β€” πŸ”’ padlock; necessary for banking/login443
FTPFile Transfer ProtocolUploading/downloading files (without encryption)20, 21
SFTPSSH File Transfer ProtocolSecure (encrypted) file transfer22 (SSH)
SSH / TelnetSecure Shell / β€”Remote login (SSH is encrypted; Telnet is not)22 / 23
SMTPSimple Mail Transfer ProtocolSending email25
POP3 / IMAPPost Office Protocol / Internet Message Access ProtocolReceiving email110 / 143
DNSDomain Name SystemName β†’ IP53
DHCPDynamic Host Configuration ProtocolGives IP addresses to devices automatically67/68
SNMPSimple Network Management ProtocolMonitoring network devices161
TCPTransmission Control ProtocolConnection-oriented, reliable (web, email, file)β€”
UDPUser Datagram ProtocolConnectionless, fast (video streaming, online games, DNS)β€”
IPInternet ProtocolAddressing and routingβ€”
ARPAddress Resolution ProtocolIP β†’ MAC addressβ€”
⚠️ Exam Traps:
  • Before entering sensitive information (password, card), check for HTTPS and πŸ”’ in the URL.
  • Secure upload to a server = SFTP (plain FTP/HTTP is not encrypted; POP3 is for email).
  • HTTP = 80, HTTPS = 443 β€” do not swap them.
🎯 PYQs β€” Official MPESB SI Prelims 2025 paper
Q1. Which is the most secure way to upload files to a server? MPESB SI Prelims 2025 β€” 16 Jan 2026, Shift 1
(A) FTP without encryption
(B) SFTP
(C) HTTP
(D) POP3
Correct answer: (B) SFTP β€” encrypted file transfer through SSH.
Q2. Which protocol should you always check in the URL before entering sensitive information online? MPESB SI Prelims 2025 β€” 17 Jan 2026, Shift 1
(A) FTP
(B) HTTP
(C) HTTPS
(D) SMTP
Correct answer: (C) HTTPS
✍️ Practice MCQs (self-made, not PYQs)
P1. What is the default port number of HTTPS? Practice MCQ
(A) 21
(B) 25
(C) 80
(D) 443
Answer: (D) 443
P2. What gives IP addresses to devices on a network automatically? Practice MCQ
(A) DNS
(B) DHCP
(C) FTP
(D) ARP
Answer: (B) DHCP

πŸ“Œ 15. Cyber Security β€” Malware, Attacks, Antivirus (10 min read)

15.1 Types of Malware (Malicious Software)

MalwareIdentification
Virus (exam books write "Vital Information Resources Under Seize" β€” this is a popular expansion made up later, not the real acronym)Spreads by attaching itself to a file/program; becomes active when run (user action). The first PC virus was "Brain" (1986, Pakistan)
WormSpreads over the network by making copies of itself; does not need a host file
Trojan HorseTakes the form of genuine/useful software to trick the user into installing it; causes harm from behind
RansomwareEncrypts/locks data and demands money (ransom) to give it back β€” e.g. WannaCry (2017)
SpywareSecretly steals information and sends it out
KeyloggerRecords every key pressed on the keyboard (passwords)
AdwareForcibly shows ads
Rootkit / BackdoorHides deep in the system and gives the hacker a secret way in
BotnetA network of infected "zombie" computers β€” used in DDoS attacks
Logic bombCode that becomes active on a set condition/date

15.2 Cyber Attacks and Fraud

AttackMeaning
PhishingStealing passwords, OTPs, bank details through fake emails/websites
Vishing / SmishingPhishing by voice call / by SMS
PharmingChanging the DNS so that even the real URL takes you to a fake site
SpoofingFake identity (email ID, caller ID, IP)
DoS / DDoSSo many requests to a server that it shuts down (DDoS = from many computers/a botnet)
Man-in-the-Middle (MITM)Secretly reading/changing data between two people β€” a risk on public Wi-Fi
SQL InjectionPutting malicious code into a website's form to reach the database
Brute force / Dictionary attackTrying lakhs of passwords
Rainbow tableCracking passwords with a table of pre-computed password hashes. Defence: a unique random salt for each password (salting) β€” a global salt gives less security
Social engineeringGetting information by trapping a person with talk (calling as bank/KYC/police)
SIM swap, Juice jacking, QR code scamGetting OTPs with a duplicate SIM; data theft through a public USB charging port; money deducted by making you scan a QR
"Digital arrest" scamThe fraudster poses as police/CBI on a video call and threatens "arrest" β€” there is no such thing as "digital arrest" in law; report immediately on 1930
Malware injection (file upload)Slipping a malicious file into a website during file upload β€” a common risk of uploads

15.3 Types of Hackers

  • White hat = ethical hacker β€” finds security weaknesses with permission and gets them fixed.
  • Black hat = criminal hacker (harm/theft). Grey hat = in between β€” enters without permission but does not necessarily have bad intent. Cracker = one who breaks security to do wrong.

15.4 Security Measures

  • Firewall β€” a "wall" between the network and the computer; allows/blocks incoming and outgoing traffic according to rules (hardware or software).
  • Antivirus detection methods:
    • Signature-based β€” matching a file against signatures of known viruses (database); updates are needed to catch new viruses.
    • Heuristic analysis β€” comparing the source code/behaviour patterns of a suspicious program with known malware patterns in a heuristic database; catches new/modified forms.
    • Sandbox detection β€” running a suspicious file in a virtual environment (sandbox) to see what it does.
    • Data mining techniques β€” classifying a file as malicious or safe using machine learning (advanced method).
    • Real-time protection β€” scans a file immediately as it is opened/downloaded.
    Indian antivirus: Quick Heal (Pune). Others: Microsoft Defender, Norton, McAfee, Kaspersky.
  • Authentication: strong password, 2FA/MFA (something you know β€” password; something you have β€” OTP/phone; something you are β€” fingerprint), CAPTCHA (human or bot).
  • Encryption β€” plaintext β†’ ciphertext. Symmetric (a single key β€” AES) vs Asymmetric (public + private key β€” RSA). Digital signature, SSL/TLS certificate, end-to-end encryption.
  • Safe habits: on public Wi-Fi do not enter passwords/banking details (or use a VPN); do not click the button of an "Install antivirus" pop-up β€” close it with the 'X' instead of a pop-up button (if needed, Alt + F4/Task Manager); keep the OS/apps updated; never tell anyone your OTP/PIN; check for HTTPS in the URL; do not open unknown links/APKs.
⚠️ Exam Traps:
  • Demands money = Ransomware; looks like genuine software = Trojan; spreads by itself = Worm.
  • Ethical hacker = White hat.
  • Running in a virtual environment = Sandbox; ML classification = Data mining; code patterns vs heuristic database = Heuristic; known signatures = Signature-based.
  • Defence against rainbow tables = unique random salt per password.
  • Turning off the firewall / using HTTP sites on public Wi-Fi = wrong.
🎯 PYQs β€” Official MPESB SI Prelims 2025 paper
Q1. Which of these is a common risk during file upload? MPESB SI Prelims 2025 β€” 16 Jan 2026, Shift 1
(A) Increased bandwidth
(B) Malware injection
(C) HTTPS encryption
(D) DNS resolution
Correct answer: (B) Malware injection
Q2. Which malware demands payment to restore access to user data? MPESB SI Prelims 2025 β€” 17 Jan 2026, Shift 1
(A) Spyware
(B) Ransomware
(C) Worm
(D) Adware
Correct answer: (B) Ransomware
Q3. Which type of hacker acts ethically to fix security weaknesses? MPESB SI Prelims 2025 β€” 18 Jan 2026, Shift 2
(A) Black hat
(B) Grey hat
(C) White hat
(D) Crackers
Correct answer: (C) White hat
Q4. What is the most effective way to stop attackers from pre-computing hashes (rainbow tables) for bulk password cracking? MPESB SI Prelims 2025 β€” 19 Jan 2026, Shift 1
(A) Encrypt all passwords with AES
(B) A global salt for all passwords
(C) A unique random salt for each password
(D) Hashing only
Correct answer: (C) Unique random salt per password
Because each password has a different salt, one precomputed table does not work on all of them.
Q5. Which malware disguises itself as genuine software to deceive users? MPESB SI Prelims 2025 β€” 19 Jan 2026, Shift 2
(A) Worm
(B) Trojan
(C) Virus
(D) Ransomware
Correct answer: (B) Trojan
Q6. Which antivirus detection method runs suspicious files in a virtual environment? MPESB SI Prelims 2025 β€” 19 Jan 2026, Shift 2
(A) Signature-based
(B) Sandbox detection
(C) Heuristic
(D) Real-time protection
Correct answer: (B) Sandbox detection
Q7. Which advanced antivirus method uses machine learning for malware classification? MPESB SI Prelims 2025 β€” 21 Jan 2026, Shift 1
(A) Heuristic analysis
(B) Data mining techniques
(C) Signature-based detection
(D) Real-time protection
Correct answer: (B) Data mining techniques
In newer antivirus methods, data mining/machine learning algorithms classify a file's behaviour as malicious or benign.
Q8. Which practice reduces risk when using public Wi-Fi for sensitive tasks? MPESB SI Prelims 2025 β€” 21 Jan 2026, Shift 1
(A) Turn off the firewall
(B) Avoid entering passwords or banking details on a public network
(C) Enable cookies
(D) Use HTTP websites
Correct answer: (B)
Q9. What should you do when a pop-up asks you to install antivirus software? MPESB SI Prelims 2025 β€” 21 Jan 2026, Shift 1
(A) Click "Install" immediately
(B) Close it with the 'X' icon instead of a pop-up button
(C) Accept it and scan
(D) Ignore it and continue browsing
Correct answer: (B)
Such pop-ups are often "scareware"; clicking any button inside them (OK/Install/Cancel) can be dangerous.
Q10. Which antivirus method compares source code patterns with known malware in a heuristic database? MPESB SI Prelims 2025 β€” 21 Jan 2026, Shift 2
(A) Signature-based detection
(B) Sandbox detection
(C) Heuristic analysis
(D) Data mining
Correct answer: (C) Heuristic analysis
✍️ Practice MCQs (self-made, not PYQs)
P1. What is phishing done through SMS called? Practice MCQ
(A) Vishing
(B) Smishing
(C) Pharming
(D) Spoofing
Answer: (B) Smishing
P2. Which malware spreads over a network by making copies of itself without any host file? Practice MCQ
(A) Virus
(B) Trojan
(C) Worm
(D) Adware
Answer: (C) Worm
P3. Which software secretly records passwords typed on the keyboard? Practice MCQ
(A) Keylogger
(B) Firewall
(C) Cookie
(D) Compiler
Answer: (A) Keylogger

πŸ“Œ 16. Backup & Cloud Storage (6 min read β€” 8 PYQs in 2025!)

16.1 Types of Backup

BackupWhat is copiedStorageRestore
FullAll the data every timeThe mostEasiest/fastest (a single set)
IncrementalFiles changed since the last backup of any kind (full or incremental)The leastSlowest β€” needs the full + all the incrementals
DifferentialAll files changed since the last full backup (incrementals in between make no difference)In between (grows every day)Full + the last differential
MirrorAn exact copy of the source (deleted from the source = deleted from the mirror too)β€”β€”
HybridA combination of Local (on-premises) + Cloudβ€”Fast from local; safe even in a disaster thanks to the cloud
CDP (Continuous Data Protection)Every write/change recorded in real timeβ€”Data from any moment can be restored
SnapshotA "photo" at a point in time (point-in-time image)β€”β€”
  • 3-2-1 rule: 3 copies of the data, on 2 different media, 1 copy offsite (far away/cloud).
  • RAID (Redundant Array of Independent Disks) = combining several disks for speed/redundancy β€” by itself it is not a complete backup.

16.2 Types of Cloud Storage

TypeData modelAccessUse
Object storageFlat namespace; each object has a unique object ID + rich metadata; on update the whole object is rewrittenThrough an API (HTTP/REST)Videos, logs, backups, data lake β€” almost unlimited scalability (e.g. Amazon S3)
Block storageData in fixed-size blocks; like a volume/diskSAN; the OS sees it as a diskDatabases, virtual machines (low latency)
File storageHierarchical folders/pathsNAS; file-share protocolsShared office folders

Tape libraries = cheap archival storage (sequential access, slow).

⚠️ Exam Traps:
  • "Since last full backup" = Differential. "Least storage, longest restore" = Incremental.
  • Local + cloud = Hybrid. Every change in real time = CDP.
  • Flat namespace + unique ID + metadata + REST API = Object storage. Hierarchical paths = file storage (not block).
🎯 PYQs β€” Official MPESB SI Prelims 2025 paper
Q1. Which backup strategy combines elements of both local (on-premises) and cloud-based backup solutions? MPESB SI Prelims 2025 β€” 17 Jan 2026, Shift 2
(A) RAID
(B) Hybrid backup
(C) Mirror backup
(D) Continuous backup
Correct answer: (B) Hybrid backup
Q2. A data lake of videos and logs needs almost unlimited scalability and rich metadata, and must also support rewrite-on-update (writing the whole object). Which storage will be most suitable? MPESB SI Prelims 2025 β€” 18 Jan 2026, Shift 1
(A) NAS file shares
(B) Object storage
(C) SAN block volumes
(D) Tape libraries
Correct answer: (B) Object storage
Q3. Which statement correctly shows the behaviour of Continuous Data Protection (CDP)? MPESB SI Prelims 2025 β€” 18 Jan 2026, Shift 2
(A) Full daily and differential every hour
(B) Snapshots only at fixed times (e.g. daily)
(C) Recovery only up to the last backup point
(D) Every write/change recorded in real time, restore from any moment
Correct answer: (D)
Q4. Which backup method copies all files changed since the last full backup, even if incremental backups were taken earlier? MPESB SI Prelims 2025 β€” 19 Jan 2026, Shift 1
(A) Differential backup
(B) Incremental backup
(C) Full backup
(D) Snapshot backup
Correct answer: (A) Differential backup
Q5. In object storage, data retrieval usually uses: MPESB SI Prelims 2025 β€” 20 Jan 2026, Shift 1
(A) File path traversal
(B) Block address mapping
(C) A unique object ID with metadata through an API
(D) Direct inode reference
Correct answer: (C)
Q6. Which backup type takes the least storage space but the most time to restore? MPESB SI Prelims 2025 β€” 21 Jan 2026, Shift 1
(A) Full backup
(B) Incremental backup
(C) Differential backup
(D) Continuous backup
Correct answer: (B) Incremental backup
Q7. In cloud storage architecture, which pairing best matches the data model with its typical access mechanism? MPESB SI Prelims 2025 β€” 21 Jan 2026, Shift 2
(A) Block storage β€” hierarchical paths and POSIX file calls
(B) Object storage β€” flat namespace and API access (HTTP/REST)
(C) File storage β€” unique object IDs and metadata-driven retrieval
(D) Block storage β€” globally unique identifiers and per-object metadata
Correct answer: (B)
In the other options, the features are paired with the wrong storage type.
Q8. Which backup method stores only the files changed since the last full backup? MPESB SI Prelims 2025 β€” 21 Jan 2026, Shift 2
(A) Full backup
(B) Incremental backup
(C) Differential backup
(D) Mirror backup
Correct answer: (C) Differential backup
Incremental = since the last backup of any kind; Differential = since the last full backup.

πŸ“Œ 17. Cyber Crime & IT Act 2000 (Cyber Crime & Law) (6 min read)

17.1 Information Technology Act, 2000

  • India's main cyber law. Act No. 21 of 2000. President's assent on 9 June 2000; came into force on 17 October 2000.
  • Objective: legal recognition of electronic transactions (e-commerce), electronic records and digital signatures; punishment for cyber crimes.
  • IT (Amendment) Act 2008 β€” in force from 27 October 2009; it added Sections 66A–66F, 67A, 67B and replaced "digital signature" with the broader concept of "electronic signature".
SectionOffence / Provision
43Damage to a computer/data without permission β€” compensation
65Tampering with computer source code/documents
66Computer-related offences (hacking) β€” up to 3 years / up to β‚Ή5 lakh
66A"Offensive messages" β€” struck down by the Supreme Court in Shreya Singhal v. Union of India (24 March 2015) β€” violation of Article 19(1)(a)
66BDishonestly keeping a stolen computer/mobile
66CIdentity theft β€” using another person's password, OTP, electronic signature
66DCheating by personation β€” cheating by posing as someone else using a computer/phone (fake profile, fake call)
66EViolation of privacy β€” capturing/publishing someone's private images
66FCyber terrorism β€” up to life imprisonment
67 / 67A / 67BObscene material / sexually explicit material / obscene material involving children in electronic form
69 / 69AInterception-monitoring by the government / blocking websites-apps (in June 2020, 59 apps including TikTok were blocked under 69A)
70 / 70BProtected system / provision for CERT-In

17.2 Institutions and Helplines

  • 1930 β€” National Cyber Crime Helpline (especially for immediate reporting of financial fraud; 24Γ—7).
  • cybercrime.gov.in β€” National Cyber Crime Reporting Portal; I4C (Indian Cyber Crime Coordination Centre), under the Ministry of Home Affairs (MHA).
  • CERT-In (Indian Computer Emergency Response Team) β€” the national nodal agency for cyber incidents, under MeitY.
  • Sanchar Saathi (Department of Telecommunications) β€” blocking lost/stolen mobiles, reporting suspected fraud calls/SMS.
  • Digital Personal Data Protection (DPDP) Act, 2023 β€” assent on 11 August 2023; protection of people's digital personal data.
  • New criminal laws (from 1 July 2024): BNS 2023 replaced the IPC; BSA 2023 replaced the Evidence Act β€” admissibility of electronic records is now in BSA Section 63 (earlier IEA 65B). The IT Act 2000 remains in force.
⚠️ Exam Traps:
  • IT Act 2000, in force 17 Oct 2000; amendment 2008 (in force 2009).
  • 66C = identity theft; 66D = cheating by personation; 66F = cyber terrorism (life).
  • 66A has been struck down (2015) β€” no FIR can now be filed under it.
  • Cyber fraud helpline = 1930 (112 is the general emergency number).
✍️ Practice MCQs (self-made, not PYQs)
P1. Which section of the IT Act 2000 relates to cyber terrorism? Practice MCQ
(A) 66A
(B) 66C
(C) 66F
(D) 67
Answer: (C) 66F
P2. Which section of the IT Act did the Supreme Court strike down in the Shreya Singhal case (2015)? Practice MCQ
(A) 66A
(B) 69A
(C) 43
(D) 79
Answer: (A) 66A (69A was held valid)
P3. What is the national helpline number for immediate complaints of online financial fraud? Practice MCQ
(A) 100
(B) 181
(C) 1930
(D) 1098
Answer: (C) 1930
P4. Stealing and using another person's password or OTP falls under which section of the IT Act? Practice MCQ
(A) 66B
(B) 66C
(C) 66E
(D) 67
Answer: (B) 66C β€” identity theft

πŸ“Œ 18. Number System & Codes (8 min read)

18.1 The Four Main Number Systems

SystemBaseDigitsExample
Binary20, 1(1011)β‚‚
Octal80–7(57)β‚ˆ
Decimal100–9(47)₁₀
Hexadecimal160–9, A=10, B=11, C=12, D=13, E=14, F=15(2F)₁₆

Inside, a computer understands everything in binary (0 = off, 1 = on). n bits give 2ⁿ different combinations β€” 8 bits give 2⁸ = 256 (0 to 255).

18.2 Conversions β€” step by step

ConversionMethodExample
Decimal β†’ BinaryDivide by 2 repeatedly, read the remainders from bottom to top25 β†’ 25Γ·2=12 r1, 12Γ·2=6 r0, 6Γ·2=3 r0, 3Γ·2=1 r1, 1Γ·2=0 r1 β†’ (11001)β‚‚
Binary β†’ DecimalPlace values from the right are 1, 2, 4, 8, 16, 32, 64, 128… β€” add those where there is a 1(1011)β‚‚ = 8+0+2+1 = 11; (101111)β‚‚ = 32+8+4+2+1 = 47
Binary β†’ OctalGroups of 3 bits from the right101 111 β†’ (57)β‚ˆ
Binary β†’ HexGroups of 4 bits from the right0010 1111 β†’ (2F)₁₆
Octal/Hex β†’ DecimalMultiply by powers of the base(57)β‚ˆ = 5Γ—8 + 7 = 47; (2F)₁₆ = 2Γ—16 + 15 = 47; (A5)₁₆ = 10Γ—16 + 5 = 165
Decimal β†’ Octal/HexDivide by 8 or 16 repeatedly100 = (144)β‚ˆ = (64)₁₆ = (1100100)β‚‚
Decimal fraction β†’ BinaryMultiply by 2 repeatedly, read the integer parts from top to bottom0.625 β†’ 1.25 (1), 0.5 (0), 1.0 (1) β†’ (0.101)β‚‚

Remember: (255)₁₀ = (11111111)β‚‚ = (377)β‚ˆ = (FF)₁₆. (15)₁₀ = (1111)β‚‚ = (F)₁₆. (8)₁₀ = (1000)β‚‚ = (10)β‚ˆ. (16)₁₀ = (10000)β‚‚ = (10)₁₆.

18.3 Binary Arithmetic

  • Addition: 0+0=0, 0+1=1, 1+1=10 (write 0, carry 1), 1+1+1=11. Example: 1011 + 0110 = 10001 (11 + 6 = 17 βœ“).
  • Subtraction: 1010 βˆ’ 0011 = 0111 (10 βˆ’ 3 = 7 βœ“).
  • 1's complement = flip every bit: 1010 β†’ 0101. 2's complement = 1's complement + 1: 1010 β†’ 0110 (used to represent negative numbers).

18.4 Codes

  • ASCII β€” American Standard Code for Information Interchange; 7-bit, 128 characters (extended 8-bit = 256). 'A' = 65, 'a' = 97, '0' = 48, space = 32.
  • Unicode β€” almost all the scripts of the world (including Hindi/Devanagari); UTF-8 is the most common on the web.
  • EBCDIC β€” the 8-bit code of IBM mainframes. BCD β€” 4 bits for each decimal digit: 25 = 0010 0101.
⚠️ Exam Traps:
  • In decimal β†’ binary, read the remainders from bottom to top.
  • Octal = 3-bit groups, Hex = 4-bit groups. Octal has no digits 8 and 9.
  • In Hex, F = 15 (not 16). (10)₁₆ = 16.
✍️ Practice MCQs (self-made, not PYQs)
P1. What is the decimal value of (1101)β‚‚? Practice MCQ
(A) 11
(B) 12
(C) 13
(D) 14
Answer: (C) 13 β€” 8+4+0+1.
P2. Write (30)₁₀ in binary. Practice MCQ
(A) 11110
(B) 11100
(C) 10110
(D) 11011
Answer: (A) 11110 β€” 16+8+4+2 = 30.
P3. What is the hexadecimal of (11010110)β‚‚? Practice MCQ
(A) C6
(B) D6
(C) D5
(D) E6
Answer: (B) D6 β€” 1101 = D (13), 0110 = 6.
P4. What is the decimal value of (64)β‚ˆ? Practice MCQ
(A) 48
(B) 52
(C) 64
(D) 54
Answer: (B) 52 β€” 6Γ—8 + 4 = 52.
P5. What is the base of the hexadecimal system? Practice MCQ
(A) 2
(B) 8
(C) 10
(D) 16
Answer: (D) 16

πŸ“Œ 19. Important Abbreviations (7 min read)

Hardware & Memory

ShortFull formShortFull form
CPUCentral Processing UnitALU / CUArithmetic Logic Unit / Control Unit
RAMRandom Access MemoryROMRead Only Memory
SRAM / DRAMStatic / Dynamic RAMPROMProgrammable ROM
EPROMErasable Programmable ROMEEPROMElectrically Erasable Programmable ROM
BIOSBasic Input/Output SystemPOSTPower-On Self-Test
CMOSComplementary Metal-Oxide-SemiconductorUSBUniversal Serial Bus
HDD / SSDHard Disk Drive / Solid State DriveSATASerial Advanced Technology Attachment
CD-ROMCompact Disc Read Only MemoryDVDDigital Versatile Disc
HDMIHigh-Definition Multimedia InterfaceVGAVideo Graphics Array
LCD / LEDLiquid Crystal Display / Light Emitting DiodeCRTCathode Ray Tube
OLEDOrganic Light Emitting DiodeVDUVisual Display Unit
SMPSSwitched-Mode Power SupplyUPSUninterruptible Power Supply
OCROptical Character RecognitionOMROptical Mark Reader/Recognition
MICRMagnetic Ink Character RecognitionBCRBar Code Reader
DPI / PPM / CPSDots per Inch / Pages per Minute / Characters per SecondRPMRevolutions per Minute
IC / VLSIIntegrated Circuit / Very Large Scale IntegrationGPUGraphics Processing Unit
MIPSMillion Instructions Per SecondFLOPSFloating-point Operations Per Second

Software, Early Computers & Languages

ShortFull formShortFull form
OSOperating SystemDOSDisk Operating System
GUIGraphical User InterfaceCLICommand Line Interface
ENIACElectronic Numerical Integrator and ComputerUNIVACUniversal Automatic Computer
EDSACElectronic Delay Storage Automatic CalculatorEDVACElectronic Discrete Variable Automatic Computer
FORTRANFormula TranslationCOBOLCommon Business Oriented Language
BASICBeginner's All-purpose Symbolic Instruction CodeSQLStructured Query Language
DBMSDatabase Management SystemCAD / CAMComputer-Aided Design / Manufacturing
ASCIIAmerican Standard Code for Information InterchangeEBCDICExtended Binary Coded Decimal Interchange Code
BCDBinary Coded DecimalGIGOGarbage In, Garbage Out
PDFPortable Document FormatJPEGJoint Photographic Experts Group
GIFGraphics Interchange FormatPNGPortable Network Graphics
MPEGMoving Picture Experts GroupCSVComma-Separated Values

Internet, Network & Security

ShortFull formShortFull form
WWWWorld Wide WebURLUniform Resource Locator
HTMLHyperText Markup LanguageHTTP(S)HyperText Transfer Protocol (Secure)
XML / CSSeXtensible Markup Language / Cascading Style SheetsISPInternet Service Provider
IP / TCP / UDPInternet Protocol / Transmission Control Protocol / User Datagram ProtocolDNSDomain Name System
FTP / SFTPFile Transfer Protocol / SSH File Transfer ProtocolDHCPDynamic Host Configuration Protocol
SMTPSimple Mail Transfer ProtocolPOP / IMAPPost Office Protocol / Internet Message Access Protocol
SSL / TLSSecure Sockets Layer / Transport Layer SecuritySSHSecure Shell
LAN / MAN / WAN / PANLocal / Metropolitan / Wide / Personal Area NetworkWLANWireless LAN
NICNetwork Interface Card (and National Informatics Centre)MACMedia Access Control
OSIOpen Systems InterconnectionNAT / CIDRNetwork Address Translation / Classless Inter-Domain Routing
VPNVirtual Private NetworkVoIPVoice over Internet Protocol
DSL / ADSLDigital Subscriber Line / Asymmetric DSLISDNIntegrated Services Digital Network
Wi-FiCommonly written as "Wireless Fidelity" (according to the Wi-Fi Alliance it is a trademark name)IEEEInstitute of Electrical and Electronics Engineers
ICANNInternet Corporation for Assigned Names and NumbersCAPTCHACompletely Automated Public Turing test to tell Computers and Humans Apart
GPSGlobal Positioning SystemGSMGlobal System for Mobile Communications
SIMSubscriber Identity ModuleIMEIInternational Mobile Equipment Identity
OTP / PINOne Time Password / Personal Identification NumberQR / RFID / NFCQuick Response / Radio Frequency Identification / Near Field Communication
SMS / MMSShort Message Service / Multimedia Messaging ServiceDDoSDistributed Denial of Service

Banking, e-Governance & New Tech

ShortFull formShortFull form
UPIUnified Payments InterfaceNPCINational Payments Corporation of India
BHIMBharat Interface for MoneyIMPSImmediate Payment Service
NEFTNational Electronic Funds TransferRTGSReal Time Gross Settlement
ATMAutomated Teller MachineKYCKnow Your Customer
AI / MLArtificial Intelligence / Machine LearningIoTInternet of Things
AR / VRAugmented Reality / Virtual RealityIaaS / PaaS / SaaSInfrastructure / Platform / Software as a Service
CERT-InIndian Computer Emergency Response TeamC-DACCentre for Development of Advanced Computing
MeitYMinistry of Electronics and Information TechnologyUIDAIUnique Identification Authority of India
UMANGUnified Mobile Application for New-age GovernanceI4CIndian Cyber Crime Coordination Centre
CCTNSCrime and Criminal Tracking Network & SystemsGeMGovernment e-Marketplace

πŸ“Œ 20. Latest Tech, UPI & e-Governance (7 min read)

20.1 Cloud Computing

  • On-demand computing resources (server, storage, software) over the internet β€” pay for as much as you use; no need to buy your own hardware.
  • Service models: IaaS (Infrastructure β€” virtual server/storage, e.g. AWS EC2), PaaS (Platform β€” for developers, e.g. Google App Engine), SaaS (Software β€” ready-made software in the browser: Gmail, Google Docs, Microsoft 365).
  • Deployment: Public, Private, Hybrid (combination of both), Community. Cloud storage: Google Drive, OneDrive, Dropbox, iCloud; government β€” DigiLocker. The Government of India's cloud initiative: MeghRaj (GI Cloud).

20.2 Artificial Intelligence (AI) and Others

  • AI = the ability of a machine to think/learn like a human. Term by John McCarthy (1956). Turing Test (Alan Turing, 1950) β€” whether a machine behaves like a human or not.
  • Machine Learning = learning by itself from data (part of AI); Deep Learning = neural networks (part of ML). Generative AI = creating new text/images β€” ChatGPT (OpenAI, Nov 2022), Gemini (Google). Chatbots, face recognition, voice assistants (Siri, Alexa).
  • Deepfake = fake video/audio made with AI β€” a danger in cyber crime and fake news.
  • IoT (Internet of Things) = everyday things connected to the internet (smart meter, smart watch, smart TV, CCTV). Term by Kevin Ashton (1999).
  • Blockchain = a decentralised, distributed digital ledger (cannot be altered); cryptocurrency (Bitcoin β€” "Satoshi Nakamoto"). RBI's Digital Rupee (eβ‚Ή) = CBDC, pilot started in 2022.
  • 5G β€” launched in India on 1 October 2022 (PM Modi, India Mobile Congress). Very high speed, low latency.
  • Others: Big Data (Volume, Velocity, Variety), Edge computing, Quantum computing (qubits), AR/VR/Metaverse, 3D printing, Drones, Robotics.

20.3 UPI and Digital Payments

  • UPI (Unified Payments Interface) β€” built by NPCI; launched on 11 April 2016 by RBI Governor Raghuram Rajan (with Nandan Nilekani). Built on top of the IMPS platform.
  • Many bank accounts in one app; instant transfer 24Γ—7; UPI ID/VPA (e.g. name@bank), QR code, UPI PIN. A PIN is needed to send money β€” never enter your PIN to receive money (a sign of fraud).
  • BHIM app β€” NPCI's UPI app (30 Dec 2016). UPI Lite (small payments), UPI 123PAY (feature phones). RuPay β€” India's card network (NPCI).
  • Others: NEFT, RTGS (large amounts), IMPS (instant 24Γ—7), AePS (through Aadhaar), FASTag (toll, RFID).

20.4 e-Governance (Digital India)

InitiativeInformation
Digital IndiaLaunched on 1 July 2015; goals β€” digital infrastructure, e-services, digital literacy
AadhaarUIDAI; 12-digit unique number; biometric (fingerprint, iris) + demographic; Aadhaar Act 2016
DigiLockerDigital locker for documents (marksheet, DL, Aadhaar) β€” MeitY
UMANGMany central and state government services in one app
BharatNet / CSCOptical fibre broadband up to gram panchayats / Common Service Centres (e-services in villages)
GeMOnline portal for government purchases
CCTNSNational crime-criminal database network linking police stations
MPMPOnline (the state's e-services portal), CM Helpline 181, e-Uparjan (registration for crop procurement), Samagra portal (scheme benefits through family/member ID)
⚠️ Exam Traps:
  • UPI = NPCI (not made by the RBI; the RBI is the regulator), launched in 2016. Digital India = 2015.
  • Gmail/Google Docs = SaaS; virtual server = IaaS.
  • AI term = McCarthy; IoT term = Kevin Ashton.
✍️ Practice MCQs (self-made, not PYQs)
P1. Which organisation developed UPI? Practice MCQ
(A) RBI
(B) SBI
(C) NPCI
(D) SEBI
Answer: (C) NPCI
P2. Google Docs is an example of which cloud computing model? Practice MCQ
(A) IaaS
(B) PaaS
(C) SaaS
(D) DaaS
Answer: (C) SaaS
P3. Who coined the term "Artificial Intelligence"? Practice MCQ
(A) Alan Turing
(B) John McCarthy
(C) Charles Babbage
(D) Bill Gates
Answer: (B) John McCarthy (1956)
P4. How many digits does an Aadhaar number have? Practice MCQ
(A) 10
(B) 12
(C) 14
(D) 16
Answer: (B) 12
πŸ“ Last-week revision plan (Computer): (1) The Exam Traps box of every topic, (2) Windows/Word/Excel/PPT shortcut tables, (3) Protocols + ports table, (4) Backup types table, (5) Malware + antivirus methods, (6) solve 5 number-conversion questions yourself, (7) all 113 PYQs once again.

PYQ source: official MPESB SI Prelims 2025 paper (16–21 Jan 2026, 12 shifts)