SBI SO Syllabus:
One of the largest public sector banks of India, State Bank of India also provides employment opportunities in its branches all over the country. These include Probationary Officers, Specialist officers, and clerks. SBI holds an entrance exam once a year for PO and twice a year for clerical posts. The vacancies for SO are announced on a requirement basis for posts like the Chief Technology Officer and Deputy General Manager (E&TA) on either a regular and contract basis.
SBI has come out with a notification for vacancies of SO, i.e. 1 for the post of Chief Technology Manager and Deputy General Manager each. The entrance exam syllabus for SBI SO is as follows:
Basic Database concepts:
- Database Management System
- File-Based Data Management – Disadvantages of file system
- Database systems – Need for Database, Advantages of using a database
- Characteristics of data in a database are Functions of DBMS, Components of a database, Comparison between Database and file-processing systems.
- Data dictionary – Data Abstraction, Data independence – Logical and Physical data independence
Architecture: Overall Architecture of DBMS.
- Three-level architecture
- Data Models: Hierarchical, Networking.
- Relational Data Models – E-R Model – E-R Diagrams – EER Model – Advantages and Disadvantages of each model
- Introduction to Data Warehousing and Data Mining – Different types
- Client/Server Technology: Client-Server – Distributed and Cooperative Processing
- Peer- to – Peer processing, Application components, Transaction management.
Relational Database Model
- Relational Structure – Characteristics of the Relational Database Model – CODD’s rules
- Tables (Relations), Rows (Tuples), Domains, Attributes, Extension, Intention.
- Keys: Candidate Key, Primary Key, Foreign Key, Super Keys, Unique Keys.
- Data Constraints: Referential Integrity Constraints, Entity Integrity Constraints,
- Constraints like a Primary key constraint, Unique, Check constraint strong Entity, Weak Entity.
- Normalization: Introduction – Purpose of Normalisation
- Definition of Functional Dependency (FD) Relational Database Design, – Normal forms: 1NF, 2NF, 3NF, BCNF, 4Nf and 5 NF.
- Database Administration: DBA Tasks, DBA Tools, User Privileges, Performance monitoring and tuning, Query tracing, Backup, and Recovery.
Introduction to SQL
- Advantages of SQL – Invoking SQL*PLUS, The Oracle Data Types, Data Definition Language (DDL), Data Manipulation Language (DML)
- Data Control Language (DCL), Data Query Language (DQL) and all related commands.
- Queries using Group by and Order by clause & Join: Querying a Single Table, Ordering results, Grouping the results, Joins, Types of Joins, Subqueries.
- Operators: Logical, Value, Syntax and Query expression operators – Set operators.
- Functions: Character, Arithmetic, Date and time, Group and Miscellaneous Functions, Commit, Rollback, Savepoint.
- Format models: Character, Numeric & Date Format Models.
Advantages of views
- Views: Introduction – Advantages of views – The Create View Command, Updating Views, Views, and Joins, Views and Subqueries – Dropping Views.
- Sequences: Creating Sequences, Altering Sequences, Dropping Sequences.
- Index Types, Creating an Index: Simple Unique and Composite Index, Dropping Indexes.
- Snapshots: Creating a Snapshot, Altering Snapshot, Dropping a Snapshot.
- Introduction to PL/SQL: The PL/SQL Syntax, The PL/SQL Block Structure, Fundamentals of PL/SQL, Advantages of PL/SQL data types.
- Control Structure: Conditional Control, Iterative Control, Sequential Control.
- Exception handling: Predefined Exception – User-defined Exception.
- Cursors: Implicit and Explicit Cursors.
- Procedures: Advantages – Creating – Executing and Deleting a Stored Procedure.
- Functions: Advantages – Creating – Executing and Deleting a Function.
- Database Triggers: Use of Database Triggers – How to apply database Triggers – Types of Triggers – Syntax for Creating Trigger – Deleting Trigger.
Data communication and Networking
This is the most important topic and the maximum number of questions are asked from this topic.
- Data Communication: Components of a data communication
- Data flow simplex – half duplex – full-duplex; Networks – Definition – Network criteria –
- Types of Connections: Point to point-multipoint; Topologies: Star, Bus, Ring, Mesh, Hybrid – Advantages and Disadvantages of each topology.
- Types of Networks: LAN – MAN – WAN – CAN – HAN – Internet – Intranet –Extranet, Client-Server, Peer To Peer Networks.
- Transmission Media: Classification of transmission media – Guided – Twisted Pair, Coaxial, Fibre optics; Unguided – Radio waves – Infrared – LOS – VSAT – cabling and standards.
- Network devices: Features and concepts of Switches – Routers (Wired and Wireless) – Gateways.
- Network Models: Protocol definition – standards – OSI Model – layered architecture – functions of all layers.
- Data Link Layer: Framing & its methods, Flow Control, Error control. DLL Protocol, Piggybacking & Pipelining. MAC Sublayer, Media access control for LAN & WAN, collision, IEEE 802 standards for LAN & MAN & their comparison. Ethernet, Wireless LANs, Broadband Wireless, Bluetooth.
- Network Layer: Routeing, Congestion Control Algorithms, IP protocol, IP Addresses, Comparative study of IPv4 & IPv6, Mobile IP.
- Transmission Control Protocol (TCP) – User Datagram Protocol, Data Traffic, Congestion Control and Quality of Service.
- Network Security: Cryptography, Message Security, Digital Signature, User Authentication, Key Management, Security Protocols Internet, DNS, SMTP, FTP, HTTP, WWW, Virtual Terminal Protocol.
This is an important topic as well for SBI SO.
- Introduction to System Programs & Operating Systems, Buffering & Spooling, Types of Operating System.
- File concepts, access methods, free space management, allocation methods, directory systems, protection, organization, real-time sharing & implementation issues.
- Process: Concept, Process Control Blocks (PCB), Scheduling criteria Preemptive & Non-Preemptive process scheduling, Scheduling algorithms, algorithm evaluation, multiple processors real-time scheduling, threads, critical section problem, semaphores, and classical problems of synchronization.
- Memory Hierarchy, logical and physical address space, swapping, contiguous and non-contiguous allocation, paging, segmentation, Concepts of virtual memory, Cache Memory Organization, demand paging, page replacement algorithms, allocation of frames, thrashing, demand segmentation.
- Distributed operating system:-Types, Design issues, File system, Remote file access, RPC, RMI, Distributed Shared Memory(DSM), Basic Concept of Parallel Processing & Concurrent Programming.
- Security & threats protection: Security violation through Parameter, Computer Worms & Virus, Security Design Principle, Authentications, Protection Mechanisms.
- The Software Product and Software Process Models, Software Process customization and improvement.
- Requirement Elicitation, Analysis, and Specification Functional and Non-functional Requirements, Validation, Traceability.
- Software Design, Architectural Design, User Interface Design, Function-oriented Design, SA/SD Component Based Design, Design Metrics.
- Software Analysis and Testing, Software Test Process, Testing Levels, Test Criteria, Test Case Design, Test Oracles, Test Techniques, Black-Box Testing.
- Software Maintenance & Software Project Measurement: Software Configuration Management (SCM), Re-engineering, Reverse Engineering. Project Management Concepts, Feasibility Analysis, Project and Process Planning, Resources Project Scheduling and Tracking,
- Introduction to Compiler, Phases and passes, Bootstrapping, Implementation of lexical analyzers, LEX: lexical analyzer generator, Input buffering, Recognition of tokens, Error handling.
- Basic Parsing Techniques: Parsers, Shift-reduce parsing, operator precedence parsing, top-down parsing, predictive parsers, LR parsers, an automatic parser generator
- Syntax directed definitions, L-attributed definitions, Syntax directed Translators, Intermediate code.
- Symbol Tables, Run-Time Administration, simple stack allocation scheme, storage allocation in a block-structured language, Code Optimization and Code Generation.
- Parsing control statements, syntax diagrams, Error Recovery, Interpreting control statements, parsing programs, procedures and Functions.
- Basic Terminology, Data types, and its classification, Array Definition, Representation and Analysis of Arrays, Single and Multidimensional Arrays.
- Stack, Array Implementation of the stack, Linked Representation of Stack, Queue, Array and linked implementation of queues, Circular queues, D-queues and Priority Queues. Linked list, Generalised linked list
- Basic terminology, Binary Trees, Complete Binary Tree, Extended Binary Trees, Array and Linked Representation of Binary trees.
- Internal and External sorting, Insertion Sort, Bubble Sort, Selection Sort Quick Sort, Merge Sort, Heap Sort, Radix sort, Searching & Hashing: Sequential search, binary search, Hash Table, Hash Functions.
- Introduction, Sequential Representations of Graphs, Adjacency Matrices, Traversal, Connected Component and Spanning Trees, Minimum Cost Spanning Trees.
Computer Organisation and Microprocessor
- Computer System: Basic Computer Operation, Machine Instructions, Addressing Modes, DLX Architecture.
- Computer Configuration, Memory, Organization, Memory Architecture, and Interface, DMA, Synchronization.
- Microprocessor As A CPU– types of Microprocessor, Microcomputers, Computer Languages, Flags, Program Counter(PC), Stack Pointer, OP Code Format.
Object-Oriented Programming (OOPS)
- General concept OOPS– Object, Classes, Data Abstraction, Encapsulation, Inheritance, Polymorphism, Methods and Messages, Dynamic Binding.
- Features, Advantages, and Applications of OOPS.
- Aggregation and Association, Generalization, Multiple Inheritance.
The entrance exam includes a test of reasoning, English language test, quantitative aptitude, and professional knowledge. The SBI SO syllabus is vast and the knowledge has to be expansive.