Post NO.
PROGRAMER
SCHEME AND SYLLABUS OF EXAMINATION OF PART-II
Part Section Subject/Syllabus No. of Maximum
Questions marks
Part-II Section Computer Basics: 90 40 270 120
’A’ Components of A Computer System – CPU,
Motherbord, Primary Storage Devices, Secondary
Storage Devices, On-Line form Entry , direct data
entry, Data base, Typers of Computer input/Output
PDA’s, Computer hardware Basics
Operating System:
System Software, Operating System, Operating
Systems for Larger Systems, their System
Softwarem, Genral Purpose Software/Utilities,
Application Software, All type of Mobile OS
Data Base Management System & Data Mining:
Concepts related to Data, Data processing, File
organizations, Data Base Management Systems,
Types of Database, Database Structures, Data Base
Components, Structure of DBMS, RDBMS, Structured
Query Language and Other Query Language,
Storage, Documentation and Program Library,
Backup, and Recovery, Data Warehouse, Data
Mining, Data Security, Internet, Data center
Data Base Management Systems
ER Diagra, data models- Relational and Object
Oriented databases. Data Base Design: Conceptual
data base design, Normalization Primitive and
Composite data type, Concept of physical and logical
database, data abstraction and data independence,
data aggregation and Relational Algebra.
Application Development using SQL: Host Language
interfacem embedded SQL Programming, Stored
procedures and triggers and views, Constraints
assertions.
Intenet of RDBMS: Physical data organisation in
sequential, indexed random and hashed files.
Inverted and multilist structures, B trees, B+ trees,
Query Optimisation, Join algorithm.
Transaction Processing, concurrency control and
recovery management. Transaction model
Properties and state serialisability. Lock base
protocols, two phase locking.
Internet & Web Tools:
Computer Programming Languages (C, Java,PHP, Dot
net, Python, Java Script, SQL, HTML, VB Net), HTTP,
Internet. Electronic Data Interchange (EDI),
Electronic Fund Transfer(EFT), Types of Electronics
paymets, Risks and Security Considerations , &
Commerce, E-Commerce
Section Operation & Maintenace of RDBMS: 50 150
‘B’ Installing Oracle Database Software, My SQL, MS
SQL, DB 2, MS Access,Creating an Oracle Database,
my SQL, MS SQL, DB 2, MS Access, Managing the
Oracle Instance, Managing Database Storage
Structures,
Part Section Subject/Syllabus No. of Maximum
Questions marks
Administering User Security, Managing Schema
Objects, Managing Undo Data, Configure undo
retention, Implementing Oracle, PL-SQL, My SQL, MS
SQL, DB 2, MS Access Database Security Configuring
Network Environment, Performing Database
Recover and Flashbacks, Configuring Recovery
Managers, Monitoring and Managing Storage,
Database Environment,
Database development base, Database Desing,
Database implementaion, client server databasem
environment, internet database environmenet, data
ware housing, Advanced DBMS
Data Communication and Computer Networks
Computer Network Architecture, Circuit switching,
packet And Massage Swithching, Network Structure.
Physical Layer, Data Link Layer, Framing.
Retransmission algorithms.
Multiple access and Aloha. CSMA/CD and Ethernet.
High Speed LANs and topologies. Broadcast routing
and spanning trees.
TCP/IP Stack. IP Networks and Internet. DNS and
Firewalls. Intrusion Detection and Prevention.
Transport layer and TCP/IP. Network Management
and Interoperability.
System Analysis and Design
System concept: Definition and characteristics,
elements and boundaries, types of system
development lifecycle, recognition of needs,
feasibility study, prototyping, role of system analyst.
System planning and tools like DFD, data dictionary,
decision trees, structured analysis and decision
tables.
IPO charts, structured walkthrough, input output
form design, requirement and classification of forms,
layout considerations form control, object oriented
Design Concepts and methods.
Software Life Cycle, Software Engineering
paradigms.
System analysis: Feasibility study requirement
analysis, Cost benefit analysis, Planning systems,
Analysis tools and techniques.
System Design: design fundamentals, Modular
Design, Data and procedural design, object oriented
design.
System Development: Code documentation,
Program design paradigms. Efficiency Consideration.
Verification, Validation and Testing: testing
methods, Formal Program Verification, Testing
Strategies.
Software Maintenance: Maintenance
Characteristics, Maintainability, Maintenance tasks
and side effects.
Programming Concepts
Introduction: Internet, Java as a tool for internet
applications, Byte Code and its advantages.
Object Oriented Programming and Design: Review of
Abstraction, Objects and other basics, Encapsulation,
Information hiding, Method, Signature, Classes and
Instances, Polymorphism, Inheritance, Exceptions
and Exception Handling with reference to object
modeling. Coupling and Cohesion in object oriented
software. Object Oriented Design -Process,
Exploration and Analysis.
Java Programming Basics: Variables and
assignments, Input and Output, Data Types and
Expressions, Flow of control, Local variables,
Overloading Parameter passing, this pointer, Java
Object Oriented Concepts: Use of file for I/O,
Formatting output with stream.
Programming Language & Practical Implementaion:
Programming Language, Programming Process,
Analysis-Flowchartsm, Program Flowcharts-Data
Sources, Algorithms, Flowcharting, Dry Run and
Debugging the Program, SQL statements and the
extraction of data from the source database, online
Google and Excel sheets development, Static and
Dynamic website development, PPT/Execl/Word
advance uses, Concept of AI and machine learning,
Programming Language-Python programming,
Control sturcture, exception handing, web logic
technologies, sofware Engineering, system design &
analysis, digital logic, JAVA Programming, OS,
computer architecture, analysis and desing of
algorithm, cloud computing, C language program
and its various functions, pointers.
