Skip to content

Latest commit

 

History

History
207 lines (177 loc) · 4.8 KB

syllabus.md

File metadata and controls

207 lines (177 loc) · 4.8 KB
Raw

RPSC Programmer - Complete Syllabus

Examination Structure

  • Total Papers: 2
  • Duration per Paper: 2 Hours
  • Questions per Paper: 100 (Multiple Choice)
  • Total Marks: 200 (100 per paper)

Paper-I Syllabus

Section A: 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

Section B: Technical Topics

1. Database Management Systems

  1. Database Fundamentals

    • ER Diagram
    • Data models- Relational and Object Oriented databases
    • Conceptual database design
    • Normalization
    • Primitive and Composite data types

  2. Database Concepts

    • Physical and logical databases
    • Data abstraction and independence
    • Data aggregation
    • Relational Algebra

  3. SQL Applications

    • Host Language interface
    • Embedded SQL programming
    • Stored procedures and triggers
    • Views
    • Constraints assertions

  4. RDBMS Internals

    • Physical data organisation
      • Sequential files
      • Indexed random files
      • Hashed files
    • Data Structures
      • Inverted and multilist structures
      • B trees
      • B+ trees
    • Query Optimisation
    • Join algorithms

  5. Transaction Management

    • Transaction Processing
    • Concurrency control
    • Recovery management
    • Transaction model properties
    • State serialisability
    • Lock base protocols
    • Two phase locking

2. Data Communication and Computer Networks

  1. Network Fundamentals

    • Computer Network Architecture
    • Circuit switching
    • Packet And Message Switching
    • Network Structure

  2. Network Layers

    • Physical Layer
    • Data Link Layer
    • Framing
    • Transport layer

  3. Network Protocols

    • Retransmission algorithms
    • Multiple access and Aloha
    • CSMA/CD and Ethernet
    • TCP/IP Stack
    • TCP/IP Protocol

  4. Network Infrastructure

    • High Speed LANs
    • Network topologies
    • Broadcast routing
    • Spanning trees
    • IP Networks and Internet

  5. Network Security

    • DNS and Firewalls
    • Intrusion Detection
    • Intrusion Prevention

  6. Network Management

    • Network Management
    • Interoperability

Paper-II Syllabus

1. System Analysis and Design

  1. System Concepts

    • Definition and characteristics
    • Elements and boundaries
    • System development lifecycle
    • Feasibility study
    • Prototyping
    • Role of system analyst

  2. System Planning Tools

    • DFD
    • Data dictionary
    • Decision trees
    • Structured analysis
    • Decision tables
    • IPO charts
    • Structured walkthrough

  3. Design & Documentation

    • Input output form design
    • Form requirements and classification
    • Layout considerations
    • Form control
    • Object oriented Design Concepts
    • Design methods

  4. Software Engineering

    • Software Life Cycle
    • Software Engineering paradigms
    • Feasibility study
    • Requirement analysis
    • Cost benefit analysis

  5. System Design

    • Design fundamentals
    • Modular Design
    • Data and procedural design
    • Object oriented design

  6. System Development & Testing

    • Code documentation
    • Program design paradigms
    • Efficiency Consideration
    • Testing methods
    • Formal Program Verification
    • Testing Strategies

  7. Maintenance

    • Maintenance Characteristics
    • Maintainability
    • Maintenance tasks
    • Maintenance side effects

2. Programming Concepts

  1. Internet & Java Basics

    • Internet fundamentals
    • Java for internet applications
    • Byte Code and advantages

  2. Object Oriented Programming

    • Abstraction
    • Objects
    • Encapsulation
    • Information hiding
    • Methods & Signatures
    • Classes and Instances
    • Polymorphism
    • Inheritance
    • Exception Handling
    • Object modeling
    • Coupling and Cohesion

  3. Java Programming

    • Variables and assignments
    • Input/Output operations
    • Data Types and Expressions
    • Flow control
    • Parameter passing
    • File I/O
    • Arrays and Strings
    • Constructors
    • Access modifiers
    • Base classes

  4. Advanced Java

    • JSP
    • RMI
    • Java Applets
    • Servlets

  5. Additional Topics

    • DotNet framework
    • Visual programming interface

Examination Instructions

  1. Negative marking applicable: 1/3 marks deducted for wrong answers
  2. Multiple answers considered wrong
  3. Using BLUE BALL POINT PEN is mandatory
  4. Must attempt all questions (mark option 5 if not attempting)
  5. Extra 10 minutes provided for darkening circles
  6. Disqualification if >10% questions have no option marked

Answer Sheet Guidelines

  1. Five options per question (1-5)
  2. Must mark one option per question
  3. Use option 5 for questions not attempted
  4. Use only blue ball point pen
  5. Fill circles completely and properly