Register

korth

235 views
0 votes
0 votes
do we have query optimaztion and processing and ch 16 from korth for gate
User Avatar

Please log in or register to answer this question.

Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
0 answers
1
akash.dinkar12 asked Apr 3, 2019
398 views
DBMS Korth Edition 4 Exercise 16 Question 31 (Page No. 636)
Give example schedules to show that if any of lookup, insert or delete do not lock the next key value, the phantom phenomenon could go undetected.
Give example schedules to show that if any of lookup, insert or delete do not lock the next key value, the phantom phenomenon could go undetected.
User Avatar
0 votes
0 votes
0 answers
2
akash.dinkar12 asked Apr 3, 2019
307 views
DBMS Korth Edition 4 Exercise 16 Question 29 (Page No. 635)
Explain the reason for the use of degree-two consistency. What disadvantages dos this approach have ?
Explain the reason for the use of degree-two consistency. What disadvantages dos this approach have ?
User Avatar
0 votes
0 votes
0 answers
3
akash.dinkar12 asked Apr 3, 2019
334 views
DBMS Korth Edition 4 Exercise 16 Question 28 (Page No. 635)
Devise a timestamp-based protocol that avoids the phantom phenomenon.
Devise a timestamp-based protocol that avoids the phantom phenomenon.
User Avatar
0 votes
0 votes
2 answers
4
akash.dinkar12 asked Apr 3, 2019
660 views
DBMS Korth Edition 4 Exercise 16 Question 27 (Page No. 635)
Explain the phantom phenomenon. Why may this phenomenon lead to an incorrect concurrent execution despite the use of the two-phase locking protocol ?
Explain the phantom phenomenon. Why may this phenomenon lead to an incorrect concurrent execution despite the use of the two-phase locking protocol ?
User Avatar
Link Copied!