chapter
    Database Systems PYQs for GATE DA

    GATE DA Database Systems: 4 chapters, 19 previous year questions (86% of Database Management and Warehousing), 0 practice questions and one solved question fr

    A question from this chapter

    Question 1
    2026 PYQ
    Let Account be a relation as shown.

    Account
    AccNo Balance
    A1 5000
    A2 5000
    A3 10000
    A4 15000
    A5 18000

    Consider the given SQL query.

    SELECT AccNo FROM Account AS A
    WHERE (SELECT COUNT(*) FROM Account AS B
    WHERE A.Balance < B.Balance) >= (SELECT COUNT(*)
    FROM Account AS C WHERE A.Balance > C.Balance)

    The number of rows returned by the SQL query is __________ . (Answer in integer)
    Question 2
    2026 PYQ
    Consider an ER model with the entities and , where, are the attributes of , and are the attributes of . Let be a multi-valued attribute. and are the primary keys of and , respectively.

    Let be a many-to-many relationship between and . Participation of both and in is total.

    The minimum number of relations required to convert the ER model into relational model (assuming there is no other functional dependency) where each relation is in third normal form (3NF) is __________ . (Answer in integer)
    Question 3
    2026 PYQ
    Let R(A,B,C,D,E) be a relational schema with functional dependency set .
    Which of the following statements is correct?
    Question 4
    2026 PYQ
    In a relational database, a B+ Tree Index is to be constructed for a relation on a key field. In a B+ Tree, a Node Pointer points to a sub-tree and a Data Record Pointer points to a block of database records.

    Let, Node size = 4096 bytes, Node Pointer size = 10 bytes, Search Key Field size = 11 bytes and Data Record Pointer size = 12 bytes.

    The maximum number of Node Pointers that can be present in a non-leaf node of the B+ Tree is ________ . (Answer in integer)
    Free preview ends here

    Login to view the complete previous-year questions and solutions

    Creating an account is free. You get the rest of this chapter, step-by-step solutions, and a study plan built around the topics you are actually weak at.

    Why MastersUp

    Personalised first. High quality throughout.

    Most platforms hand everyone the same content. Here the content moves with your performance, topic by topic.

    Built around you, not around a syllabus PDF

    Every answer you give moves your topic-level intelligence rate. The next question, the next revision card and tomorrow's plan all change with it.

    Revision that hits your weak spots

    We only revise topics you have actually attempted and are still below the safe bar on — never the same chapter on repeat.

    Questions calibrated to the real exam

    Each question carries a measured toughness. You are served a rung above your current level, so practice keeps stretching you.

    Notes written for recall, not for volume

    Full lesson cards for first study, curated short-note cards for the last mile — with derivations, traps and exam patterns marked.

    One place for everything

    Notes, chapter practice, previous-year questions, test series and full-length papers — all feeding one picture of your preparation.

    Honest progress

    No vanity streaks. Progress here means chapters mastered and accuracy that held up on harder questions.

    Unlock the whole course

    Full notes and short notes, the complete question bank with worked solutions, mock tests, full-length papers, and an adaptive plan that rebuilds itself as you improve.

    Database Systems PYQs for GATE DA

    GATE DA Database Systems: 4 chapters, 19 previous year questions (86% of Database Management and Warehousing), 0 practice questions and one solved question from each chapter.

    About Database Systems Previous Year Questions (PYQs)

    19 previous year questions from Database Systems in GATE DA, grouped by chapter with the exam year, answer key and step-by-step solution for each.

    Database Systems Weightage in GATE DA

    Database Systems accounts for 19 of 22 Database Management and Warehousing previous year questions in our bank (86%), about 6.3 per paper across 3 papers.

    Database Systems Chapter Matrix

    ChapterTopicsPYQsShare of unit PYQsPractice questions
    Relational Algebra and SQL QueriesRelational Algebra Expressions and Query Semantics, SQL Joins, Aggregation and Grouping, SQL Subqueries and Query Result Evaluation947%0
    ER Model, Keys and Integrity ConstraintsER-to-Relational Mapping and Multivalued Attributes, Keys, NULL Constraints and Foreign Key Integrity316%0
    Functional Dependencies and NormalizationFunctional Dependencies and Candidate Keys, Normalization, BCNF and Dependency Preservation, Armstrong Axioms and Derived Dependencies421%0
    Indexing and B+ TreesB+ Tree Structure, Insertion and Fanout Calculation, Index Selection for SQL Query Processing316%0

    More from Database Management and Warehousing

    One Solved Question from Each Database Systems Chapter

    Question 1 · Relational Algebra and SQL Queries · 2026 NAT
    Let Account be a relation as shown.

    Account
    AccNo Balance
    A1 5000
    A2 5000
    A3 10000
    A4 15000
    A5 18000

    Consider the given SQL query.

    SELECT AccNo FROM Account AS A
    WHERE (SELECT COUNT(*) FROM Account AS B
    WHERE A.Balance < B.Balance) >= (SELECT COUNT(*)
    FROM Account AS C WHERE A.Balance > C.Balance)

    The number of rows returned by the SQL query is __________ . (Answer in integer)
    Question 2 · ER Model, Keys and Integrity Constraints · 2026 NAT
    Consider an ER model with the entities and , where, are the attributes of , and are the attributes of . Let be a multi-valued attribute. and are the primary keys of and , respectively.

    Let be a many-to-many relationship between and . Participation of both and in is total.

    The minimum number of relations required to convert the ER model into relational model (assuming there is no other functional dependency) where each relation is in third normal form (3NF) is __________ . (Answer in integer)
    Question 3 · Functional Dependencies and Normalization · 2026 MCQ
    Let R(A,B,C,D,E) be a relational schema with functional dependency set .
    Which of the following statements is correct?
    1. A.

      AD, ED and CD are the only candidate keys of R.

    2. B.

      AD and ED are the only candidate keys of R.

    3. C.

      A, E and CD are the only candidate keys of R.

    4. D.

      A and CD are the only candidate keys of R.

    Question 4 · Indexing and B+ Trees · 2026 NAT
    In a relational database, a B+ Tree Index is to be constructed for a relation on a key field. In a B+ Tree, a Node Pointer points to a sub-tree and a Data Record Pointer points to a block of database records.

    Let, Node size = 4096 bytes, Node Pointer size = 10 bytes, Search Key Field size = 11 bytes and Data Record Pointer size = 12 bytes.

    The maximum number of Node Pointers that can be present in a non-leaf node of the B+ Tree is ________ . (Answer in integer)