Study guide
18.2 Networking Protocols, Cybersecurity & Microsoft Office
SBI Clerk Junior Associate
Track your progress as you read
Finished sections get a check mark.
1 Chapter 1: Exam Structure, Eligibility, Selection & Winning Strategy
1.1 SBI Clerk Overview, Eligibility & Two-Stage Selection 1.2 Exam Pattern, Sectional Timing & Negative Marking Mechanics 1.3 Time Allocation, Question Selection & Cutoff Strategy 1.4 Final Selection, Local Language Proficiency Test & Joining Formalities
2 Chapter 2: Reasoning — Coding, Series, Relations & Input-Output
2.1 Alphanumeric, Symbol & Number Sequences 2.2 Coding-Decoding Techniques 2.3 Blood Relations 2.4 Input-Output (Machine Input) Arrangements
3 Chapter 3: Reasoning — Direction, Ranking, Inequalities & Miscellaneous
3.1 Direction Sense & Distance 3.2 Order, Ranking & Comparison Tests 3.3 Coded and Direct Inequalities 3.4 Alphabet Test, Word Formation, Calendar & Clock
4 Chapter 4: Reasoning — Syllogisms, Critical Deduction & Data Sufficiency
4.1 Standard Syllogisms & Venn Diagram Foundations 4.2 Advanced Syllogism Cases: Only a Few & Possibility Models 4.3 Critical Reasoning for Mains Examination 4.4 Reasoning Data Sufficiency
5 Chapter 5: Reasoning — Seating Arrangements
5.1 Linear Seating Arrangements 5.2 Parallel Row Seating Arrangements 5.3 Circular & Square/Rectangular Seating Arrangements
6 Chapter 6: Reasoning — Puzzles & Complex Enigmas
6.1 Floor and Flat-Based Puzzles 6.2 Box-Based Puzzles & Vertical Stacks 6.3 Scheduling, Month-Date & Multi-Variable Matrix Puzzles
7 Chapter 7: Quantitative Aptitude: Speed Math & Number Foundations
7.1 Speed Math, Vedic Shortcuts & BODMAS Simplification 7.2 Approximation Strategies for High-Speed Calculations 7.3 Missing and Wrong Number Series
8 Chapter 8: Quantitative Aptitude: Equations & Percentage Mathematics
8.1 Quadratic Equations & Root Comparison 8.2 Percentages, Base Conversions & Successive Changes 8.3 Profit, Loss, Marked Price, Discount & Dishonest Seller Traps
9 Chapter 9: Quantitative Aptitude: Interest, Ratio & Partnership
9.1 Simple & Compound Interest Mechanics 9.2 Ratio, Proportion & Variation Techniques 9.3 Partnership Mathematics
10 Chapter 10: Quantitative Aptitude: Averages, Mixtures & Time-Work
10.1 Averages, Weighted Averages & Age Problems 10.2 Alligation Method & Solution Replacement Problems 10.3 Time & Work, Efficiency Ratios & Pipes and Cisterns
11 Chapter 11: Quantitative Aptitude: Speed, Motion & Applied Mathematics
11.1 Speed, Time & Distance Principles 11.2 Problems on Trains, Platforms, and Boats & Streams 11.3 2D/3D Mensuration & Banking Permutation, Combination, Probability
12 Chapter 12: Quantitative Aptitude: Data Interpretation & Sufficiency
12.1 Tabular, Bar & Line Graph Data Interpretation 12.2 Pie Charts & Paragraph-Based Caselet DI 12.3 Advanced Mains DI & Quantitative Data Sufficiency
13 Chapter 13: English Language: Grammar & Usage
13.1 Core Grammar Rules for Banking Exams 13.2 Tenses, Prepositional Usages & Conditional Clauses 13.3 Error Spotting & Sentence Correction Strategies
14 Chapter 14: English Language: Comprehension, Vocabulary, Idioms & Discourse
14.1 Phrase Replacement, Single/Double Fillers & Sentence Improvement 14.2 Reading Comprehension Mastery 14.3 Cloze Tests, Para Jumbles & Discourse Connectors 14.4 Vocabulary: Synonyms, Antonyms, One-Word Substitution & Word Usage 14.5 Idioms, Phrasal Verbs, Spelling & Odd Sentence Out
15 Chapter 15: General & Financial Awareness: Banking System, RBI & Capital Regulation
15.1 Structure of the Indian Banking System 15.2 Reserve Bank of India & Monetary Policy Framework 15.3 Banking Operations, Negotiable Instruments & KYC/AML 15.4 Basel III Capital Framework, Prompt Corrective Action & D-SIBs
16 Chapter 16: General & Financial Awareness: Digital Banking & Financial Inclusion
16.1 Payment Systems, NPCI & Digital Banking 16.2 Priority Sector Lending & Financial Inclusion Initiatives 16.3 Non-Performing Assets & Debt Recovery Mechanisms
17 Chapter 17: General & Financial Awareness: Financial Markets, Economy, Schemes & Current Affairs
17.1 Money Market & Capital Market Instruments 17.2 Flagship Government Social Security Schemes & Union Budget 17.3 Static Banking GK, Financial Regulators & Current Affairs Mastery 17.4 Indian Economy Essentials: National Income, Inflation, Fiscal Indicators, GST & External Sector
18 Chapter 18: Computer Aptitude
18.1 Computer Fundamentals: Hardware Architecture, Memory & OS 18.2 Networking Protocols, Cybersecurity & Microsoft Office 18.3 Number Systems, Logic Gates, Flowcharts & Computer Basics
18.2 Networking Protocols, Cybersecurity & Microsoft Office
Key Takeaways Explain This Topic AI
Computer networks are categorized geographically into PAN, LAN, MAN, WAN, and SAN, with physical topologies dictating fault tolerance and link counts (Full Mesh requiring n(n-1)/2 physical connections).
The Open Systems Interconnection (OSI) 7-layer model standardizes protocol communication through discrete Protocol Data Units (Bits, Frames, Packets, Segments, and Application Data).
Essential network services operate on standard transport port numbers, including HTTP (80), HTTPS (443), FTP (20/21), SMTP (25/587), DNS (53), and DHCP (67/68), while addressing migrates from 32-bit IPv4 to 128-bit IPv6.
Banking security demands defenses against malware (ransomware, worms, keyloggers) and network deception (phishing, MitM, DDoS), reinforced by firewalls, symmetric encryption such as AES and asymmetric public-key encryption such as RSA.
Branch counter operations require fluency in Microsoft Office, particularly Excel cell referencing modes ($A$1), financial lookup functions (VLOOKUP, XLOOKUP), and essential keyboard shortcuts.
Last updated: September 2026
18.2 Networking Protocols, Cybersecurity & Microsoft Office
Large Indian banks run enterprise networks that link thousands of branches, administrative offices, ATMs and digital channels to centralized data centers. For a Junior Associate, daily operations require interacting with local and wide area networks, adhering to strict cybersecurity hygiene, and executing financial data analysis in Microsoft Office.
1. Network Classifications & Topologies
Computer networks are categorized by their geographical span, operational purpose, and transmission infrastructure:
Personal Area Network (PAN): Spans the immediate space around an individual, typically within a 10-meter radius. Utilizes short-range wireless technologies such as Bluetooth (IEEE 802.15.1), Zigbee, Ultra-Wideband (UWB), or Near Field Communication (NFC) for pairing micro-ATM point-of-sale peripherals.
Local Area Network (LAN): Interconnects computers and peripherals within a restricted geographic area, such as a single bank branch, office floor, or campus building. Typically built using high-speed twisted-pair Ethernet cables (IEEE 802.3) or Wireless LAN (Wi-Fi, IEEE 802.11) delivering speeds from 100 Mbps to 10 Gbps.
Metropolitan Area Network (MAN): Covers an entire town or municipality, spanning distances of 5 to 50 kilometers. Connects multiple bank branches across a metropolitan district or links regional clearing houses via optical fiber backbones.
Wide Area Network (WAN): Spans vast geographic territories across states, nations, or continents. A bank's enterprise WAN links its branches to central database servers using leased telecommunication lines, Multiprotocol Label Switching (MPLS) circuits, and satellite VSAT (Very Small Aperture Terminal) links for remote rural outposts.
Storage Area Network (SAN): A dedicated, high-performance sub-network connecting shared pools of block-level enterprise storage devices (RAID disk arrays, tape libraries) to database servers via Fibre Channel (FC) or iSCSI protocols in core data centers.
Network Topologies
Topology defines the geometric arrangement of network nodes and communication channels: STAR TOPOLOGY BUS TOPOLOGY RING TOPOLOGY
- [Node 1] [Node 1] [Node 2] [Node 1]
- | | | / \
- [Node 4]-[Hub]-[Node 2] ===+==========+=== Backbone [Node 4] [Node 2]
- | | | \ /
- [Node 3] [Node 3] [Node 4] [Node 3]
Star Topology: Every branch workstation connects directly to a central networking device (switch or hub) via point-to-point links. Failure of a single workstation cable isolates only that workstation; however, failure of the central switch disables the entire branch network. This is the universal topology used in bank branch LANs.
Bus Topology: All devices connect sequentially to a single shared central coaxial or twisted-pair transmission cable (the backbone), terminated at both ends with electrical resistors to absorb signal reflections. If the primary backbone cable is severed, the entire network fails completely. Prone to data collisions under heavy traffic.
Ring Topology: Devices are connected in a closed circular loop. Data packets travel sequentially from node to node in a single direction (or dual counter-rotating directions for redundancy, as in FDDI) via token-passing arbitration. A single node or cable break can disrupt the entire loop unless self-healing bypass relays are installed.
Mesh Topology: Nodes possess point-to-point connections to other nodes:
Full Mesh: Every node is directly wired to every other node. For a network comprising n n n nodes, the total number of physical duplex transmission lines required is: Physical Links = n ( n − 1 ) 2 \mathbf{\text{Physical Links} = \frac{n(n - 1)}{2}} Physical Links = 2 n ( n − 1 )
(Example: An inter-data center cluster with 8 core servers requires 8 × 7 2 = 28 \frac{8 \times 7}{2} = 28 2 8 × 7 = 28 physical dedicated links). Full mesh offers unmatched redundancy and zero routing bottlenecks but is exceptionally costly.
Partial Mesh: Provides redundant pathways between mission-critical servers while peripheral nodes connect to only one or two neighbors, balancing cost and fault tolerance.
Tree (Hierarchical) Topology: Integrates multiple star topologies linked along an overarching bus backbone. Commonly adopted in multi-story administrative zonal offices.
Hybrid Topology: Blends two or more distinct topologies (e.g., star-bus or star-ring) across enterprise networks.
2. The OSI 7-Layer Reference Model vs. TCP/IP Architecture
The International Organization for Standardization (ISO) established the Open Systems Interconnection (OSI) 7-Layer Model as an architectural framework standardizing network communication into distinct functional layers.
Layer Number & Name Primary Operational Function Protocol Data Unit (PDU) Common Protocols & Standards Physical Hardware Devices
7. Application Direct interface with end-user application software; network services and resource discovery. Data HTTP, HTTPS, FTP, SMTP, POP3, IMAP, DNS, DHCP, Telnet, SSH Web browsers, Email clients, CBS portal
6. Presentation Data formatting, syntax conversion, character translation (ASCII/EBCDIC), compression, and cryptographic encryption/decryption (SSL/TLS). Data SSL, TLS, JPEG, MPEG, GIF, ASCII, MIME Software libraries, Cryptographic coprocessors
5. Session Establishes, maintains, synchronizes, checkpoints, and terminates duplex communication dialogues between applications. Data NetBIOS, RPC, PPTP, Sockets, Session SIP Operating system network subsystems
4. Transport End-to-end process-to-process delivery, flow control, sequence numbering, error detection/recovery, and port multiplexing. Segments (TCP) / Datagrams (UDP) TCP (Transmission Control Protocol), UDP (User Datagram Protocol) Firewalls, Load balancers, Layer 4 switches
3. Network Logical host addressing (IP addressing), packet forwarding, routing through intermediate subnets, and fragmentation. Packets IPv4, IPv6, ICMP, ARP, RARP, OSPF, BGP, RIP, IPsec Routers, Layer 3 multi-layer switches
2. Data Link Hop-to-hop physical framing, hardware MAC addressing, media access control (CSMA/CD), and error detection (CRC). Frames Ethernet (802.3), Wi-Fi (802.11), PPP, HDLC, Frame Relay, ATM Network Interface Cards (NIC), Layer 2 switches, Bridges
1. Physical Unstructured transmission of raw binary bits over physical media, voltage levels, pinouts, and signal encoding. Bits RS-232, 1000BASE-T, Cat6 cables, Fiber optics, RJ-45, V.35 Repeaters, Passive Hubs, Modems, Transceivers
Note
OSI vs. TCP/IP Mapping: While the academic OSI model has 7 layers, the practical Internet standard TCP/IP Model combines the top three OSI layers (Application, Presentation, Session) into a single Application Layer , retains the Transport (Host-to-Host) and Internet (Network) layers, and groups Data Link and Physical into the Network Access (Link) layer.
3. Essential Network Protocols, Standard Ports & IP Addressing
Network communication relies on standardized communication rules (protocols) mapped to agreed-upon logical communication endpoints called Port Numbers (ranging from 0 to 65,535; ports 0-1023 are Well-Known Ports reserved by IANA):
Protocol Name Acronym Default Port Transport Protocol Primary Operational Role in Banking
Hypertext Transfer Protocol HTTP 80 TCP Unencrypted plaintext transfer of web hypermedia.
Hypertext Transfer Protocol Secure HTTPS 443 TCP Encrypted web browsing utilizing SSL/TLS; compulsory for all internet banking and mobile banking portals.
File Transfer Protocol FTP 20 (Data), 21 (Control) TCP Bulk transfer of files between client and server across networks.
Secure Shell SSH 22 TCP Encrypted remote terminal access and secure command execution on core bank servers.
Telnet - 23 TCP Legacy unencrypted plaintext remote terminal protocol (strictly prohibited in banking networks).
Simple Mail Transfer Protocol SMTP 25, 587 (TLS) TCP Pushes/transfers outgoing email messages from client to mail server and between mail transfer agents.
Post Office Protocol version 3 POP3 110, 995 (SSL) TCP Downloads incoming emails from server to local client storage, removing them from the server by default.
Internet Message Access Protocol IMAP 143, 993 (SSL) TCP Syncs incoming email across multiple client devices while permanently retaining messages on the mail server.
Domain Name System DNS 53 UDP (Queries) & TCP (Zone transfers) Translates human-readable domain hostnames (e.g., sbi.co.in ) into machine-routable numerical IP addresses.
Dynamic Host Configuration Protocol DHCP 67 (Server), 68 (Client) UDP Automatically leases dynamic IP configurations (IP address, subnet mask, default gateway, DNS) to client terminals.
IP Addressing: IPv4 vs. IPv6
IPv4 (Internet Protocol version 4): Utilizes a 32-bit binary address , written as four decimal integers (octets) separated by periods (e.g., 192.168.10.1 ), providing a maximum theoretical address space of 2 32 ≈ 4.29 × 10 9 2^{32} \approx 4.29 \times 10^9 2 32 ≈ 4.29 × 1 0 9 addresses.
Classes: Class A ( 1.0.0.0 - 126.255.255.255 ), Class B ( 128.0.0.0 - 191.255.255.255 ), Class C ( 192.0.0.0 - 223.255.255.255 ), Class D ( 224.0.0.0 - 239.255.255.255 reserved for Multicasting), Class E ( 240.0.0.0 - 255.255.255.255 reserved for experimental use).
Loopback Address: 127.0.0.1 is reserved for internal software diagnostics and localhost testing.
RFC 1918 Private Address Blocks: Non-routable on the public internet: 10.0.0.0/8 , 172.16.0.0/12 , and 192.168.0.0/16 .
IPv6 (Internet Protocol version 6): Developed to permanently resolve IPv4 address exhaustion. Utilizes a 128-bit binary address , expressed as eight groups of four hexadecimal digits separated by colons (e.g., 2001:0db8:85a3:0000:0000:8a2e:0370:7334 ), yielding 2 128 ≈ 3.4 × 10 38 2^{128} \approx 3.4 \times 10^{38} 2 128 ≈ 3.4 × 1 0 38 unique addresses. Supports zero compression (substituting a single contiguous sequence of zero-value blocks with :: exactly once per address).
4. Financial Cybersecurity & Threat Taxonomy
Protecting banking records and customer balances requires defensive countermeasures against diverse cyber threats: +----------------------------+
- | CYBERSECURITY ATTACKS |
- +--------------+-------------+
- |
- +--------------------+-----------------+--------------------+--------------------+
- | | | |
- v v v v
- +--------------+ +---------------+ +---------------+ +---------------+
- | MALWARE | | ENGINEERING | | NETWORK | | DATABASE |
- | Virus / Worm | | Phishing/Vish | | MitM / DoS | | SQL Injection |
- | Ransomware | | Smishing Fraud| | IP Spoofing | | Zero-Day Vuln |
- +--------------+ +---------------+ +---------------+ +---------------+
- Malware Typology
Computer Virus: Malicious code that attaches itself to a legitimate host executable file or document. It requires human action (such as executing an infected .exe or opening an infected macro document) to activate and propagate.
Computer Worm: Standalone, self-replicating malicious software that does not require a host file or human intervention. It spreads automatically across networks by exploiting unpatched OS vulnerabilities, consuming bandwidth and degrading network performance (e.g., WannaCry, Conficker).
Trojan Horse: Deceptive malware masquerading as legitimate, beneficial software (e.g., an unauthorized branch utility or calculator) that secretly creates a covert backdoor allowing remote attackers unauthorized access.
Ransomware: Sophisticated malware that uses strong encryption (e.g., AES-256) to lock a victim's files or system drives, displaying a ransom note demanding cryptocurrency payment in exchange for the decryption key.
Spyware & Keyloggers: Covert programs installed without consent that monitor user activity. Keyloggers record every physical keystroke on a keyboard, capturing login credentials, card numbers, and passwords.
Social Engineering & Network Attacks
Phishing, Vishing & Smishing: Fraudulent deception targeting banking customers. Phishing uses deceptive emails imitating the bank to lure users to spoofed websites. Vishing utilizes voice phone calls impersonating bank officials to extract CVV numbers and One-Time Passwords (OTPs). Smishing deploys fraudulent SMS texts containing malicious links.
Denial of Service (DoS) & Distributed DoS (DDoS): Cyberattacks designed to overwhelm a bank's web servers or payment gateways with a flood of illegitimate traffic generated by a distributed network of compromised computers ( botnet ), rendering online services unavailable to legitimate customers.
Man-in-the-Middle (MitM) Attack: An attacker intercepts and relays communications between two parties who believe they are communicating directly (e.g., between an internet banking client and the bank's web server). Prevented using end-to-end SSL/TLS encryption with verified digital certificates.
Spoofing: Masquerading as a trusted entity by forging network data headers (e.g., IP Address Spoofing, MAC Address Spoofing, or Email Address Header Spoofing).
Defensive Countermeasures & Cryptography
Firewalls: Hardware or software security barriers that inspect incoming and outgoing network traffic based on predefined security rules. Types include Packet Filtering Firewalls (inspects source/destination IP and ports), Stateful Inspection Firewalls (tracks active connection states), and Application-Layer / Proxy Firewalls .
Symmetric Encryption: Uses a single identical secret key for both encryption and decryption (e.g., AES - Advanced Encryption Standard, 3DES). Fast and computationally efficient, ideal for encrypting bulk transactional databases and ATM PIN blocks.
Asymmetric (Public Key) Encryption: Uses a mathematically linked key pair: a publicly distributed Public Key for encryption and a guarded Private Key for decryption (e.g., RSA, ECC). Forms the foundation of Digital Signatures , ensuring authenticity, data integrity, and non-repudiation in RTGS and NEFT high-value settlement messages.
5. Microsoft Office Essentials for Banking
Clerical staff in banks rely on Microsoft Office applications to prepare notices, analyze branch performance metrics, and track loan portfolios.
Microsoft Word in Branch Operations
Mail Merge: An essential feature that merges a standard form document (such as a loan overdue recovery notice or welcome letter) with a structured data source (an Excel spreadsheet or Access database of account holders). It automatically generates hundreds of personalized customer letters containing individualized names, addresses, account numbers, and overdue balances.
Track Changes & Templates: Enables administrative review and auditing of internal branch inspection reports.
Microsoft Excel: Cell Referencing & Key Formulas
Excel workbooks are organized into worksheets composed of rows (numbered 1, 2, 3... ) and columns (lettered A, B, C... ), intersecting at individual cells . CELL ADDRESSING MODES IN EXCEL:
- 1. Relative Reference: =A1 (Row and column shift when copied)
- 2. Absolute Reference: =$A$1 (Both column and row locked with $)
- 3. Mixed Reference: =$A1 or =A$1 (Only column locked OR only row locked)
Relative Referencing ( A1 ): Cell references adjust automatically relative to the destination cell when a formula is copied across rows or columns.
Absolute Referencing ( $A$1 ): The dollar sign ( $ ) locks the reference. Copying the formula to any other cell leaves the reference pointing to cell A1 . Toggled conveniently using the F4 key .
Mixed Referencing ( $A1 or A$1 ): Locks either the column alone ( $A1 ) or the row alone ( A$1 ).
High-Frequency Banking Excel Formulas
=SUM(number1, [number2], ...) : Computes the arithmetic total of a numeric cell range (e.g., =SUM(C2:C50) for total daily counter cash deposits).
=AVERAGE(range) : Returns the arithmetic mean of a selected numerical range.
=COUNT(range) vs. =COUNTA(range) : =COUNT counts only cells containing numeric data; =COUNTA counts all non-empty cells (including text, numbers, and logical values).
=IF(logical_test, value_if_true, value_if_false) : Evaluates a conditional test and returns one value if TRUE and another if FALSE (e.g., =IF(D2>=60, "Pass", "Review Required") ).
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) : Searches for a key value in the leftmost column of a table array and returns a value from the specified column in the same row. Exact matching requires FALSE (or 0 ) as the fourth parameter.
=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found]) : The modern successor to VLOOKUP; searches in any direction (left, right, vertical, horizontal) and defaults to an exact match without requiring numeric column index references.
=PMT(rate, nper, pv, [fv], [type]) : Financial function calculating the fixed periodic Equated Monthly Installment (EMI) for a loan based on constant interest rate and payment periods.
6. High-Frequency Keyboard Shortcuts
Mastering standard keyboard shortcuts is heavily tested in the Computer Aptitude segment:
Shortcut Combination Universal Function in Windows / MS Word / MS Excel
Ctrl + A Select All contents in the active document, window, or worksheet.
Ctrl + B / Ctrl + I / Ctrl + U Toggle Bold / Italic / Underline formatting on selected text.
Ctrl + C / Ctrl + X / Ctrl + V Copy / Cut / Paste selected text, cells, or objects.
Ctrl + D Fill Down active cell's formula/value in Excel; Open Font Dialog in Word.
Ctrl + E Center Align paragraph in Word; Flash Fill data down column in Excel.
Ctrl + F Open Find tool to search for text strings or cell values.
Ctrl + H Open Find and Replace dialog window.
Ctrl + K Insert a Hyperlink on selected text or object.
Ctrl + N Open a new blank document, presentation, or workbook.
Ctrl + P Open Print dialog window.
Ctrl + S Save the active document or file to disk.
Ctrl + Z / Ctrl + Y Undo last operational action / Redo previously undone action.
Ctrl + ; (Semicolon) Insert the current system Date into an active Excel cell.
Ctrl + Shift + : (Colon) Insert the current system Time into an active Excel cell.
F1 Open application Contextual Help documentation.
F2 Edit active cell contents in Excel; Rename selected file in Windows Explorer.
F4 Repeat last action in Word; Toggle relative/absolute/mixed reference ( $ ) in Excel formula bar.
F5 Open 'Go To' navigation dialog in Office; Refresh browser page in web browsers.
F7 Launch automated Spelling and Grammar check tool across the document.
F11 Create an immediate standalone Chart sheet from selected data in Excel.
F12 Open the 'Save As' dialog window to save with a new name or file format.