Success TrackerSuccess Tracker
Log inSign up

GATE CS Databases Previous Year Questions

12 solved GATE CS questions on Databases, drawn from 1 exam year and grouped by year. Every question shows the official answer and a step-by-step solution.

GATE CS 202412 questions

  1. Set 1 Q20Let S be the specification: "Instructors teach courses. Students register for courses. Courses are allocated classrooms. Instructors guide students." Which one…MCQ · +1 marks · Easy
  2. Set 1 Q21In a B+B^+ tree, the requirement of at least half-full (50%) node occupancy is relaxed for which one of the following cases?MCQ · +1 marks · Easy
  3. Set 1 Q22Which of the following statements about a relation R\mathbf{R} in first normal form (1NF) is/are TRUE ?MSQ · +1 marks · Medium
  4. Set 1 Q35Consider the following two relations, R(A,B) and S(A,C): Relation R | A | B | |---|---| | 10 | 20 | | 20 | 30 | | 30 | 40 | | 30 | 50 | | 50 | 95 |…NAT · +1 marks · Easy
  5. Set 1 Q44The symbol →\rightarrow indicates functional dependency in the context of a relational database. Which of the following options is/are TRUE?MSQ · +2 marks · Easy
  6. Set 1 Q46Consider the following read-write schedule SS over three transactions T1,T2T_1, T_2, and T3T_3, where the subscripts in the schedule indicate transaction IDs:…MSQ · +2 marks · Medium
  7. Set 2 Q19Once the DBMS informs the user that a transaction has been successfully completed, its effect should persist even if the system crashes before all its changes…MCQ · +1 marks · Easy
  8. Set 2 Q20In the context of owner and weak entity sets in the ER (Entity-Relationship) data model, which one of the following statements is TRUE?MCQ · +1 marks · Easy
  9. Set 2 Q26Which of the following file organizations is/are I/O efficient for the scan operation in DBMS?MSQ · +1 marks · Medium
  10. Set 2 Q27Which of the following statements about the Two Phase Locking (2PL) protocol is/are TRUE?MSQ · +1 marks · Medium
  11. Set 2 Q45The relation schema, Person(pid, city), describes the city of residence for every person uniquely identified by pid. The following relational algebra…MCQ · +2 marks · Hard
  12. Set 2 Q56A functional dependency F:X→YF: X \to Y is termed as a useful functional dependency if and only if it satisfies all the following three conditions: - XX is…NAT · +2 marks · Medium

Other GATE CS topics

Engineering Mathematics(23)General Aptitude(20)Programming & Data Structures(17)Computer Networks(12)Computer Organization & Architecture(12)Operating System(10)Compiler Design(9)Theory of Computation(8)Digital Logic(8)Algorithms(5)

Practice Databases with adaptive difficulty

Timed practice, skill tracking, and AI explanations — free to start.

Start practicing free