Question 1
Consider the instance of a relation R. Which among the following functional dependencies set can be inferred from the given information?
| StudentID | Course | Grade | Instructor |
|---|---|---|---|
| S1 | C1 | A | I1 |
| S1 | C2 | B | I2 |
| S2 | C1 | A | I1 |
| S3 | C3 | C | I3 |
| S2 | C2 | B | I2 |
| S4 | C4 | A | I4 |
Question 2
Question 3
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 23rd day of the month after the backup for the day has been completed, how many backup sets have to be loaded for a full recovery?
4
5
6
3
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 QDD3 paper
The IIT Madras BS Database Management Systems (DBMS) End Term paper sat on 13 Apr 2025, in the January 2025 term, set QDD3: 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 QDD3 at a glance |
|---|---|
| Term | January 2025 term |
| Subject | Database Management Systems |
| Course code | BSCS2001 |
| Questions | 20 |
| Marks | 50 |
| Duration | 180 min |
| MCQ | 8 |
| MSQ | 5 |
| Numerical | 7 |
| Official paper | IIT M DIPLOMA AN EXAM QDD3 13 Apr 2025 |
| Negative marking | No negative marking. |
| Updated |