Skip to Content

RPSC SENION PROGRAMMER CUM DEPUTY DIRECTOR SYLLABUS

1 August 2024 by
RPSC SENION PROGRAMMER CUM DEPUTY DIRECTOR SYLLABUS
VIVEK

RAJASTHAN PUBLIC SERVICE COMMISSION, AJMER

SYLLABUS FOR COMPETITIVE EXAMINATION

FOR THE POST OF ANALYST CUM PROGRAMMER DEPARTMENT OF INFORMATION TECHNOLOGY AND COMMUNICATION

RECOMMENDED BOOKS AND TEST SERIES FOR RPSC PROGRAMMER EXAM

PAPER - I

Reasoning Test & Numerical Analysis & General Knowledge

Problem solving, Data Interpretation, Data Sufficiency, Logical Reasoning and Analytical Reasoning. General Knowledge and Current Affairs relating to India and Rajasthan.


Data Base Management Systems

ER Diagram, data models- relational and object-oriented databases. Data Base Design: Conceptual data base design, Normalization Primitive and Composite data types, concept of physical and logical databases, data abstraction and data independence, data aggregation and Relational Algebra.

Application Development using SQL: host language interface, embedded SQL programming, Stored procedures and triggers and views, constraints assertions.

Internal 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.

Different server multi user, multiprocess operating systems and requirement for client interfaces in distributed application environments.

RECOMMENDED BOOKS AND TEST SERIES FOR RPSC PROGRAMMER EXAM

Data Communication and Computer Networks

Computer Network Architecture, Circuit switching, Packet and Massage Switching, 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.

 RECOMMENDED BOOKS AND TEST SERIES FOR RPSC PROGRAMMER EXAM

PAPER - II

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.

RECOMMENDED BOOKS AND TEST SERIES FOR RPSC PROGRAMMER EXAM

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.

Software Project Management-

Software Project Management Concept- the management spectrum, people, product, process and project.

Software Process & Project Matrix: software measurement size-oriented matrixes, function oriented matrices.

Software Project Planning: objectives, decomposition techniques, empirical estimation model. Risk analysis and management: risk identification, projection, risk refinement, risk monitoring and management.

Project scheduling and tracking, software quality assurance, software configuration management.

 RECOMMENDED BOOKS AND TEST SERIES FOR RPSC PROGRAMMER EXAM

* * * * *

 

 

S. No.

Subject

No. of Questions

Total Marks

Examination Duration

1

Paper-I

100

100

2.00 Hours

2

Paper-II

100

100

2.00 Hours

 

Total

200

200

 

 RECOMMENDED BOOKS AND TEST SERIES FOR RPSC PROGRAMMER EXAM

RPSC SENION PROGRAMMER CUM DEPUTY DIRECTOR SYLLABUS
VIVEK 1 August 2024
Share this post
Tags
Our blogs
Archive