IBPS Specialist Officers CWE SPL - 3: I.T. Officer Online Exam Practice Work Book

    Essentials of Bank Computerisation, Computer : Introduction, Classification of Computers, Important Developments in the Field of Computer, The Supercomputers, e-world, Computer Abbreviations, Computer Terminology, Software Handsbanking, Software, History of Computer, Early Electronic Computers, Computer Generations, Characteristics of Computer, Microsoft Windows, Computer Networks, Data Structures, Payment System and Electronic Banking, Role of Technology, Upgradation and its impact on Banks, Information Technology Act, 2000, Electrnoic Governance IT-07 IT-66 l Objective Questions IT-67 IT-752. Computer Architecture and Origination
    Von Neumann Model, Bus, Data Format, I/O System, Program Execution and Instruction, Microprogrammed Control Unit, Operand (Data) Types and Formats, Instruction Set, Instruction Types, Instruction Format, Addressing Modes, RISC Versus CISC, Memory Hierarchy, Cache Memory and Cache Memory Organisation, Main Memory, Associative Memory, Virtual Memory, Read Only Memory (ROM) and Random Access Memory (RAM), Memory Address Mapping, Common I/O Devices, Interrupt Driven I/O, I/O Devices and Interfaces, Direct Memory Access (DMA), IOP Organisation, General Pipeline, Instruction and Arithmetic Pipeline, Register Forwarding, Branch Handling IT-76 IT-953. Data Structure

    Introduction to Data Structure, The Need for Data Structure, Characteristics of Data Structure, Arrays, Vectors, Lists, String, Recursion, Expression, pointer, Stack, Stack Operations, Stack Implementation, Queue, Queue Operation, Applications of Queue, Queue Implementation, types of queue, Differences between Stack and Queue, Linked List, Advantages and Disadvantages of Linked List, Operations on Linked List, Types of Linked List, Tree, Binary Tree, Binary Tree Representation, Operations on Binary Tree, Traversing Binary Tree Recursively, Types of Tree, Graph, Representation of Graph, Operations on Graph, Methods of graph traversing (Breadth First Search (BFS), Depth First Search (DFS)), Minimum spanning tree, Shortest Path, Searching techniques, Hashing, Hash Function, Hash Collision, Sorting, (Bubble Sort, Selection Sort, Insertion Sort, Shell Sort, Merge Sort, Quick Sort, Heap Sort) IT-96 IT-1094. Data Communication and Networking
    Transmission (Serial Transmission, Parallel Transmission), Synchronous transmission, Asynchronous transmission, Simplex, Half-duplex, Full-duplex, Front-end processor, Line splitter, Multiplexing (Frequency- division multiplexing (FDM), Wave-division multiplexing (WDM), Time-division multiplexing (TDM), Inverse Multiplexing), OSI Model, Poll and select, Automatic repeat request (ARQ), Interfacing (EIA RS-232 DTE/DCE interface, EIA RS-232-D DTE/DCE interface, EIA RS-232-C DTE/DCE interface, RS-449 (RS-422-A and RS-423-A) interface), Modulation(Amplitude modulation (AM), Frequency modulation (FM), Phase modulation (PM)), Modem (Quick-Pak, Microcom Network Protocol (MNP) Error Controller, Bell modems), Types of Modems, Parity bit, Parity Check, Simple Parity Check, Cyclic redundancy check (CRC), Check sum, Hamming code, Error-control techniques, Switches, Circuit switching, Packet Switching, Frame Relay, Local Area Networks, Metropolitan Area Networks, Wide Area Networks, Ethernet (Token bus, Token Ring), Repeater, Router, Gateway, Bridge, Hubs IT-110 IT-1295. Networking Security
    Conventional Encryption, Data Encryption Standard (DES), Cryptanalysis (Block Cipher, P Box), Private-key and Public-key cryptography, Diffie and Hellman, RivestShamirAdleman method (RSA), Intruders, IP Security, Web Security, Firewalls, Virus IT-130 IT-1446. Operating System
    Operating System, Multiprogramming, Storage Structure, Time Sharing System, Operating-System Services, System Calls, Multiprocessor Operating Systems, CPU Scheduling, Scheduling Criteria, Scheduling Algorithms, Multiple-Processor Scheduling, Real-Time CPU Scheduling, Process Scheduling, Operations on Processes, Interprocess Communication, Thread, Critical-Section Problem, Semaphores, Classical Problems of Synchronization, Deadlock Characterisation, Methods for Deadlock Handling, Deadlock Prevention, Deadlock Avoidance, Deadlock Detection, Recovery from Deadlock, Logical Versus Physical Address Space, Swapping, Contiguous Memory Allocation, Paging, Segmentation, File Concepts, File AccessIT-145 IT-1707. Digital Circuits and System
    Boolean Algebra (Switching Algebra) and Boolean Functions, Binary System Arithmetic, Venn Diagrams, Karnaugh Maps, QuineMcCluskey Procedure, Adders, Decoder and Encoder, Multiplexers and Demultiplexer IT-171 IT-1808. Microprocessor, 8085 IT-181 IT-183
    9. Introduction to DBMS
    What is Database ?, What is Database Management System?, Why DBMS, Three level architecture for a DBMS, Entity, Data Models, RDBMS, Keys, Primary key, Entity Relationship - E-R Modelling, Structured Query Language (SQL), Data Definition Language (DDL), Data Manipulation Language (DML), Data Control Language (DCL) IT-184 IT-19210. Data Mining
    Data mining, Transaction (OLTP), On line Analytical Processing (OLAP) IT-193 IT-19611. Software Engineering
    Software Engineering, Project Planning, Project anagement Concept, Project Planning Objectives, System Engineering, System Engineering Program Testing (Black Box Testing, White Box Testing and Verification and Validation) IT-197 IT-20012. Secutiry and Service Level Management
    Security Controls and Guidelines, Information System Security Measures, Basel Committee Principles, Service Level Management, Change Management and Monitoring IT-201 IT-20513. Introduction to Programming Language C
    Definition of C, Use of C in Operating System, Applicaitons of C, Steps in Language, Types of C Constants, Data Types, Rules for Constructing Integer Constants, Instructions in C, The Decision Control Structure in C, The Loop Control Structure, Array, String, Functions, Pointer, Structure, Union IT-206 IT-219 I Objective Questions IT-220 IT-221

    TABLE OF CONTENTS

    Model Practice Set


    Set - 01 : Model Practice Set IT
    Set - 02 : Model Practice Set IT
    Set - 03 : Model Practice Set IT
    Set - 04 : Model Practice Set IT
    Set - 05 : Model Practice Set IT
    Set - 06 : Model Practice Set IT
    Set - 07 : Model Practice Set IT
    Set - 08 : Model Practice Set IT
    Set - 09 : Model Practice Set IT
    Set - 10 : Model Practice Set IT
    Set - 11 : Model Practice Set IT
    Set - 12 : Model Practice Set IT
    Set - 13 : Model Practice Set IT
    Set - 14 : Model Practice Set IT
    Set - 15 : Model Practice Set IT
    Set - 16 : Model Practice Set IT
    Set - 17 : Model Practice Set IT
    Set - 18 : Model Practice Set IT
    Set - 19 : Model Practice Set IT
    Set - 20 : Model Practice Set IT
    Set - 21 : Model Practice Set IT
    Set - 22 : Model Practice Set IT
    Set - 23 : Model Practice Set IT
    Set - 24 : Model Practice Set IT
    Set - 25 : Model Practice Set IT
    Set - 26 : Model Practice Set IT
    Set - 27 : Model Practice Set IT
    Set - 28 : Model Practice Set IT
    Set - 29 : Model Practice Set IT
    Set - 30 : Model Practice Set IT
    Set - 31 : Model Practice Set IT
    Set - 32 : Model Practice Set IT
    Set - 33 : Model Practice Set IT
    Set - 34 : Model Practice Set IT



    Model Solved Paper


    Set - 35 : Indian Bank IT Officer Exam, 22.05.2011 IT
    Set - 36 : SBI I. T. Officer For Assistant Manager, (Computer & Communication 02.12.2012 IT
    Set - 37 : SBI I. T. Officer For Assistant Manager, (System), 02.12.2012 IT
    Set - 38 : SBI I. T. Officer, 11.03.2012 IT
    Set - 39 : SBI I. T. Officer, 17.03.2013 IT

    Leave a Reply

    Blogger templates

    Blogger news

    Blogroll