Solving GATE Previous Year’s Questions (PYQs) not only clears the concepts but also helps to gain flexibility, speed, accuracy, and understanding of the level of questions generally asked in the GATE exam, and that eventually helps you to gain good marks in the examination. Previous Year Questions help a candidate practice and revise for GATE, which helps crack GATE with a good score.
Database Management Systems Previous Year GATE Questions help in analyzing the question pattern of a subject and marking scheme as well as it helps in time management which overall increases the score in the GATE exam. With regular practice of PYQs, candidates can easily crack GATE with a good GATE Score.
Before 2006, questions asked in GATE were mainly theoretical, but in recent years, the questions asked were multiple-choice questions with a single correct option or multiple correct options. We are looking to provide the multiple-choice questions that are asked in GATE.
DBMS GATE Previous Year Questions
In this article, we are mainly focusing on the DBMS GATE Questions that are asked in Previous Years with their solutions, and where an explanation is required, we have also provided the reason.
In Database Management System, we will deal with the following concepts. We have also provided GATE Previous Year’s Questions on these topics. Here is the list of those topics along with their links.
Below mentioned are the links to the Database Management Systems PYQ’s pages. On each page, you will get the questions asked in DBMS along with the years asked.
Also, here we are going to discuss some basic PYQs related to Database Management Systems.
1. Which one of the options given below refers to the degree (or arity) of relation in relational database systems? [GATE CSE 2023]
(A) Number of attributes of its relation schema.
(B) Number of tuples stored in the relation.
(C) Number of entries in the relation.
(D) Number of distinct domains of its relation schema.
Solution: Correct Option is (A)
2. In a relational data model, which one of the following statements is TRUE? [GATE CSE 2022]
(A) A relation with only two attributes is always in BCNF.
(B) If all attributes of a relation are prime attributes, then the relation is in BCNF.
(C) Every relation has at least one non-prime attribute.
(D) BCNF decompositions preserve functional dependencies.
Solution: Correct Option is (A)
For more, refer to GATE | CS 2022 | Question 14.
3. Which one of the following is used to represent the supporting many-one relationships of a weak entity set in an entity-relationship diagram? [GATE CSE 2020]
(A) Diamonds with double/bold border
(B) Rectangles with double/bold border
(C) Ovals with double/bold border
(D) Ovals that contain underlined identifiers
Solution: Correct Option is (A)
For more, refer to GATE | GATE CS 2020 | Question 24.
4. A prime attribute of a relation scheme R is an attribute that appears [GATE CSE 2014]
(A) in all candidate keys of R.
(B) in some candidate keys of R.
(C) In a foreign key of R.
(D) only in the primary key of R.
Solution: Correct Option is (B)
For more, refer to GATE | GATE-CS-2014-(Set-3) | Question 65.
5. Given the basic ER and relational models, which of the following is INCORRECT? [GATE CSE 2012]
(A) An attribute of an entity can have more than 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.
Solution: Correct Option is (C)
For more, refer to GATE | GATE CS 2012 | Question 14.
GATE CSE Previous Year Question Papers
These previous year’s questions help you in understanding the question patterns followed by GATE that directly help a candidate in scoring good marks in GATE. Below are the mentioned links of year-wise GATE Previous Question Papers.