Practising the DBMS GATE questions with answers will yield very good results for the aspirants. The question papers will give an idea about the important and high scoring topics for the GATE 2024 exam.
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
