SBI Specialist Officer Professional Knowledge Study Material

I want the Study Materials of Professional Knowledge of State bank of India SBI Specialist Officer exam so can you provide me?

[pawan]

I am providing you the Study Materials of Professional Knowledge of State bank of India SBI Specialist Officer exam

SBI Specialist Officer exam Professional Knowledge Study Materials

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.

Books-

Data Structures using C and C++, Tannenbaum, 2nd edition 1995

W. Stallings, Computer Organization and Architecture Designing for Performance 8th Edition 2009, Prentice Hall of India.

Ramakrishanan, J. Gehrke, Database Management Systems 3rd Edition, McGraw-Hill 2002.

A.S. Tanenbaum, Modern Operating Systems, 3rd Edition, Pearson Education 2007.

B. A. Forouzan: Data Communications and Networking, Fourth edition, THM Publishing Company Ltd 2007.

E. Balaguruswamy, Object Oriented Programming with C++ , 4th Edition, Tata McGraw Hill 1997.