GATE Database Management and Warehousing: Relational algebra, tuple calculus and SQL – Previous Year Questions
9 GATE previous year questions on Relational algebra, tuple calculus and SQL (Database Management and Warehousing, Data Science and Artificial Intelligence) with answers and explanations, from every paper.
- GATE 2024 DA Q26 – Consider a database that includes the following relations: Defender(name, rating, side, goals) Forward(name, rating, assists, goals) Team(name, club,…
- GATE 2024 DA Q31 – Consider the following two tables named Raider and Team in a relational database maintained by a Kabaddi league. The attribute ID in table Team…
- GATE 2025 DA Q17 – Consider the following three relations: Car (model, year, serial, color) Make (maker, model) Own (owner, serial) A tuple in Car represents a specific…
- GATE 2025 DA Q33 – On a relation named Loan of a bank: loan number branch name amount --- --- --- L11 Banjara Hills 90000 L14 Kondapur 50000 L15 SR Nagar 40000 L22 SR…
- GATE 2025 DA Q62 – Consider the following tables, Loan and Borrower, of a bank. Loan: loan num branch name amount --- --- --- L11 Banjara Hills 90000 L14 Kondapur 50000…
- GATE 2026 DA Q42 – Consider the given relations X, Y and Z. The relation X has three columns P, Q and R. The relation Y has three columns P, Q and S. The relation Z has…
- GATE 2026 DA Q51 – Consider a table Employee(EmpID, TeamID), where the column EmpID (ID of an employee) is the primary key. The column TeamID denotes the team ID of the…
- GATE 2026 DA Q59 – Let there be two relations X and Y as shown. X has three columns P, Q and R. Y has two columns P and S. X: P Q R --- --- --- P1 Q1 R1 P2 Q2 R2 P3 Q3…
- GATE 2026 DA Q60 – Let Account be a relation as shown. AccNo Balance --- --- A1 5000 A2 5000 A3 10000 A4 15000 A5 18000 Consider the given SQL query. The number of rows…