Consider the table Champions_League for given subquestions | Name | Age | Team | Country | Goals | |---|---|---|---|---| | De jong | 26 | Barcelona | Netherlands | 20 | | Bellingham | 20 | Real Madrid | England | 18 | | Haaland | 23 | Manchester City | Norway | 18 | | Araujo | 25 | Barcelona | Uruguay | 20 | | Martinelli | 22 | Arsenal | Brazil | 16 | | Mbappe | 25 | PSG | France | 16 | | Kroos | 34 | Real Madrid | Germany | 18 | | Dembele | 26 | PSG | France | 14 | | Saka | 22 | Arsenal | England | 16 | | Cubarsi | 17 | Barcelona | Spain | 12 | Table 1: Figure 1: Champions_League Choose the correct SQL statement that will return the resultant table given in Figure 2. | Goals | Team | Count | |---|---|---| | 20 | Barcelona | 2 | | 18 | Real Madrid | 2 | | 18 | Manchester City | 1 | | 16 | Arsenal | 2 | | 16 | PSG | 1 | | 14 | PSG | 1 | | 12 | Barcelona | 1 | Table 2: Figure 2: Result

(A) Option figure from the original question paper

(B) Option figure from the original question paper

(C) Option figure from the original question paper

(D) Option figure from the original question paper

Consider the following SQL statement: Create table Cars( CarID varchar(8), CarName varchar(20), CarColour varchar(8), YearOfPurchase integer, Weight integer, primary key (CarID), check(YearOfPurchase in (1990, 2000, 2005, 2010))); Which among the following will cause an integrity constraint violation in the Cars table? Note: Insertions are done in the order of the options given.

(A) Option figure from the original question paper

(B) Option figure from the original question paper

(C) Option figure from the original question paper

(D) Option figure from the original question paper

Database Management Systems Quiz 1: 7 July 2024 (May 2024 term)

Question 1

+3 marksOne correct option

Consider the table Champions_League for given subquestions

Name	Age	Team	Country	Goals
De jong	26	Barcelona	Netherlands	20
Bellingham	20	Real Madrid	England	18
Haaland	23	Manchester City	Norway	18
Araujo	25	Barcelona	Uruguay	20
Martinelli	22	Arsenal	Brazil	16
Mbappe	25	PSG	France	16
Kroos	34	Real Madrid	Germany	18
Dembele	26	PSG	France	14
Saka	22	Arsenal	England	16
Cubarsi	17	Barcelona	Spain	12

Table 1: Figure 1: Champions_League

Choose the correct SQL statement that will return the resultant table given in Figure 2.

Goals	Team	Count
20	Barcelona	2
18	Real Madrid	2
18	Manchester City	1
16	Arsenal	2
16	PSG	1
14	PSG	1
12	Barcelona	1

Table 2: Figure 2: Result

Question 2

+4 marksNumerical answer

Consider the table Champions_League for given subquestions

Name	Age	Team	Country	Goals
De jong	26	Barcelona	Netherlands	20
Bellingham	20	Real Madrid	England	18
Haaland	23	Manchester City	Norway	18
Araujo	25	Barcelona	Uruguay	20
Martinelli	22	Arsenal	Brazil	16
Mbappe	25	PSG	France	16
Kroos	34	Real Madrid	Germany	18
Dembele	26	PSG	France	14
Saka	22	Arsenal	England	16
Cubarsi	17	Barcelona	Spain	12

Table 1: Figure 1: Champions_League

Question 3

+3 marksOne correct option

Consider the following SQL statement:

sql

1Create table Cars(
2CarID varchar(8),
3CarName varchar(20),
4CarColour varchar(8),
5YearOfPurchase integer,
6Weight integer,
7primary key (CarID),
8check(YearOfPurchase in (1990, 2000, 2005, 2010)));

Which among the following will cause an integrity constraint violation in the Cars table?

Note: Insertions are done in the order of the options given.

12 more questions in this paper

Sign in with Google — it is free — to see every question with its answer and explanation, practise it in learning mode, or take it as a timed mock test.

More on the DBMS Quiz 1 7 Jul 2024 paper

The IIT Madras BS Database Management Systems (DBMS) Quiz 1 paper sat on 7 Jul 2024, in the May 2024 term: 15 questions for 50 marks in 120 minutes. The first 3 questions are below. Sign in with Google — it is free — to see the whole paper with its answers and explanations, in learning mode or as a timed mock test.

Feature	DBMS Quiz 1 7 Jul 2024 at a glance
Term	May 2024 term
Subject	Database Management Systems
Course code	BSCS2001
Questions	15
Marks	50
Duration	120 min
MCQ	7
Numerical	2
MSQ	6
Official paper	IIT M DIPLOMA AN EXAM QDD2 7 July 2024
Negative marking	No negative marking.
Updated	25 Sept 2026