Q1. Let a table R have three candidate keys A, B and (C, D). Which of the following must not be correct ?
- (a) A → BC
- (b) B → AD
- (c) C → AB
- (d) A → D
ACF & Forest Range Officer 2018 Computer Engineering Question Paper PDF
- Year 2018
- Conducted By RPSC
- Questions 120
- Maximum Marks 200
- Duration 3.00 Hours
- Languages Hindi & English
Exam Details
| Detail | Information |
|---|---|
| Examination | ACF AND FOREST RANGE OFFICER GR-I COMP. EXAM |
| Year | 2018 |
| Conducting Body | RPSC |
| Paper | Computer Engineering |
| Subject | Computer Engineering |
| Duration | 3.00 Hours |
| Maximum Marks | 200 |
| Number of Questions | 120 |
| Question Type | Objective (MCQ) |
This page provides the ACF and Forest Range Officer Gr-I Competitive Exam 2018 Computer Engineering Paper III question paper, conducted by RPSC. The exam was held for a duration of 3.00 hours, with a maximum of 200 marks, and contained 120 objective questions. This paper is crucial for aspirants preparing for the ACF and Forest Range Officer examination, offering insights into the exam pattern, difficulty level, and important topics covered in Computer Engineering. Downloading and practicing with this previous year's paper can significantly aid in exam preparation and strategy development.
Major Topics Covered
- Database Management Systems
- Normal Forms
- BCNF
- SQL
- Relational Algebra
- Data Dictionary
- B+ Tree
- Computer Engineering Concepts
Why This Paper is Important
- Useful for ACF AND FOREST RANGE OFFICER GR-I COMP. preparation
- Helps understand the latest exam pattern
- Useful for practice and self-assessment
- Covers frequently asked General Studies topics
- Helpful for analysing question trends
Related Resources
- ACF & Forest Range Officer 2021 Computer Engineering Paper
- ACF & Forest Range Officer 2019 Computer Engineering Paper
- RPSC AE/AEn Computer Engineering Paper
- ACF Forest Range Officer 2018 Computer Engineering Answer Key
- ACF Forest Range Officer Computer Engineering Syllabus
- RPSC Exam Syllabus
- ACF Forest Range Officer Exam Pattern
- RPSC Exam Pattern
Instructions
- प्रत्येक प्रश्न का केवल एक ही उत्तर दीजिए ।
- If more than one answers are marked, it would be treated as एक से अधिक उत्तर देने की दशा में प्रश्न के उत्तर को गलत माना जाएगा ।
- प्रत्येक प्रश्न के चार वैकल्पिक उत्तर दिये गये हैं, जिन्हें क्रमश: 1, 2, 3,
- Each question has four alternative responses marked serially 4 ऑकत किया गया है ।
- अभ्यर्थी को सही उत्तर निर्दिष्ट करते हुए उनमें as 1, 2, 3,
- You have to darken only one circle or bubble indicating the correct answer on the Answer Sheet using BLUE से केवल एक गोले अथवा बबल को उत्तर पत्रक पर नीले बॉल प्वाइंट पेन से गहरा करना है । BALL POINT PEN. The OMR Answer Sheet is inside this Test Booklet. When
- OMR उत्तर पत्रक इस परीक्षा पुस्तिका के अन्दर रखा है ।
- जब आपको you are directed to open the Test Booklet, take out the परीक्षा पुस्तिका खोलने को कहा जाए, तो उत्तर-पत्रक निकाल कर Answer Sheet and fill in the particulars carefully with blue ध्यान से केवल नीले बॉल पॉइंट पेन से विवरण भरें । ball point pen only.
- प्रत्येक गलत उत्तर के लिए प्रश्न अंक का 1/3 भाग काटा जायेगा । गलत
- 1/3 part of the mark(s) of each question will be उत्तर से तात्पर्य अशुद्ध उत्तर अथवा किसी भी प्रश्न के एक से अधिक deducted for each wrong answer. A wrong answer means उत्तर से है ।
- किसी भी प्रश्न से संबंधित गोले या बबल को खाली छोड़ना an incorrect answer or more than one answers for any गलत उत्तर नहीं माना जायेगा । question. Leaving all the relevant circles or bubbles of any question blank will not be considered as wrong answer.
- मोबाइल फोन अथवा इलेक्ट्रोनिक यंत्र का परीक्षा हॉल में प्रयोग पूर्णतया Mobile Phone or any other electronic gadget in the वर्जित है ।
- यदि किसी अभ्यर्थी के पास ऐसी कोई वर्जित सामग्री
- examination hall is strictly prohibited. A candidate found मिलती है तो उसके विरुद्ध आयोग द्वारा नियमानुसार कार्यवाही की with any of such objectionable material with him/her will be जायेगी । strictly dealt as per rules.
- कृपया अपना रोल नम्बर ओ.एम.आर. पत्रक पर सावधानीपूर्वक सही
- Please correctly fill your Roll Number in O.M.R. Sheet. भरें।
- गलत अथवा अपूर्ण रोल नम्बर भरने पर 5 अंक कुल प्राप्तांकों में 5 Marks can be deducted for filling wrong or incomplete Roll से काटे जा सकते हैं । Number. चेतावनी : अगर कोई अभ्यर्थी नकल करते पकड़ा जाता है या उसके पास Warning: If a candidate is found copying or if any unauthorized से कोई अनधिकृत सामग्री पाई जाती है, तो उस अभ्यर्थी के विरुद्ध पुलिस में material is found in his/her possession, F.I.R. would be lodged against him/her in the Police Station and he/she would liable to be प्राथमिकी दर्ज कराते हुए विविध नियमों-प्रावधानों के तहत कार्यवाही की जाएगी ।
- साथ ही विभाग ऐसे अभ्यर्थी को भविष्य में होने वाली विभाग की prosecuted. Department may also debar him/her permanently from all future examinations. समस्त परीक्षाओं से विवर्जित कर सकता है ।
- इस परीक्षा पुस्तिका को तब तक न खोलें जब तक कहा न जाए । Do not open this Test Booklet until you are asked to do so. 13 - 12
- Only one answer is to be given for each question.
Questions (page 2)
Q2. A relation is in which of the form if it is BCNF and also has no multivalued dependencies :
- (a) Second normal form
- (b) Third normal form
- (c) Fourth normal form
- (d) Domain normal form
Q3. In which normal form partial depedency removed ?
- (a) First normal form
- (b) Second normal form
- (c) Third normal form
- (d) BCNF
Q4. Which of the following creates a virtual relation for storing the query ?
- (a) Function
- (b) View
- (c) Procedure
- (d) None of these
Q5. Which of the join operations do not preserve non matched tuples ?
- (a) Left Outer Join
- (b) Right Outer Join
- (c) Inner Join
- (d) Full Outer Join
Q6. Which of the following is a procedural language ?
- (a) tuple relational calculus
- (b) domain relational calculus
- (c) relational algebra
- (d) None of these
Q7. The content of the data dictionary is
- (a) DML Commands
- (b) DDL Commands
- (c) Indexes to user data
- (d) Metadata
Q8. Consider the relations r1 (A, B, C), r2 (C, D, E) and r3 (E, F), with primary keys A, C and E, respectively. Assume that r1 has 50 tuples, r2 has 15 tuples, and r3 has 75 tuples. What is the size of r1 \bowtie r2 \bowtie r3 ?
- (a) 56250
- (b) 50
- (c) 15
- (d) 75
Q9. A B+ tree index is to be built on the attribute of the relation with length 8 bytes. The disk blocks are of size 512 bytes and index pointer is of size 4 bytes. What could be the optimal degree of the B+ tree ?
- (a) 43
- (b) 15
- (c) 17
- (d) 18
Q10. What is the constraint the leads to fifth normal form ?
- (a) General Constraints
- (b) Multivated dependencies
- (c) Functional dependency
- (d) Join Dependency
Q11. Which of the following is false about static member functions ?
- (a) static member functions can access not static members of class.
- (b) static member functions belong to class.
- (c) static member functions cannot be called using class object.
- (d) static member functions cannot be overloaded.
Question paper preview
Scanned pages 1–2 for reference. Download the official PDF for the full paper.
Free question paper download
Download question paper PDF
Your download starts in 10s
Preparing your question paper file…
Frequently asked questions
What is the full name of the exam?
The full name of the exam is ACF And Forest Range Officer Gr-I Comp. Exam.
What year is this question paper from?
This question paper is from the year 2018.
Which conducting body organized this exam?
The exam was organized by RPSC (Rajasthan Public Service Commission).
What is the subject of this paper?
The subject of this paper is Computer Engineering.
What is the paper code?
The paper code is 13.
What was the maximum marks for this paper?
The maximum marks for this paper were 200.