GATE 2025 · session-5
On a relation named Loan of a bank:
The following SQL query is executed:
SELECT L1.loan_number FROM Loan L1 WHERE L1.amount \(>\) (SELECT MAX(L2.amount) FROM Loan L2 WHERE L2.branch_name = 'SR Nagar');
Related Database Management and Warehousing PYQs
If a relational decomposition is not dependency-preserving, which one of the following relational operators will be executed more …
Consider the following three relations: Car (model, year, serial, color) Make (maker, model) Own (owner, serial) A tuple in Car re…
Consider a fact table in an OLAP application: Facts(D1, D2, val), where D1 and D2 are its dimension attributes and val is a depend…
Consider the following two relations, named Customer and Person, in a database: Which of the following statements is/are correct?
Consider a database relation \( R \) with attributes \( A, B, C, D, E, F, G \), and having the following functional dependencies: …
Consider the following tables of a bank. | Loan number | Branch name | Amount | | --- | --- | --- | | L11 | Banjara Hills | 90000…
Free account benefits
Turn practice into measurable progress
Public PYQs and reference pages stay free. Sign in when you want GATEverse to remember what you studied and guide what to practise next.
Saved progressKeep answers, mock results and completion history across devices.
Adaptive practiceGet questions matched to your recent accuracy and difficulty level.
Bookmarks and notesBuild a personal revision list and record why a question was difficult.
Performance insightsSee weak subjects, accuracy trends, streaks and exam readiness.