Consider a log of a transaction as shown below, where the immediate database modification scheme is used. | step | log details | |---|---| | 1 | | | 2 | | | 3 | | | 4 | | | 5 | | Table 1: log table Suppose the transaction failed before step 5, then which of the following is true?

(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

DBMS End Term: 13 April 2025, Set QDD1 (January 2025 term)

Question 1

+2 marksOne correct option

Consider a B+-tree index to be built on the attribute StudentID of a table Students, with the following properties:

The length of the attribute StudentID is 10 bytes.
The size of each child pointer is 14 bytes.
The size of each disk block size is 470 bytes.

With the given information, what is the best choice for the order of the non-leaf nodes of the B+-tree?

A
19
B
20
C
21
D
22

Question 2

+2 marksOne correct option

Consider a log of a transaction as shown below, where the immediate database modification scheme is used.

step	log details
1	$< T_1, start >$
2	$< T_1, A, 1000, 700 >$
3	$< T_1, B, 600, 450 >$
4	$< T_1, C, 800, 1300 >$
5	$< T_1, Commit >$

Table 1: log table

Suppose the transaction failed before step 5, then which of the following is true?

Question 3

+2 marksOne correct option

Consider the following monthly backup schedule used by a company:

Monday	Tuesday	Wednesday	Thursday	Friday	Saturday	Sunday
1/ Full	2/ Incremental	3/ Incremental	4/ Incremental	5/ Incremental	6/ Incremental	7/ Differential
8/ Incremental	9/ Incremental	10/ Incremental	11/ Incremental	12/ Differential	13/ Incremental	14/ Incremental
15/ Incremental	16/ Incremental	17/ Differential	18/ Incremental	19/ Incremental	20/ Incremental	21/ Incremental
22/ Differential	23/ Incremental	24/ Incremental	25/ Incremental	26/ Incremental	27/ Incremental	28/ Incremental
29/ Incremental	30/ Incremental

If a failure occurs on the 12th day of the month before the backup for the day has been completed, how many backup sets have to be loaded for a full recovery?

17 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 13 Apr 2025 Set QDD1 paper

The IIT Madras BS Database Management Systems (DBMS) End Term paper sat on 13 Apr 2025, in the January 2025 term, set QDD1: 20 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 13 Apr 2025 Set QDD1 at a glance
Term	January 2025 term
Subject	Database Management Systems
Course code	BSCS2001
Questions	20
Marks	50
Duration	180 min
MCQ	7
MSQ	6
Numerical	7
Official paper	IIT M DIPLOMA AN EXAM QDD3 13 Apr 2025
Negative marking	No negative marking.
Updated	25 Sept 2026

Other sets that day

Set QDD3

DBMS End Term: 13 April 2025, Set QDD1 (January 2025 term)

Question 1

Question 2

Question 3

17 more questions in this paper

More on the DBMS End Term 13 Apr 2025 Set QDD1 paper

Other sets that day

Same End Term, other subjects

More DBMS