Quiz Space

Database Management Systems · End Term · 13 Apr 2025 · January 2025 term · Set QDD1

Question 3: Consider the following monthly backup schedule used by a …

Question 3

+2 marksOne correct option

Consider the following monthly backup schedule used by a company:

MondayTuesdayWednesdayThursdayFridaySaturdaySunday
1/ Full2/ Incremental3/ Incremental4/ Incremental5/ Incremental6/ Incremental7/ Differential
8/ Incremental9/ Incremental10/ Incremental11/ Incremental12/ Differential13/ Incremental14/ Incremental
15/ Incremental16/ Incremental17/ Differential18/ Incremental19/ Incremental20/ Incremental21/ Incremental
22/ Differential23/ Incremental24/ Incremental25/ Incremental26/ Incremental27/ Incremental28/ Incremental
29/ Incremental30/ 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?

  1. A

    4

  2. B

    5

  3. C

    6

  4. D

    7

Show answer

Correct answer

  • C

    6

See the whole paperTake it as a mock test

Question 3 of 20 in the IIT Madras BS Database Management Systems (DBMS) End Term paper sat on 13 Apr 2025, in the January 2025 term (IIT M DIPLOMA AN EXAM QDD3 13 Apr 2025). It carries 2 marks.

More questions from this paper

  1. Q1Consider a B+-tree index to be built on the attribute StudentID of a table Students, with the following properties: The…
  2. Q2Consider a log of a transaction as shown below, where the immediate database modification scheme is used. | step | log …
  3. Q4Figure question
  4. Q5Figure question
  5. Q6Consider the following relational schema:\ Employee(<u>emp_id</u>, first_name, last_name, dept_id)\ Department(<u>dept_…
  6. Q7Choose the correct statement(s).
  7. Q8Consider the instance of a relation R. Which among the following functional dependencies set(s) can be inferred from th…
  8. Q9Consider the Employee table given below: | EmpID | Name | Dept | Salary | |---|---|---|---| | 001 | Harry | IT | 80000 …
  9. Q10Figure question
  10. Q11Consider the following Entity Relationship Diagram: Choose the correct statements.
  11. Q12Figure question
  12. Q13Consider you have a file in your hard disk of size 1000 KB. Seek time of your hard disk read head is 3ms and rotational…
  13. Q14Consider a system using the Least Recently Used (LRU) page replacement policy. The system has a main memory buffer with…
  14. Q15Consider the given log records at an instance of time: Table 5: Log records | < T_0 \text{ start} > | |---| | < T_0, A,…
  15. Q16Figure question
  16. Q17Figure question
  17. Q18Consider a Block nested loop join for the two relations, instructor and department. Assuming the worst-case memory avai…
  18. Q19The instance of the table insurance and nominee is as shown below: | ins_id | policyHolderName | age | premium | |---|-…
  19. Q20The instance of the table insurance and nominee is as shown below: | ins_id | policyHolderName | age | premium | |---|-…