How to Prepare for RPSC Programmer?

Rajasthan Public Service Commission(RPSC) is conducting the RPSC Programmer exam 2013 on 6th September 2013 as per the latest notification from RPSC NOTIFICATION.

The exams is objective having weightage of 200 marks and been divided into two parts for 2 hours each as follow :

PART-I includes :

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

2. Data Base Management Systems

3. Data Communication and Computer Networks



PART-II Includes:


1. System Analysis and Design

2. Programming Concepts

The marks and time allowed for each Paper shall be as under:

Name of Papers                              Marks                  Time

PAPER- I                                          100                    2 Hours

PAPER- II                                        100                    2 Hours

Minimum qualifying marks :  40% marks in the aggregate 

                                                             36% Scheduled Castes/Scheduled Tribes. 

                                             

grace marks three in the aggregate.

WHERE TO START?

• motivate yourself and aim to clear the exam and it doesn't matter how many or who is giving the exam.
• Don't panic from Syllabus. Divide the study as per the division of the syllabus.
• make a rough time table of what you have to study today and how much you have to study.
• divide days to dedicate the topic on it. at the end of this topic, solve the objective questions. analyse your strength and weakness.
• Don't Panic. keep your focus on karma Or STRATEGIC KARMA(SMART WORK)
• Make your notes. Don't Rely on other's notes
• Study as according to the syllabus. be precise and practise your to more objective problems.
• Make charts/ diagrams to sharpen up your memory and concepts
• Don't under confident and over-confident yourself!!

PART- I

1. Test & Numerical Analysis & General Knowledge

Book For Problem solving, Data Interpretation, Data Sufficiency, Logical Reasoning and Analytical Reasoning :

Quantitative Aptitude by R S Agarwal

General Knowledge and Current Affairs relating to India and Rajasthan : 

1. Pratyogita Darpan 

2. Give your 15-20 reading the Rajasthan section of Rajasthan

3. overview the rajasthan.gov.in 

2. Data Base Management Systems 

Syllabus :

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.

Book : 

Database management system by Korth. You can buy it or download from internet itself. 

3. Data Communication and Computer Networks

Syllabus : 

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.

Book : 

computer networks By tanenbaum. You can buy it or download from internet itself. 

PART-II

1. System Analysis and Design

Syllabus :

System concept: Definition and characteristics, elements and boundaries, types of system development life cycle, 

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.

Book : will upload the precise content later!

2. Programming Concepts:

Syllabus :

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 functions, Character I/O, Inheritance, Public and private members, Constructors for

initializations, Derived classes, Flow of Control Arrays-Programming with arrays, arrays of classes, arrays as function 

arguments, Strings, Multidimensional arrays, Arrays of strings, vectors, Base classes.

Introduction to JSP, RMI, Java Applets and servlets.

Introduction to DotNet framework and visual programming interface

Book :

as per the Syllabus, it only include java as a primary language, so people having java for their projects in academics are been benefited in their 2nd paper. in this, there is little part of DotNet Framework and visual programming interface, so you have a basic knowledge about  .net framework , Visual studio, Client-server architecture, Interface (HTML, XML, CSS, AJAX, JQuery)

Book For Java : Khalid Mughal for JAVA

Book For Dotnet Framework and VPI Intro : i will upload the precise content later.

LINK THAT WILL HELP YOU :

http://rpsc.rajasthan.gov.in
http://rajasthan.gov.in

Those Who Want the Old Exam paper of Programmer. Send message to My facebook page :
PsyPher-Logic 

Or 

Mail Me Subject : "Request for Programmer paper" and send it to Khizar

All other content for exam is been uploaded soon. stay in touch!

DISCLAIMER : This is all my personal views, if you have any query, you can Ask in comments. happy Reading! Share to your Social network so that it help more people. :)