lOMoARcPSD|54516663
Week 12 - DBMS
dbms (Anna University)
Scan to open on Studocu
Studocu is not sponsored or endorsed by any college or university
Downloaded by Bubu Maity (maitybubu96@gmail.com)
lOMoARcPSD|54516663
Answer Submitted.
X
(https://swayam.gov.in) (https://swayam.gov.in/nc_details/NPTEL)
arunkumaran0705@gmail.com
NPTEL (https://swayam.gov.in/explorer?ncCode=NPTEL) » Introduction to Database
Systems (course)
Course
outline Week 12: Assignment 12
Introduction
(Non Graded)
to Assignment not submitted
Database
Note : This assignment is only for practice purpose and it will not be
Systems ()
counted towards the Final score
Week 0 () 1) Assuming that the recovery manager uses REDO logging method, the 1 point
value of B on disk immediately after restart but before the recovery manager is
Week 1 () activated.
may be 20
Week 2 ()
must be 20
Week 3 () may be 40
must be 40
Week 4 ()
No, the answer is incorrect.
Score: 0
Week 5 () Accepted Answers:
may be 40
Week 6 ()
2) Consider the following sets about system recovery after a crash 1 point
Week 7 ()
{1: UNDO; 2: REDO; 3: UNDO-REDO}
Week 8 () {p: Ignore committed transactions; q: Consider committed transactions; r:
Ignore committed and incomplete transactions; s: Consider committed and
Week 9 () incomplete transactions; t: Write ahead log }
Downloaded by Bubu Maity (maitybubu96@gmail.com)
lOMoARcPSD|54516663
Week 10 ()
Identify the correct matching between the sets:
Week 11 () 1--p; 2--q; 3--r
1--t; 2--q; 3--s
Week 12 ()
1--p; 2--q; 3--t
Concurrency 1--p; 2--t; 3--s
control
No, the answer is incorrect.
using Locks
Score: 0
(unit?
Accepted Answers:
unit=99&lesson=100)
1--p; 2--t; 3--s
Recovery
3) Consider the following schedule S. 1 point
using undo
logging
method S: r1 (x); r2 (z); r1 (z); r3 (x); r3 (y); w1 (x); w3 (y); r2 (y); w2 (z); w2 (y);
(unit?
unit=99&lesson=101) Here ri (a) denotes transaction i reads item a and wi (a) denotes transaction i
writes data item a. The commit operations of the transactions can
Recovery
be added at the end of S in an appropriate order such that S is recoverable.
using Redo
and Undo-
The number of such orders is
Redo
1
logging
methods 2
(unit? 3
unit=99&lesson=102)
4
Recoverable
Yes, the answer is correct.
schdeules Score: 1
and
Accepted Answers:
transaction
3
isolation
levels (unit?
unit=99&lesson=103) 4) Consider the following schedule S. 1 point
Practice: S: r1 (x); r2 (z); r1 (z); r3 (x); r3 (y); w1 (x); c1 ; w3 (y); c3 ; r2 (y); w2 (z); w2 (y);
Week 12:
c2
Assignment
12 (Non
Here ri (a) denotes transaction i reads item a, wi (a) denotes transaction i
Graded)
(assessment? writes data item a, ci denotes that transaction i is committed. The transaction S is
name=124)
cascadeless and strict
Quiz: Week
cascadeless and not strict
12:
Assignment not strict; cascadeless is irrelevant
12 not cascadeless and not strict
(assessment?
No, the answer is incorrect.
name=142)
Score: 0
Week 12 Accepted Answers:
Feedback cascadeless and strict
form :
Downloaded by Bubu Maity (maitybubu96@gmail.com)
lOMoARcPSD|54516663
Introduction
Check Answers and Submit
to
Database
Your score is: 1/4
Systems
(unit?
unit=99&lesson=104)
Download
Videos ()
Lecture
Notes ()
Live
Sessions
()
Problem
Solving
Session ()
Downloaded by Bubu Maity (maitybubu96@gmail.com)
