DBMS GATE Questions with Answers - Download PDF

DBMS GATE questions with answers must be practised thoroughly by the aspirants preparing for the GATE exam. The previous year's question papers provide a clear understanding of the question pattern and the marks distribution along with the weightage of different sections in CSE, among which DBMS is an important section.

GATE 2024 is scheduled to be conducted from Feb 3, 2024, to Feb 11, 2024. The GATE admit card 2024 was released on the official website of IISc on Jan 4, 2024. Candidates opting for the CSE domain must practise the previous year question papers along with the sample papers thoroughly to crack the exam with flying colours.

DBMS GATE Questions with Answers - Download PDF

The DBMS GATE questions with answers likely to be asked in GATE are added in the PDF below, and students can download the PDF directly by clicking on the link.

DBMS GATE Questions with Answers

Download PDF

Also Check: GATE CSE Question Papers 2024: Answer Keys, Previous Years PDF 

Top 25+ DBMS GATE Questions with Answers

The difficulty level of the questions given in the GATE exam remains between moderate to high. So, the candidates must prepare thoroughly. Practising the GATE question papers will help them perform better in the examination hall.

DBMS or the Database Management System is an important section of the GATE Computer Science Engineering (CSE) syllabus. Compiled below is a list of important DBMS GATE questions along with their answers.

1. Which among the given options below is the highest level of isolation in transaction management?

(A) Committed read

(B) Serializable

(C) Repeated read

(D) Uncommitted read

Ans: (B) Serializable

2. Which of the following is TRUE?

(A) Every relation in 2NF is also in BCNF

(B) A relation R is in 3NF if every non-prime attribute of R is fully functionally dependent on every key of R

(C) Every relation in BCNF is also in 3NF

(D) No relation can be in both BCNF and 3NF

Ans: (C) Every relation in BCNF is also in 3NF

Also Check: GATE CSE Paper Analysis 2024: Difficulty Level, Weightage

3. Which of the statements given below might cause an irrevocable error in the database system?

(A) A data item is read by the  transaction post it is written by the uncommitted transaction

(B) A data item is read by the  transaction post it is written by the committed transaction

(C) A data item is written by the  transaction post it is read by the committed transaction

(D) A data item is written by the  transaction post it is read by the uncommitted transaction

Ans: (A) A data item is read by the  transaction post it is written by the uncommitted transaction

4. Given the basic ER and relational models, which of the following is INCORRECT?

(A) An attributes of an entity can have more that one value

(B) An attribute of an entity can be composite

(C) In a row of a relational table, an attribute can have more than one value

(D) In a row of a relational table, an attribute can have exactly one value or a NULL value

Ans: (C) In a row of a relational table, an attribute can have more than one value

Also Read: Last Minute Preparation Tips for GATE 2024

5. Which of the following statements are TRUE about an SQL query?

P: An SQL query can contain a HAVING clause even if it does not a GROUP BY clause

Q: An SQL query can contain a HAVING clause only if it has a GROUP BY clause

R: All attributes used in the GROUP BY clause must appear in the SELECT clause

S: Not all attributes used in the GROUP BY clause need to appear in the SELECT clause

(A) P and R

(B) P and S

(C) Q and R

(D) Q and S

Ans: (C) Q and R

6. Given below is the basic ER and relational model. In this context which of the statements given below is Incorrect?

(A) An attribute of an entity can be composite

(B) In the row of a relational table, an attribute may have exactly one or a Null value

(C) An attribute of an entity may have a value more than one

(D) In the row of a relational table, an attribute can have more than one value

Ans: (D) In the row of a relational table, an attribute can have more than one value

Also, Check: GATE Response Sheet 2024

7. Given below is the basic ER and relational model. In this context which of the statements given below is Incorrect?

(A) An attribute of an entity can be composite

(B) In the row of a relational table, an attribute may have exactly one or a Null value

(C) An attribute of an entity may have a value more than one.

(D) In the row of a relational table, an attribute can have more than one value

Ans: (A) An attribute of an entity can be composite

8. Referential Integrity constraint functions make use of the ________ concept

(A) Primary key

(B) Super key

(C) Foreign key

(D) Secondary key

Ans: (C) Foreign key

Also Read: Importance of GATE Mock Tests 2024 for Effective Preparation

9. In a given relational schema, each tuple will be divided into fields called the ______

(A) Domains

(B) Queries

(C) Relations

(D) None of the above

Ans: (A) Domains

10. Which one from the list given below is an aggregate function in SQL?

(A) Avg

(B) Distinct

(C) Ordered by

(D) Select

Ans: (A) Avg

Also, Check: GATE Answer Key 2024

11. What is the hashing function in the Hierarchical database used for locating from the list given below?

(A) Foreign key

(B) Root

(C) Records

(D) Collision

Ans: (C) Records

12. _____ is said to be the logical design of a database, whereas the snapshot of data in a database at any given point in time is called the __________

(A) Attribute domain, attribute value

(B) Database schema, database instance

(C) Database schema, attribute domain

(D) Database relation, attribute

Ans: (B) Database schema, database instance

Also Read: GATE Subject Wise Weightage 2024: Chapter-wise Topic

13. The type of fields in which a clustering index is defined is of which type among the following?

(A) Non-key and ordering

(B) Key and non-ordering

(C) Non-key and non-ordering

(D) Key and ordering

Ans: (D) Key and ordering

14. In a conservative two-phase locking protocol, what is the role of a transaction?

(A) It must release the exclusive locks only after the commit operation

(B) It must acquire the locks at the beginning of the transaction

(C) It must acquire the exclusive locks at the beginning of the transaction

(D) It must release the locks at the beginning of the transaction

Ans: (B) It must acquire the locks at the beginning of the transaction

Also, Check: GATE Books for CSE 2024: Exam Pattern, Preparation Tips

15. Which of the statements about an SQL query given below can be considered to be “TRUE”?

P: The SQL query may consist of a HAVING clause even when it does not have GROUP BY clause

Q: The SQL query may consist of a HAVING clause only if it contains a GROUP BY clause

R: All the attributes used in a GROUP BY clause should appear in the SELECT clause

S: Not all the attributes used in GROUP BY clause must appear in the SELECT clause

(A) P and S

(B) P and R

(C) Q and S

(D) Q and R

Ans: (C) Q and S

16. Which of the options from the list given below in the place sorting algorithms must be the minimum number of swaps?

(A) Quick sort

(B) Heap sort

(C) Insertion sort

(D) Selection sort

Ans: (C) Insertion sort

Also Read: GATE 2024 Preparation Tips from Toppers & Experts

17. Which of the statements given below is/are true?

(A) An SQL query will automatically eliminate the duplicates

(B) An SQL allows the attribute names to get repeated within the same relation

(C) An SQL query may work if there happens to exist no indexes on the relations

(D) None of the above-mentioned

Ans: (C) An SQL query may work if there happens to exist no indexes on the relations

18. DML (Data Manipulation Language) cannot be used for which of the options given below?

(A) Creation of an information table within the Database

(B) Deletion of the existing information in the Database

(C) Modification of the existing information in the Database

(D) Insertion of a new information into the existing Database

Ans: (A) Creation of an information table within the Database

19. What is the task of a Transaction manager? Choose the correct answer from the options given below.

(A) Maintains the log of transactions

(B) Maintains the before and after image of database

(C) Maintains an appropriate control of concurrency

(D) None of these

Ans: (C) Maintains an appropriate control of concurrency

20. In the relation scheme R (A, B, C, D, E, H) upon which the functional dependencies are {A–>B, BC–>D, E–>C, D–>A}, which are the candidate keys of R?

(A) AE, BE, DEAE, BE

(B) AE, BE

(C) AEH, BEH, BCH

(D) AEH, BEH, DEH

Ans: (D) AEH, BEH, DEH

Also Read: GATE Qualifying Marks 2024: Passing Marks, Admission Cutoff

21. Which of the following statements is true?

(A) Every relation present in 3NF is also present in BCNF

(B) A relation R can be said to be in 3NF if each non-prime attribute of R is entirely functionally dependent on each key of R

(C) Every relation present in BCNF is also present in 3NF

(D) No relation can exist in both BCNF and 3NF

Ans: (A) Every relation present in 3NF is also present in BCNF

22. Which of the options given below contains a complete record of all the activities that have affected the content in a database in a given period of time.

(A) Transaction log

(B) Report writer

(C) Query language

(D) Data manipulation language

Ans: (A) Transaction log

23. The rules of Classification in the Data Mining system are extracted from which of the options given below?

(A) Decision Tree

(B) Data

(C) Information

(D) Database

Ans: (A) Decision Tree

25. The use of Preemption and Transaction Rollback prevents which among the following situations?

(a) Data manipulation

(b) Deadlock situation

(c) File preemption

(d) Unauthorised usage of data files

Ans: (b) Deadlock situation

Also Read: GATE Score Calculation 2024: Formula, Calculation, Normalization

26. From the options given below for desired features, which can be said to be beyond the capacity of a relational algebra?

(A) Finding a transitive closure

(B) Aggregate computation

(C) Multiplication

(D) All of the above

Ans: (A) Finding a transitive closure

27. If a certain block is capable of holding either 10 key pointers or 3 records or and a database consists of “n” number of records, how many blocks are needed to hold the data file as well as the dense index?

(A)13n/30

(B) N/10

(C) N/30

(D) N/3

Ans: (a)13n/30

28. What among the given options refers to the correctness and the completeness of a given data in the database?

(A) Data security

(B) Data integrity

(C) Data constraint

(D) Data independence

Ans: (B) Data integrity

Also Read: What Does it Take to Become a GATE Topper? Tips, Strategies