SBI/IBPS/RRB SO 2020 Eligibility

 

Eligibility for SBI SO Assistant Manager (System)

1. Age:
Minimum: 21 years

Maximum: 30 years
Age Relaxation: (add +3 yrs for OBC, +5yrs for SC/ST, +10yrs for PWD{Gen}, +13yrs for PWD{OBC}, +15yrs for PWD{SC/ST})

2. Educational Qualifications:

The candidate should have completed either one or all of the following along with any one/multiple of the courses mentioned below:

a) B.E. / B. Tech. in Computer Science / Computer Applications / Information Technology / Electronics/
Electronics & Telecommunications / Electronics & Communications / Electronics & Instrumentations
OR
b) M. Sc. in Electronics / Electronics & Telecommunications / Electronics & Communications/ Electronics & Instrumentation / Computer Science / Information Technology / Computer Applications
OR
c) MCA from Government recognized University or institution

Pattern for SBI Specialist Assistant Manager (System). 

The pattern for SBI Specialist Assistant Manager (System) is as follows:

Paper I: Qualifying in nature

Paper II: Merit paper 

 

Syllabus for SBI Specialist Assistant Manager (System). 

A) Data Base Management System (DBMS)

a) Introduction
b) RDBMS

i. Entity Relationship Model
ii. Relational Model

c) Normalization
d) Overview of SQL queries
e) E-R Diagrams
f) Transaction Management

B) Data Communication & Networking

a) Network Architecture
b) OSI Model
c) Transmission Control Protocol
d) Internet Protocol
e) Data Communication
f) IP Addressing and Subnetting

C) Operating System

a) Process in OS
b) Thread
c) Types of OS
d) Semaphore
e) Scheduling
f) Dead Lock
g) Memory Partitioning
h) Page Replacement

D) Computer organization + Hardware (Microprocessor)

a) Bus Structure

E) Network Security

a)Cryptography and System Security
b) Cyber Crimes
c) Risk Management
d) Firewall
F) Software Engineering
a) Basics of Software Engineering
b) Software Development Life Cycle (SDLC)
c) Software Development Models

G) Data Structures
a)Basics of Data Structures
b) Array
c) Linked List
d) Stacks

H) Web Technologies
a) HTML Tags
b) XML

I) Programming Languages (BASIC)

a) C: Complete course on C (programming language)
b) OOP (Object Oriented Programming)

And, lastly, as we know that this is the same syllabus for IBPS SO IT Officer. Well the similarity ends there. Prepare hard for SBI SO. All the best.

 

IBPS SO Professional Knowledge Syllabus:

1. Data Base Management Systems (DBMS) –15 to 20 Questions.

DBMS (Data Base Management System) is the technology which is responsible for capturing and analyzing data and retrieving them with appropriate security measures. DBMS is the most important section and carries the highest marks. 15-20 questions can be expected from this topic, mostly concentrating on the following sub topics.

a) RDBMS (Relational Algebra)

b) E- R diagrams (Concepts of Entity, Attribute, and Relationship etc.)

c) Normalization (Concepts of 1NF, 2NF, 3NF and BCNF)

d) Transaction Management

e) Overview of SQL Queries

f) Relational Database Model

g) Data Constraints

h) Database Administration

i) Sequences and Indexes

j) Implicit and Explicit cursors

k) Database triggers

l) Control Structure

m) Keys

n) Data directory

2. Data Communication and Networking– 10 to 15 Questions

Data Communication is the exchange of digital data between two or more computers. Computer Network is a set of interconnected computers and peripherals (printers, webcams etc.). The following sub topics are important for the exam:-

a) Network Architecture: – It is the basic layout design of the communication network and includes the entire component (hardware, software, mode of connectivity etc.)

b) Types of Networks

c) OSI Model (Open Systems Interconnection Model)

d) Network Devices and Models

e) TCP- IP Model (Transmission Control Protocol and Internet Protocol Model)

f) IP Addressing

g) Network Security

3. Operating System: –4 to 5 Questions

Operating System is the software needed to support the basic functions of a computer. The important sub topics for the exam are:-

a) Types of OS

b) File concepts, Access methods

b) Semaphore

c) Page Replacement

e) Distributed Operating System

d) Memory Partitioning

e) Scheduling

f) Process

g) Thread

i) Security and Threats protection

4. Computer Organization + Hardware: – 4 to 5 Questions

 

5. Network Security: – 2 to 3 questions

All steps and policies undertaken to prevent the networking infrastructure from unauthorized access, misuse, malfunction, modification, and destruction come under ‘Network Security’. Important sub topics are:-

a) Cyber Crimes

b) Risk Management

c) Firewall

d) Cryptography

 

6. Software Engineering: – 2 to 3 Questions

a) SDLC (Software Development Life Cycle)

b) Software Configuration Management (SCM)

b) Software Development Models

c) Requirement Elicitation

d) Software Design and Maintenance

7. Data Structure: – 3 to 4 Questions

a) Stacks

b) Linked Tests

c) Array

d) Sorting: Internal and External

e) Graphs

8. Web Technologies: –1 to 2 Questions

This is of slightly lesser importance. You are expected to know HTML, XML etc.

9. Programming Languages (Basic):- 1 to 2 Questions

You are expected to know OOP (Objected Oriented Programming), C, C++ etc.

Please note that the list is not exhaustive and it is based on the trends of past year papers. You may encounter significant variations in the actual exam.

It is important that you strategize your IBPS SO 2016-17 Exam preparation well in advance. Knowing and analyzing the previous years’ cut off marks will help you strategize it better

 

 

Exam Pattern of IT Officer 2016 Exam (IBPS SO )

S. No.	Sections	Maximum Marks	No. of Questions	Time
1.	Test of Reasoning	50	50	2 hours
2.	English Language	35	25
3.	Quantitative Aptitude	35	50
4.	Professional Knowledge	50	75
Total		120	200	2 hours

Detailed Syllabus for IT Officer 2016 Exam

DATABASE MANAGEMENT SYSTEM ( Most Important and Max question)

Unit 1 – Basic Database concepts:

(i) Database Management System

(ii) File Based Data Management – Disadvantages of file system

(iii) Database systems – Need for Database, Advantages of using a database

(iv) Characteristics of data in a database – Functions of DBMS, Components of a database, Comparison between Database and file-processing systems

(v) Data dictionary – Data abstraction, Data independence – Logical and Physical data independence

(vi) 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

(vii) Advanced Concepts: Introduction to Data warehousing and Data mining – Different types

(viii) Client/Server Technology: Client – Server – Distributed and Co-operative processing – Peer- to – Peer processing – Application components – Transaction management.

Unit – 2

(i) Relational Structure – Characteristics of Relational Database Model – CODD’s rules – Tables (Relations), Rows (Tuples), Domains, Attributes, Extension, Intention.

(ii) Keys: Candidate Key, Primary Key, Foreign Key, Super Keys, Unique Keys.

(iii) Data Constraints: Referential Integrity Constraints, Entity Integrity Constraints, Constraints like Primary key constraint, Unique, Check constraint strong Entity, Weak Entity.

(iv) Normalization: Introduction – Purpose of Normalization – Definition of Functional Dependence ( FD) Relational database Design, – Normal forms: 1NF, 2NF, 3NF, BCNF, 4Nf and 5 NF.

(v) Database Administration : DBA Tasks – DBA Tools – User Privileges – Performance monitoring and tuning – Query tracing – Backup and Recovery

Unit – 3

(i) 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.

(ii) Queries using Group by and Order by clause & Join: Querying a Single Table, Ordering results, Grouping the results, Joins, Types of Joins, Sub queries.

(iii) Operators: Logical, Value, Syntax and Query expression operators – Set operators.

(iv) Functions: Character, Arithmetic, Date and time, Group and Miscellaneous Functions, Commit, Rollback, Savepoint.

(v) Format models: Character, Numeric & Date Format models.

Unit – 4

(i) Views: Introduction – Advantages of views – The Create View Command, Updating Views, Views and Joins, Views and Sub queries – Dropping Views.

(ii) Sequences: Creating Sequences, Altering Sequences, Dropping Sequences.

(iii) Indexes: Index Types, Creating of an Index: Simple Unique and Composite Index, Dropping Indexes.

(iv) Snapshots: Creating a Snapshot, Altering Snapshot, Dropping a Snapshot.

(v) Introduction to PL/SQL: The PL/SQL Syntax, The PL/SQL Block Structure, Fundamentals of PL/SQL, Advantages of PL/SQL data Types.

(vi) Control Structure: Conditional Control, Iterative Control, Sequential Control.

Unit – 5

(i) Exception handling: Predefined Exception – User defined Exception.

(ii) Cursors: Implicit and Explicit Cursors

(iii) Procedures: Advantages – Creating – Executing and Deleting a Stored Procedure.

(iv) Functions: Advantages – Creating – Executing and Deleting a Function.

(v) Database Triggers: Use of Database Triggers – How to apply database Triggers – Types of Triggers – Syntax for Creating Trigger – Deleting Trigger.

DATA COMMUNICATION AND NETWORKING

(i) 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.

(ii) Types of Networks: LAN – MAN – WAN – CAN – HAN – Internet – Intranet –Extranet, Client-Server, Peer To Peer Networks.

(iii)Transmission Media : Classification of transmission media – Guided – Twisted pair, Coaxial, Fiber optics; Unguided – Radio waves – Infrared – LOS – VSAT – cabling and standards

(iv) Network devices: Features and concepts of Switches – Routers(Wired and Wireless) – Gateways.

(v) Network Models: Protocol definition – standards – OSI Model – layered architecture – functions of all layers..

(vi) Data Link Layer: Framing & its methods, Flow Control, Error control. DLL Protocol, Piggybacking & Pipelining. MAC Sub layer, Media access control for LAN & WAN, collision, IEEE 802 standards for LAN & MAN & their comparison. Ethernet, Wireless LANs, Broadband Wireless, Bluetooth.

(vii) Network Layer: Routing, Congestion Control Algorithms, IP protocol, IP Addresses, Comparative study of IPv4 & IPv6, Mobile IP.

(viii) Transmission Control Protocol (TCP) – User Datagram Protocol, Data Traffic, Congestion Control and Quality of Service

(ix) Network Security: Cryptography, Message Security, Digital Signature, User Authentication, Key Management, Security Protocols Internet,DNS,SMTP, FTP, HTTP, WWW, Virtual Terminal Protocol.

OPERATING SYSTEM

(i) Introduction to System Programs & Operating Systems, Buffering & Spooling, Types of Operating System.

(ii) File concepts, access methods, free space managements, allocation methods, directory systems, protection, organization ,sharing & implementation issues, etc.

(iii) Process: Concept, Process Control Blocks (PCB), Scheduling criteria Preemptive & non Preemptive process scheduling, Scheduling algorithms, algorithm evaluation, multiple processor scheduling, real time scheduling, threads, critical section problem, semaphores, and classical problems of synchronization, etc.

(iv) 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.

(v) Distributed operating system:-Types, Design issues, File system, Remote file access, RPC, RMI, Distributed Shared Memory(DSM), Basic Concept of Parallel Processing & Concurrent Programming

(vi) Security & threats protection: Security violation through Parameter, Computer Worms & Virus, Security Design Principle, Authentications, Protection Mechanisms.

SOFTWARE ENGINEERING

(i) The Software Product and Software Process Models, Software Process customization and improvement.

(ii) Requirement Elicitation, Analysis, and Specification Functional and Non-functional requirements, Validation, Trace ability.

(iii) Software Design, Architectural Design, User Interface Design, Function-oriented Design, SA/SD Component Based Design, Design Metrics.

(iv) Software Analysis and Testing, Software Test Process, Testing Levels, Test Criteria, Test Case Design, Test Oracles, Test Techniques, Black-Box Testing, etc.

(v) Software Maintenance & Software Project Measurement: Software Configuration Management (SCM), Re-engineering, Reverse Engineering. Project Management Concepts, Feasilibility Analysis, Project and Process Planning, Resources Project Scheduling and Tracking, etc.

DATA STRUCTURE

(i) Introduction: Basic Terminology, Data types and its classification, Array Definition, Representation and Analysis of Arrays, Single and Multidimensional Arrays, etc.

(ii) Stack, Array Implementation of stack, Linked Representation of Stack, Queue, Array and linked implementation of queues, Circular queues, D-queues and Priority Queues. Linked list, Generalized linked list.

(iii) Trees: Basic terminology, Binary Trees, Complete Binary Tree, Extended Binary Trees, Array and Linked Representation of Binary trees, etc.

(iv) 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, etc.

(v) Graphs: Introduction, Sequential Representations of Graphs, Adjacency Matrices, Traversal, Connected Component and Spanning Trees, Minimum Cost Spanning Trees.

COMPILER DESIGN

(i) Introduction to Compiler, Phases and passes, Bootstrapping, Implementation of lexical analyzers, LEX: lexical analyzer generator, Input buffering, Recognition of tokens, Error handling.

(ii) Basic Parsing Techniques: Parsers, Shift reduce parsing, operator precedence parsing, top down parsing, predictive parsers, LR parsers , an automatic parser generator

(iii) Syntax directed definitions, L-attributed definitions, Syntax directed Translators, Intermediate code, etc.

(iv) Symbol Tables, Run-Time Administration, simple stack allocation scheme, storage allocation in block structured language, Code Optimization and Code Generation

(v) Parsing control statements, syntax diagrams, Error Recovery, Interpreting control statements, parsing programs, procedures and Functions.

COMPUTER ORGANIZATION AND MICROPROCESSOR

(i) Computer System: Basic Computer Operation, Machine Instructions, Addressing Modes, DLX Architecture,

(ii) Computer Configuration, Memory organization, Memory Architecture and Interface, DMA, Synchronization, etc.

(iii) Microprocessor As A CPU– types of Microprocessor, Microcomputers, Computer Languages, Flags, Program Counter(PC), Stack Pointer, OPCode Format, etc.

(iv) Input-output System.

 OBJECT ORIENTED PROGRAMMING(OOPS)

(i) General concept OOPS– Object, Classes, Data Abstraction, Encapsulation, Inheritance, Polymorphism, Methods and Messages, Dynamic Binding.

(ii) Features, Advantages and Applications of OOPS

(iii) Aggregation and Association, Generalization, Multiple Inheritance