Скачать или смотреть DBS: 6.7 Summary

This is the Database Systems II
Instructor: Ouldooz Baghban Karimi (https://ouldooz.com)

Textbook: Database Management Systems
Raghu Ramakrishnan, Johannes Gehrke
http://pages.cs.wisc.edu/~dbbook/

Database System Concepts
Avi Silberschatz, Henry F. Korth, S. Sudarshan
https://www.db-book.com/


Review Questions:
(1) What are the different types of failures in the database management system? (DBS: 6.1)
(2) What are the different types of log records? (DBS: 6.2)
(3) What is Write Ahead Logging? (DBS:6.3)
(4) What is a fuzzy checkpoint? (DBS:6.3)
(5) In which direction the ARIES recovery algorithm scans the logs? (DBS:6.4-6.5)
(6) What are the log record pointers in the dirty page table and transaction table? (DBS:6.3)
(7) What is a loser transaction? (DBS:6.5)
(8) In ARIES: What type of logs are used in Redo phase? What type of logs are used in Undo phase? (DBS:6.5)
(9) What are the advantages of the ARIES algorithm ? (DBS:6.4-6.5)
(10) What is a shadow page? (DBS:6.6)