🇮🇳 IBPS SO · subject
IBPS SO Professional Knowledge - IT Officer (Scale I) Syllabus
The Professional Knowledge - IT Officer (Scale I) syllabus for IBPS SO in full: 5 chapters and 22 topics, every one listed below, plus 51 Professional Knowledge - IT Officer (Scale I) flashcards with answers.
Professional Knowledge - IT Officer (Scale I) syllabus: all 5 chapters
Expand any chapter to see its topics and sub-topics.
-
Database Management Systems
5 topics- Relational Model, Keys and Integrity Constraints
- Normalization (1NF to BCNF) and Functional Dependency
- SQL and Relational Algebra
- Transactions, ACID Properties and Concurrency Control
- Indexing, ER Model and Data Warehousing
-
Computer Networks
5 topics- OSI and TCP/IP Reference Models
- IP Addressing, Subnetting and Routing
- Protocols (HTTP, FTP, DNS, DHCP, TCP, UDP)
- Network Devices and Topologies
- Network Security, Firewalls and Cryptography
-
Operating Systems
4 topics- Process Management and Scheduling Algorithms
- Deadlocks, Synchronization and Semaphores
- Memory Management and Virtual Memory / Paging
- File Systems and Disk Scheduling
-
Programming and Data Structures
4 topics- Data Structures (arrays, linked lists, stacks, queues, trees, graphs)
- Algorithms, Sorting and Searching Complexity
- OOP Concepts and Programming Fundamentals
- Software Engineering and SDLC Models
-
Emerging Technologies and Web
4 topics- Cloud Computing and Virtualization
- Cyber Security and Information Security
- Big Data, AI/ML and IoT Basics
- Web Technologies and Digital Banking Systems
IBPS SO Professional Knowledge - IT Officer (Scale I) flashcards — 51 questions with answers
In the relational model, what is the difference between a candidate key, a primary key, and a foreign key?
A candidate key is any minimal set of attributes that uniquely identifies a tuple. A primary key is the one candidate key chosen to identify tuples (cannot be NULL). A foreign key is an attribute in one relation that references the primary key of another, enforcing referential integrity.
What are the three main integrity constraints in the relational model?
Entity integrity (primary key attributes cannot be NULL), referential integrity (a foreign key must match an existing primary key value or be NULL), and domain integrity (attribute values must come from their defined domain/data type).
Define a superkey and explain how it differs from a candidate key.
A superkey is any set of attributes that uniquely identifies a tuple. A candidate key is a minimal superkey (no proper subset is also a superkey). Every candidate key is a superkey, but not every superkey is a candidate key.
What is a functional dependency? Give the notation.
A functional dependency X to Y means that the value of attribute set X uniquely determines the value of attribute set Y; for any two tuples with the same X, the Y values must also be equal. Notation: X to Y (X functionally determines Y).
State the requirements for a relation to be in 1NF, 2NF, and 3NF.
1NF: all attribute values are atomic (no repeating groups/multivalued attributes). 2NF: in 1NF and no partial dependency (no non-prime attribute depends on part of a candidate key). 3NF: in 2NF and no transitive dependency (non-prime attributes depend only on candidate keys).
What is Boyce-Codd Normal Form (BCNF) and how is it stricter than 3NF?
A relation is in BCNF if for every non-trivial functional dependency X to Y, X is a superkey. It is stricter than 3NF because 3NF allows a determinant that is a prime attribute (part of a key), while BCNF requires every determinant to be a superkey.
List the basic operators of relational algebra.
Selection (sigma), Projection (pi), Union, Set difference, Cartesian product, and Rename. Additional derived operators include Intersection, Join, and Division.
What is the difference between the WHERE and HAVING clauses in SQL?
WHERE filters individual rows before grouping and cannot use aggregate functions. HAVING filters groups after GROUP BY aggregation and can use aggregate functions like COUNT, SUM, AVG.
Compare the SQL commands DELETE, TRUNCATE, and DROP.
DELETE (DML) removes rows based on a condition and can be rolled back. TRUNCATE (DDL) removes all rows quickly, cannot use WHERE, and resets the table. DROP (DDL) removes the entire table structure and data from the database.
What is the difference between INNER JOIN and LEFT OUTER JOIN in SQL?
INNER JOIN returns only rows with matching values in both tables. LEFT OUTER JOIN returns all rows from the left table plus matching rows from the right; unmatched right-side columns are filled with NULL.
What do the four ACID properties of a transaction stand for?
Atomicity (all operations complete or none do), Consistency (transactions move the database from one valid state to another), Isolation (concurrent transactions do not interfere), and Durability (committed changes persist even after a crash).
What are the three concurrency problems that isolation aims to prevent?
Dirty read (reading uncommitted data), non-repeatable read (re-reading a row returns different values due to another committed update), and phantom read (a re-executed query returns new rows inserted by another transaction).
What is two-phase locking (2PL) in concurrency control?
A protocol with a growing phase (the transaction acquires locks but releases none) and a shrinking phase (it releases locks but acquires none). 2PL guarantees conflict-serializable schedules.
What is a clustered index versus a non-clustered index?
A clustered index determines the physical storage order of rows, so a table can have only one. A non-clustered index is a separate structure with pointers to the data rows, and a table can have many.
In the ER model, what is the difference between a strong entity and a weak entity?
A strong entity has its own primary key and exists independently. A weak entity has no sufficient key of its own and depends on a strong (owner) entity, identified by a partial key combined with the owner's key; it is drawn with a double rectangle.
What distinguishes OLTP from OLAP systems in data warehousing?
OLTP (Online Transaction Processing) handles many short, frequent read/write transactions for daily operations. OLAP (Online Analytical Processing) handles complex analytical queries over large historical data for decision support; data warehouses are OLAP systems.
Name the seven layers of the OSI reference model in order.
Physical, Data Link, Network, Transport, Session, Presentation, Application (layers 1 to 7). Mnemonic: Please Do Not Throw Sausage Pizza Away.
How do the OSI and TCP/IP reference models differ in number of layers?
OSI has 7 layers. The TCP/IP model has 4 layers: Network Access (Link), Internet, Transport, and Application; the TCP/IP Application layer combines OSI's Application, Presentation, and Session layers.
What is the protocol data unit (PDU) name at the Transport, Network, and Data Link layers?
Transport layer PDU is a segment (TCP) or datagram (UDP), Network layer PDU is a packet, and Data Link layer PDU is a frame.
What are the IPv4 address ranges for Class A, B, and C networks?
Class A: 1.0.0.0 to 126.255.255.255 (default mask /8). Class B: 128.0.0.0 to 191.255.255.255 (/16). Class C: 192.0.0.0 to 223.255.255.255 (/24).
Show the other 31 Professional Knowledge - IT Officer (Scale I) flashcards
How many usable host addresses are in a /24 subnet, and what is the formula?
A /24 has 8 host bits, giving 2^8 = 256 total addresses and 256 - 2 = 254 usable hosts. The general formula is (2^h) - 2 usable hosts, where h is the number of host bits (subtracting network and broadcast addresses).
What are the private IPv4 address ranges defined by RFC 1918?
10.0.0.0 to 10.255.255.255 (/8), 172.16.0.0 to 172.31.255.255 (/12), and 192.168.0.0 to 192.168.255.255 (/16).
What is the difference between a routing protocol and a routed protocol, with examples?
A routed protocol carries user data and is routed across networks (e.g., IP). A routing protocol is used by routers to exchange path information and build routing tables (e.g., RIP, OSPF, BGP, EIGRP).
Compare TCP and UDP transport protocols.
TCP is connection-oriented, reliable, ordered, with flow/congestion control and error recovery (used for web, email, file transfer). UDP is connectionless, unreliable, faster, with no guaranteed delivery (used for streaming, DNS, VoIP).
What are the default port numbers for HTTP, HTTPS, FTP, DNS, and DHCP?
HTTP: 80, HTTPS: 443, FTP: 20 (data) and 21 (control), DNS: 53, DHCP: 67 (server) and 68 (client).
What is the purpose of DNS and DHCP?
DNS (Domain Name System) translates human-readable domain names into IP addresses. DHCP (Dynamic Host Configuration Protocol) automatically assigns IP addresses and network configuration (subnet mask, gateway, DNS) to hosts on a network.
What is the four-step DHCP address assignment process?
DORA: Discover (client broadcasts request), Offer (server offers an IP), Request (client requests the offered IP), Acknowledge (server confirms the lease).
At which OSI layers do a hub, a switch, and a router operate?
A hub operates at the Physical layer (Layer 1), a switch operates at the Data Link layer (Layer 2, using MAC addresses), and a router operates at the Network layer (Layer 3, using IP addresses).
Name common network topologies and a key property of the star topology.
Common topologies: bus, star, ring, mesh, tree, and hybrid. In a star topology all nodes connect to a central hub/switch; failure of one cable affects only one node, but failure of the central device brings down the whole network.
What is the difference between symmetric and asymmetric (public-key) cryptography?
Symmetric cryptography uses a single shared secret key for both encryption and decryption (e.g., AES, DES) and is fast. Asymmetric cryptography uses a public/private key pair (e.g., RSA), where one key encrypts and the other decrypts, solving key distribution but being slower.
What is the difference between a stateless (packet-filtering) firewall and a stateful firewall?
A stateless firewall inspects each packet independently against rules (source/destination IP, port). A stateful firewall tracks the state of active connections and allows return traffic for established sessions, providing more intelligent filtering.
What is the difference between symmetric encryption and hashing?
Symmetric encryption is reversible (data can be decrypted with the key) and provides confidentiality. Hashing is a one-way function producing a fixed-length digest (e.g., SHA-256), is irreversible, and is used for integrity verification, not confidentiality.
What are the typical states of a process in process management?
New, Ready, Running, Waiting (Blocked), and Terminated. A process moves between these states as it is created, scheduled, executes, waits for I/O, and finishes.
Compare FCFS, SJF, and Round Robin CPU scheduling algorithms.
FCFS executes processes in arrival order (non-preemptive, can cause convoy effect). SJF runs the shortest job next (minimizes average waiting time but can starve long jobs). Round Robin gives each process a fixed time quantum cyclically (preemptive, good for time-sharing).
What are the four necessary (Coffman) conditions for a deadlock?
Mutual exclusion, Hold and wait, No preemption, and Circular wait. All four must hold simultaneously for a deadlock to occur.
What is a semaphore, and what are the two types?
A semaphore is an integer variable used for process synchronization, accessed via wait (P) and signal (V) operations. A binary semaphore (mutex) takes values 0 or 1 for mutual exclusion; a counting semaphore can take any non-negative value to manage a set of identical resources.
What is the difference between a mutex and a semaphore?
A mutex is a locking mechanism that allows only one thread access and must be released by the same thread that acquired it (ownership). A semaphore is a signaling mechanism (a counter) that can allow multiple threads and can be signaled by any thread.
What is virtual memory and how does paging support it?
Virtual memory lets a process use an address space larger than physical RAM by keeping parts on disk. Paging divides logical memory into fixed-size pages and physical memory into frames; a page table maps pages to frames, and pages are swapped in/out on demand (demand paging).
What is a page fault, and name two page replacement algorithms.
A page fault occurs when a process accesses a page not currently in physical memory, requiring the OS to load it from disk. Page replacement algorithms include FIFO, LRU (Least Recently Used), and Optimal (replace the page not used for the longest future time).
What is Belady's anomaly?
Belady's anomaly is the phenomenon where increasing the number of page frames results in more page faults instead of fewer. It can occur with the FIFO page replacement algorithm but not with stack-based algorithms like LRU or Optimal.
Compare the disk scheduling algorithms FCFS, SSTF, and SCAN.
FCFS services requests in arrival order. SSTF (Shortest Seek Time First) services the request closest to the current head position (can cause starvation). SCAN (elevator) moves the head in one direction servicing requests, then reverses, giving more uniform wait times.
What is the difference between internal and external fragmentation?
Internal fragmentation is wasted space inside an allocated block (allocated memory larger than requested, common in paging). External fragmentation is free memory scattered in small non-contiguous blocks too small to satisfy requests (common in variable partitioning/segmentation).
Compare arrays and linked lists in terms of access and insertion.
Arrays allow O(1) random access by index but O(n) insertion/deletion (shifting elements) and have fixed/contiguous memory. Linked lists allow O(1) insertion/deletion at a known node but O(n) sequential access, with dynamic, non-contiguous memory.
What is the difference between a stack and a queue?
A stack is a LIFO (Last In First Out) structure with push/pop at one end. A queue is a FIFO (First In First Out) structure with enqueue at the rear and dequeue at the front.
What is the difference between a binary tree and a binary search tree (BST)?
A binary tree is any tree where each node has at most two children. A BST is an ordered binary tree where, for every node, all left-subtree values are smaller and all right-subtree values are larger, enabling O(log n) average search.
State the average and worst-case time complexities of QuickSort and MergeSort.
QuickSort: average O(n log n), worst case O(n^2) (already sorted/poor pivot). MergeSort: O(n log n) in all cases (best, average, worst) but needs O(n) extra space.
What is the time complexity of binary search and what is its prerequisite?
Binary search has O(log n) time complexity. Its prerequisite is that the array/list must be sorted, since it repeatedly halves the search interval by comparing with the middle element.
Name and define the four core principles of Object-Oriented Programming.
Encapsulation (bundling data and methods, hiding internal state), Abstraction (exposing only essential features), Inheritance (a class deriving properties from another), and Polymorphism (one interface, many forms, e.g., method overloading/overriding).
What is the difference between compile-time and run-time polymorphism?
Compile-time (static) polymorphism is resolved during compilation via method overloading or operator overloading. Run-time (dynamic) polymorphism is resolved during execution via method overriding using inheritance and virtual functions/dynamic dispatch.
List the main phases of the SDLC and compare the Waterfall and Agile models.
SDLC phases: requirement analysis, design, implementation/coding, testing, deployment, maintenance. Waterfall is sequential and rigid with phases completed before the next begins. Agile is iterative and incremental, delivering working software in short sprints with continuous feedback.
In cloud computing, what do IaaS, PaaS, and SaaS provide? Give the difference between a hypervisor's Type 1 and Type 2.
IaaS provides virtualized hardware (servers, storage); PaaS provides a development platform/runtime; SaaS provides ready-to-use applications over the internet. A Type 1 (bare-metal) hypervisor runs directly on hardware; a Type 2 (hosted) hypervisor runs on top of a host operating system.
IBPS SO Professional Knowledge - IT Officer (Scale I) FAQ
What is in the IBPS SO Professional Knowledge - IT Officer (Scale I) syllabus?
IBPS SO Professional Knowledge - IT Officer (Scale I) is split into 5 chapters: Database Management Systems, Computer Networks, Operating Systems, Programming and Data Structures and Emerging Technologies and Web. Together they contain 22 topics.
How many chapters are in IBPS SO Professional Knowledge - IT Officer (Scale I)?
5 chapters, containing 22 topics. The largest chapter is Database Management Systems, with 5 topics.
Are there flashcards for IBPS SO Professional Knowledge - IT Officer (Scale I)?
Yes — a 51-card Professional Knowledge - IT Officer (Scale I) deck, printed in full in the flashcards section of this page and available in the Examius app with spaced repetition. The free plan covers one exam of your choice, including its flashcards; Examius Pro, a one-time purchase, unlocks every other exam and deck.