Quiz Space

Database Management Systems · End Term · 28 Apr 2024 · January 2024 term · Set QDB1

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

Question 16

+3 marksNumerical answer

Consider the following monthly backup schedule used by a company:

MondayTuesdayWednesdayThursdayFridaySaturdaySunday
1/ Full2/ Incremental3/ Incremental4/ Differential5/ Incremental6/ Incremental7/ Differential
8/ Incremental9/ Incremental10/ Differential11/ Incremental12/ Incremental13/ Differential14/ Incremental
15/ Incremental16/ Differential17/ Incremental18/ Incremental19/ Differential20/ Incremental21/ Incremental
22/ Differential23/ Incremental24/ Incremental25/ Differential26/ Incremental27/ Incremental28/ Differential
29/ Incremental30/ Incremental

Let A be the number of backup sets that need to be loaded for a complete recovery, if there is a system failure on the 11th day of the month (after the backup for the day had been completed). Let B be the number of backup sets that need to be loaded for a complete recovery , if there is a system failure on the 25th day of the month (before the backup for the day had been completed).What will be the value of B-A?

Show answer

Correct answer: 1

Question 16 of 20 in the IIT Madras BS Database Management Systems (DBMS) End Term paper sat on 28 Apr 2024, in the January 2024 term (IIT M DEGREE FN EXAM QDB1 28 Apr 2024). It carries 3 marks.

More questions from this paper

  1. Q1Figure question
  2. Q2Let us consider the following statistics for searching a condition within a given relation. Number of blocks containing…
  3. Q3Consider the relational schema: prescription(doctor_id, doctor_name, patient_id, patient_name, medicine_id, medicine_na…
  4. Q4Consider the table Students given below: | ID | Name | Department | Marks | |---|---|---|---| | 001 | Harry | Comp. Sci…
  5. Q5Choose the correct statement(s):
  6. Q6Choose the correct statement(s):
  7. Q7Figure question
  8. Q8Figure question
  9. Q9Figure question
  10. Q10Consider the following relations: players(<u>pid</u>, name, age, jersey_no) teams(<u>team_name</u>, matches, points, pi…
  11. Q11Consider you are designing a database schema for a university management system. One of the key relations, R, represent…
  12. Q12Figure question
  13. Q13Consider the following two schedules S1 and S2 and three transactions T_1, T_2, T_3: \mathbf{S1}: R_2(X); R_3(Y); W_2(X…
  14. Q14Figure question
  15. Q15Figure question
  16. Q17Figure question
  17. Q18Figure question
  18. Q19What will be the output of the following SQL query:
  19. Q20Choose the correct expression(s) for the statement given below:\ Name all the teams from England, with atmost 5 wins an…