DBMS End Term: 3 September 2023, Set QPD1-S2 (May 2023 term)

Question 1

+3 marksNumerical answer

Consider the table Scores given below.

Player	Country	Runs
Kohli	India	86
Dhoni	India	43
Pele	Brazil	89
Gautam	India	100
Lato	Poland	78
Rahn	Germany	55
Muller	Germany	98
Rohit	India	30
Klose	Germany	95
Hardik	India	67

Figure 1: Scores

The following query is executed on the Scores table.

sql

1SELECT ta.Player FROM Scores AS ta
2WHERE ta.Runs > ALL ( SELECT tb.Runs
3                      FROM Scores AS tb
4                      WHERE tb.Country = 'Brazil' AND tb.Runs > 90 )
5   AND ta.Runs > ANY (SELECT tc.Runs
6                      FROM Scores AS tc
7                      WHERE tc.Country = 'India')

How many tuples are returned by the above SQL query?

Question 2

+3 marksNumerical answer

Consider the log records at an instance of time and the statements given below.

Table 2: Log records

$< T_0 \text{ start} >$
$< T_0, A, 1000, 3000 >$
$< T_0, B, 500, 300 >$
$< T_1 \text{ start} >$
$< T_1, C, 790, 700 >$
$< T_0, B, 300, 200 >$
$< Commit\ T_1 >$
$< T_2 \text{ start} >$
$< Checkpoint\ L >$
$< T_2, D, 5000, 4500 >$
System crash

Identify the number of correct statements:

Undo $T_0$
Redo $T_1$
The value of $A$ is updated to 3000
The value of $B$ is restored to 500
The value of $C$ is restored to 790
The value of $D$ is restored to 5000

Question 3

+1 markOne or more correct options

If a relation R is in Fourth Normal form then, which of the following holds?

Select all that apply.

A
No partial dependency
B
No trivial dependency
C
More than one multivalued dependency
D
None of these

19 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 End Term 3 Sept 2023 Set QPD1-S2 paper

The IIT Madras BS Database Management Systems (DBMS) End Term paper sat on 3 Sept 2023, in the May 2023 term, set QPD1-S2: 22 questions for 50 marks in 180 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 End Term 3 Sept 2023 Set QPD1-S2 at a glance
Term	May 2023 term
Subject	Database Management Systems
Course code	BSCS2001
Questions	22
Marks	50
Duration	180 min
Numerical	3
MSQ	8
MCQ	11
Official paper	IIT M DIPLOMA ET1 EXAM QPD1 S2 03 Sep
Negative marking	No negative marking.
Updated	25 Sept 2026

Other sets that day

Set QPD1-S1