a) DB Log in RAM captures commit and flushed to disk DB log b) Commit issued c)
ID: 3838207 • Letter: A
Question
a) DB Log in RAM captures commit and flushed to disk DB log b) Commit issued c) Application: Update SQL d) DB Log in RAM flushed to DB LOG on disk e Retrieve Table able blocks from disk, load into DB RAM Buffer Cache, copy blocks to Application f) Application updates data blocks g) DB Log in RAM records update h) Row in DB RAM Buffer Cache updated i) Updated row in DB RAM Buffer Cache flushed to DB on disk j) Checks DB RAM for Table data blocks in Update 1. Application: Update SQL 2. Checks DB RAM for Table data blocks in Update 3. Retrieve Table blocks from disk, load into DB RAM Buffer Cache, copy blocks back to Application 4. Application updates data blocks 5. DB Log in RAM records update 6. DB Log in RAM flushed to DB LOG on disk 7. Row in DB RAM Buffer Cache updated 8. Commit issued 9. DB Log in RAM captures Commit and flushed to disk DB log 10. Updated row in DB RAM Buffer Cache flushed to DB on diskExplanation / Answer
1.Application Update SQL.
2.Retrieve Table blocks from disk load into DB RAM Buffer Cache copy blocks back to application
3.Checks DB RAM for Table data blocks in Update
4.Application updates data blocks
5.DB log in RAM flushed to DB LOG on disk
6.DB log in RAM records update
7.update rows in DB RAM Buffer Cache flushed to DB on disk
8.Row in DB RAM Buffer cache updated
9.commit issued
10.DB Log in RAM captures Commit and flushed to disk DB Log
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.