Exam Scheme

Note :-

1. Examination Duration: 2.00 Hours for each paper.
2. Multiple Choice Type questions.
3. Negative marking shall be applicable in the evaluation of answers. For every wrong answer one-third part of the marks prescribed for that particular question shall be deducted. Wrong answer means an incorrect answer or multiple answers.
4. Each question has five options marked as 1, 2, 3, 4, 5. Candidate has to darken only one circle (bubble) indicating the correct answer on the Answer Sheet using BLUE BALL POINT PEN.
5. It is mandatory to fill one option for each question.
6. If a question is not attempted, darken circle '5'. If none of the five circles is darkened, one-third (1/3) part of the marks of the question shall be deducted.
7. After solving the question paper, the candidate must ascertain that they have darkened one of the circles (bubbles) for each of the questions. Extra time of 10 minutes beyond the scheduled time is provided for this.
8. A candidate who has not darkened any of the five circles in more than 10% of the questions shall be disqualified.

---

Syllabus :- Paper - I

---

1. Reasoning Test & Numerical Analysis & General Knowledge

1. Problem solving
2. Data Interpretation
3. Data Sufficiency
4. Logical Reasoning and Analytical Reasoning
5. General Knowledge and Current Affairs relating to India and Rajasthan

2. Data Base Management Systems

1. ER Diagram
2. Data models- relational and object-oriented databases
3. Data Base Design:
   1. Conceptual data base design
   2. Normalization Primitive and Composite data types
   3. Concept of physical and logical databases
   4. Data abstraction and data independence
   5. Data aggregation and Relational Algebra
4. Application Development using SQL:
   1. Host language interface
   2. Embedded SQL programming
   3. Stored procedures and triggers and views
   4. Constraints assertions
5. Internal of RDBMS:
   1. Physical data organisation in sequential, indexed random and hashed files
   2. Inverted and multilist structures, B trees, B+ trees
   3. Query Optimisation, Join algorithm
6. Transaction Processing, concurrency control and recovery management
7. Transaction model properties and state serialisability
8. Lock base protocols, two phase locking
9. ( Note :- this point only for exam Analyst Cum Programmer ) Different server multi user, multiprocess operating systems and requirement for client interfaces in distributed application environments

3. Data Communication and Computer Networks

1. Computer Network Architecture
2. Circuit switching, Packet and Massage Switching
3. Network Structure
4. Physical Layer, Data Link Layer, Framing
5. Retransmission algorithms
6. Multiple access and Aloha
7. CSMA/CD and Ethernet
8. High Speed LANs and topologies
9. Broadcast routing and spanning trees
10. TCP/IP Stack
11. IP Networks and Internet
12. DNS and Firewalls
13. Intrusion Detection and Prevention
14. Transport layer and TCP/IP
15. Network Management and Interoperability