RPSC Programmer Recruitment 2013
Rajasthan Public Service Commission(RPSC) is going to conduct the Direct recruitment for the post of Programmer. The details & syllabus of the examination is given below.
Paper Style
| Name of Papers | Marks | Time |
| PAPER- I | 100 | 2 Hrs |
| PAPER- II | 100 | 2 Hrs |
Qualifying marks :- Candidates who obtain a minimum of 40% marks of the total to qualify the examination, however for candidates having categories like Scheduled Castes/Scheduled Tribes, shall be 36%. The Commission/Appointing Authority may in their/its discretion award grace marks upto three in the aggregate.”
Written Examination
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.
Sample Questions
Software that defines a database, stores the data, supports a query language, produces reports and creates data entry screens is a:
A) data dictionary
B) database management system (DBMS)
C) decision support system
D) relational database
a) Accessed by only one user
b) Modified by users with the correct password
c) Is used to hide sensitive information
d) Both B and C
e) None of above
Ans is a) Accessed by only one user
The following are components of a database except ________ .
A. user data
B. metadata
C. reports
D. indexes
Ans is C. reports
Versatile report generator can provide ?
a) Columnar totals
b) Subtotals
c) Calculations
d) All of above
e) None of above
Ans is d) All of above
The database design that consists of multiple tables that are linked together through matching data stored in each table is called a:
A) Hierarchical database
B) Network database
C) Object oriented database
D) Relational database
a) Prime
b) Non Prime
c) Unique
d) None of these
Ans is C
>> 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.
Sample Questions
Ques: __________ is used to build ‘intuitive’ queries.
A) SQL
B) Xbase
C) QBE
D) XML
Ques DBMS stand for ___________.
A) Database Management System
B) Database Memory System
C) Database Manipulation System
D) Database Memory Service
Ques: SQL stands for __________.
A) Standard Query Language
B) Structured Query Language
C) Simplified Query Language
D) Static Query Language
Data Communication and Computer Networks
Computer Network Architecture, Circuit switching, Packet And Massage Switching, Network Structure. Physical Layer, Data Link Layer, Framing. Re transmission 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.
Best Books used in Top Colleges
For B.E/B.Tech , M.E, B.C.A, M.C.A
Sample Questions
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 walk through, 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.
Sample Questions
Ques: Which model incurs more cost?
A) RAD
B) Prototyping
C) Spiral
D) All of these
Ans is C) Spiral model
Ques: Which model incurs more cost?
a) RAD b)Prototyping c) Spiral d) All of these
Ques: Software configuration belongs to which of the following activities?
a) Umbrella activity b) Economic activity c) None of these d)All of the above
Ques:The first activity in software project planning is the determination of.
a) Software Size b) Software Scope c) Software Prize d) All of the above
Ques:A statement of software scope must be.
a) Free b) Bounded c) None of these d) All of the above
Ques: What is the full form of MTBF:
a) Meantime – between-failure b)Max time between failure c) All of the above d)None of these
Ques: Software______&_______ estimation will never be an exact science.
a) Cost & Effort b) Cost & Time c) Scope & Effort d) None of these
Ques: In order to develop a project schedule, a task set must be _______ on the project time line.
a) Assign b) Completed c) None of these d) Distributed
Ques: The concept of locking cannot be used to solve the problem of
1. Lost update
2. Uncommitted Dependency
3. Incosistent Data
4. Deadlock
Ans is 1. Lost update
Ques: In, Transaction, In ACIT properties A stands for
1. Atomicity
2. Acidity
3. Alphabetically
4. None of the above
Ans is 1. Atomicity
Ques: Architecture of the database can be viewed as
1. two levels.
2. four levels.
3. three levels.
4. one level.
Ans is 1. two levels.
Ques: A schedule S of n transactions is serializable if it is equivalent to some
1. Serial schedule of same n transactions
2. Non Serial schedule of same n transactions
3. Serial schedule of different n transactions
4. Non Serial schedule of different n transactions
Ans is 1. Serial schedule of same n transactions
Ques: The method in which records are physically stored in a specified order according to a key
field in each record is
1. hash.
2. direct.
3. sequential.
4. all of the above.
Ans is 1. hash.
Ques: A subschema expresses
1. the logical view.
2. the physical view.
3. the external view.
4. all of the above.
Ans is 1. the logical view.
Best books in used in Top Colleges
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 functions, Character I/O, Inheritance, Public and private members, Constructors for initialization, 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.
Ques: The ability to define common properties or functions in the higher class and then modify them in the lower classes is called:
A) Inheritance B) Polymorphism C) Reflexive D) Transformation
Ques: The occurrence of one property in different forms is called
A) Inheritance B) Polymorphism C) Reflexive D) Transformation
Best Books used in Top Colleges
For B.E/B.Tech , M.E, B.C.A, M.C.A
Download Prev Year paper
Paper-I Paper-II
No comments:
Post a Comment