Quiz Space

Database Management Systems · End Term · 22 Dec 2024 · September 2024 term · Set QDF1

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

Question 6

+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/ Incremental13/ Differential14/ Incremental
15/ Incremental16/ Incremental17/ Incremental18/ Incremental19/ Differential20/ Incremental21/ Incremental
22/ Incremental23/ Incremental24/ Incremental25/ Differential26/ Incremental27/ Incremental28/ Incremental
29/ Incremental30/ Incremental

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

  1. A

    5

  2. B

    4

  3. C

    3

  4. D

    6

Show answer

Correct answer

  • C

    3

See the whole paperTake it as a mock test

Question 6 of 20 in the IIT Madras BS Database Management Systems (DBMS) End Term paper sat on 22 Dec 2024, in the September 2024 term (IIT M FOUNDATION DIPLOMA AN EXAM QDF3 22 Dec 2024). It carries 2 marks.

More questions from this paper

  1. Q1Consider the table Player given in Figure 1. | pname | team | rating | age | type | |---|---|---|---|---| | AJAY | TEAM…
  2. Q2Figure question
  3. Q3Consider seek time of your hard disk read head is 2ms, rotational speed is 60,000 RPM. The disk has 300 sectors/track a…
  4. Q4Consider a non-empty B+-tree of order 13. What are the maximum and minimum number of keys that can be placed in the roo…
  5. Q5Consider a multilevel index with five levels as L1, L2, L3, L4 and L5. Let L1 be the innermost and L5 be the outermost …
  6. Q7Figure question
  7. Q8Consider the given log records at an instance of time: | < T_0 \text{ start} > | |---| | < T_0, A, 1000, 800 > | | < T_…
  8. Q9Consider the following statements:\ Hot backup refers to keeping a database up and running while the backup is being pe…
  9. Q10Figure question
  10. Q11Consider the Schedule given below: | T_1 | T_2 | T_3 | |---|---|---| | | | R(D) | | | R(A) | | | R(C) | | | | | W(A) | …
  11. Q12Consider the following two schedules S1 and S2 and three transactions T_1, T_2, T_3: \begin{aligned} &\mathbf{S1}: R_1(…
  12. Q13Figure question
  13. Q14Consider the definition of the table Products. The following sequence of queries is executed on this table: Which of th…
  14. Q15Figure question
  15. Q16Figure question
  16. Q17Figure question
  17. Q18Figure question
  18. Q19Consider the following table: | BookID | Title | Author | Publisher | |---|---|---|---| | 301 | Introduction to SQL | D…
  19. Q20Consider a Block nested loop join for the two relations, instructor and department. Assuming the worst-case memory avai…