As you are searching for syllabus of IT Officer Recruitment Exam of NICL, so here I am providing complete syllabus:

NICL IT Officer Recruitment Exam Syllabus

Quantitative Aptitude:
Roots
Clocks
Averages
Bar Graphs
Line Graphs
Percentages
Simplification
Time & Work
Number System
Problems on Ages
Time & Distance
Stocks & Shares
Ratio & Proportions
Permutation & Combination
Heights & Distance Relationships
Pie Charts
HCL & LCM
Logarithms
Probability
Boats & Streams
Pipes & Cisterns
Profit & Loss
Mensuration
Problems on trains
Mixtures & Allegations
Tabulation
Decimal & Fractions
Simple & Compound Interest
Volume & Surface Area

General Awareness:
Sports
History
Indian Economy
Geography
Scientific Research
Indian Constitution
UNO
Financial News
Science & Technology
Memorandum of Understanding
Appointments & Companies Mergers
Culture
General Politics
International Economy
Countries and Capitals
Agriculture
Bills – New & Amendments
Budget & Five Years Plans
Marketing
Awards & Honors Sports

English
Verb
Adverb
Articles
Grammar
Synonyms
Vocabulary
Conclusion
Error Correction
Sentence Completion
Theme Detection
Passage Completion
Sentence Framing
Indirect-Direct Speech
Phrases and Idioms.
Tenses
Antonyms
Homonyms
Word Formation
Fill in the Blanks
Spelling
Rearrangement of Passage
Active-Passive Voice

Reasoning
Logic
Cubes and Dice
Arithmetical Reasoning
Input-Output
Coding-Decoding
Blood Relation
Direction Sense
Alphabet & Alpha Numeric Sequence Test
Classification
Clocks & Calendars
Data Sufficiency
Syllogism
Analogy
Mathematical Operations
Puzzle Test
Eligibility Test
Arrangements-Linear & Circular
Series test
Logical Venn Diagrams
Odd figures
Miscellaneous test.

IT Officer Syllabus
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 – 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 – Hierarchical, Networking, Relational Data Models (E-R Model, E-R Diagrams, EER Model), Advantages and Disadvantages of each model.
Advanced Concepts: Introduction to Data warehousing and Data mining – Different types
Client/Server Technology: Client – Server – Distributed and Co-operative processing – Peer- to – Peer processing – Application components – Transaction management.
Relational Structure – Characteristics of 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 Primary key constraint, Unique, Check constraint strong Entity, Weak Entity.
Normalization: Introduction – Purpose of Normalization – Definition of Functional Dependence (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, Sub queries.
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.
Views: Introduction – Advantages of views – The Create View Command, Updating Views, Views and Joins, Views and Sub queries – Dropping Views.
Sequences: Creating Sequences, Altering Sequences, Dropping Sequences.
Indexes: Index Types, Creating of 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
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, Fiber 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 Sub layer, Media access control for LAN & WAN, collision, IEEE 802 standards for LAN & MAN & their comparison. Ethernet, Wireless LANs, Broadband Wireless, Bluetooth.
Network Layer: Routing, 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.

Software Engineering
The Software Product and Software Process Models, Software Process customization and improvement.
Requirement Elicitation, Analysis, and Specification Functional and Non-functional requirements, Validation, Trace ability.
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, etc.
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
Introduction: Basic Terminology, Data types and its classification, Array Definition, Representation and Analysis of Arrays, Single and Multidimensional Arrays, etc.

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.

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

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.

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

Compiler Design
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, etc.
Symbol Tables, Run-Time Administration, simple stack allocation scheme, storage allocation in block structured language, Code Optimization and Code Generation
Parsing control statements, syntax diagrams, Error Recovery, Interpreting control statements, parsing programs, procedures and Functions.

Computer Organization and Microprocessor
Computer System: Basic Computer Operation, Machine Instructions, Addressing Modes, DLX Architecture,
Computer Configuration, Memory organization, Memory Architecture and Interface, DMA, Synchronization, etc.
Microprocessor As A CPU– types of Microprocessor, Microcomputers, Computer Languages, Flags, Program Counter(PC), Stack Pointer, OPCode Format, etc.
Input-output System.