Subject analysis · 2017–2026

Database Management Systems (DBMS)

Every GATE CS question on Database Management Systems (DBMS), with how the marks are spread across years and topics.

Practise Database Management Systems (DBMS)

Questions

72

7 topics

Avg marks / year

11.1

111 marks over 10 years

Peak year

2025

17 marks

Trend

Rising

+59% last 3 yrs

Marks per year

Both shifts counted where there were two · peak highlighted

Rising +59%
avg 11.1
16
6
8
8
16
7
5
16
17
12
'17'18'19'20'21'22'23'24'25'26

Topic share

Share of Database Management Systems (DBMS)'s 111 marks

7

topics

  • Transactions, Concurrency Control, Conflict Serializability21%
  • Relational Models, Relational Algebra, Tuple Calculus19%
  • SQL Queries15%
  • Integrity Constraints & Functional Dependencies14%
  • Normalization Schemes14%
  • File Organization & Indexing14%
  • ER-Model5%

Topic × year heatmap

Marks from each topic in each year — darker is heavier. Topics that light up every column are the safest bets.

'17'18'19'20'21'22'23'24'25'26
Transactions, Concurrency Control, Conflict Serializability41252441
Relational Models, Relational Algebra, Tuple Calculus422311323
SQL Queries31212224
Integrity Constraints & Functional Dependencies23145
Normalization Schemes22221141
File Organization & Indexing21212232
ER-Model1112
Recommended book · affiliate linkDatabase System Concepts (Korth)Normalisation, SQL, transactions and indexing — the DBMS syllabus in one book.

All 72 Database Management Systems (DBMS) questions

2026 8 questions · 12 marks
  1. FN · Q30Let P, Q, R and S be the attributes of a relation in a relational schema. Let X Y indicate functional dependency in the context of a relational database, where…Integrity Constraints & Functional Dependencies · MSQ · 1 mark
  2. FN · Q31In the context of relational database normalization, which of the following statements is/are true?Normalization Schemes · MSQ · 1 mark
  3. FN · Q43Consider a relational database schema with two relations R(P, Q) and S(X, Y) . Let E = \ u v w ( u, v R v, w S)\ be a tuple relational calculus expression. Whi…Relational Models, Relational Algebra, Tuple Calculus · MCQ · 2 marks
  4. FN · Q65Consider a relational database schema with a relation R(A, B, C, D) . If \ A, B\ and \ A, C\ are the only two candidate keys of the relation R , then the numbe…Integrity Constraints & Functional Dependencies · NAT · 2 marks
  5. AN · Q15In the context of DBMS, consider the two sets T and S given below. T I: Logical schema II: Physical schema III: External schema S L: Views M: File organization…Relational Models, Relational Algebra, Tuple Calculus · MCQ · 1 mark
  6. AN · Q20Consider concurrent execution of two transactions T1 and T2 in a DBMS, both of which access a data object A . For these two transactions to not conflict on A ,…Transactions, Concurrency Control, Conflict Serializability · MCQ · 1 mark
  7. AN · Q42In the context of schema normalization in relational DBMS, consider a set F of functional dependencies. The set of all functional dependencies implied by F is…Integrity Constraints & Functional Dependencies · MCQ · 2 marks
  8. AN · Q46An index in a DBMS is said to be dense if an index entry appears for every search-key value in the indexed file. Otherwise it is called a sparse index. Conside…File Organization & Indexing · MCQ · 2 marks
2025 10 questions · 17 marks
  1. FN · Q15A schedule of three database transactions T 1 , T 2 , and T 3 is shown. R i(A) and W i(A) denote read and write of data item A by transaction T i , i = 1, 2, 3…Transactions, Concurrency Control, Conflict Serializability · MCQ · 1 mark
  2. FN · Q21Consider the following B + tree with 5 nodes, in which a node can store at most 3 key values. The value 23 is now inserted in the B + tree. Which of the follow…File Organization & Indexing · MSQ · 1 mark
  3. FN · Q39Consider two relations describing teams and players in a sports league: • teams(tid, tname): tid, tname are team-id and team-name, respectively. • players(pid,…Relational Models, Relational Algebra, Tuple Calculus · MCQ · 2 marks
  4. FN · Q47Consider a relational schema team(name, city, owner), with functional dependencies \ name city , name owner \ . The relation team is decomposed into two relati…Normalization Schemes · MSQ · 2 marks
  5. FN · Q55Consider the following database tables of a sports league. player(pid, pname, age) team(tid, tname, city, cid) coach(cid, cname) members(pid, tid) An instance…SQL Queries · NAT · 2 marks
  6. AN · Q27An audit of a banking transactions system has found that on an earlier occasion, two joint holders of account A attempted simultaneous transfers of Rs. 10000 e…Transactions, Concurrency Control, Conflict Serializability · MSQ · 1 mark
  7. AN · Q46Consider the following relational schema along with all the functional dependencies that hold on them. R1(A, B, C, D, E) : \ D E, EA B, EB C\ R2(A, B, C, D) :…Normalization Schemes · MSQ · 2 marks
  8. AN · Q53Consider the database transactions T1 and T2, and data items X and Y. Which of the schedule(s) is/are conflict serializable?Transactions, Concurrency Control, Conflict Serializability · MSQ · 2 marks
  9. AN · Q54Consider the following relational schema: Students (rollno: integer, name: string, age: integer, cgpa: real) Courses (courseno: integer, cname: string, credits…SQL Queries · MSQ · 2 marks
  10. AN · Q57In a B+ - tree where each node can hold at most four key values, a root to leaf path consists of the following nodes: A = (49, 77, 83, –), B = (7, 19, 33, 44),…File Organization & Indexing · NAT · 2 marks
2024 12 questions · 16 marks
  1. FN · Q20Let S be the specification: “Instructors teach courses. Students register for courses. Courses are allocated classrooms. Instructors guide students.” Which one…ER-Model · MCQ · 1 mark
  2. FN · Q21In a B+ tree, the requirement of at least half-full (50%) node occupancy is relaxed for which one of the following cases?File Organization & Indexing · MCQ · 1 mark
  3. FN · Q22Which of the following statements about a relation R in first normal form (1NF) is/are TRUE?Normalization Schemes · MSQ · 1 mark
  4. FN · Q35Consider the following two relations, R(A, B) and S(A, C) : The total number of tuples obtained by evaluating the following expression B < C (R R.A = S.A S) is…Relational Models, Relational Algebra, Tuple Calculus · NAT · 1 mark
  5. FN · Q44The symbol indicates functional dependency in the context of a relational database. Which of the following options is/are TRUE?Integrity Constraints & Functional Dependencies · MSQ · 2 marks
  6. FN · Q46Consider the following read-write schedule S over three transactions T 1 , T 2 and T 3 , where the subscripts in the schedule indicate transaction IDs: S : r 1…Transactions, Concurrency Control, Conflict Serializability · MSQ · 2 marks
  7. AN · 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…Transactions, Concurrency Control, Conflict Serializability · MCQ · 1 mark
  8. AN · Q20In the context of owner and weak entity sets in the ER (Entity-Relationship) data model, which one of the following statements is TRUE?ER-Model · MCQ · 1 mark
  9. AN · Q26Which of the following file organizations is/are I/O efficient for the scan operation in DBMS?File Organization & Indexing · MSQ · 1 mark
  10. AN · Q27Which of the following statements about the Two Phase Locking (2PL) protocol is/are TRUE?Transactions, Concurrency Control, Conflict Serializability · MSQ · 1 mark
  11. AN · Q45The relation schema, Person (pid, city), describes the city of residence for every person uniquely identified by pid. The following relational algebra operator…Relational Models, Relational Algebra, Tuple Calculus · MCQ · 2 marks
  12. AN · Q56A functional dependency F : X Y is termed as a useful functional dependency if and only if it satisfies all the following three conditions: • X is not the empt…Integrity Constraints & Functional Dependencies · NAT · 2 marks
2023 3 questions · 5 marks
  1. FN · Q16Which one of the options given below refers to the degree (or arity) of a relation in relational database systems?Relational Models, Relational Algebra, Tuple Calculus · MCQ · 1 mark
  2. FN · Q61Consider the following table named Student in a relational database. The primary key of this table is rollNum. The SQL query below is executed on this database…SQL Queries · NAT · 2 marks
  3. FN · Q62Consider a database of fixed-length records, stored as an ordered file. The database has 25,000 records, with each record being 100 bytes, of which the primary…File Organization & Indexing · NAT · 2 marks
2022 5 questions · 7 marks
  1. FN · Q14In a relational data model, which one of the following statements is TRUE?Normalization Schemes · MCQ · 1 mark
  2. FN · Q25Consider the following three relations in a relational database. Employee ( eId , Name), Brand ( bId , bName), Own( eId, bId ) Which of the following relationa…Relational Models, Relational Algebra, Tuple Calculus · MSQ · 1 mark
  3. FN · Q31Consider a relation R(A, B, C, D, E) with the following three functional dependencies. AB C; BC D; C E; The number of superkeys in the relation R is .Integrity Constraints & Functional Dependencies · NAT · 1 mark
  4. FN · Q39Let R i(z) and W i(z) denote read and write operations on a data element z by a transaction T i, respectively. Consider the schedule S with four transactions.…Transactions, Concurrency Control, Conflict Serializability · MCQ · 2 marks
  5. FN · Q56Consider the relational database with the following four schemas and their respective instances. Student(sNo, sName, dNo) Dept(dNo, dName) Course(cNo, cName, d…SQL Queries · NAT · 2 marks
2021 10 questions · 16 marks
  1. FN · Q23Suppose a database system crashes again while recovering from a previous crash. Assume checkpointing is not done by the database either during the transactions…Transactions, Concurrency Control, Conflict Serializability · MSQ · 1 mark
  2. FN · Q33A relation r(A, B) in a relational database has 1200 tuples. The attribute A has integer values ranging from 6 to 20, and the attribute B has integer values ra…Relational Models, Relational Algebra, Tuple Calculus · NAT · 1 mark
  3. FN · Q37The following relation records the age of 500 employees of a company, where empNo (indicating the employee number) is the key: empAge( empNo , age) Consider th…Relational Models, Relational Algebra, Tuple Calculus · MCQ · 2 marks
  4. FN · Q42Let r i(z) and w i(z) denote read and write operations respectively on a data item z by a transaction T i. Consider the following two schedules: S 1 : r 1(x),…Transactions, Concurrency Control, Conflict Serializability · MCQ · 2 marks
  5. FN · Q43Consider the relation R(P, Q, S, T, X, Y, Z, W) with the following functional dependencies PQ X; P YX; Q Y; Y ZW Consider the decomposition of the relation R i…Normalization Schemes · MCQ · 2 marks
  6. AN · Q16Consider the following statements S 1 and S 2 about the relational data model : S 1 : A relation scheme can have at most one foreign key. S 2 : A foreign key i…Integrity Constraints & Functional Dependencies · MCQ · 1 mark
  7. AN · Q31A data file consisting of 1,50,000 student-records is stored on a hard disk with block size of 4096 bytes. The data file is sorted on the primary key RollNo. T…File Organization & Indexing · NAT · 1 mark
  8. AN · Q41The relation scheme given below is used to store information about the employees of a company, where empId is the key and deptId indicates the department to wh…SQL Queries · MCQ · 2 marks
  9. AN · Q42Let S be the following schedule of operations of three transactions T 1, T 2 and T 3 in a relational database system: R 2(Y), R 1(X), R 3(Z), R 1(Y), W 1(X), R…Transactions, Concurrency Control, Conflict Serializability · MCQ · 2 marks
  10. AN · Q50Suppose the following functional dependencies hold on a relation U with attributes P, Q, R, S and T: P QR RS T Which of the following functional dependencies c…Integrity Constraints & Functional Dependencies · MSQ · 2 marks
2020 5 questions · 8 marks
  1. FN · Q23Consider a relational database containing the following schemas. The primary key of each table is indicated by underlining the constituent fields. sql SELECT s…SQL Queries · MCQ · 1 mark
  2. FN · Q24Which one of the following is used to represent the supporting many-one relationships of a weak entity set in an entity-relationship diagram?ER-Model · MCQ · 1 mark
  3. FN · Q46Consider a relational table R that is in 3NF, but not in BCNF. Which one of the following statements is TRUE?Normalization Schemes · MCQ · 2 marks
  4. FN · Q47Consider a schedule of transactions T 1 and T 2 : Here, RX stands for "Read(X)" and WX stands for "Write(X)". Which one of the following schedules is conflict…Transactions, Concurrency Control, Conflict Serializability · MCQ · 2 marks
  5. FN · Q64Consider a database implemented using B+ tree for file indexing and installed on a disk drive with block size of 4 KB. The size of search key is 12 bytes and t…File Organization & Indexing · NAT · 2 marks
2019 5 questions · 8 marks
  1. FN · Q21Consider the following two statements about database transaction schedules: I. Strict two-phase locking protocol generates conflict serializable schedules that…Transactions, Concurrency Control, Conflict Serializability · MCQ · 1 mark
  2. FN · Q24Which one of the following statements is NOT correct about the B+ tree data structure used for creating an index of a relational database table?File Organization & Indexing · MCQ · 1 mark
  3. FN · Q42Let the set of functional dependencies F = \ QR S, R P, S Q\ hold on a relation schema X = (PQRS) . X is not in BCNF. Suppose X is decomposed into two schemas…Normalization Schemes · MCQ · 2 marks
  4. FN · Q61A relational database contains two tables Student and Performance as shown below: The primary key of the Student table is Roll no. For the Performance table, t…SQL Queries · NAT · 2 marks
  5. FN · Q65Consider the following relations P(X, Y, Z), Q(X, Y, T) and R(Y, V). How many tuples will be returned by the following relational algebra query? x ( (P.Y = R.Y…Relational Models, Relational Algebra, Tuple Calculus · NAT · 2 marks
2018 4 questions · 6 marks
  1. FN · Q21In an Entity-Relationship (ER) model, suppose R is a many-to-one relationship from entity set E1 to entity set E2. Assume that E1 and E2 participate totally in…ER-Model · MCQ · 1 mark
  2. FN · Q22Consider the following two tables and four queries in SQL. Book (isbn, bname), Stock (isbn, copies) Query 1: SELECT B.isbn, S.copies FROM Book B INNER JOIN Sto…SQL Queries · MCQ · 1 mark
  3. FN · Q51Consider the relations r(A, B) and s(B, C), where s.B is a primary key and r.B is a foreign key referencing s.B. Consider the query Q: r ( B<5 (s)) Let LOJ den…Relational Models, Relational Algebra, Tuple Calculus · MCQ · 2 marks
  4. FN · Q52Consider the following four relational schemas. For each schema, all non-trivial functional dependencies are listed. The underlined attributes are the respecti…Normalization Schemes · MCQ · 2 marks
2017 10 questions · 16 marks
  1. FN · Q16The following functional dependencies hold true for the relational schema R V, W, X, Y, Z : V W VW X Y VX Y Z Which of the following is irreducible equivalent…Integrity Constraints & Functional Dependencies · MCQ · 1 mark
  2. FN · Q23Consider a database that has the relation schema EMP (EmpId, EmpName, and DeptName). An instance of the schema EMP and a SQL query on it are given below: EMP s…SQL Queries · NAT · 1 mark
  3. FN · Q41Consider a database that has the relation schemas EMP(EmpId, EmpName, DeptId) and DEPT(DeptName, DeptId). Note that the DeptId can be permitted to be NULL in t…Relational Models, Relational Algebra, Tuple Calculus · MCQ · 2 marks
  4. FN · Q42In a database system, unique timestamps are assigned to each transaction using Lamport's logical clock. Let TS(T 1) and TS(T 2) be the timestamps of transactio…Transactions, Concurrency Control, Conflict Serializability · MCQ · 2 marks
  5. FN · Q46Consider a database that has the relation schema CR( StudentName, CourseName). An instance of the schema CR is as given below: The following query is made on t…Relational Models, Relational Algebra, Tuple Calculus · NAT · 2 marks
  6. AN · Q17An ER model of a database consists of entity types A and B. These are connected by a relationship R which does not have its own attribute. Under which one of t…ER-Model · MCQ · 1 mark
  7. AN · Q19Consider the following tables T 1 and T 2. In table T 1, P is the primary key and Q is the foreign key referencing R in table T 2 with on-delete cascade and on…Integrity Constraints & Functional Dependencies · NAT · 1 mark
  8. AN · Q44Two transactions T 1 and T 2 are given as T 1: r 1(X) \ w 1(X) \ r 1(Y) \ w 1(Y) T 2: r 2(Y) \ w 2(Y) \ r 2(Z) \ w 2(Z) where r i(V) denotes a read operation b…Transactions, Concurrency Control, Conflict Serializability · NAT · 2 marks
  9. AN · Q46Consider the following database table named top\ scorer . Consider the following SQL query: sql SELECT ta.player FROM top scorer as ta WHERE ta.goals > ALL (SE…SQL Queries · NAT · 2 marks
  10. AN · Q49In a B + tree, if the search-key value is 8 bytes long, the block size is 512 bytes and the block pointer size is 2 bytes, then the maximum order of the B + tr…File Organization & Indexing · NAT · 2 marks