Open In App

Database Management System – GATE CSE Previous Year Questions

Improve
Improve
Improve
Like Article
Like
Save Article
Save
Share
Report issue
Report

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.

GATE DBMS Previous Year Questions
Database Management Systems | Set 1,2 
Database Management Systems | Set 3
Database Management Systems | Set 4
Database Management Systems | Set 5
Database Management Systems | Set 6
Database Management Systems | Set 7
Database Management Systems | Set 8
Database Management Systems | Set 9
Database Management Systems | Set 10

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.

Year Paper Keys
2023 2023 Paper 2023 Answer Keys
2022 2022 Paper 2022 Answer Keys
2021 2021 Set 1 Paper 2021 Set 1 Key
2021 Set 2 Paper 2021 Set 2 Key
2020 2020 Paper 2020 Keys
2019 2019 Paper 2019 Keys
2018 2018 Paper 2018 Keys
2017 2017 Set 1 Paper 2017 Set 1 Keys
2017 Set 2 Paper 2017 Set 2 Keys
2016 2016 Set 1 Paper 2016 Set 1 Keys
2016 Set 2 Paper 2016 Set 2 Keys
2015 2015 Set 1 Paper 2015 Set 1 Keys
2015 Set 2 Paper 2015 Set 2 Keys
2015 Set 3 Paper 2015 Set 3 Keys
2014 2014 Set 1 Paper 2014 Set 1 Keys
2014 Set 2 Paper 2014 Set 2 Keys
2014 Set 3 Paper 2014 Set 3 Keys
2013 2013 Paper 2013 Keys
2012 2012 Paper 2012 Keys
2011 2011 Paper 2011 Keys


Last Updated : 19 May, 2023
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads